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