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();
}
