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