public List <Partner> FilterList(ListArgsRequest <BackendPartnerFilter> args, out Int32 TotalCount) { var qry = GetItems(); if (args.Filter.StatusSelected != StatusFilterEnum.Alle) { if (args.Filter.StatusSelected == StatusFilterEnum.Aktiv) { qry = qry.Where(x => x.IsActive); } else { qry = qry.Where(x => !x.IsActive); } } if (args.Filter.PartnerTypeSelected != "Alle") { qry = qry.Where(x => x.PartnerPack.Name == args.Filter.PartnerTypeSelected); } if (!String.IsNullOrEmpty(args.Filter.Name)) { qry = qry.Where(x => x.Name.ToLower().Contains(args.Filter.Name.ToLower())); } TotalCount = qry.Count(); qry = qry.OrderBy(x => x.Name); var items = qry.Skip(args.Pagination.ItemsPerPageSelected * (args.Pagination.Page - 1)) .Take(args.Pagination.ItemsPerPageSelected) .ToList(); return(items); }
public IEnumerable <CateringOrder> FilterList(ListArgsRequest <BackendCateringFilter> args, out Int32 TotalCount) { var qry = db.CateringOrder.AsQueryable(); qry.Include(x => x.CateringOrderDetail); qry = qry.Where(x => x.EventID == args.Filter.EventSelected.ID); if (!String.IsNullOrEmpty(args.Filter.Name)) { qry = qry.Where(x => (x.User.FirstName + " " + x.User.LastName).Contains(args.Filter.Name)); } if (!String.IsNullOrEmpty(args.Filter.SeatNumber)) { qry = qry.Where(x => x.Seat.SeatNumber.ToString().Contains(args.Filter.SeatNumber)); } if (args.Filter.StatusSelected == CateringStatusFilterEnum.Offen) { qry = qry.Where(x => x.OrderState >= 0 && x.OrderState < 2); } if (args.Filter.StatusSelected == CateringStatusFilterEnum.Abgeschlossen) { qry = qry.Where(x => x.OrderState == -1 || x.OrderState == 2); } TotalCount = qry.Count(); qry = qry.OrderByDescending(x => x.Registered); qry = qry.Skip(args.Pagination.ItemsPerPageSelected * (args.Pagination.Page - 1)) .Take(args.Pagination.ItemsPerPageSelected); return(qry); }
public List <User> FilterList(ListArgsRequest <BackendProfileFilter> args, out Int32 TotalCount) { List <BackendUserViewModelItem> result = new List <BackendUserViewModelItem>(); var qry = GetItems(); if (!String.IsNullOrEmpty(args.Filter.FirstName)) { qry = qry.Where(x => x.FirstName.ToLower().Contains(args.Filter.FirstName.ToLower())); } if (!String.IsNullOrEmpty(args.Filter.LastName)) { qry = qry.Where(x => x.LastName.ToLower().Contains(args.Filter.LastName.ToLower())); } if (!String.IsNullOrEmpty(args.Filter.Nickname)) { qry = qry.Where(x => x.Nickname.ToLower().Contains(args.Filter.Nickname.ToLower())); } TotalCount = qry.Count(); qry = qry.OrderBy(x => x.FirstName); var items = qry.Skip(args.Pagination.ItemsPerPageSelected * (args.Pagination.Page - 1)) .Take(args.Pagination.ItemsPerPageSelected) .ToList(); return(items); }
public List <Seat> FilterList(ListArgsRequest <BackendSeatingFilter> args) { var qry = GetItems(); qry = qry.Where(x => x.EventID == args.Filter.EventSelected.ID); qry = qry.OrderByDescending(x => x.ID); return(qry.ToList()); }
public List <Tournament> FilterList(ListArgsRequest <BackendTournamentFilter> args, out Int32 TotalCount) { var qry = GetItems(); qry = qry.Where(x => x.EventID == args.Filter.EventSelected.ID); if (args.Filter.GameSelected.ID != -1) { qry = qry.Where(x => x.TournamentGameID == args.Filter.GameSelected.ID); } TotalCount = qry.Count(); qry = qry.OrderByDescending(x => x.EventID); qry = qry.Skip(args.Pagination.ItemsPerPageSelected * (args.Pagination.Page - 1)) .Take(args.Pagination.ItemsPerPageSelected); return(qry.ToList()); }
public List <CateringProduct> FilterList(ListArgsRequest <BackendProductFilter> args, out Int32 TotalCount) { var qry = GetItems(); if (!String.IsNullOrEmpty(args.Filter.Name)) { qry = qry.Where(x => x.Name.ToLower().Contains(args.Filter.Name.ToLower())); } TotalCount = qry.Count(); qry = qry.OrderByDescending(x => x.ID); var items = qry.Skip(args.Pagination.ItemsPerPageSelected * (args.Pagination.Page - 1)) .Take(args.Pagination.ItemsPerPageSelected) .ToList(); return(items); }
public List <TournamentGame> FilterList(ListArgsRequest <BackendGameFilter> args, out Int32 TotalCount) { var qry = GetItems(); if (!String.IsNullOrEmpty(args.Filter.Name)) { qry = qry.Where(x => x.Name.ToLower().IndexOf(args.Filter.Name.ToLower()) != -1); } TotalCount = qry.Count(); qry = qry.OrderBy(x => x.Name); var items = qry.Skip(args.Pagination.ItemsPerPageSelected * (args.Pagination.Page - 1)) .Take(args.Pagination.ItemsPerPageSelected) .ToList(); return(items); }
public IHttpActionResult Backend_FilterList(ListArgsRequest <BackendSeatingFilter> request) { BackendSeatingListViewModel viewmodel = new BackendSeatingListViewModel(); SeatDataController dataCtrl = new SeatDataController(); EventDataController eventDataCtrl = new EventDataController(); UserDataController userDataCtrl = new UserDataController(); var events = eventDataCtrl.GetItems().OrderByDescending(x => x.Start).ToList(); var users = userDataCtrl.GetItems().OrderBy(x => x.FirstName).ToList(); var eID = request.Filter.EventSelected.ID; var seats = dataCtrl.FilterList(request); viewmodel.Filter.EventSelected = request.Filter.EventSelected; viewmodel.Filter.EventOptions = events.ConvertAll(x => { return(new SeatingFilterEvent() { ID = x.ID, Name = $"{x.EventType.Name} Vol.{x.Volume}" }); }); for (int i = 1; i <= Properties.Settings.Default.SeatAmount; i++) { BackendSeatingViewModelItem item = new BackendSeatingViewModelItem(); Seat model = seats.FirstOrDefault(x => x.SeatNumber == i); if (model == null) { model = new Seat() { SeatNumber = i, State = 0, Event = events[0] } } ; item.FromModel(model); viewmodel.Data.Add(item); } return(Ok(viewmodel)); }