public void DeleteFridgeProducts(int id_fridge, int id_product, int amount)
{
using (hotelDBEntities context = new hotelDBEntities())
{
Product_Fridge fridge_product = context.Product_Fridge.FirstOrDefault(r => (r.id_fr == id_fridge) && (r.id_pr == id_product));
int? currentamount = fridge_product.amount;
currentamount = currentamount - amount;
fridge_product.amount = currentamount;
context.SaveChanges();
}
}
private bool DoesProductInFridgeExists(int id_fridge, int id_product)
{
using (hotelDBEntities context = new hotelDBEntities())
{
Product_Fridge fridge_product = context.Product_Fridge.FirstOrDefault(r => (r.id_fr == id_fridge) && (r.id_pr == id_product));
if (fridge_product != null)
{
return(true);
}
else
{
return(false);
}
}
}
public bool IsEnoughAmountInFridge(int id_fridge, int id_product, int amount)
{
using (hotelDBEntities context = new hotelDBEntities())
{
Product_Fridge fridge_product = context.Product_Fridge.FirstOrDefault(r => (r.id_fr == id_fridge) && (r.id_pr == id_product));
if (fridge_product == null) // Pokud produkt neexistuje
{
return(false);
}
int?currentamount = fridge_product.amount; // Pokud existuje, zkontruji zda je dostatek amountu
if (currentamount >= amount)
{
return(true);
}
else
{
return(false);
}
}
}