public static void delete(tbl_FoodItem fooditem) { RMSDBEntities db = DBContext.getInstance(); db.tbl_FoodItem.Remove(fooditem); db.SaveChanges(); }
public static List <FoodItemViewModelForDSR> getAllMappedToFoodITemViewModelForDSRByDate(DateTime fromDate, DateTime toDate) { List <tbl_SaleItem> soldItems = getAllByDate(fromDate, toDate); List <FoodItemViewModelForDSR> mappedList = new List <FoodItemViewModelForDSR>(); foreach (tbl_SaleItem soldItem in soldItems) { FoodItemViewModelForDSR item = new FoodItemViewModelForDSR(); item.Id = (int)soldItem.Item_id; item.Quantity = (int)soldItem.Quantity; item.SaleId = (int)soldItem.Sale_id; item.Date = (DateTime)soldItem.tbl_Sale.Date_Time; if (item.Id >= 20000) { tbl_Deal deal = Deal.getById(item.Id); item.Name = deal.Name; item.SalePrice = (int)deal.SalePrice; item.CategoryName = deal.tbl_FoodItemCategory.Name; item.Total = item.SalePrice * item.Quantity; mappedList.Add(item); } else { tbl_FoodItem foodItem = FoodItem.getById(item.Id); item.Name = foodItem.Name; item.SalePrice = (int)foodItem.SalePrice; item.CategoryName = foodItem.tbl_FoodItemCategory.Name; item.Total = item.SalePrice * item.Quantity; mappedList.Add(item); } } return(mappedList); }
public static void insert(tbl_FoodItem fooditem) { RMSDBEntities db = DBContext.getInstance(); db.tbl_FoodItem.Add(fooditem); db.SaveChanges(); }
private void btn_EditAFoodItem(object sender, RoutedEventArgs e) { if (dg_AllFoodItems.SelectedItem != null) { tbl_FoodItem fi = (tbl_FoodItem)dg_AllFoodItems.SelectedItem; new Form_EditAFoodItem(fi.Id).Show(); Close(); } }
public static void updateWithRecipeString(tbl_FoodItem fooditem, string recipe) { RMSDBEntities db = DBContext.getInstance(); db.Entry(fooditem).State = EntityState.Modified; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); db.Configuration.ValidateOnSaveEnabled = true; }
private void btn_SaveFoodItem(object sender, RoutedEventArgs e) { tbl_FoodItem r = new tbl_FoodItem(); r.Name = tb_FoodItemName.Text; r.SalePrice = Convert.ToInt32(tb_FoodSalePrice.Text); r.Category_Id = cateroryid; r.ManageInventory = cbx_ManageInventory.IsChecked.Value; r.Recipe = tb_FoodItemRecipe.Text; FoodItem.insert(r); Close(); new Form_AddNewFoodItem().Show(); }
private void btn_DeleteAFoodItem(object sender, RoutedEventArgs e) { if (dg_AllFoodItems.SelectedItem != null) { tbl_FoodItem fi = (tbl_FoodItem)dg_AllFoodItems.SelectedItem; FoodItem.delete(fi); AutoClosingMessageBox.Show("Food Item Deleted", "Success", 3000); initFormOperations(); } else { AutoClosingMessageBox.Show("Please Select A Item", "Alert", 3000); } }
public static List <ItemSaleSearchModel> itemSalesSearchByDate(int itemId, DateTime fromDate, DateTime toDate) { List <ItemSaleSearchModel> list = new List <ItemSaleSearchModel>(); List <DateTime> daysList = new List <DateTime>(); daysList.Add(fromDate); while (fromDate.AddDays(1) <= toDate) { fromDate = fromDate.AddDays(1); daysList.Add(fromDate); } if (itemId < 20000) { tbl_FoodItem fi = FoodItem.getById(itemId); foreach (DateTime date in daysList) { int quantity = getTotalQuantityOfItemSoldOnSpecificDate(itemId, date); if (quantity > 0) { ItemSaleSearchModel n = new ItemSaleSearchModel(); n.Date = date; n.Quantity = getTotalQuantityOfItemSoldOnSpecificDate(itemId, date); n.Total = (int)fi.SalePrice * n.Quantity; list.Add(n); } } } else { tbl_Deal deal = Deal.getById(itemId); foreach (DateTime date in daysList) { int quantity = getTotalQuantityOfItemSoldOnSpecificDate(itemId, date); if (quantity > 0) { ItemSaleSearchModel n = new ItemSaleSearchModel(); n.Date = date; n.Quantity = getTotalQuantityOfItemSoldOnSpecificDate(itemId, date); n.Total = (int)deal.SalePrice * n.Quantity; list.Add(n); } } } return(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) { foodItem = FoodItem.getById(id); tb_FoodItemName.Text = foodItem.Name; tb_FoodSalePrice.Text = Convert.ToString(foodItem.SalePrice); cateroryid = (int)foodItem.Category_Id; if (foodItem.ManageInventory == true) { cbx_ManageInventory.IsChecked = true; } tb_FoodItemRecipe.Text = foodItem.Recipe; var categoriesList = FoodItemCategory.getAll(); foreach (tbl_FoodItemCategory item1 in categoriesList) { cb_FoodItemCategory.ItemsSource = categoriesList; cb_FoodItemCategory.DisplayMemberPath = "Name"; cb_FoodItemCategory.SelectedValuePath = "Id"; } cb_FoodItemCategory.SelectedValue = (int)foodItem.Category_Id; UpdateLayout(); }