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