// GET: ApplicantsList
public ActionResult Index()
{
ViewBag.MainTitle = "ApplicantsList";
ViewBag.Title = "Applicants";
ViewBag.Icon = "fa fa-user";
ApplicantsListBO objApplicantsListBO = new ApplicantsListBO();
ApplicantsListBAL objApplicantsListBAL = new ApplicantsListBAL();
objApplicantsListBO.JobList = objApplicantsListBAL.GetJobTypeList();
return(View(objApplicantsListBO));
}
public List <ApplicantsListBO> getApplicantsList(int iJobId)
{
DataSet objDataSet = null;
ApplicantsListBO objApplicantsListBO = null;
List <ApplicantsListBO> objApplicantsBOList = new List <ApplicantsListBO>();
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(ProcGetApplicantsList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objApplicantsListBO = new ApplicantsListBO();
objApplicantsListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objApplicantsListBO.FullName = objDataSet.Tables[0].Rows[i][1].ToString();
objApplicantsListBO.AcademicQualification = objDataSet.Tables[0].Rows[i][2].ToString();
objApplicantsListBO.PhoneNumber = objDataSet.Tables[0].Rows[i][3].ToString();
objApplicantsListBO.EmailAddress = objDataSet.Tables[0].Rows[i][4].ToString();
objApplicantsListBO.MotherTongue = objDataSet.Tables[0].Rows[i][5].ToString();
objApplicantsListBO.DateOfBirth = objDataSet.Tables[0].Rows[i][6].ToString();
objApplicantsListBO.Gender = objDataSet.Tables[0].Rows[i][7].ToString();
objApplicantsListBO.DonorProgram = objDataSet.Tables[0].Rows[i][8].ToString();
objApplicantsListBO.ProfessionalBodyName = objDataSet.Tables[0].Rows[i][9].ToString();
objApplicantsListBO.MembershipNumber = objDataSet.Tables[0].Rows[i][10].ToString();
objApplicantsListBO.Validity = objDataSet.Tables[0].Rows[i][11].ToString();
objApplicantsListBO.Subject = objDataSet.Tables[0].Rows[i][12].ToString();
objApplicantsListBO.Status = objDataSet.Tables[0].Rows[i][13].ToString();
objApplicantsBOList.Add(objApplicantsListBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApplicantsList");
throw ex;
}
return(objApplicantsBOList);
}