public async Task <List <IngredientModel> > GetIngredients() { using (CircleCoffeeContext db = new CircleCoffeeContext()) { var ingredients = db.TblIngredientInventory.Select(a => new IngredientModel { Id = a.Id, IngredientName = a.IngredientName }); return(await ingredients.ToListAsync()); } }
public async Task <List <TblProduct> > GetProducts() { using (CircleCoffeeContext db = new CircleCoffeeContext()) { var products = db.TblProduct.Select(a => new TblProduct { Id = a.Id, ProductName = a.ProductName }); return(await products.ToListAsync()); } }
public async Task <List <IngredientInventoryModel> > GetIngredientUnits() { using (CircleCoffeeContext db = new CircleCoffeeContext()) { var IngredientInventories = db.TblIngredientInventory.Select(a => new IngredientInventoryModel { Id = a.Id, IngredientName = a.IngredientName, TotalUnit = a.TotalUnit }).OrderByDescending(x => x.Id); return(await IngredientInventories.ToListAsync()); } }
public async Task <List <ProductIngredientUnitModel> > GetProductIngredientUnits() { using (CircleCoffeeContext db = new CircleCoffeeContext()) { var queryProductIngredientUnit = from main in db.TblProductIngredientUnit join prod in db.TblProduct on main.ProductId equals prod.Id join ingredient in db.TblIngredientInventory on main.IngredientId equals ingredient.Id select new { Main = main, Prod = prod, Ingredient = ingredient }; var productIngredientUnits = queryProductIngredientUnit.Select(a => new ProductIngredientUnitModel { Id = a.Main.Id, IngredientName = a.Ingredient.IngredientName, ProductName = a.Prod.ProductName, Unit = a.Main.Unit }); return(await productIngredientUnits.ToListAsync()); } }
public async Task <bool> SaveIngredientInventory(IngredientTotalUnitModel model) { using (CircleCoffeeContext db = new CircleCoffeeContext()) { var ingredientTotalUnit = db.TblIngredientInventory.Where (x => x.IngredientName == model.IngredientName).FirstOrDefault(); if (ingredientTotalUnit == null) { ingredientTotalUnit = new TblIngredientInventory() { IngredientName = model.IngredientName, TotalUnit = model.TotalUnit }; db.TblIngredientInventory.Add(ingredientTotalUnit); } else { ingredientTotalUnit.IngredientName = model.IngredientName; ingredientTotalUnit.TotalUnit = model.TotalUnit; } return(await db.SaveChangesAsync() >= 1); } }