示例#1
0
        public string RejectJobWiseApplicant(JobApplicantModelBO objJobApplicantModelBo, int iUserId)
        {
            ProcParameterBO        objDbParameter         = null;
            List <ProcParameterBO> objListProcParameterBo = new List <ProcParameterBO>();
            string strResult = "";

            try
            {
                objDbParameter                = new ProcParameterBO();
                objDbParameter.Direction      = ParameterDirection.Input;
                objDbParameter.ParameterName  = "@iAppliedJobId";
                objDbParameter.dbType         = DbType.Int32;
                objDbParameter.ParameterValue = objJobApplicantModelBo.ApplicantJobId;
                objListProcParameterBo.Add(objDbParameter);

                objDbParameter                = new ProcParameterBO();
                objDbParameter.Direction      = ParameterDirection.Input;
                objDbParameter.ParameterName  = "@iApplicantId";
                objDbParameter.dbType         = DbType.Int32;
                objDbParameter.ParameterValue = objJobApplicantModelBo.ApplicantId;
                objListProcParameterBo.Add(objDbParameter);

                objDbParameter                = new ProcParameterBO();
                objDbParameter.Direction      = ParameterDirection.Input;
                objDbParameter.ParameterName  = "@strComments";
                objDbParameter.dbType         = DbType.String;
                objDbParameter.ParameterValue = objJobApplicantModelBo.StatusComments;
                objListProcParameterBo.Add(objDbParameter);

                objDbParameter                = new ProcParameterBO();
                objDbParameter.Direction      = ParameterDirection.Input;
                objDbParameter.ParameterName  = "@iUserId";
                objDbParameter.dbType         = DbType.Int32;
                objDbParameter.ParameterValue = iUserId;
                objListProcParameterBo.Add(objDbParameter);

                objDbParameter               = new ProcParameterBO();
                objDbParameter.Direction     = ParameterDirection.Output;
                objDbParameter.ParameterName = "@strResult";
                objDbParameter.dbType        = DbType.String;
                objDbParameter.Size          = 100;
                objListProcParameterBo.Add(objDbParameter);

                objDBAccess.executeNonQuery(PrcoRejectJobApplicant, ref objListProcParameterBo);

                for (int i = 0; i < objListProcParameterBo.Count; i++)
                {
                    if (objListProcParameterBo[i].Direction == ParameterDirection.Output)
                    {
                        strResult = objListProcParameterBo[i].ParameterValue.ToString();
                    }
                }
            }

            catch (Exception ex)
            {
                ExceptionError.Error_Log(ex, "RejectJobWiseApplicant");
                strResult = "FAILED";
                throw ex;
            }
            return(strResult);
        }