public ActionResult List() { ListViewModel model = new ListViewModel(); model.Filter = new ListFilterViewModel(); model.CurrentPage = 1; model.PageSize = 10; HospitalSearchFilter searchFilter = new HospitalSearchFilter(); searchFilter.CurrentPage = model.CurrentPage.HasValue ? model.CurrentPage.Value : 1; searchFilter.PageSize = model.PageSize.HasValue ? model.PageSize.Value : 10; searchFilter.SortOn = model.SortOn; searchFilter.SortDirection = model.SortDirection; searchFilter.Filter_Name = model.Filter.Filter_Name; searchFilter.Filter_CityCode = model.Filter.Filter_CityCode; model.FilterCitySelectList = GetCitySelectList(); try { model.DataList = _hospitalService.GetAllPaginatedWithDetailBySearchFilter(searchFilter); } catch { model.DataList = new PaginatedList <HospitalWithDetail>(new List <HospitalWithDetail>(), 0, searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection); ViewBag.ErrorMessage = "Error"; } return(View(model)); }
public ActionResult List(ListViewModel model) { // filter bilgilerinin default boş değerlerle doldurulması sağlanıyor if (model.Filter == null) { model.Filter = new ListFilterViewModel(); } if (!model.CurrentPage.HasValue) { model.CurrentPage = 1; } if (!model.PageSize.HasValue) { model.PageSize = 10; } HospitalSearchFilter searchFilter = new HospitalSearchFilter(); searchFilter.CurrentPage = model.CurrentPage.HasValue ? model.CurrentPage.Value : 1; searchFilter.PageSize = model.PageSize.HasValue ? model.PageSize.Value : 10; searchFilter.SortOn = model.SortOn; searchFilter.SortDirection = model.SortDirection; searchFilter.Filter_Name = model.Filter.Filter_Name; searchFilter.Filter_CityCode = model.Filter.Filter_CityCode; model.FilterCitySelectList = GetCitySelectList(); try { model.DataList = _hospitalService.GetAllPaginatedWithDetailBySearchFilter(searchFilter); } catch { model.DataList = new PaginatedList <HospitalWithDetail>(new List <HospitalWithDetail>(), 0, searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection); ViewBag.ErrorMessage = "Error"; } return(View(model)); }
public PaginatedList <HospitalWithDetail> GetAllPaginatedWithDetailBySearchFilter(HospitalSearchFilter searchFilter) { PaginatedList <HospitalWithDetail> resultList = new PaginatedList <HospitalWithDetail>(new List <HospitalWithDetail>(), 0, searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection); using (AppDBContext dbContext = new AppDBContext(_config)) { var query = from h in dbContext.Hospital from c in dbContext.City.Where(x => x.Code == h.CityCode).DefaultIfEmpty() where h.IsDeleted == false select new HospitalWithDetail() { Id = h.Id, Name = h.Name, CityCode = h.CityCode, Address = h.Address, DeletedBy = h.DeletedBy, IsDeleted = h.IsDeleted, Phone = h.Phone, City_Name = c == null ? String.Empty : c.Name }; // filtering if (!string.IsNullOrEmpty(searchFilter.Filter_Name)) { query = query.Where(r => r.Name.Contains(searchFilter.Filter_Name)); } if (searchFilter.Filter_CityCode.HasValue) { query = query.Where(r => r.CityCode == searchFilter.Filter_CityCode.Value); } // asnotracking query = query.AsNoTracking(); //total count var totalCount = query.Count(); //sorting if (!string.IsNullOrEmpty(searchFilter.SortOn)) { // using System.Linq.Dynamic.Core; nuget paketi ve namespace eklenmelidir, dynamic order by yapmak icindir query = query.OrderBy(searchFilter.SortOn + " " + searchFilter.SortDirection.ToUpper()); } else { // deefault sıralama vermek gerekiyor yoksa skip metodu hata veriyor ef 6'da -- 28.10.2019 15:40 // https://stackoverflow.com/questions/3437178/the-method-skip-is-only-supported-for-sorted-input-in-linq-to-entities query = query.OrderBy(r => r.Id); } //paging query = query.Skip((searchFilter.CurrentPage - 1) * searchFilter.PageSize).Take(searchFilter.PageSize); resultList = new PaginatedList <HospitalWithDetail>( query.ToList(), totalCount, searchFilter.CurrentPage, searchFilter.PageSize, searchFilter.SortOn, searchFilter.SortDirection ); } return(resultList); }