// GET: ShortListDetailsList public ActionResult Index() { ViewBag.MainTitle = "Short List Details"; ViewBag.Title = "Short List details"; ViewBag.Icon = "fa fa-user"; ShortListDetailsListBO objShortListDetailsListBO = new ShortListDetailsListBO(); ShortListDetailsListBAL objShortListDetailsListBAL = new ShortListDetailsListBAL(); objShortListDetailsListBO.JobList = objShortListDetailsListBAL.GetJobTypeList(); return(View(objShortListDetailsListBO)); }
public List <ShortListDetailsListBO> getShortListDetailsList(int iJobId) { DataSet objDataSet = null; ShortListDetailsListBO objShortListDetailsListBO = null; List <ShortListDetailsListBO> objShortListDetailsBOList = new List <ShortListDetailsListBO>(); 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(ProcGetShortListDetailsList, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables.Count > 0) { for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { objShortListDetailsListBO = new ShortListDetailsListBO(); objShortListDetailsListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); objShortListDetailsListBO.FullName = objDataSet.Tables[0].Rows[i][1].ToString(); objShortListDetailsListBO.AcademicQualification = objDataSet.Tables[0].Rows[i][2].ToString(); objShortListDetailsListBO.PhoneNumber = objDataSet.Tables[0].Rows[i][3].ToString(); objShortListDetailsListBO.EmailAddress = objDataSet.Tables[0].Rows[i][4].ToString(); objShortListDetailsListBO.MotherTongue = objDataSet.Tables[0].Rows[i][5].ToString(); objShortListDetailsListBO.DateOfBirth = objDataSet.Tables[0].Rows[i][6].ToString(); objShortListDetailsListBO.Gender = objDataSet.Tables[0].Rows[i][7].ToString(); objShortListDetailsListBO.DonorProgram = objDataSet.Tables[0].Rows[i][8].ToString(); objShortListDetailsListBO.ProfessionalBodyName = objDataSet.Tables[0].Rows[i][9].ToString(); objShortListDetailsListBO.MembershipNumber = objDataSet.Tables[0].Rows[i][10].ToString(); objShortListDetailsListBO.Validity = objDataSet.Tables[0].Rows[i][11].ToString(); objShortListDetailsListBO.Subject = objDataSet.Tables[0].Rows[i][12].ToString(); objShortListDetailsListBO.Status = objDataSet.Tables[0].Rows[i][13].ToString(); objShortListDetailsBOList.Add(objShortListDetailsListBO); //objShortListDetailsListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); //objShortListDetailsListBO.FullName = objDataSet.Tables[0].Rows[i][1].ToString(); //objShortListDetailsListBO.PhoneNumber = objDataSet.Tables[0].Rows[i][2].ToString(); //objShortListDetailsListBO.EmailAddress = objDataSet.Tables[0].Rows[i][3].ToString(); //objShortListDetailsListBO.Address = objDataSet.Tables[0].Rows[i][4].ToString(); //objShortListDetailsListBO.Status = objDataSet.Tables[0].Rows[i][5].ToString(); //objShortListDetailsListBO.DonorProgram = objDataSet.Tables[0].Rows[i][6].ToString(); //objShortListDetailsListBO.RequiredStaffLevel = objDataSet.Tables[0].Rows[i][7].ToString(); //objShortListDetailsListBO.CurrentStaffLevel = objDataSet.Tables[0].Rows[i][8].ToString(); //objShortListDetailsListBO.Gaps = objDataSet.Tables[0].Rows[i][9].ToString(); //objShortListDetailsListBO.HOD_Comments = objDataSet.Tables[0].Rows[i][10].ToString(); //objShortListDetailsListBO.JobLocation = objDataSet.Tables[0].Rows[i][11].ToString(); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "getShortListDetailsList"); throw ex; } return(objShortListDetailsBOList); }