public ActionResult getQualification()
{
ApplicantDashboardBAL objApplicantDashboardBAL = new ApplicantDashboardBAL();
ApplicantQualificationBO objApplicantQualificationBO = new ApplicantQualificationBO();
return(PartialView("_EditQualification", objApplicantQualificationBO));
}
public JsonResult EditApplicantQualification(int A_iApplicantQualificationId)
{
UpdateProfileBAL objUpdateProfileBAL = new UpdateProfileBAL();
ApplicantQualificationBO objApplicantQualificationBO = objUpdateProfileBAL.EditApplicantQualificationList(A_iApplicantQualificationId, Convert.ToInt32(ViewData["EmployeeId"]));
return(Json(objApplicantQualificationBO, JsonRequestBehavior.AllowGet));
}
public ActionResult EditQualification(int iApplicantId)
{
ApplicantDashboardBAL objApplicantDashboardBAL = new ApplicantDashboardBAL();
ApplicantQualificationBO objApplicantQualificationBO = objApplicantDashboardBAL.editQualification(iApplicantId);
return(PartialView("_EditQualification", objApplicantQualificationBO));
}
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 JsonResult SaveApplicantQualification(ApplicantQualificationBO Data)
{
string strResult = "";
if (Request.Files.Count > 0)
{
string strFileName = "";
string strExtention = "";
Random objRandom = new Random();
string strRandom = objRandom.Next(10000) + "";
string strFileUploadPath = "";
string fileName = "";
string fileContentType = "";
byte[] tempFileBytes = null;
dynamic data = null;
dynamic types = null;
bool result = false;
HttpFileCollectionBase files = Request.Files;
if (files != null)
{
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
if (file.ContentLength == 0)
{
strResult = "Upload file should not be empty";
}
else if (file.ContentLength > 0)
{
strExtention = Path.GetExtension(file.FileName);
fileName = file.FileName; // getting File Name
fileContentType = file.ContentType; // getting ContentType
tempFileBytes = new byte[file.ContentLength]; // getting filebytes
data = file.InputStream.Read(tempFileBytes, 0, Convert.ToInt32(file.ContentLength));
types = CommonUtils.FileType.Image; // Setting Image type
if (strExtention.ToUpper() == ".PDF")
{
types = CommonUtils.FileType.PDF;
}
else if (strExtention.ToUpper() == ".DOC")
{
types = CommonUtils.FileType.DOC;
}
else if (strExtention.ToUpper() == ".DOCX")
{
types = CommonUtils.FileType.DOCX;
}
result = CommonUtils.isValidFile(tempFileBytes, types, fileContentType); // Validate Header
strFileName = strRandom + "_" + DateTime.UtcNow.ToString("yyyyMMddHHmmssfff", CultureInfo.InvariantCulture) + strExtention;
var strFileType = file.FileName.Split(new string[] { "_" }, StringSplitOptions.RemoveEmptyEntries);
if (result)
{
int FileLength = 1024 * 1024 * 3; //FileLength 3 MB
if (file.ContentLength > FileLength)
{
strResult = "Upload file should not be greater than 3MB";
}
Data.AttachmentSavedName = strFileName;
strFileUploadPath = strAcademicQualificationUploadPath;
strFileName = Path.Combine(strFileUploadPath, strFileName);
file.SaveAs(strFileName);
}
//else
//{
// strResult = strResult + "Please Upload Valid file for " + strFileType[0] + "</br>";
//}
}
}
}
}
UpdateProfileBAL objUpdateProfileBAL = new UpdateProfileBAL();
Data.IsActive = true;
strResult = objUpdateProfileBAL.SaveorUpdateApplicantQualification(Data, 1);
//if (strResult == "")
//{
// strResult = objUpdateProfileBAL.SaveorUpdateApplicantQualification(Data, 1);
//}
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public JsonResult saveQualification(ApplicantQualificationBO Data)
{
if (Request.Files.Count > 0)
{
string strFileName2 = "";
string strExtention2 = "";
HttpFileCollectionBase files2 = Request.Files;
for (int k = 0; k < files2.Count; k++)
{
HttpPostedFileBase file = files2[k];
strExtention2 = Path.GetExtension(file.FileName);
strFileName2 = ViewData["LoginUserId"].ToString() + "_" + DateTime.UtcNow.ToString("yyyyMMddHHmmssfff", CultureInfo.InvariantCulture) + strExtention2;
Data.FileSavedName2 = strFileName2;
strFileName2 = Path.Combine(strFileUploadPath2, strFileName2);
file.SaveAs(strFileName2);
}
}
if (Request.Files.Count > 0)
{
string strFileName3 = "";
string strExtention3 = "";
HttpFileCollectionBase files3 = Request.Files;
for (int l = 0; l < files3.Count; l++)
{
HttpPostedFileBase file = files3[l];
strExtention3 = Path.GetExtension(file.FileName);
strFileName3 = ViewData["LoginUserId"].ToString() + "_" + DateTime.UtcNow.ToString("yyyyMMddHHmmssfff", CultureInfo.InvariantCulture) + strExtention3;
Data.FileSavedName3 = strFileName3;
strFileName3 = Path.Combine(strFileUploadPath3, strFileName3);
file.SaveAs(strFileName3);
}
}
if (Request.Files.Count > 0)
{
string strFileName4 = "";
string strExtention4 = "";
HttpFileCollectionBase files4 = Request.Files;
for (int m = 0; m < files4.Count; m++)
{
HttpPostedFileBase file = files4[m];
strExtention4 = Path.GetExtension(file.FileName);
strFileName4 = ViewData["LoginUserId"].ToString() + "_" + DateTime.UtcNow.ToString("yyyyMMddHHmmssfff", CultureInfo.InvariantCulture) + strExtention4;
Data.FileSavedName4 = strFileName4;
strFileName4 = Path.Combine(strFileUploadPath4, strFileName4);
file.SaveAs(strFileName4);
}
}
if (Request.Files.Count > 0)
{
string strFileName5 = "";
string strExtention5 = "";
HttpFileCollectionBase files5 = Request.Files;
for (int n = 0; n < files5.Count; n++)
{
HttpPostedFileBase file = files5[n];
strExtention5 = Path.GetExtension(file.FileName);
strFileName5 = ViewData["LoginUserId"].ToString() + "_" + DateTime.UtcNow.ToString("yyyyMMddHHmmssfff", CultureInfo.InvariantCulture) + strExtention5;
Data.FileSavedName5 = strFileName5;
strFileName5 = Path.Combine(strFileUploadPath5, strFileName5);
file.SaveAs(strFileName5);
}
}
ApplicantDashboardBAL objApplicantDashboardBAL = new ApplicantDashboardBAL();
string strResult = objApplicantDashboardBAL.SaveApplicantQualification(Data, Convert.ToInt32(ViewData["LoginUserId"]));
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public string SaveorUpdateApplicantQualification(ApplicantQualificationBO objApplicantQualificationBO, int iUserId)
{
return(objUpdateProfileDAL.SaveorUpdateApplicantQualification(objApplicantQualificationBO, iUserId));
}
public string SaveApplicantQualification(ApplicantQualificationBO objApplicantQualificationBO, int iUserId)
{
return(objApplicantDashboardDAL.SaveApplicantQualification(objApplicantQualificationBO, iUserId));
}
