예제 #1
0
        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);
        }
예제 #2
0
        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));
        }
예제 #3
0
        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)));
        }
예제 #4
0
 public int CheckOfferIssedToAnyCandidate(HRMBOL objHRMBOL)
 {
     return(countOfOfferIssedToAnyCandidate = objHRMDAL.CheckOfferIssedToAnyCandidate(objHRMBOL));
 }
예제 #5
0
 public void SetRecruiterToRRF(HRMBOL objHRMBOL)
 {
     objHRMDAL.SetRecruiterToRRF(objHRMBOL);
 }
예제 #6
0
 public DataSet GetRRFToApprove(HRMBOL objHRMBOL)
 {
     dsRRFDetails = objHRMDAL.GetRRFToApprove(objHRMBOL);
     return(dsRRFDetails);
 }