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); }
private void btn_EditADeal(object sender, RoutedEventArgs e) { if (dg_AllDeals.SelectedItem != null) { tbl_Deal deal = (tbl_Deal)dg_AllDeals.SelectedItem; new Form_EditADeal(deal.Id).Show(); Close(); } }
private void btn_DeleteADeal(object sender, RoutedEventArgs e) { if (dg_AllDeals.SelectedItem != null) { tbl_Deal deal = (tbl_Deal)dg_AllDeals.SelectedItem; Deal.delete(deal.Id); AutoClosingMessageBox.Show("Deal Deleted", "Success", 3000); initFormOperation(); } }
public static void delete(int dealId) { RMSDBEntities db = DBContext.getInstance(); tbl_Deal d = getById(dealId); db.tbl_Deal.Remove(d); db.SaveChanges(); List <tbl_DealFoodItem> list = db.tbl_DealFoodItem.Where(a => a.Deal_Id == dealId).ToList(); db.tbl_DealFoodItem.RemoveRange(list); db.SaveChanges(); }
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); } } } } }
public static void insert(string dealName, int salePrice, List <FoodItemSmallModel> list, bool manageInventory, int catId) { RMSDBEntities db = DBContext.getInstance(); tbl_Deal deal = new tbl_Deal(); deal.Name = dealName; deal.SalePrice = salePrice; deal.ManageInventory = manageInventory; deal.Category_Id = catId; db.tbl_Deal.Add(deal); db.SaveChanges(); foreach (FoodItemSmallModel item in list) { tbl_DealFoodItem dfi = new tbl_DealFoodItem(); dfi.Deal_Id = deal.Id; dfi.FoodItem_Id = item.Id; db.tbl_DealFoodItem.Add(dfi); db.SaveChanges(); } }
public static void update(tbl_Deal deal, List <FoodItemSmallModel> list) { int dealId = deal.Id; RMSDBEntities db = DBContext.getInstance(); db.Entry(deal).State = System.Data.Entity.EntityState.Modified; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); db.Configuration.ValidateOnSaveEnabled = true; List <tbl_DealFoodItem> oldlist = db.tbl_DealFoodItem.Where(a => a.Deal_Id == dealId).ToList(); db.tbl_DealFoodItem.RemoveRange(oldlist); db.SaveChanges(); foreach (FoodItemSmallModel item in list) { tbl_DealFoodItem dfi = new tbl_DealFoodItem(); dfi.Deal_Id = deal.Id; dfi.FoodItem_Id = item.Id; db.tbl_DealFoodItem.Add(dfi); db.SaveChanges(); } }
private void initFormOperations(int dealId) { deal = Deal.getById(dealId); tb_DealName.Text = deal.Name; tb_DealSalePrice.Text = Convert.ToString(deal.SalePrice); cbx_ManageInventory.IsChecked = deal.ManageInventory; foreach (FoodItemSmallModel item in Deal.getMAppedListOfDealDetailsToFoodItemSmallModelByDealId(dealId)) { dg_DealFoodItems.Items.Add(item); } foreach (FoodItemSmallModel item in FoodItem.getMappedListOfAllFoodItemToFoodItemSmallModel()) { dg_AllFoodItems.Items.Add(item); } foreach (tbl_FoodItemCategory item in FoodItemCategory.getAll()) { cb_Cat.ItemsSource = FoodItemCategory.getAll(); cb_Cat.DisplayMemberPath = "Name"; cb_Cat.SelectedValuePath = "Id"; } cb_Cat.SelectedValue = deal.Category_Id; update_lbl_Total(); }