Exemple #1
0
 public DataSet SearchRRFCodeData(RecruiterBOL objRecruiterBOL)
 {
     SqlParameter[] param = new SqlParameter[3];
     param[0]       = new SqlParameter("@UserId", SqlDbType.Int);
     param[0].Value = objRecruiterBOL.UserID;
     param[1]       = new SqlParameter("@RoleType", SqlDbType.VarChar);
     param[1].Value = objRecruiterBOL.RoleType;
     param[2]       = new SqlParameter("@RRFNo", SqlDbType.VarChar);
     param[2].Value = objRecruiterBOL.RRFCode;
     return(dsGetRRFCodeList = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_RRFNoSearch", param));
 }
Exemple #2
0
        public void ChangeStatus(RecruiterBOL objRecruiterBOL)
        {
            SqlParameter[] param = new SqlParameter[4];

            param[0]       = new SqlParameter("@RRFID", SqlDbType.VarChar);
            param[0].Value = objRecruiterBOL.RRFID;

            param[1]       = new SqlParameter("@ModifiedDate", SqlDbType.DateTime);
            param[1].Value = objRecruiterBOL.ModifiedDate;

            param[2]       = new SqlParameter("@ModifiedBy", SqlDbType.Int);
            param[2].Value = objRecruiterBOL.ModifiedBy;

            param[3]       = new SqlParameter("@RRFAcceptedDate", SqlDbType.DateTime);
            param[3].Value = objRecruiterBOL.RRFAcceptedDate;

            SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_ChangeRRFStatus", param);
        }
Exemple #3
0
 public DataSet SearchRRFCodeData(RecruiterBOL objRecruiterBOL)
 {
     return(dsGetRRFCodeList = objRecruiterDAL.SearchRRFCodeData(objRecruiterBOL));
 }
Exemple #4
0
 public void ChangeStatus(RecruiterBOL objRecruiterBOL)
 {
     objRecruiterDAL.ChangeStatus(objRecruiterBOL);
 }