public void SetRecruiterToRRF(HRMBOL objHRMBOL)
{
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@RRFID", SqlDbType.Int);
param[0].Value = objHRMBOL.RRFID;
param[1] = new SqlParameter("@RecruiterID", SqlDbType.Int);
param[1].Value = objHRMBOL.RecruiterID;
param[2] = new SqlParameter("@AssignedBy", SqlDbType.Int);
param[2].Value = objHRMBOL.AssignedBy;
param[3] = new SqlParameter("@AssignedDate", SqlDbType.DateTime);
param[3].Value = objHRMBOL.AssignedDate;
param[4] = new SqlParameter("@ModifiedDate", SqlDbType.DateTime);
param[4].Value = objHRMBOL.ModifiedDate;
param[5] = new SqlParameter("@ModifiedBy", SqlDbType.Int);
param[5].Value = objHRMBOL.ModifiedBy;
param[6] = new SqlParameter("@SLAType", SqlDbType.Int);
param[6].Value = objHRMBOL.SLAType;
SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_SetRecruiterToRRF", param);
}
public DataSet GetRRFToApprove(HRMBOL objHRMBOL)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@RRFID", SqlDbType.Int);
param[0].Value = objHRMBOL.RRFID;
return(SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetRRFToApprove", param));
}
public int CheckOfferIssedToAnyCandidate(HRMBOL objHRMBOL)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@RRFId", SqlDbType.Int);
param[0].Value = objHRMBOL.RRFID;
return(countOfOfferIssedToAnyCandidate = Convert.ToInt32(SqlHelper.ExecuteScalar(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_CheckOfferissedtoAnyCandidate", param)));
}
public int CheckOfferIssedToAnyCandidate(HRMBOL objHRMBOL)
{
return(countOfOfferIssedToAnyCandidate = objHRMDAL.CheckOfferIssedToAnyCandidate(objHRMBOL));
}
public void SetRecruiterToRRF(HRMBOL objHRMBOL)
{
objHRMDAL.SetRecruiterToRRF(objHRMBOL);
}
public DataSet GetRRFToApprove(HRMBOL objHRMBOL)
{
dsRRFDetails = objHRMDAL.GetRRFToApprove(objHRMBOL);
return(dsRRFDetails);
}