// GET: SelectedApplicantsList public ActionResult Index() { ViewBag.MainTitle = "Selected Applicants List"; ViewBag.Title = "Selected Applicants List"; ViewBag.Icon = "fa fa-user"; SelectedApplicantsListBO objSelectedApplicantsListBO = new SelectedApplicantsListBO(); SelectedApplicantsListBAL objSelectedApplicantsListBAL = new SelectedApplicantsListBAL(); objSelectedApplicantsListBO.JobList = objSelectedApplicantsListBAL.GetJobTypeList(); return(View(objSelectedApplicantsListBO)); }
public List <SelectedApplicantsListBO> getSelectedApplicantsList(int iJobId) { DataSet objDataSet = null; SelectedApplicantsListBO objSelectedApplicantsListBO = null; List <SelectedApplicantsListBO> objSelectedApplicantsBOList = new List <SelectedApplicantsListBO>(); List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); try { ProcParameterBO objDbParameter = new ProcParameterBO(); objDbParameter.Direction = ParameterDirection.Input; objDbParameter.ParameterName = "@iJobId"; objDbParameter.dbType = DbType.Int32; objDbParameter.ParameterValue = iJobId; objProcParameterBOList.Add(objDbParameter); objDataSet = objDBAccess.execuitDataSet(ProcGetSelectedApplicantsDetailsList, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables.Count > 0) { for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { objSelectedApplicantsListBO = new SelectedApplicantsListBO(); objSelectedApplicantsListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); objSelectedApplicantsListBO.FullName = objDataSet.Tables[0].Rows[i][1].ToString(); objSelectedApplicantsListBO.AcademicQualification = objDataSet.Tables[0].Rows[i][2].ToString(); objSelectedApplicantsListBO.PhoneNumber = objDataSet.Tables[0].Rows[i][3].ToString(); objSelectedApplicantsListBO.EmailAddress = objDataSet.Tables[0].Rows[i][4].ToString(); objSelectedApplicantsListBO.MotherTongue = objDataSet.Tables[0].Rows[i][5].ToString(); objSelectedApplicantsListBO.DateOfBirth = objDataSet.Tables[0].Rows[i][6].ToString(); objSelectedApplicantsListBO.Gender = objDataSet.Tables[0].Rows[i][7].ToString(); objSelectedApplicantsListBO.DonorProgram = objDataSet.Tables[0].Rows[i][8].ToString(); objSelectedApplicantsListBO.ProfessionalBodyName = objDataSet.Tables[0].Rows[i][9].ToString(); objSelectedApplicantsListBO.MembershipNumber = objDataSet.Tables[0].Rows[i][10].ToString(); objSelectedApplicantsListBO.Validity = objDataSet.Tables[0].Rows[i][11].ToString(); objSelectedApplicantsListBO.Subject = objDataSet.Tables[0].Rows[i][12].ToString(); objSelectedApplicantsListBO.Status = objDataSet.Tables[0].Rows[i][13].ToString(); objSelectedApplicantsBOList.Add(objSelectedApplicantsListBO); //objSelectedApplicantsListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); //objSelectedApplicantsListBO.FullName = objDataSet.Tables[0].Rows[i][1].ToString(); //objSelectedApplicantsListBO.PhoneNumber = objDataSet.Tables[0].Rows[i][2].ToString(); //objSelectedApplicantsListBO.EmailAddress = objDataSet.Tables[0].Rows[i][3].ToString(); //objSelectedApplicantsListBO.Address = objDataSet.Tables[0].Rows[i][4].ToString(); //objSelectedApplicantsListBO.Status = objDataSet.Tables[0].Rows[i][5].ToString(); //objSelectedApplicantsListBO.DonorProgram = objDataSet.Tables[0].Rows[i][6].ToString(); //objSelectedApplicantsListBO.RequiredStaffLevel = objDataSet.Tables[0].Rows[i][7].ToString(); //objSelectedApplicantsListBO.CurrentStaffLevel = objDataSet.Tables[0].Rows[i][8].ToString(); //objSelectedApplicantsListBO.Gaps = objDataSet.Tables[0].Rows[i][9].ToString(); //objSelectedApplicantsListBO.HOD_Comments = objDataSet.Tables[0].Rows[i][10].ToString(); //objSelectedApplicantsListBO.JobLocation = objDataSet.Tables[0].Rows[i][11].ToString(); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "getSelectedApplicantsList"); throw ex; } return(objSelectedApplicantsBOList); }