public ActionResult getEmployment()
{
ApplicantDashboardBAL objApplicantDashboardBAL = new ApplicantDashboardBAL();
ApplicantEmploymentHistoryBO objApplicantEmploymentHistoryBO = new ApplicantEmploymentHistoryBO();
return(PartialView("_EditEmploymenyHistory", objApplicantEmploymentHistoryBO));
}
public JsonResult EditApplicantEmploymentHistory(int A_iEmploymentHistoryId)
{
UpdateProfileBAL objUpdateProfileBAL = new UpdateProfileBAL();
ApplicantEmploymentHistoryBO objApplicantEmploymentHistoryBO = objUpdateProfileBAL.EditApplicantEmploymentHistory(A_iEmploymentHistoryId, Convert.ToInt32(ViewData["EmployeeId"]));
return(Json(objApplicantEmploymentHistoryBO, JsonRequestBehavior.AllowGet));
}
public ActionResult EditEmploymentHistory(int iApplicantId)
{
ApplicantDashboardBAL objApplicantDashboardBAL = new ApplicantDashboardBAL();
ApplicantEmploymentHistoryBO objApplicantEmploymentHistoryBO = objApplicantDashboardBAL.editEmploymentHistory(iApplicantId);
return(PartialView("_EditEmploymenyHistory", objApplicantEmploymentHistoryBO));
}
public JsonResult saveEmploymentHistory(ApplicantEmploymentHistoryBO Data)
{
ApplicantDashboardBAL objApplicantDashboardBAL = new ApplicantDashboardBAL();
string strResult = objApplicantDashboardBAL.SaveApplicantEmploymentHistory(Data, Convert.ToInt32(ViewData["LoginUserId"]));
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveApplicantEmploymentHistory(ApplicantEmploymentHistoryBO Data)
{
UpdateProfileBAL objUpdateProfileBAL = new UpdateProfileBAL();
Data.IsActive = true;
string strResult = objUpdateProfileBAL.SaveorUpdateApplicantEmploymentHistory(Data, 1);
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public SelectedListBO ViewSelectedApplicant(int iApplicantId, int iJobPostingId)
{
DataSet objDataSet = null;
SelectedListBO objSelectedListBO = 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(ProcViewSelectedApplicant, ref ObjProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objSelectedListBO = new SelectedListBO();
objSelectedListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objSelectedListBO.Title = objDataSet.Tables[0].Rows[0][1].ToString();
objSelectedListBO.FirstName = objDataSet.Tables[0].Rows[0][2].ToString();
objSelectedListBO.MiddleName = objDataSet.Tables[0].Rows[0][3].ToString();
objSelectedListBO.LastName = objDataSet.Tables[0].Rows[0][4].ToString();
objSelectedListBO.DateOfBirth = objDataSet.Tables[0].Rows[0][5].ToString();
objSelectedListBO.Gender = objDataSet.Tables[0].Rows[0][6].ToString();
objSelectedListBO.IdType = objDataSet.Tables[0].Rows[0][7].ToString();
objSelectedListBO.CitizenShipIdCopy = objDataSet.Tables[0].Rows[0][8].ToString();
objSelectedListBO.CitizenShipIdCopySavedName = objDataSet.Tables[0].Rows[0][9].ToString();
objSelectedListBO.Country = objDataSet.Tables[0].Rows[0][10].ToString();
objSelectedListBO.EmailAddress = objDataSet.Tables[0].Rows[0][11].ToString();
objSelectedListBO.PhoneNumber = objDataSet.Tables[0].Rows[0][12].ToString();
objSelectedListBO.AlternativePhoneNumber = objDataSet.Tables[0].Rows[0][13].ToString();
objSelectedListBO.MotherTongue = objDataSet.Tables[0].Rows[0][14].ToString();
objSelectedListBO.Nationality = objDataSet.Tables[0].Rows[0][15].ToString();
objSelectedListBO.County = objDataSet.Tables[0].Rows[0][16].ToString();
objSelectedListBO.ApplicationLetter = objDataSet.Tables[0].Rows[0][17].ToString();
objSelectedListBO.ApplicationLetterSavedName = objDataSet.Tables[0].Rows[0][18].ToString();
objSelectedListBO.CV = objDataSet.Tables[0].Rows[0][19].ToString();
objSelectedListBO.CVSavedName = objDataSet.Tables[0].Rows[0][20].ToString();
objSelectedListBO.SpecialNeed = objDataSet.Tables[0].Rows[0][21].ToString();
objSelectedListBO.SpecialNeedDetails = objDataSet.Tables[0].Rows[0][22].ToString();
objSelectedListBO.Address = objDataSet.Tables[0].Rows[0][23].ToString();
objSelectedListBO.Photo = objDataSet.Tables[0].Rows[0][24].ToString();
objSelectedListBO.PhotoSavedName = objDataSet.Tables[0].Rows[0][25].ToString();
if (objDataSet != null && objDataSet.Tables[1].Rows.Count > 0)
{
objSelectedListBO.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();
objSelectedListBO.ApplicantRelationList.Add(objApplicantRelationBO);
}
}
if (objDataSet != null && objDataSet.Tables[2].Rows.Count > 0)
{
objSelectedListBO.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();
objSelectedListBO.ApplicantLanguageList.Add(objLanguageSpokenBO);
}
}
if (objDataSet != null && objDataSet.Tables[3].Rows.Count > 0)
{
objSelectedListBO.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();
objSelectedListBO.ApplicantQualificationList.Add(objApplicantQualificationBO);
}
}
if (objDataSet != null && objDataSet.Tables[4].Rows.Count > 0)
{
objSelectedListBO.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();
objSelectedListBO.ApplicantEmploymentList.Add(objApplicantEmploymentHistoryBO);
}
}
if (objDataSet != null && objDataSet.Tables[5].Rows.Count > 0)
{
objSelectedListBO.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();
objSelectedListBO.ApplicantRefereesList.Add(objApplicantRefereesBO);
}
}
if (objDataSet != null && objDataSet.Tables[6].Rows.Count > 0)
{
objSelectedListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[6].Rows[0][0].ToString());
objSelectedListBO.ApplicantMotivationId = Convert.ToInt32(objDataSet.Tables[6].Rows[0][1].ToString());
objSelectedListBO.MembershipData = objDataSet.Tables[6].Rows[0][2].ToString();
objSelectedListBO.NameofProfessionalBody = objDataSet.Tables[6].Rows[0][3].ToString();
objSelectedListBO.MembershipNumber = objDataSet.Tables[6].Rows[0][4].ToString();
objSelectedListBO.ValidityData = objDataSet.Tables[6].Rows[0][5].ToString();
objSelectedListBO.JobDescription = objDataSet.Tables[6].Rows[0][6].ToString();
objSelectedListBO.Referer = objDataSet.Tables[6].Rows[0][7].ToString();
objSelectedListBO.ApplicationNote = objDataSet.Tables[6].Rows[0][8].ToString();
}
if (objDataSet != null && objDataSet.Tables[7].Rows.Count > 0)
{
objSelectedListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[7].Rows[0][0].ToString());
objSelectedListBO.TerminatedId = objDataSet.Tables[7].Rows[0][1].ToString();
objSelectedListBO.Terminatation = objDataSet.Tables[7].Rows[0][2].ToString();
objSelectedListBO.MisconductId = objDataSet.Tables[7].Rows[0][3].ToString();
objSelectedListBO.Misconduct = objDataSet.Tables[7].Rows[0][4].ToString();
objSelectedListBO.ManagementId = objDataSet.Tables[7].Rows[0][5].ToString();
objSelectedListBO.Management = objDataSet.Tables[7].Rows[0][6].ToString();
objSelectedListBO.InvestigationId = objDataSet.Tables[7].Rows[0][7].ToString();
objSelectedListBO.Investigation = objDataSet.Tables[7].Rows[0][8].ToString();
objSelectedListBO.CriminalOffenceId = objDataSet.Tables[7].Rows[0][9].ToString();
objSelectedListBO.CriminalOffence = objDataSet.Tables[7].Rows[0][10].ToString();
objSelectedListBO.ConvictionsId = objDataSet.Tables[7].Rows[0][11].ToString();
objSelectedListBO.Convictions = objDataSet.Tables[7].Rows[0][12].ToString();
objSelectedListBO.CorruptionId = objDataSet.Tables[7].Rows[0][13].ToString();
objSelectedListBO.Corruption = objDataSet.Tables[7].Rows[0][14].ToString();
objSelectedListBO.DisciplinaryId = objDataSet.Tables[7].Rows[0][15].ToString();
objSelectedListBO.Disciplinary = objDataSet.Tables[7].Rows[0][16].ToString();
objSelectedListBO.RelationToChildId = objDataSet.Tables[7].Rows[0][17].ToString();
objSelectedListBO.RelationToChild = objDataSet.Tables[7].Rows[0][18].ToString();
objSelectedListBO.RelationToAdultId = objDataSet.Tables[7].Rows[0][19].ToString();
objSelectedListBO.RelationToAdult = objDataSet.Tables[7].Rows[0][20].ToString();
objSelectedListBO.RelativeId = objDataSet.Tables[7].Rows[0][21].ToString();
objSelectedListBO.DealingsWithWIKId = objDataSet.Tables[7].Rows[0][22].ToString();
objSelectedListBO.DealingsWithWIK = objDataSet.Tables[7].Rows[0][23].ToString();
objSelectedListBO.Declarationinfo = Convert.ToBoolean(objDataSet.Tables[7].Rows[0][24].ToString());
objSelectedListBO.Statement = Convert.ToBoolean(objDataSet.Tables[7].Rows[0][25].ToString());
objSelectedListBO.DeclarationID = Convert.ToInt32(objDataSet.Tables[7].Rows[0][26].ToString());
}
if (objDataSet != null && objDataSet.Tables[8].Rows.Count > 0)
{
objSelectedListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[8].Rows[0][0].ToString());
objSelectedListBO.CommunicationSkills = objDataSet.Tables[8].Rows[0][1].ToString();
objSelectedListBO.Experience = objDataSet.Tables[8].Rows[0][2].ToString();
objSelectedListBO.Year = objDataSet.Tables[8].Rows[0][3].ToString();
objSelectedListBO.Month = objDataSet.Tables[8].Rows[0][4].ToString();
}
if (objDataSet != null && objDataSet.Tables[9].Rows.Count > 0)
{
objSelectedListBO.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();
objSelectedListBO.SkillsList.Add(objApplicantSkillsDetailsBO);
}
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "ViewSelectedApplicant");
throw ex;
}
return(objSelectedListBO);;
}
public string SaveorUpdateApplicantEmploymentHistory(ApplicantEmploymentHistoryBO objApplicantEmploymentHistoryBO, int iUserId)
{
return(objUpdateProfileDAL.SaveorUpdateApplicantEmploymentHistory(objApplicantEmploymentHistoryBO, iUserId));
}
public string SaveApplicantEmploymentHistory(ApplicantEmploymentHistoryBO objApplicantEmploymentHistoryBO, int iUserId)
{
return(objApplicantDashboardDAL.SaveApplicantEmploymentHistory(objApplicantEmploymentHistoryBO, iUserId));
}
