private void DeleteStorageProductAmount(int id_storage, int id_product, int amount)
{
using (hotelDBEntities context = new hotelDBEntities())
{
Storage_Product storage_product = context.Storage_Product.FirstOrDefault(r => (r.id_st == id_storage) && (r.id_pr == id_product));
int? currentamount = storage_product.amount;
currentamount = currentamount - amount;
storage_product.amount = currentamount;
context.SaveChanges();
}
}
private void UpdateStorageProducts(int id_product, int id_storage, int amount)
{
using (hotelDBEntities context = new hotelDBEntities())
{
Storage_Product product_storage = context.Storage_Product.FirstOrDefault(r => (r.id_pr == id_product) && (r.id_st == id_storage));
int? currentamount = product_storage.amount;
MessageBox.Show("BYLO : " + currentamount.ToString());
currentamount = currentamount + amount;
MessageBox.Show("PO PRIDANI : " + currentamount.ToString());
product_storage.amount = currentamount;
context.SaveChanges();
MessageBox.Show("OK PRIDANO");
}
}
private bool DoesProductInStorageExists(int id_product, int id_storage)
{
using (hotelDBEntities context = new hotelDBEntities())
{
Storage_Product product_storage = context.Storage_Product.FirstOrDefault(r => (r.id_pr == id_product) && (r.id_st == id_storage));
if (product_storage != null)
{
return(true);
}
else
{
return(false);
}
}
}
private bool IsEnoughAmountInStorage(int id_storage, int id_product, int amount)
{
using (hotelDBEntities context = new hotelDBEntities())
{
Storage_Product storage_product = context.Storage_Product.FirstOrDefault(r => (r.id_st == id_storage) && (r.id_pr == id_product));
if (storage_product == null) // Pokud produkt neexistuje
{
return(false);
}
int?currentamount = storage_product.amount; // Pokud existuje, zkontruji zda je dostatek amountu
if (currentamount >= amount)
{
return(true);
}
else
{
return(false);
}
}
}
