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