public ActionResult Index()
{
ViewBag.Title = "Applicants";
ViewBag.MainTitle = "Rejected Applicants";
ViewBag.Icon = "fa fa-user";
RejectedApplicantsBO objRejectedApplicantsBO = new RejectedApplicantsBO();
RejectedApplicantsBAL objRejectedApplicantsBAL = new RejectedApplicantsBAL();
objRejectedApplicantsBO.JobList = objRejectedApplicantsBAL.GetJobTypeList();
return(View(objRejectedApplicantsBO));
}
public ActionResult ViewRejectedApplicants(int iApplicantId, int iJobPostingId)
{
RejectedApplicantsBAL objRejectedApplicantsBAL = new RejectedApplicantsBAL();
RejectedApplicantsBO objRejectedApplicantsBO = objRejectedApplicantsBAL.DisplayRejectedApplicant(iApplicantId, iJobPostingId);
if (objRejectedApplicantsBO.PhotoSavedName != "" && objRejectedApplicantsBO.PhotoSavedName != null)
{
ViewBag.ImagePath = Url.Content(strDownLoadPhoto + objRejectedApplicantsBO.PhotoSavedName);
}
else
{
ViewBag.ImagePath = Url.Content("../assets/images/user-1.png");
}
return(PartialView("_ViewRejectedApplicant", objRejectedApplicantsBO));
}
public List <RejectedApplicantsBO> getRejectedApplicantsList(int iJobId)
{
DataSet objDataSet = null;
RejectedApplicantsBO objRejectedApplicantsBO = null;
List <RejectedApplicantsBO> objRejectedApplicantsBOList = new List <RejectedApplicantsBO>();
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(ProcRejectedApplicantsList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objRejectedApplicantsBO = new RejectedApplicantsBO();
objRejectedApplicantsBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objRejectedApplicantsBO.ApplicantName = objDataSet.Tables[0].Rows[i][1].ToString();
objRejectedApplicantsBO.PhoneNumber = objDataSet.Tables[0].Rows[i][2].ToString();
objRejectedApplicantsBO.EmailAddress = objDataSet.Tables[0].Rows[i][3].ToString();
objRejectedApplicantsBO.Address = objDataSet.Tables[0].Rows[i][4].ToString();
objRejectedApplicantsBO.Status = objDataSet.Tables[0].Rows[i][5].ToString();
objRejectedApplicantsBO.JobWiseComments = objDataSet.Tables[0].Rows[i][6].ToString();
objRejectedApplicantsBOList.Add(objRejectedApplicantsBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getRejectedApplicantsList");
throw ex;
}
return(objRejectedApplicantsBOList);
}
public RejectedApplicantsBO DisplayRejectedApplicant(int iApplicantId, int iJobPostingId)
{
DataSet objDataSet = null;
RejectedApplicantsBO objRejectedApplicantsBO = null;
ApplicantRelationBO objApplicantRelationBO = null;
LanguageSpokenBO objLanguageSpokenBO = null;
ApplicantQualificationBO objApplicantQualificationBO = null;
ApplicantEmploymentHistoryBO objApplicantEmploymentHistoryBO = null;
ApplicantRefereesBO objApplicantRefereesBO = null;
ApplicantSkillsDetailsBO objApplicantSkillsDetailsBO = null;
List <ProcParameterBO> ObjProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iApplicantId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iApplicantId;
ObjProcParameterBOList.Add(objDbParameter);
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iJobPostingId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iJobPostingId;
ObjProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcViewRejectedApplicant, ref ObjProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objRejectedApplicantsBO = new RejectedApplicantsBO();
objRejectedApplicantsBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objRejectedApplicantsBO.Title = objDataSet.Tables[0].Rows[0][1].ToString();
objRejectedApplicantsBO.FirstName = objDataSet.Tables[0].Rows[0][2].ToString();
objRejectedApplicantsBO.MiddleName = objDataSet.Tables[0].Rows[0][3].ToString();
objRejectedApplicantsBO.LastName = objDataSet.Tables[0].Rows[0][4].ToString();
objRejectedApplicantsBO.DateOfBirth = objDataSet.Tables[0].Rows[0][5].ToString();
objRejectedApplicantsBO.Gender = objDataSet.Tables[0].Rows[0][6].ToString();
objRejectedApplicantsBO.IdType = objDataSet.Tables[0].Rows[0][7].ToString();
objRejectedApplicantsBO.CitizenShipIdCopy = objDataSet.Tables[0].Rows[0][8].ToString();
objRejectedApplicantsBO.CitizenShipIdCopySavedName = objDataSet.Tables[0].Rows[0][9].ToString();
objRejectedApplicantsBO.Country = objDataSet.Tables[0].Rows[0][10].ToString();
objRejectedApplicantsBO.EmailAddress = objDataSet.Tables[0].Rows[0][11].ToString();
objRejectedApplicantsBO.PhoneNumber = objDataSet.Tables[0].Rows[0][12].ToString();
objRejectedApplicantsBO.AlternativePhoneNumber = objDataSet.Tables[0].Rows[0][13].ToString();
objRejectedApplicantsBO.MotherTongue = objDataSet.Tables[0].Rows[0][14].ToString();
objRejectedApplicantsBO.Nationality = objDataSet.Tables[0].Rows[0][15].ToString();
objRejectedApplicantsBO.County = objDataSet.Tables[0].Rows[0][16].ToString();
objRejectedApplicantsBO.ApplicationLetter = objDataSet.Tables[0].Rows[0][17].ToString();
objRejectedApplicantsBO.ApplicationLetterSavedName = objDataSet.Tables[0].Rows[0][18].ToString();
objRejectedApplicantsBO.CV = objDataSet.Tables[0].Rows[0][19].ToString();
objRejectedApplicantsBO.CVSavedName = objDataSet.Tables[0].Rows[0][20].ToString();
objRejectedApplicantsBO.SpecialNeed = objDataSet.Tables[0].Rows[0][21].ToString();
objRejectedApplicantsBO.SpecialNeedDetails = objDataSet.Tables[0].Rows[0][22].ToString();
objRejectedApplicantsBO.Address = objDataSet.Tables[0].Rows[0][23].ToString();
objRejectedApplicantsBO.Photo = objDataSet.Tables[0].Rows[0][24].ToString();
objRejectedApplicantsBO.PhotoSavedName = objDataSet.Tables[0].Rows[0][25].ToString();
if (objDataSet != null && objDataSet.Tables[1].Rows.Count > 0)
{
objRejectedApplicantsBO.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();
objRejectedApplicantsBO.ApplicantRelationList.Add(objApplicantRelationBO);
}
}
if (objDataSet != null && objDataSet.Tables[2].Rows.Count > 0)
{
objRejectedApplicantsBO.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();
objRejectedApplicantsBO.ApplicantLanguageList.Add(objLanguageSpokenBO);
}
}
if (objDataSet != null && objDataSet.Tables[3].Rows.Count > 0)
{
objRejectedApplicantsBO.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();
objRejectedApplicantsBO.ApplicantQualificationList.Add(objApplicantQualificationBO);
}
}
if (objDataSet != null && objDataSet.Tables[4].Rows.Count > 0)
{
objRejectedApplicantsBO.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();
objRejectedApplicantsBO.ApplicantEmploymentList.Add(objApplicantEmploymentHistoryBO);
}
}
if (objDataSet != null && objDataSet.Tables[5].Rows.Count > 0)
{
objRejectedApplicantsBO.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();
objRejectedApplicantsBO.ApplicantRefereesList.Add(objApplicantRefereesBO);
}
}
if (objDataSet != null && objDataSet.Tables[6].Rows.Count > 0)
{
objRejectedApplicantsBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[6].Rows[0][0].ToString());
objRejectedApplicantsBO.ApplicantMotivationId = Convert.ToInt32(objDataSet.Tables[6].Rows[0][1].ToString());
objRejectedApplicantsBO.MembershipData = objDataSet.Tables[6].Rows[0][2].ToString();
objRejectedApplicantsBO.NameofProfessionalBody = objDataSet.Tables[6].Rows[0][3].ToString();
objRejectedApplicantsBO.MembershipNumber = objDataSet.Tables[6].Rows[0][4].ToString();
objRejectedApplicantsBO.ValidityData = objDataSet.Tables[6].Rows[0][5].ToString();
objRejectedApplicantsBO.JobDescription = objDataSet.Tables[6].Rows[0][6].ToString();
objRejectedApplicantsBO.Referer = objDataSet.Tables[6].Rows[0][7].ToString();
objRejectedApplicantsBO.ApplicationNote = objDataSet.Tables[6].Rows[0][8].ToString();
}
if (objDataSet != null && objDataSet.Tables[7].Rows.Count > 0)
{
objRejectedApplicantsBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[7].Rows[0][0].ToString());
objRejectedApplicantsBO.TerminatedId = objDataSet.Tables[7].Rows[0][1].ToString();
objRejectedApplicantsBO.Terminatation = objDataSet.Tables[7].Rows[0][2].ToString();
objRejectedApplicantsBO.MisconductId = objDataSet.Tables[7].Rows[0][3].ToString();
objRejectedApplicantsBO.Misconduct = objDataSet.Tables[7].Rows[0][4].ToString();
objRejectedApplicantsBO.ManagementId = objDataSet.Tables[7].Rows[0][5].ToString();
objRejectedApplicantsBO.Management = objDataSet.Tables[7].Rows[0][6].ToString();
objRejectedApplicantsBO.InvestigationId = objDataSet.Tables[7].Rows[0][7].ToString();
objRejectedApplicantsBO.Investigation = objDataSet.Tables[7].Rows[0][8].ToString();
objRejectedApplicantsBO.CriminalOffenceId = objDataSet.Tables[7].Rows[0][9].ToString();
objRejectedApplicantsBO.CriminalOffence = objDataSet.Tables[7].Rows[0][10].ToString();
objRejectedApplicantsBO.ConvictionsId = objDataSet.Tables[7].Rows[0][11].ToString();
objRejectedApplicantsBO.Convictions = objDataSet.Tables[7].Rows[0][12].ToString();
objRejectedApplicantsBO.CorruptionId = objDataSet.Tables[7].Rows[0][13].ToString();
objRejectedApplicantsBO.Corruption = objDataSet.Tables[7].Rows[0][14].ToString();
objRejectedApplicantsBO.DisciplinaryId = objDataSet.Tables[7].Rows[0][15].ToString();
objRejectedApplicantsBO.Disciplinary = objDataSet.Tables[7].Rows[0][16].ToString();
objRejectedApplicantsBO.RelationToChildId = objDataSet.Tables[7].Rows[0][17].ToString();
objRejectedApplicantsBO.RelationToChild = objDataSet.Tables[7].Rows[0][18].ToString();
objRejectedApplicantsBO.RelationToAdultId = objDataSet.Tables[7].Rows[0][19].ToString();
objRejectedApplicantsBO.RelationToAdult = objDataSet.Tables[7].Rows[0][20].ToString();
objRejectedApplicantsBO.RelativeId = objDataSet.Tables[7].Rows[0][21].ToString();
objRejectedApplicantsBO.DealingsWithWIKId = objDataSet.Tables[7].Rows[0][22].ToString();
objRejectedApplicantsBO.DealingsWithWIK = objDataSet.Tables[7].Rows[0][23].ToString();
objRejectedApplicantsBO.Declarationinfo = Convert.ToBoolean(objDataSet.Tables[7].Rows[0][24].ToString());
objRejectedApplicantsBO.Statement = Convert.ToBoolean(objDataSet.Tables[7].Rows[0][25].ToString());
objRejectedApplicantsBO.DeclarationID = Convert.ToInt32(objDataSet.Tables[7].Rows[0][26].ToString());
}
if (objDataSet != null && objDataSet.Tables[8].Rows.Count > 0)
{
objRejectedApplicantsBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[8].Rows[0][0].ToString());
objRejectedApplicantsBO.CommunicationSkills = objDataSet.Tables[8].Rows[0][1].ToString();
objRejectedApplicantsBO.Experience = objDataSet.Tables[8].Rows[0][2].ToString();
objRejectedApplicantsBO.Year = objDataSet.Tables[8].Rows[0][3].ToString();
objRejectedApplicantsBO.Month = objDataSet.Tables[8].Rows[0][4].ToString();
}
if (objDataSet != null && objDataSet.Tables[9].Rows.Count > 0)
{
objRejectedApplicantsBO.SkillsList = new List <ApplicantSkillsDetailsBO>();
for (int i = 0; i < objDataSet.Tables[9].Rows.Count; i++)
{
objApplicantSkillsDetailsBO = new ApplicantSkillsDetailsBO();
objApplicantSkillsDetailsBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[9].Rows[i][0].ToString());
objApplicantSkillsDetailsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[9].Rows[i][1].ToString());
objApplicantSkillsDetailsBO.Skill = objDataSet.Tables[9].Rows[i][2].ToString();
objApplicantSkillsDetailsBO.RatingId = Convert.ToInt32(objDataSet.Tables[9].Rows[i][3].ToString());
objApplicantSkillsDetailsBO.EvaluationComments = objDataSet.Tables[9].Rows[i][4].ToString();
objRejectedApplicantsBO.SkillsList.Add(objApplicantSkillsDetailsBO);
}
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "DisplayRejectedApplicant");
throw ex;
}
return(objRejectedApplicantsBO);
}