public async Task <Dish> GetDish(Guid id) { Data.Dish dish = null; using (LazyPhytonsContext context = CreateLazyPhytonsContext()) { dish = await context.Dishes.AsNoTracking().FirstOrDefaultAsync(x => x.Id.Equals(id)).ConfigureAwait(false); } return(dish?.ToApi()); }
public async Task <Caffe> GetCaffe(string name) { Data.Caffe caffe = null; using (LazyPhytonsContext context = CreateLazyPhytonsContext()) { caffe = await context.Caffes.AsNoTracking().FirstOrDefaultAsync(x => x.Name.Equals(name)).ConfigureAwait(false); } return(caffe?.ToApi()); }
public async Task <Beverage> GeBeverage(Guid id) { Data.Beverage beverage = null; using (LazyPhytonsContext context = CreateLazyPhytonsContext()) { beverage = await context.Beverages.AsNoTracking().FirstOrDefaultAsync(x => x.Id.Equals(id)).ConfigureAwait(false); } return(beverage?.ToApi()); }
public async Task <IEnumerable <ICaffe> > GetCaffesWithLunchPriceLessThan(int price) { List <Data.Caffe> caffes = null; using (LazyPhytonsContext context = CreateLazyPhytonsContext()) { caffes = await context.Caffes.AsNoTracking().Where(x => x.Lunch3Price <= price || x.Lunch2Price <= price).ToListAsync().ConfigureAwait(false); } if (caffes == null) { return(Enumerable.Empty <Caffe>()); } return(caffes.Select(x => x.ToApi()).ToList()); }
public async Task <IEnumerable <ICaffe> > GetCaffesWithFreeBeaverages() { List <Data.Caffe> caffes = null; using (LazyPhytonsContext context = CreateLazyPhytonsContext()) { caffes = await context.Caffes.AsNoTracking().Where(x => x.IsFreeBeverages).ToListAsync().ConfigureAwait(false); } if (caffes == null) { return(Enumerable.Empty <Caffe>()); } return(caffes.Select(x => x.ToApi()).ToList()); }
public async Task <IEnumerable <Caffe> > GetCaffesInRange(long distance) { List <Data.Caffe> caffes = null; using (LazyPhytonsContext context = CreateLazyPhytonsContext()) { caffes = await context.Caffes.AsNoTracking().Where(x => x.DistanceFromOffice <= distance).ToListAsync().ConfigureAwait(false); } if (caffes == null) { return(Enumerable.Empty <Caffe>()); } return(caffes.Select(x => x.ToApi()).ToList()); }
public async Task <IEnumerable <Dish> > GetAllDishes() { List <Data.Dish> dishes = null; using (LazyPhytonsContext context = CreateLazyPhytonsContext()) { dishes = await context.Dishes.AsNoTracking().ToListAsync().ConfigureAwait(false); } if (dishes == null) { return(Enumerable.Empty <Dish>()); } return(dishes.Select(x => x.ToApi())); }
public async Task <IEnumerable <Beverage> > GetAllBeveragesByMenuId(Guid menuId) { List <Data.Beverage> beverages = null; using (LazyPhytonsContext context = CreateLazyPhytonsContext()) { beverages = await context.Beverages.AsNoTracking().Where(x => x.MenuId.Equals(menuId)).ToListAsync().ConfigureAwait(false); } if (beverages == null) { return(Enumerable.Empty <Beverage>()); } return(beverages.Select(x => x.ToApi()).ToList()); }