private void btn_Save(object sender, RoutedEventArgs e)
{
if (tb_Name.Text == "" || tb_Quantity.Text == "" || tb_MinimumQuantity.Text == "" || tb_PurchasePrice.Text == "")
{
AutoClosingMessageBox.Show("Please Enter Correct Values", "Alert", 3000);
return;
}
tbl_KitchenInventory ki = new tbl_KitchenInventory();
try
{
ki.Name = tb_Name.Text;
ki.Quantity = Convert.ToDouble(tb_Quantity.Text);
ki.MinimumQuantity = Convert.ToDouble(tb_MinimumQuantity.Text);
ki.PurchasePrice = Convert.ToDouble(tb_PurchasePrice.Text);
ki.ExpiryDate = dp_ExpiryDate.SelectedDate;
ki.KitchenInventoryCategory_Id = catId;
KitchenInventory.insert(ki);
AutoClosingMessageBox.Show("Item Added", "Success", 3000);
Close();
new Form_AddNewKitchenInventory().Show();
}
catch
{
AutoClosingMessageBox.Show("Some Error Occured", "Alert", 3000);
return;
}
}
public static void delete(tbl_KitchenInventory ki)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_KitchenInventory.Remove(ki);
db.SaveChanges();
}
public static void insert(tbl_KitchenInventory ki)
{
RMSDBEntities db = DBContext.getInstance();
db.tbl_KitchenInventory.Add(ki);
db.SaveChanges();
}
private void btn_UpdateKitchenInventory(object sender, RoutedEventArgs e)
{
if (dg_AllKitchenInventory.SelectedItem != null)
{
tbl_KitchenInventory ki = (tbl_KitchenInventory)dg_AllKitchenInventory.SelectedItem;
new Form_EditKitchenInventory(ki.Id).Show();
Close();
}
}
public static void update(tbl_KitchenInventory ki)
{
RMSDBEntities db = DBContext.getInstance();
db.Entry(ki).State = EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
}
private void tb_Price_KeyDown_PressEnter(object sender, KeyEventArgs e)
{
if (dg_AllKitchenItems.SelectedItem != null)
{
if (e.Key == Key.Enter)
{
tbl_KitchenInventory ki = (tbl_KitchenInventory)dg_AllKitchenItems.SelectedItem;
ki.PurchasePrice = Convert.ToDouble(tb_Price.Text);
KitchenInventory.update(ki);
initFormOperations();
}
}
}
private void btn_Add(object sender, RoutedEventArgs e)
{
if (dg_AllInventoryItems.SelectedItem != null)
{
tbl_KitchenInventory ki = (tbl_KitchenInventory)dg_AllInventoryItems.SelectedItem;
DetuctInventoryModel item = new DetuctInventoryModel();
item.id = ki.Id;
item.name = ki.Name;
item.quantity = (double)ki.Quantity;
list.Add(item);
dg_SelectedInventoryItems.ItemsSource = null;
dg_SelectedInventoryItems.ItemsSource = list;
}
}
public static void detuctInventoryOfList(List <ItemOrDealSaleModel> saleList)
{
foreach (ItemOrDealSaleModel item in saleList)
{
if (item.Id < 20000)
{
tbl_FoodItem foodItem = FoodItem.getById(item.Id);
if ((bool)foodItem.ManageInventory)
{
RMSDBEntities db = DBContext.getInstance();
List <tbl_DetuctInventory> diList = db.tbl_DetuctInventory.Where(a => a.FoodItem_Id == item.Id).ToList();
foreach (tbl_DetuctInventory item1 in diList)
{
tbl_KitchenInventory ki = KitchenInventory.getById((int)item1.KitchenInventory_id);
double quantity1 = (double)ki.Quantity;
double quantity2 = (double)item1.DeductedQuantity * item.Quantity;
double quantity3 = quantity1 - quantity2;
ki.Quantity = quantity3;
KitchenInventory.update(ki);
}
}
}
else
{
tbl_Deal foodItem = Deal.getById(item.Id);
if ((bool)foodItem.ManageInventory)
{
RMSDBEntities db = DBContext.getInstance();
List <tbl_DetuctInventory> diList = db.tbl_DetuctInventory.Where(a => a.FoodItem_Id == item.Id).ToList();
foreach (tbl_DetuctInventory item1 in diList)
{
tbl_KitchenInventory ki = KitchenInventory.getById((int)item1.KitchenInventory_id);
double quantity1 = (double)ki.Quantity;
double quantity2 = (double)item1.DeductedQuantity * item.Quantity;
double quantity3 = quantity1 - quantity2;
ki.Quantity = quantity3;
KitchenInventory.update(ki);
}
}
}
}
}
void initFormOperations(int id)
{
ki = KitchenInventory.getById(id);
tb_Name.Text = ki.Name;
tb_Quantity.Text = Convert.ToString(ki.Quantity);
tb_MinimumQuantity.Text = Convert.ToString(ki.MinimumQuantity);
tb_PurchasePrice.Text = Convert.ToString(ki.PurchasePrice);
dp_ExpiryDate.SelectedDate = ki.ExpiryDate;
catId = (int)ki.KitchenInventoryCategory_Id;
cb_Category.SelectedValue = catId;
UpdateLayout();
var allCategories = KitchenInventoryCategory.getAll();
foreach (tbl_KitchenInventoryCategory item in allCategories)
{
cb_Category.ItemsSource = allCategories;
cb_Category.DisplayMemberPath = "Name";
cb_Category.SelectedValuePath = "Id";
}
}
