public ActionResult ViewHRAllJob(int iJobPostingId) { HROfficeBAL objHROfficeBAL = new HROfficeBAL(); AllJobsBO objAllJobsBO = objHROfficeBAL.DisplayHRAllJob(iJobPostingId); return(PartialView("ViewHRJobs", objAllJobsBO)); }
public List <AllJobsBO> getHOPUpdateGridList() { DataSet objDataSet = null; AllJobsBO objAllJobsBO = null; List <AllJobsBO> objAllJobsBOList = new List <AllJobsBO>(); List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { objDataSet = objDBAccess.execuitDataSet(ProHOPUpdateGrid, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables.Count > 0) { for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { objAllJobsBO = new AllJobsBO(); objAllJobsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); objAllJobsBO.JobName = objDataSet.Tables[0].Rows[i][1].ToString(); objAllJobsBO.JobDescription = objDataSet.Tables[0].Rows[i][2].ToString(); objAllJobsBO.JobLocation = objDataSet.Tables[0].Rows[i][3].ToString(); objAllJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[i][4].ToString(); objAllJobsBO.Status = objDataSet.Tables[0].Rows[i][5].ToString(); objAllJobsBO.ApprovedBy = Convert.ToInt32(objDataSet.Tables[0].Rows[i][6].ToString()); objAllJobsBO.RejectedBy = Convert.ToInt32(objDataSet.Tables[0].Rows[i][7].ToString()); objAllJobsBO.HROffice_Comments = objDataSet.Tables[0].Rows[i][8].ToString(); objAllJobsBOList.Add(objAllJobsBO); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "getHOPUpdateGridList"); throw ex; } return(objAllJobsBOList); }
public ActionResult EditHROfficeGrid(AllJobsBO Data, int iJobPostingId) { HROfficeBAL objHROfficeBAL = new HROfficeBAL(); AllJobsBO objAllJobsBO = objHROfficeBAL.EditHROfficeGrid(iJobPostingId); objAllJobsBO.DonorProgrammList = objHROfficeBAL.GetDropDownDonorProgramList(Convert.ToInt32(ViewData["LoginUserId"])); return(PartialView("EditGrid", objAllJobsBO)); }
public JsonResult SaveOnHoldJob(AllJobsBO Data) { AllJobsBAL objAllJobsBAL = new AllJobsBAL(); string strRoleName = ViewData["LoginRoleName"].ToString().ToUpper(); string strResult = objAllJobsBAL.SaveOnHoldJob(Data, Convert.ToInt32(ViewData["LoginUserId"]), strRoleName); return(Json(strResult, JsonRequestBehavior.AllowGet)); }
public JsonResult SavePMApprovedJob(AllJobsBO Data) { PMUpdateBAL objPMUpdateBAL = new PMUpdateBAL(); Data.IsActive = true; string strResult = objPMUpdateBAL.SavePMApprovedJob(Data, Convert.ToInt32(ViewData["LoginUserId"])); return(Json(strResult, JsonRequestBehavior.AllowGet)); }
public ActionResult EditPMUpdateGrid(AllJobsBO Data, int iJobPostingId) { ApprovedJobsBAL objApprovedJobsBAL = new ApprovedJobsBAL(); AllJobsBAL objAllJobsBAL = new AllJobsBAL(); ApprovedJobsBO objJobsBO = objApprovedJobsBAL.DisplayApprovedJob(iJobPostingId); objJobsBO.DonorProgramList = objAllJobsBAL.DonorProgramList(Convert.ToInt32(ViewData["LoginUserId"])); return(PartialView("EditPMGrid", objJobsBO)); }
// GET: HROffice public ActionResult Index() { ViewBag.MainTitle = "All Jobs"; ViewBag.Title = "HR Office"; ViewBag.Icon = "fa fa-graduation"; AllJobsBO objAllJobsBO = new AllJobsBO(); return(View(objAllJobsBO)); }
public JsonResult SaveHRApprovedJob(AllJobsBO Data) { HROfficeBAL objHROfficeBAL = new HROfficeBAL(); Data.HRStatus = 1; Data.IsActive = true; string strResult = objHROfficeBAL.SaveHRApprovedJob(Data, Convert.ToInt32(ViewData["LoginUserId"]), 1); return(Json(strResult, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveHRRejectedJob(AllJobsBO Data) { HROfficeBAL objHROfficeBAL = new HROfficeBAL(); Data.StatusId = 3; Data.HRStatus = 2; Data.IsActive = true; string strResult = objHROfficeBAL.SaveHRRejectedJob(Data, 1); return(Json(strResult, JsonRequestBehavior.AllowGet)); }
public AllJobsBO EditPMGrid(int iJobPostingId) { DataSet objDataSet = null; AllJobsBO objAllJobsBO = null; List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { ProcParameterBO objDbParameter = new ProcParameterBO(); objDbParameter.Direction = ParameterDirection.Input; objDbParameter.ParameterName = "@iJobPostingId"; objDbParameter.dbType = DbType.Int32; objDbParameter.ParameterValue = iJobPostingId; objProcParameterBOList.Add(objDbParameter); objDataSet = objDBAccess.execuitDataSet(ProcEditPMJob, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0) { objAllJobsBO = new AllJobsBO(); objAllJobsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString()); objAllJobsBO.JobName = objDataSet.Tables[0].Rows[0][1].ToString(); objAllJobsBO.JobCode = objDataSet.Tables[0].Rows[0][2].ToString(); objAllJobsBO.JobDescription = objDataSet.Tables[0].Rows[0][3].ToString(); objAllJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[0][4].ToString(); objAllJobsBO.JobLocation = objDataSet.Tables[0].Rows[0][5].ToString(); objAllJobsBO.JobTimings = objDataSet.Tables[0].Rows[0][6].ToString(); objAllJobsBO.JobDuration = objDataSet.Tables[0].Rows[0][7].ToString(); objAllJobsBO.Qualification = objDataSet.Tables[0].Rows[0][8].ToString(); objAllJobsBO.Experience = objDataSet.Tables[0].Rows[0][9].ToString(); objAllJobsBO.Skills = objDataSet.Tables[0].Rows[0][10].ToString(); objAllJobsBO.Status = objDataSet.Tables[0].Rows[0][11].ToString(); objAllJobsBO.ApprovedById = objDataSet.Tables[0].Rows[0][12].ToString(); objAllJobsBO.ApprovedDate = objDataSet.Tables[0].Rows[0][13].ToString(); objAllJobsBO.RejectedById = objDataSet.Tables[0].Rows[0][14].ToString(); objAllJobsBO.RejectedDate = objDataSet.Tables[0].Rows[0][15].ToString(); objAllJobsBO.MarketedBy = objDataSet.Tables[0].Rows[0][16].ToString(); objAllJobsBO.MarketedDate = objDataSet.Tables[0].Rows[0][17].ToString(); objAllJobsBO.HROffice_Comments = objDataSet.Tables[0].Rows[0][18].ToString(); objAllJobsBO.HOP_Comments = objDataSet.Tables[0].Rows[0][19].ToString(); objAllJobsBO.PM_Comments = objDataSet.Tables[0].Rows[0][20].ToString(); objAllJobsBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][21].ToString()); objAllJobsBO.DonorProgramId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][22].ToString()); } } catch (Exception ex) { ExceptionError.Error_Log(ex, "EditPMGrid"); throw ex; } return(objAllJobsBO); }
public AllJobsBO DisplayPMAllJob(int iJobPostingId) { DataSet objDataSet = null; AllJobsBO objAllJobsBO = null; List <ProcParameterBO> ObjProcParameterBOList = new List <ProcParameterBO>(); try { ProcParameterBO objDbParameter = new ProcParameterBO(); objDbParameter.Direction = ParameterDirection.Input; objDbParameter.ParameterName = "@iJobPostingId"; objDbParameter.dbType = DbType.Int32; objDbParameter.ParameterValue = iJobPostingId; ObjProcParameterBOList.Add(objDbParameter); objDataSet = objDBAccess.execuitDataSet(ProcPMViewAllJob, ref ObjProcParameterBOList); if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0) { objAllJobsBO = new AllJobsBO(); objAllJobsBO.JobName = objDataSet.Tables[0].Rows[0][0].ToString(); objAllJobsBO.JobCode = objDataSet.Tables[0].Rows[0][1].ToString(); objAllJobsBO.JobDescription = objDataSet.Tables[0].Rows[0][2].ToString(); objAllJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[0][3].ToString(); objAllJobsBO.JobLocation = objDataSet.Tables[0].Rows[0][4].ToString(); objAllJobsBO.JobTimings = objDataSet.Tables[0].Rows[0][5].ToString(); objAllJobsBO.JobDuration = objDataSet.Tables[0].Rows[0][6].ToString(); objAllJobsBO.DonorProgramName = objDataSet.Tables[0].Rows[0][7].ToString(); objAllJobsBO.Qualification = objDataSet.Tables[0].Rows[0][8].ToString(); objAllJobsBO.Experience = objDataSet.Tables[0].Rows[0][9].ToString(); objAllJobsBO.Skills = objDataSet.Tables[0].Rows[0][10].ToString(); objAllJobsBO.Status = objDataSet.Tables[0].Rows[0][11].ToString(); objAllJobsBO.HROffice_Comments = objDataSet.Tables[0].Rows[0][12].ToString(); objAllJobsBO.HOP_Comments = objDataSet.Tables[0].Rows[0][13].ToString(); objAllJobsBO.PM_Comments = objDataSet.Tables[0].Rows[0][14].ToString(); } } catch (Exception ex) { ExceptionError.Error_Log(ex, "DisplayPMAllJob"); throw ex; } return(objAllJobsBO); }
public JsonResult SaveApprovedJob(AllJobsBO Data) { AllJobsBAL objAllJobsBAL = new AllJobsBAL(); int iRoleId = Convert.ToInt32(ViewData["LoginRoleId"]); string strResult = objAllJobsBAL.SaveApprovedJob(Data, Convert.ToInt32(ViewData["LoginUserId"]), iRoleId); if (ViewData["LoginRoleName"].ToString().ToUpper() == "HR OFFICE") { List <string> usersList = objAllJobsBAL.GetHOPPMHAFUsersList(); string strEmailBody = ""; if (usersList.Count > 0) { strEmailBody = getHROfficeEmailBodyforJobPosted(); CommonUtils.SendEmail(strSenderEmailAddress, usersList, "New Job Approval Request", strEmailBody); } } else if (ViewData["LoginRoleName"].ToString().ToUpper() == "HAF") { List <string> usersList = objAllJobsBAL.GetEDUsersList(); string strEmailBody = ""; if (usersList.Count > 0) { strEmailBody = getHAFEmailBodyforJobPosted(); CommonUtils.SendEmail(strSenderEmailAddress, usersList, "New Job Approval Request", strEmailBody); } } else if (ViewData["LoginRoleName"].ToString().ToUpper() == "ED") { List <string> usersList = objAllJobsBAL.GetMarketerUsersList(); string strEmailBody = ""; if (usersList.Count > 0) { strEmailBody = getEDEmailBodyforJobPosted(); CommonUtils.SendEmail(strSenderEmailAddress, usersList, "New Job Approval Request", strEmailBody); } } return(Json(strResult, JsonRequestBehavior.AllowGet)); }
public string SaveHRApprovedJob(AllJobsBO objAllJobsBO, int iUserId, int iStatusId) { return(objHROfficeDAL.SaveHRApprovedJob(objAllJobsBO, iUserId, iStatusId)); }
public string SaveApprovedJob(AllJobsBO objAllJobsBO, int iUserId, int iRoleId) { List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); ProcParameterBO objDBparameter = null; string strResult = ""; try { objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iRoleId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = iRoleId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iJobPostingId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.JobPostingId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobName"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobName; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobCode"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobCode; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobDescription"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobDescription; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iNoOfPositions"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.NoOfPositions; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobLocation"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobLocation; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobTimings"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobTimings; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobDuration"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobDuration; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strQualification"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.Qualification; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strExperience"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.Experience; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strSkills"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.Skills; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strComments"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.Comments; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iDonorProgrammId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.DonorProgramId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iRequiredStaffLevel"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.RequiredStaffLevel; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iCurrentStaffLevel"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.CurrentStaffLevel; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iGaps"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.Gaps; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iUserId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = iUserId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Output; objDBparameter.ParameterName = "@strResult"; objDBparameter.dbType = DbType.String; objDBparameter.Size = 100; objProcParameterBOList.Add(objDBparameter); objDBAccess.executeNonQuery(ProcSaveApprovedJob, ref objProcParameterBOList); for (int i = 0; i < objProcParameterBOList.Count; i++) { if (objProcParameterBOList[i].Direction == ParameterDirection.Output) { strResult = objProcParameterBOList[i].ParameterValue.ToString(); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "SaveApprovedJob"); strResult = "FAILED"; throw ex; } return(strResult); }
public string SaveHRRejectedJob(AllJobsBO objAllJobsBO, int iUserId) { List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); ProcParameterBO objDBparameter = null; string strResult = ""; try { objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iJobPostingId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.JobPostingId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobName"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobName; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobCode"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobCode; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobDescription"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobDescription; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iNoOfPositions"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.NoOfPositions; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iDonorProgramId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.DonorProgramId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobLocation"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobLocation; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobTimings"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobTimings; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobDuration"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.JobDuration; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strQualification"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.Qualification; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strExperience"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.Experience; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strSkills"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.Skills; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strStatusId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.StatusId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@ApprovedDate"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.ApprovedDate; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iRejectedBy"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.RejectedBy; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@RejectedDate"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.RejectedDate; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iMarketedBy"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.MarketedBy; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@MarketedDate"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.MarketedDate; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strHROffice_Comments"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.HROffice_Comments; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iHRStatus"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.HRStatus; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@bIsActive"; objDBparameter.dbType = DbType.Boolean; objDBparameter.ParameterValue = objAllJobsBO.IsActive; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iUserId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = iUserId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Output; objDBparameter.ParameterName = "@strResult"; objDBparameter.dbType = DbType.String; objDBparameter.Size = 100; objProcParameterBOList.Add(objDBparameter); objDBAccess.executeNonQuery(ProcHRRejectedJob, ref objProcParameterBOList); for (int i = 0; i < objProcParameterBOList.Count; i++) { if (objProcParameterBOList[i].Direction == ParameterDirection.Output) { strResult = objProcParameterBOList[i].ParameterValue.ToString(); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "SaveHRRejectedJob"); strResult = "FAILED"; throw ex; } return(strResult); }
public string SavePMApprovedJob(AllJobsBO objAllJobsBO, int iUserId) { List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); ProcParameterBO objDBparameter = null; string strResult = ""; try { objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iJobPostingId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objAllJobsBO.JobPostingId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strPM_Comments"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objAllJobsBO.PM_Comments; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@bIsActive"; objDBparameter.dbType = DbType.Boolean; objDBparameter.ParameterValue = objAllJobsBO.IsActive; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iUserId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = iUserId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Output; objDBparameter.ParameterName = "@strResult"; objDBparameter.dbType = DbType.String; objDBparameter.Size = 100; objProcParameterBOList.Add(objDBparameter); objDBAccess.executeNonQuery(ProcSavePMApprovedJob, ref objProcParameterBOList); for (int i = 0; i < objProcParameterBOList.Count; i++) { if (objProcParameterBOList[i].Direction == ParameterDirection.Output) { strResult = objProcParameterBOList[i].ParameterValue.ToString(); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "SavePMApprovedJob"); strResult = "FAILED"; throw ex; } return(strResult); }
public string SaveHRRejectedJob(AllJobsBO objAllJobsBO, int iUserId) { return(objHROfficeDAL.SaveHRRejectedJob(objAllJobsBO, iUserId)); }
public string SaveOnHoldJob(AllJobsBO objAllJobsBO, int iUserId, string strRoleName) { return(objAllJobsDAL.SaveOnHoldJob(objAllJobsBO, iUserId, strRoleName)); }
public string SaveHOPApprovedJob(AllJobsBO objAllJobsBO, int iUserId) { return(objHOPUpdateDAL.SaveHOPApprovedJob(objAllJobsBO, iUserId)); }
public string SaveRejectedJob(AllJobsBO objAllJobsBO, int iUserId, int iRoleId) { return(objAllJobsDAL.SaveRejectedJob(objAllJobsBO, iUserId, iRoleId)); }