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)); }