public ActionResult Index() { ViewBag.MainTitle = "Apply Jobs"; ViewBag.Title = "Jobs"; JobStatusBO objJobStatusBo = new JobStatusBO(); return(View(objJobStatusBo)); }
public List <JobStatusBO> GetAllApplicantsJobList(int iApplicantId) { DataSet objDataSet = null; JobStatusBO objJobStatusBo = null; List <JobStatusBO> objListJobStatusBo = new List <JobStatusBO>(); List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { ProcParameterBO objProcParameterBo = new ProcParameterBO(); objProcParameterBo.Direction = ParameterDirection.Input; objProcParameterBo.ParameterName = "@iApplicantId"; objProcParameterBo.dbType = DbType.Int32; objProcParameterBo.ParameterValue = iApplicantId; objProcParameterBOList.Add(objProcParameterBo); objDataSet = objDBAccess.execuitDataSet(ProcGetAllApplicantsList, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables.Count > 0) { for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { objJobStatusBo = new JobStatusBO(); objJobStatusBo.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); objJobStatusBo.FullName = objDataSet.Tables[0].Rows[i][1].ToString(); objJobStatusBo.PhoneNumber = objDataSet.Tables[0].Rows[i][2].ToString(); objJobStatusBo.EmailAddress = objDataSet.Tables[0].Rows[i][3].ToString(); objJobStatusBo.Address = objDataSet.Tables[0].Rows[i][4].ToString(); objJobStatusBo.StatusId = objDataSet.Tables[0].Rows[i][5].ToString(); objJobStatusBo.Comments = objDataSet.Tables[0].Rows[i][6].ToString(); objListJobStatusBo.Add(objJobStatusBo); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "GetAllApplicantsJobList"); throw ex; } return(objListJobStatusBo); }