public JsonResult RejectJobWiseApplicant(JobApplicantModelBO Data)
{
JobApplicantBAL obJobApplicantBAL = new JobApplicantBAL();
string strResult = obJobApplicantBAL.RejectJobWiseApplicant(Data, Convert.ToInt32(ViewData["LoginUserId"]));
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
ViewBag.Title = "Applicants";
ViewBag.MainTitle = "Job Wise Applicant";
JobApplicantModelBO objJobApplicantModelBo = new JobApplicantModelBO();
JobApplicantBAL obJobApplicantBAL = new JobApplicantBAL();
objJobApplicantModelBo.JobList = obJobApplicantBAL.GetJobTypeList();
return(View(objJobApplicantModelBo));
}
public ActionResult ViewJobApplicants(int A_iApplicantJobId)
{
JobApplicantBAL obJobApplicantBAL = new JobApplicantBAL();
JobApplicantModelBO objJobApplicantModelBo = obJobApplicantBAL.ViewAllApplicants(A_iApplicantJobId);
if (objJobApplicantModelBo.PhotoSavedName != "" && objJobApplicantModelBo.PhotoSavedName != null)
{
ViewBag.ImagePath = Url.Content(strDownLoadPhoto + objJobApplicantModelBo.PhotoSavedName);
}
else
{
ViewBag.ImagePath = Url.Content("../assets/images/user-1.png");
}
return(PartialView("_JobWiseApplicantList", objJobApplicantModelBo));
}
public List <JobApplicantModelBO> GetJobApplicantList(int iJobId)
{
DataSet objDataSet = null;
JobApplicantModelBO objJobApplicantModelBo = null;
List <JobApplicantModelBO> objListJobApplicantModelBo = new List <JobApplicantModelBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objProcParameterBo = new ProcParameterBO();
objProcParameterBo.Direction = ParameterDirection.Input;
objProcParameterBo.ParameterName = "@iJobId";
objProcParameterBo.dbType = DbType.Int32;
objProcParameterBo.ParameterValue = iJobId;
objProcParameterBOList.Add(objProcParameterBo);
objDataSet = objDBAccess.execuitDataSet(ProcGetJobApplicantList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objJobApplicantModelBo = new JobApplicantModelBO();
objJobApplicantModelBo.ApplicantJobId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objJobApplicantModelBo.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][1].ToString());
objJobApplicantModelBo.Applicantname = objDataSet.Tables[0].Rows[i][2].ToString();
objJobApplicantModelBo.Gender = objDataSet.Tables[0].Rows[i][3].ToString();
objJobApplicantModelBo.DateOfBirth = objDataSet.Tables[0].Rows[i][4].ToString();
objJobApplicantModelBo.PhoneNumber = objDataSet.Tables[0].Rows[i][5].ToString();
objJobApplicantModelBo.JobName = objDataSet.Tables[0].Rows[i][6].ToString();
objJobApplicantModelBo.Status = objDataSet.Tables[0].Rows[i][7].ToString();
objListJobApplicantModelBo.Add(objJobApplicantModelBo);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "GetJobApplicantList");
throw ex;
}
return(objListJobApplicantModelBo);
}
public string RejectJobWiseApplicant(JobApplicantModelBO objJobApplicantModelBo, int iUserId)
{
return(objJobApplicantDAL.RejectJobWiseApplicant(objJobApplicantModelBo, iUserId));
}
public string UpdateJobWiseApplicant(JobApplicantModelBO objJobApplicantModelBo, int iUserId)
{
return(objJobApplicantDAL.UpdateJobWiseApplicant(objJobApplicantModelBo, iUserId));
}
public JobApplicantModelBO ViewAllApplicants(int iApplicantJobId)
{
DataSet objDataSet = null;
JobApplicantModelBO objJobApplicantModelBO = null;
ApplicantRelationBO objApplicantRelationBO = null;
LanguageSpokenBO objLanguageSpokenBO = null;
ApplicantQualificationBO objApplicantQualificationBO = null;
ApplicantEmploymentHistoryBO objApplicantEmploymentHistoryBO = null;
ApplicantRefereesBO objApplicantRefereesBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iAppliedJobId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iApplicantJobId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcViewAllApplicants, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objJobApplicantModelBO = new JobApplicantModelBO();
objJobApplicantModelBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objJobApplicantModelBO.Title = objDataSet.Tables[0].Rows[0][1].ToString();
objJobApplicantModelBO.FirstName = objDataSet.Tables[0].Rows[0][2].ToString();
objJobApplicantModelBO.MiddleName = objDataSet.Tables[0].Rows[0][3].ToString();
objJobApplicantModelBO.LastName = objDataSet.Tables[0].Rows[0][4].ToString();
objJobApplicantModelBO.DateOfBirth = objDataSet.Tables[0].Rows[0][5].ToString();
objJobApplicantModelBO.Gender = objDataSet.Tables[0].Rows[0][6].ToString();
objJobApplicantModelBO.IdType = objDataSet.Tables[0].Rows[0][7].ToString();
objJobApplicantModelBO.CitizenShipIdCopy = objDataSet.Tables[0].Rows[0][8].ToString();
objJobApplicantModelBO.CitizenShipIdCopySavedName = objDataSet.Tables[0].Rows[0][9].ToString();
objJobApplicantModelBO.Country = objDataSet.Tables[0].Rows[0][10].ToString();
objJobApplicantModelBO.EmailAddress = objDataSet.Tables[0].Rows[0][11].ToString();
objJobApplicantModelBO.PhoneNumber = objDataSet.Tables[0].Rows[0][12].ToString();
objJobApplicantModelBO.AlternativePhoneNumber = objDataSet.Tables[0].Rows[0][13].ToString();
objJobApplicantModelBO.MotherTongue = objDataSet.Tables[0].Rows[0][14].ToString();
objJobApplicantModelBO.Nationality = objDataSet.Tables[0].Rows[0][15].ToString();
objJobApplicantModelBO.County = objDataSet.Tables[0].Rows[0][16].ToString();
objJobApplicantModelBO.ApplicationLetter = objDataSet.Tables[0].Rows[0][17].ToString();
objJobApplicantModelBO.ApplicationLetterSavedName = objDataSet.Tables[0].Rows[0][18].ToString();
objJobApplicantModelBO.CV = objDataSet.Tables[0].Rows[0][19].ToString();
objJobApplicantModelBO.CVSavedName = objDataSet.Tables[0].Rows[0][20].ToString();
objJobApplicantModelBO.SpecialNeed = objDataSet.Tables[0].Rows[0][21].ToString();
objJobApplicantModelBO.SpecialNeedDetails = objDataSet.Tables[0].Rows[0][22].ToString();
objJobApplicantModelBO.Address = objDataSet.Tables[0].Rows[0][23].ToString();
objJobApplicantModelBO.Photo = objDataSet.Tables[0].Rows[0][24].ToString();
objJobApplicantModelBO.PhotoSavedName = objDataSet.Tables[0].Rows[0][25].ToString();
objJobApplicantModelBO.ApplicantJobId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][26].ToString());
objJobApplicantModelBO.Status = objDataSet.Tables[0].Rows[0][27].ToString();
if (objDataSet != null && objDataSet.Tables[1].Rows.Count > 0)
{
objJobApplicantModelBO.ApplicantRelationList = new List <ApplicantRelationBO>();
for (int i = 0; i < objDataSet.Tables[1].Rows.Count; i++)
{
objApplicantRelationBO = new ApplicantRelationBO();
objApplicantRelationBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[1].Rows[i][0].ToString());
objApplicantRelationBO.RelationId = Convert.ToInt32(objDataSet.Tables[1].Rows[i][1].ToString());
objApplicantRelationBO.AnyoneWorkinWIK = objDataSet.Tables[1].Rows[i][2].ToString();
objApplicantRelationBO.RelativeName = objDataSet.Tables[1].Rows[i][3].ToString();
objApplicantRelationBO.Relationship = objDataSet.Tables[1].Rows[i][4].ToString();
objJobApplicantModelBO.ApplicantRelationList.Add(objApplicantRelationBO);
}
}
if (objDataSet != null && objDataSet.Tables[2].Rows.Count > 0)
{
objJobApplicantModelBO.ApplicantLanguageList = new List <LanguageSpokenBO>();
for (int i = 0; i < objDataSet.Tables[2].Rows.Count; i++)
{
objLanguageSpokenBO = new LanguageSpokenBO();
objLanguageSpokenBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[2].Rows[i][0].ToString());
objLanguageSpokenBO.LanguageSpokenId = Convert.ToInt32(objDataSet.Tables[2].Rows[i][1].ToString());
objLanguageSpokenBO.Language = objDataSet.Tables[2].Rows[i][2].ToString();
objLanguageSpokenBO.LanguageRead = objDataSet.Tables[2].Rows[i][3].ToString();
objLanguageSpokenBO.Write = objDataSet.Tables[2].Rows[i][4].ToString();
objLanguageSpokenBO.Speak = objDataSet.Tables[2].Rows[i][5].ToString();
objLanguageSpokenBO.Understand = objDataSet.Tables[2].Rows[i][6].ToString();
objJobApplicantModelBO.ApplicantLanguageList.Add(objLanguageSpokenBO);
}
}
if (objDataSet != null && objDataSet.Tables[3].Rows.Count > 0)
{
objJobApplicantModelBO.ApplicantQualificationList = new List <ApplicantQualificationBO>();
for (int i = 0; i < objDataSet.Tables[3].Rows.Count; i++)
{
objApplicantQualificationBO = new ApplicantQualificationBO();
objApplicantQualificationBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[3].Rows[i][0].ToString());
objApplicantQualificationBO.ApplicantQualificationId = Convert.ToInt32(objDataSet.Tables[3].Rows[i][1].ToString());
objApplicantQualificationBO.AcademicQualification = objDataSet.Tables[3].Rows[i][2].ToString();
objApplicantQualificationBO.AcademicQualificationAttachment = objDataSet.Tables[3].Rows[i][3].ToString();
objApplicantQualificationBO.AttachmentSavedName = objDataSet.Tables[3].Rows[i][4].ToString();
objApplicantQualificationBO.StartDate = objDataSet.Tables[3].Rows[i][5].ToString();
objApplicantQualificationBO.EndDate = objDataSet.Tables[3].Rows[i][6].ToString();
objApplicantQualificationBO.Discipline = objDataSet.Tables[3].Rows[i][7].ToString();
objApplicantQualificationBO.University = objDataSet.Tables[3].Rows[i][8].ToString();
objApplicantQualificationBO.CreditScoreClass = objDataSet.Tables[3].Rows[i][9].ToString();
objJobApplicantModelBO.ApplicantQualificationList.Add(objApplicantQualificationBO);
}
}
if (objDataSet != null && objDataSet.Tables[4].Rows.Count > 0)
{
objJobApplicantModelBO.ApplicantEmploymentList = new List <ApplicantEmploymentHistoryBO>();
for (int i = 0; i < objDataSet.Tables[4].Rows.Count; i++)
{
objApplicantEmploymentHistoryBO = new ApplicantEmploymentHistoryBO();
objApplicantEmploymentHistoryBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[4].Rows[i][0].ToString());
objApplicantEmploymentHistoryBO.EmploymentHistoryId = Convert.ToInt32(objDataSet.Tables[4].Rows[i][1].ToString());
objApplicantEmploymentHistoryBO.EmployerName = objDataSet.Tables[4].Rows[i][2].ToString();
objApplicantEmploymentHistoryBO.TypeOfIndustry = objDataSet.Tables[4].Rows[i][3].ToString();
objApplicantEmploymentHistoryBO.JobTitle = objDataSet.Tables[4].Rows[i][4].ToString();
objApplicantEmploymentHistoryBO.EmpStartDate = objDataSet.Tables[4].Rows[i][5].ToString();
objApplicantEmploymentHistoryBO.EmpEndDate = objDataSet.Tables[4].Rows[i][6].ToString();
objApplicantEmploymentHistoryBO.Responsibility = objDataSet.Tables[4].Rows[i][7].ToString();
objApplicantEmploymentHistoryBO.NoticePeriod = objDataSet.Tables[4].Rows[i][8].ToString();
objApplicantEmploymentHistoryBO.Reasonforleaving = objDataSet.Tables[4].Rows[i][9].ToString();
objJobApplicantModelBO.ApplicantEmploymentList.Add(objApplicantEmploymentHistoryBO);
}
}
if (objDataSet != null && objDataSet.Tables[5].Rows.Count > 0)
{
objJobApplicantModelBO.ApplicantRefereesList = new List <ApplicantRefereesBO>();
for (int i = 0; i < objDataSet.Tables[5].Rows.Count; i++)
{
objApplicantRefereesBO = new ApplicantRefereesBO();
objApplicantRefereesBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[5].Rows[i][0].ToString());
objApplicantRefereesBO.RefereesId = Convert.ToInt32(objDataSet.Tables[5].Rows[i][1].ToString());
objApplicantRefereesBO.EmpFirstName = objDataSet.Tables[5].Rows[i][2].ToString();
objApplicantRefereesBO.SecondName = objDataSet.Tables[5].Rows[i][3].ToString();
objApplicantRefereesBO.Position = objDataSet.Tables[5].Rows[i][4].ToString();
objApplicantRefereesBO.RelationshipTOApplicant = objDataSet.Tables[5].Rows[i][5].ToString();
objApplicantRefereesBO.NameOfTheOrganization = objDataSet.Tables[5].Rows[i][6].ToString();
objApplicantRefereesBO.TelephoneContact = objDataSet.Tables[5].Rows[i][7].ToString();
objApplicantRefereesBO.EmpEmailAddress = objDataSet.Tables[5].Rows[i][8].ToString();
objJobApplicantModelBO.ApplicantRefereesList.Add(objApplicantRefereesBO);
}
}
if (objDataSet != null && objDataSet.Tables[6].Rows.Count > 0)
{
objJobApplicantModelBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[6].Rows[0][0].ToString());
objJobApplicantModelBO.ApplicantMotivationId = Convert.ToInt32(objDataSet.Tables[6].Rows[0][1].ToString());
objJobApplicantModelBO.MembershipData = objDataSet.Tables[6].Rows[0][2].ToString();
objJobApplicantModelBO.NameofProfessionalBody = objDataSet.Tables[6].Rows[0][3].ToString();
objJobApplicantModelBO.MembershipNumber = objDataSet.Tables[6].Rows[0][4].ToString();
objJobApplicantModelBO.ValidityData = objDataSet.Tables[6].Rows[0][5].ToString();
objJobApplicantModelBO.JobDescription = objDataSet.Tables[6].Rows[0][6].ToString();
objJobApplicantModelBO.Referer = objDataSet.Tables[6].Rows[0][7].ToString();
objJobApplicantModelBO.ApplicationNote = objDataSet.Tables[6].Rows[0][8].ToString();
}
if (objDataSet != null && objDataSet.Tables[7].Rows.Count > 0)
{
objJobApplicantModelBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[7].Rows[0][0].ToString());
objJobApplicantModelBO.TerminatedId = objDataSet.Tables[7].Rows[0][1].ToString();
objJobApplicantModelBO.Terminatation = objDataSet.Tables[7].Rows[0][2].ToString();
objJobApplicantModelBO.MisconductId = objDataSet.Tables[7].Rows[0][3].ToString();
objJobApplicantModelBO.Misconduct = objDataSet.Tables[7].Rows[0][4].ToString();
objJobApplicantModelBO.ManagementId = objDataSet.Tables[7].Rows[0][5].ToString();
objJobApplicantModelBO.Management = objDataSet.Tables[7].Rows[0][6].ToString();
objJobApplicantModelBO.InvestigationId = objDataSet.Tables[7].Rows[0][7].ToString();
objJobApplicantModelBO.Investigation = objDataSet.Tables[7].Rows[0][8].ToString();
objJobApplicantModelBO.CriminalOffenceId = objDataSet.Tables[7].Rows[0][9].ToString();
objJobApplicantModelBO.CriminalOffence = objDataSet.Tables[7].Rows[0][10].ToString();
objJobApplicantModelBO.ConvictionsId = objDataSet.Tables[7].Rows[0][11].ToString();
objJobApplicantModelBO.Convictions = objDataSet.Tables[7].Rows[0][12].ToString();
objJobApplicantModelBO.CorruptionId = objDataSet.Tables[7].Rows[0][13].ToString();
objJobApplicantModelBO.Corruption = objDataSet.Tables[7].Rows[0][14].ToString();
objJobApplicantModelBO.DisciplinaryId = objDataSet.Tables[7].Rows[0][15].ToString();
objJobApplicantModelBO.Disciplinary = objDataSet.Tables[7].Rows[0][16].ToString();
objJobApplicantModelBO.RelationToChildId = objDataSet.Tables[7].Rows[0][17].ToString();
objJobApplicantModelBO.RelationToChild = objDataSet.Tables[7].Rows[0][18].ToString();
objJobApplicantModelBO.RelationToAdultId = objDataSet.Tables[7].Rows[0][19].ToString();
objJobApplicantModelBO.RelationToAdult = objDataSet.Tables[7].Rows[0][20].ToString();
objJobApplicantModelBO.RelativeId = objDataSet.Tables[7].Rows[0][21].ToString();
objJobApplicantModelBO.DealingsWithWIKId = objDataSet.Tables[7].Rows[0][22].ToString();
objJobApplicantModelBO.DealingsWithWIK = objDataSet.Tables[7].Rows[0][23].ToString();
objJobApplicantModelBO.Declarationinfo = Convert.ToBoolean(objDataSet.Tables[7].Rows[0][24].ToString());
objJobApplicantModelBO.Statement = Convert.ToBoolean(objDataSet.Tables[7].Rows[0][25].ToString());
objJobApplicantModelBO.DeclarationID = Convert.ToInt32(objDataSet.Tables[7].Rows[0][26].ToString());
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "ViewAllApplicants");
throw ex;
}
return(objJobApplicantModelBO);
}
public string RejectJobWiseApplicant(JobApplicantModelBO objJobApplicantModelBo, int iUserId)
{
ProcParameterBO objDbParameter = null;
List <ProcParameterBO> objListProcParameterBo = new List <ProcParameterBO>();
string strResult = "";
try
{
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iAppliedJobId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = objJobApplicantModelBo.ApplicantJobId;
objListProcParameterBo.Add(objDbParameter);
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iApplicantId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = objJobApplicantModelBo.ApplicantId;
objListProcParameterBo.Add(objDbParameter);
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@strComments";
objDbParameter.dbType = DbType.String;
objDbParameter.ParameterValue = objJobApplicantModelBo.StatusComments;
objListProcParameterBo.Add(objDbParameter);
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iUserId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iUserId;
objListProcParameterBo.Add(objDbParameter);
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Output;
objDbParameter.ParameterName = "@strResult";
objDbParameter.dbType = DbType.String;
objDbParameter.Size = 100;
objListProcParameterBo.Add(objDbParameter);
objDBAccess.executeNonQuery(PrcoRejectJobApplicant, ref objListProcParameterBo);
for (int i = 0; i < objListProcParameterBo.Count; i++)
{
if (objListProcParameterBo[i].Direction == ParameterDirection.Output)
{
strResult = objListProcParameterBo[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "RejectJobWiseApplicant");
strResult = "FAILED";
throw ex;
}
return(strResult);
}