How to get Multiple output Parameter in My Presendation Laye
My Stored Procedure:
ALTER PROCEDURE [dbo].[ApplicantRequestInsert]
(@periodID int,
@RequestTypeID int,
@ApplicationNumber Varchar(100) output ,
@ApplicantName Varchar(100) output,
@ProgramID int,
@statusID int,
@RequestID int OUTPUT,
@EstimateAmount Money,
@RegulationID int)
My Class
public object InsertApplicationRequest( AdmissionRequestDAL admiRequest)
{
bool isInsert = false;
SqlParameter[] parms = {
new SqlParameter ("@periodID",SqlDbType.Int),
new SqlParameter ("@RequestTypeID",SqlDbType.Int),
new SqlParameter ("@ApplicationNumber",SqlDbType.VarChar, 50),
new SqlParameter ("@ApplicantName",SqlDbType.VarChar,100),
new SqlParameter ("@ProgramID", SqlDbType.Int),
new SqlParameter ("@statusID",SqlDbType.Int),
new SqlParameter ("@EstimateAmount",SqlDbType.Money),
new SqlParameter ("@RegulationID", SqlDbType.Int),
new SqlParameter("@RequestID", SqlDbType.Int)
};
parms[0].Value = admiRequest.periodID;
parms[1].Value = admiRequest.RequestTypeID;
parms[2].Value = admiRequest.ApplicationNumber;
parms[2].Direction = ParameterDirection.Output;
parms[3].Value = admiRequest.@ApplicantName;
parms[3].Direction = ParameterDirection.InputOutput;
parms[4].Value = admiRequest.ProgramID;
parms[5].Value = Convert.ToInt32("1");
parms[6].Value = admiRequest.EstimateAmount;
parms[7].Value = admiRequest.RegulationID;
parms[8].Value = Convert.ToInt32("0");
parms[8].Direction = ParameterDirection.InputOutput;
SQLHelper.ExecuteNonQuery(SQLHelper.conection, CommandType.StoredProcedure, "ApplicantRequestInsert", parms);
string[] returnparm = new string[3];
returnparm[0] = parms[2].Value.ToString();
returnparm[1] = parms[3].Value.ToString();
returnparm[2] = parms[8].Value.ToString();
return isInsert ;
}
how to get my output parameter in my presentation Layer