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