public ActionResult Instituicoes() { var model = new SearchFilterViewModel(); model.Categorias = GetCategories(); return(View("SearchInstitutions", model)); }
public ActionResult SearchInstitutions(SearchFilterViewModel filter) { var lista = institutionService.ListByFilters(filter.SelectedCategories, filter.Nome, filter.Localidade); var model = ParseToResumedViewModel(lista); return(View("ViewInstitutions", model)); }
private void InitializeSubmittedFormInfomationInViewData(SearchFilterViewModel searchFilterViewModel) { ViewData["query"] = searchFilterViewModel.Query; ViewData["creationDateRange"] = searchFilterViewModel.CreationDateRange; ViewData["approvalDateRange"] = searchFilterViewModel.ApprovalDateRange; ViewData["author"] = searchFilterViewModel.Author; ViewData["tags"] = searchFilterViewModel.Tags; ViewData["orderBy"] = searchFilterViewModel.OrderBy; }
public IActionResult Index(SearchFilterViewModel search, int page = 1, string sort = "") { //if (ModelState.IsValid) //{ var photos = _context.Photos .Select(p => new PhotoViewModel { PhotoId = p.PhotoId, PropertyId = p.PropertyId, ImageString = string.Format("data:image/jpg;base64,{0}", Convert.ToBase64String(p.ImageData)) }); if (search.PhotoId != null) { photos = photos.Where(p => p.PhotoId == search.PhotoId); } if (search.PropertyId != null) { photos = photos.Where(p => p.PropertyId == search.PropertyId); } int filteredCount = photos.Count(); int totalPages = Convert.ToInt32(Math.Ceiling((decimal)filteredCount / PageSize)); switch (sort.ToLower()) { default: photos = photos.OrderBy(p => p.PropertyId); break; //case "namedesc": // photos = photos.OrderByDescending(u => u.FirstName).ThenByDescending(u => u.LastName); // break; //case "emailasc": // photos = photos.OrderBy(u => u.Email); // break; //case "emaildesc": // photos = photos.OrderByDescending(u => u.Email); // break; //case "typeasc": // photos = photos.OrderBy(u => u.UsertypeSortingOrder); // break; //case "typedesc": // photos = photos.OrderByDescending(u => u.UsertypeSortingOrder); // break; } photos = photos.Skip(PageSize * (page - 1)).Take(PageSize); return(View(photos)); //} //return View(); }
private async Task <List <Job> > GetFilteredJobs(SearchFilterViewModel searchFilterViewModel) { var category = searchFilterViewModel.Category; var jobs = _context.Jobs .Include(j => j.Company) .Include(j => j.Category).AsQueryable(); if (category != null && !category.ToLower().Equals("all")) { category = category.ToLower(); ViewBag.Category = category; jobs = jobs.Where(j => j.Category.Name.ToLower().Equals(category)); } var jobTypes = searchFilterViewModel.Type; var selectedCategories = jobTypes.Where(j => j.Selected == true).Select(j => j.Value).ToList(); if (selectedCategories.Count > 0) { jobs = jobs.Where(j => selectedCategories.Contains(j.Type)); } var experienceRequired = searchFilterViewModel.Experience; var experienceLevels = experienceRequired.Where(e => e.Selected == true).Select(j => j.Value).ToArray(); if (experienceLevels.Length > 0) { var(min, max) = ExperienceLevelInfoHelper.GetNumberOfYears(experienceLevels); jobs = jobs.Where(j => j.ExperienceRequired >= min && j.ExperienceRequired <= max); } var postedDuration = searchFilterViewModel.PostedWithin.Where(d => d.Selected == true).Select(d => d.Value).ToArray(); if (postedDuration.Length > 0) { if (PostDurationHelper.ApplyDurationFilter(postedDuration, out int days)) { jobs = jobs.Where(j => j.CreatedOn.AddDays(days).Day >= DateTime.UtcNow.Day); } } if (searchFilterViewModel.MinSalary != null) { var minAmount = searchFilterViewModel.MinSalary * 10000; jobs = jobs.Where(j => j.SalaryMin >= minAmount); } if (searchFilterViewModel.MaxSalary != null) { var maxAmount = searchFilterViewModel.MaxSalary * 10000; jobs = jobs.Where(j => j.SalaryMin <= maxAmount); } return(await jobs.ToListAsync()); }
public virtual ActionResult Search(SearchFilterViewModel filter) { var responseMVC = new ReloadHtmlContentResponse(); var model = new StatusSearchViewModel(); model.Filter = filter; model = GetStatusSearch(model); var html = this.RenderRazorViewToString("ReadPartial/NonPagedTables", model.Tables); responseMVC.ContentToReplace.Add("[data-section=\"NonPagedTables\"]", html); return(Json(responseMVC)); }
public async Task <ActionResult> SearchFilters(SearchFilterViewModel searchFilterViewModel) { var userId = User.FindFirstValue(ClaimTypes.NameIdentifier); var user = _userManager.FindByIdAsync(userId).Result; var roles = await _userManager.GetRolesAsync(user); var managementService = _resourceManagementStrategy.FindService(roles.FirstOrDefault()); var resourceFilter = ConvertToSearchFilterDto(searchFilterViewModel); var resources = managementService.SearchResourcesByFilterObject(resourceFilter, user); InitializeSubmittedFormInfomationInViewData(searchFilterViewModel); return(View("SearchResults", resources)); }
public ActionResult SearchUserRecord() { var countriesList = db.Countries.ToList(); var coursesList = db.Courses.ToList(); var rolesList = db.Roles.ToList(); SearchFilterViewModel searchFilterViewModel = new SearchFilterViewModel { CountryList = countriesList, CourseList = coursesList, RoleList = rolesList }; return(View(searchFilterViewModel)); }
public async Task <IActionResult> HomeAsync([Bind(Prefix = "Filter")] SearchFilterViewModel searchFilter) { var filteredJobs = await GetFilteredJobs(searchFilter); var categories = await _context.Set <JobCategory>().Include(jc => jc.Jobs).ToListAsync(); var testimonials = await _context.Testimonials.ToListAsync(); var blogPosts = await _context.Posts.Select(p => p.ToViewModel()).ToListAsync(); var vm = new HomeViewModel { Jobs = filteredJobs, Categories = categories, Testimonials = testimonials, Posts = blogPosts }; return(View(vm)); }
private void Convert(SearchFilterViewModel <T> f) { m_paramIdx++; var param = string.Format("p{0}", m_paramIdx); m_parameters.Add(param, "%" + f.Term + "%"); var q = new List <string>(); foreach (string column in f.Columns) { q.Add(string.Format("[{0}] LIKE @{1}", column, param)); } var clause = string.Format("({0})", string.Join(" OR ", q.ToArray())); m_clauses.Add(clause); }
private static ResourceFilter ConvertToSearchFilterDto(SearchFilterViewModel searchFilterViewModel) { var tagNames = new Collection <string>(); if (!string.IsNullOrEmpty(searchFilterViewModel.Tags)) { tagNames = new Collection <string>(searchFilterViewModel.Tags.Split(',')); } var creationDateRange = searchFilterViewModel.CreationDateRange.ParseToDateRange(); var approvalDateRange = searchFilterViewModel.ApprovalDateRange.ParseToDateRange(); return(new ResourceFilter() { Query = searchFilterViewModel.Query, Tags = tagNames, CreationDateRange = creationDateRange, ApprovalDateRange = approvalDateRange, AuthorName = searchFilterViewModel.Author, OrderBy = searchFilterViewModel.OrderBy }); }
public void SetupSearch(string searchString = "") { if (!string.IsNullOrWhiteSpace(searchString)) { SortingPaging.SearchString = searchString; } var searchable = Columns.Where(c => c.Searchable); if (searchable.Count() > 0) { IsSearchingEnabled = true; var columns = searchable.ToList().ConvertAll(c => c.PropertyName); SearchableColumnsString = string.Join(", ", columns.ToArray()); string term = SortingPaging.SearchString; if (!string.IsNullOrWhiteSpace(term)) { var filter = new SearchFilterViewModel <T>(columns, term); Filters.Add(filter); } } }
public ActionResult SearchUserRecord(SearchFilterViewModel objSearchFilterViewModel) { UserInRole userInRole = new UserInRole(); SearchFilterViewModel searchFilterViewModel = new SearchFilterViewModel(); try { //var tempResult = (db.UserRegistrations.Where((i => // i.Fname.Contains(objSearchFilterViewModel.Fname.Trim()) || // i.Lname.Contains(objSearchFilterViewModel.Lname.Trim()) || // i.Email.Contains(objSearchFilterViewModel.Email.Trim()) || // i.Hobbies.Contains(objSearchFilterViewModel.Hobbies.Trim()) || // i.Gender.Contains(objSearchFilterViewModel.Gender) || // i.Address.CurrentAddress.Contains(objSearchFilterViewModel.UserAddress.Trim()) || // i.Address.PermanentAddress.Contains(objSearchFilterViewModel.UserAddress.Trim()) || // i.CourseId.Equals(objSearchFilterViewModel.CourseId) || // i.Address.State.Equals(objSearchFilterViewModel.StateId) || // i.Address.CityId.Equals(objSearchFilterViewModel.CityId) || // i.Address.CountryId.Equals(objSearchFilterViewModel.CountryId) || // i.Address.ZipCode.Equals(objSearchFilterViewModel.ZipCode) || // i.DateOfBirth.Equals(objSearchFilterViewModel.DateOfBirth) || // i.DateCreated.Equals(objSearchFilterViewModel.DateCreated))) // .Select(i => i.UserId)); //using linq //List<SearchFilterViewModel> searchFilterViewModel = new List<SearchFilterViewModel>(); //List<UserRegistrationViewModel> userList = db.UserRegistrations.Where(x => // x.Fname.Contains(searchFilterViewModel.Fname) || // x.Lname.Contains(searchFilterViewModel.Lname)|| // x.DateOfBirth.Equals(searchFilterViewModel.DateOfBirth) || // x.CourseId.Equals(searchFilterViewModel.CourseId) || // x.Email.Contains(searchFilterViewModel.Email) || // x.Fname.Contains(searchFilterViewModel.Fname) || // x.Gender.Contains(searchFilterViewModel.Gender) || // x.IsActive.Equals(searchFilterViewModel.IsActive) || // x.IsVerified.Equals(searchFilterViewModel.IsVerified) || // x.Address.PermanentAddress.Contains(searchFilterViewModel.UserAddress)|| // x.Address.CurrentAddress.Contains(searchFilterViewModel.UserAddress) || // x.Address.CountryId.Equals(searchFilterViewModel.CountryId) || // x.Address.StateId.Equals(searchFilterViewModel.StateId) || // x.Address.CityId.Equals(searchFilterViewModel.CityId) || // x.Address.ZipCode.Equals(searchFilterViewModel.ZipCode) || // x.Hobbies.Contains(searchFilterViewModel.Hobbies)) // .Select(x => new UserRegistrationViewModel // { // UserId = x.UserId, // Fname = x.Fname, // Lname = x.Lname, // DateOfBirth = x.DateOfBirth, // Hobbies = x.Hobbies, // Email = x.Email, // Gender = x.Gender, // CourseId = x.CourseId, // IsActive = x.IsActive, // IsVerified = x.IsVerified, // AddressId = x.AddressId, // CurrentAddress = x.Address.CurrentAddress, // PermanentAddress = x.Address.PermanentAddress, // ZipCode = x.Address.ZipCode, // CountryId = x.Address.CountryId, // StateId = x.Address.StateId, // CityId = x.Address.CityId, // }).ToList(); List <SearchFilterViewModel> temp = new List <SearchFilterViewModel>(); var result = (from pd in db.Addresses join od in db.UserRegistrations on pd.AddressId equals od.AddressId join ct in db.UserInRoles on od.UserId equals ct.UserId where (pd.CountryId.Equals(searchFilterViewModel.CountryList.Select(m => m.CountryId)) || pd.CountryId == 0) && (pd.StateId.Equals(searchFilterViewModel.StateList.Select(m => m.StateId)) || pd.StateId == 0) && (pd.CityId.Equals(searchFilterViewModel.CityList.Select(m => m.CityId)) || pd.CityId == 0) && (pd.CurrentAddress.Contains(searchFilterViewModel.UserAddress) || pd.CurrentAddress == null) && (pd.PermanentAddress.Contains(searchFilterViewModel.UserAddress) || pd.PermanentAddress == null) && (pd.ZipCode.Equals(searchFilterViewModel.ZipCode) || pd.ZipCode == null) && (od.Fname.Contains(searchFilterViewModel.Fname) || od.Fname == null) && (od.Lname.Contains(searchFilterViewModel.Lname) || od.Lname == null) && (od.Gender.Contains(searchFilterViewModel.Gender) || od.Gender == null) && (od.DateCreated.Equals(searchFilterViewModel.DateCreated) || od.DateCreated == null) && (od.DateOfBirth.Equals(searchFilterViewModel.DateOfBirth) || od.DateOfBirth == null) && (od.IsActive.Equals(searchFilterViewModel.IsActive) || od.IsActive == false) && (od.IsVerified.Equals(searchFilterViewModel.IsVerified) || od.IsVerified == false) && (od.Email.Contains(searchFilterViewModel.Email) || od.Email == null) && (od.CourseId.Equals(searchFilterViewModel.CourseList.Select(m => m.CourseId)) || od.CourseId == null) && (od.Hobbies.Contains(searchFilterViewModel.Hobbies) || od.Hobbies == null) && (ct.RoleId.Equals(searchFilterViewModel.RoleId) || ct.RoleId == null) select new SearchFilterViewModel { //UserId = od.UserId, Fname = od.Fname, Lname = od.Lname, DateOfBirth = od.DateOfBirth, Hobbies = od.Hobbies, Email = od.Email, Gender = od.Gender, CourseId = od.CourseId, IsActive = od.IsActive, IsVerified = od.IsVerified, AddressId = od.AddressId, UserAddress = od.Address.CurrentAddress, // UserAddress = od.Address.PermanentAddress, ZipCode = od.Address.ZipCode, CountryId = od.Address.CountryId, StateId = od.Address.StateId, CityId = od.Address.CityId, }).ToList(); foreach (var item in result) { SearchFilterViewModel tempList = new SearchFilterViewModel(); temp.Add(tempList); } return(View(temp)); } catch (Exception ex) { Console.WriteLine("Exception source: {0}", ex.Message); } return(View()); }
public async Task <ActionResult> JobFilters([Bind(Prefix = "Filter")] SearchFilterViewModel searchFilterViewModel) { var jobLists = await GetFilteredJobs(searchFilterViewModel); return(PartialView("_JobFilters", jobLists)); }