public List <SearchResumeListViewModel> GetAdvanceSearchResumeList(AdvanceResumeSearch searches, int userId) { List <SearchResumeListViewModel> lstSearchedResume = new List <SearchResumeListViewModel>(); DataTable searchedResume = _serarchresumeProcess.GetAdvanceSearchResumeList(searches, userId); if (searchedResume.Rows.Count > 0) { for (int i = 0; i < searchedResume.Rows.Count; i++) { string resumePath = Convert.ToString(searchedResume.Rows[i]["Resume"]); if (!string.IsNullOrWhiteSpace(resumePath)) { if (!File.Exists($"{_hostingEnviroment.WebRootPath}{resumePath}")) { resumePath = string.Empty; } } var skillsObject = new SearchResumeListViewModel { Skills = JsonConvert.DeserializeObject <Skills>(Convert.ToString(searchedResume.Rows[i]["Skills"])), FirstName = (searchedResume.Rows[i]["FirstName"] as string) ?? "", LastName = (searchedResume.Rows[i]["LastName"] as string) ?? "", Email = (searchedResume.Rows[i]["Email"] as string) ?? "", Resume = resumePath, UserId = (searchedResume.Rows[i]["UserId"] as int?) ?? 0, CityName = (searchedResume.Rows[i]["CityName"] as string) ?? "", JobIndustryAreaName = (searchedResume.Rows[i]["JobIndustryAreaName"] as string) ?? "", JobTitle = (searchedResume.Rows[i]["JobTitleName"] as string) ?? "", //Address = (searchedResume.Rows[i]["Address"] as string) ?? "", AboutMe = (searchedResume.Rows[i]["AboutMe"] as string) ?? "", ProfilePic = Convert.ToString(searchedResume.Rows[i]["ProfilePic"]), CurrentSalary = Convert.ToString(searchedResume.Rows[i]["CurrentSalary"]), ExpectedSalary = Convert.ToString(searchedResume.Rows[i]["ExpectedSalary"]), LinkedinProfile = Convert.ToString(searchedResume.Rows[i]["LinkedinProfile"]), ExperienceDetails = JsonConvert.DeserializeObject <ExperienceDetails[]>(searchedResume.Rows[i]["ExperienceDetails"].ToString()) }; lstSearchedResume.Add(skillsObject); string picpath = Path.GetFullPath(_hostingEnviroment.WebRootPath + lstSearchedResume[i].ProfilePic); if (!System.IO.File.Exists(picpath)) { string fName = $@"\ProfilePic\" + "Avatar.jpg"; lstSearchedResume[i].ProfilePic = fName; } } return(lstSearchedResume); } throw new UserNotFoundException("Data Not found"); }
public IActionResult AdvanceResumeSearchData(AdvanceResumeSearch model) { List <SearchResumeListViewModel> lstResumeList = new List <SearchResumeListViewModel>(); var user = HttpContext.Session.Get <UserViewModel>(Constants.SessionKeyUserInfo); user = user ?? new UserViewModel(); try { lstResumeList = searchresumehandler.GetAdvanceSearchResumeList(model, user.UserId); } catch (UserNotFoundException ex) { Logger.Logger.WriteLog(Logger.Logtype.Error, ex.Message, user.UserId, typeof(SearchResumeController), ex); ModelState.AddModelError("ErrorMessage", string.Format("{0}", ex.Message)); } return(View(lstResumeList)); }
public List <AdvanceResumeSearch> AdvanceSearchStates(int UserId) { DataTable dt = _serarchresumeProcess.AdvanceSearchStates(UserId); var SearchStats = new List <AdvanceResumeSearch>(); for (int i = 0; i < dt.Rows.Count; i++) { var search = new AdvanceResumeSearch() { id = Convert.ToInt32(dt.Rows[i]["Id"]), HiringRequirement = Convert.ToString(dt.Rows[i]["HiringRequirement"]), AllKeyword = Convert.ToString(dt.Rows[i]["AllKeyword"]), skills = Convert.ToString(dt.Rows[i]["Skills"]), isSavedSearch = Convert.ToBoolean(dt.Rows[i]["IsSavedSearch"]) }; SearchStats.Add(search); } return(SearchStats); throw new UserNotFoundException("data not found"); }
public List <AdvanceResumeSearch> AdvanceSearchById(int Id, int UserId) { DataTable dt = _serarchresumeProcess.AdvanceSearchById(Id, UserId); var SearchStats = new List <AdvanceResumeSearch>(); for (int i = 0; i < dt.Rows.Count; i++) { var search = new AdvanceResumeSearch() { HiringRequirement = Convert.ToString(dt.Rows[i]["HiringRequirement"]), AnyKeyword = Convert.ToString(dt.Rows[i]["AnyKeyword"]), AllKeyword = Convert.ToString(dt.Rows[i]["AllKeyword"]), ExculudeKeyword = Convert.ToString(dt.Rows[i]["ExculudeKeyword"]), MinExperiance = Convert.ToInt32(dt.Rows[i]["MinExperience"]), MaxExperiance = Convert.ToInt32(dt.Rows[i]["MaxExperience"]), MinSalary = Convert.ToString(dt.Rows[i]["MinSalary"]), MaxSalary = Convert.ToString(dt.Rows[i]["MaxSalary"]), CurrentLocation = Convert.ToString(dt.Rows[i]["CurrentLocation"]), PreferredLocation1 = Convert.ToString(dt.Rows[i]["PreferredLocation1"]), PreferredLocation2 = Convert.ToString(dt.Rows[i]["PreferredLocation2"]), PreferredLocation3 = Convert.ToString(dt.Rows[i]["PreferredLocation3"]), FuncationlArea = Convert.ToInt32(dt.Rows[i]["FuncationlArea"]), JobIndustryAreaId = Convert.ToInt32(dt.Rows[i]["JobIndustryAreaId"]), CurrentDesignation = Convert.ToString(dt.Rows[i]["CurrentDesignation"]), NoticePeriod = Convert.ToString(dt.Rows[i]["NoticePeriod"]), skills = Convert.ToString(dt.Rows[i]["Skills"]), AgeFrom = Convert.ToInt32(dt.Rows[i]["AgeFrom"]), AgeTo = Convert.ToInt32(dt.Rows[i]["AgeTo"]), Gender = Convert.ToString(dt.Rows[i]["Gender"]), CandidatesType = Convert.ToString(dt.Rows[i]["CandidatesType"]), ShowCandidateSeeking = Convert.ToInt32(dt.Rows[i]["ShowCandidateSeeking"]), isSavedSearch = Convert.ToBoolean(dt.Rows[i]["IsSavedSearch"]), }; SearchStats.Add(search); } return(SearchStats); throw new UserNotFoundException("data not found"); }
public DataTable GetAdvanceSearchResumeList(AdvanceResumeSearch searches, int userId) { var dt = new DataTable(); using (var connection = new SqlConnection(connectionString)) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@HiringRequirement", searches.HiringRequirement), new SqlParameter("@AnyKeyword", searches.AnyKeyword), new SqlParameter("@AllKeyword", searches.AllKeyword), new SqlParameter("@ExculudeKeyword", searches.ExculudeKeyword), new SqlParameter("@MinExp", searches.MinExperiance), new SqlParameter("@MaxExp", searches.MaxExperiance), new SqlParameter("@MinSalary", searches.MinSalary), new SqlParameter("@MaxSalary", searches.MaxSalary), new SqlParameter("@CurrentLocation", searches.CurrentLocation), new SqlParameter("@PreferredLocation1", searches.PreferredLocation1), new SqlParameter("@PreferredLocation2", searches.PreferredLocation2), new SqlParameter("@PreferredLocation3", searches.PreferredLocation3), new SqlParameter("@FuncationlArea", searches.FuncationlArea), new SqlParameter("@JobIndustryAreaId", searches.JobIndustryAreaId), new SqlParameter("@CurrentDesignation", searches.CurrentDesignation), new SqlParameter("@NoticePeriod", searches.NoticePeriod), new SqlParameter("@Skills", searches.skills), new SqlParameter("@AgeFrom", searches.AgeFrom), new SqlParameter("@AgeTO", searches.AgeTo), new SqlParameter("@Gender", searches.Gender), new SqlParameter("@CandidatesType", searches.CandidatesType), //new SqlParameter("@ShowCandidateWith",searches.ShowCandidateWith), new SqlParameter("@ShowCandidateSeeking", searches.ShowCandidateSeeking), new SqlParameter("@UserId", userId), new SqlParameter("@IsSavedSearch", searches.isSavedSearch) }; var searchList = SqlHelper.ExecuteReader ( connection, CommandType.StoredProcedure, "usp_AdvanceSearchResume", parameters ); if (null != searchList && searchList.HasRows) { dt.Load(searchList); } } catch (Exception ex) { var data = ex; } finally { SqlHelper.CloseConnection(connection); } } return(dt); throw new DataNotFound("Data not found"); }