public JsonResult addQuantity(Inventory newItem) { var date = DateTime.Today; string DateFormat = date.ToString(@"MM\/dd\/yyyy"); var data = context.tbl_Inventory.SingleOrDefault(s => s.ID == newItem.ID); if (data != null) { data.Quantity = data.Quantity == null ? 0 : data.Quantity; data.Price = newItem.Price; data.Quantity = newItem.Quantity + data.Quantity; data.Added_Date = DateFormat; data.VendorID = newItem.VendorID; context.Entry(data).State = EntityState.Modified; context.SaveChanges(); tbl_InventoryUsage usg = new tbl_InventoryUsage(); usg.InventoryID = data.ID; usg.Used_Qty = 0; usg.Description = newItem.Quantity + " " + data.Measurement + " added."; usg.Used_Date = DateFormat; context.tbl_InventoryUsage.Add(usg); context.SaveChanges(); } var lst = (from x in context.tbl_ConsumableItems.Where(x => x.Inventory_ID == newItem.ID) select new { ID = x.MenuItem_ID }).ToList(); return(Json(lst)); }
public JsonResult SaveUsageofItem(InventoryUsage invUsage) { var date = DateTime.Today; //string DateFormat = date.ToString("MM/dd/yyyy"); string DateFormat = date.ToString(@"MM\/dd\/yyyy"); tbl_InventoryUsage usg = new tbl_InventoryUsage(); usg.InventoryID = invUsage.InventoryID; usg.Used_Qty = invUsage.Used_Qty; usg.Description = invUsage.Description; usg.Used_Date = DateFormat; context.tbl_InventoryUsage.Add(usg); context.SaveChanges(); return(Json("Saved")); }
public JsonResult addMoreNewItemsInDB(MenusBillingSection model) { var gstPercentFromConfig = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["FoodGstPercent"]); double?amtWithoutTax = 0; double?gst = 0; var date = DateTime.Today; string DateFormat = date.ToString(@"MM\/dd\/yyyy"); var billDet = context.tbl_MenusBillingSection.SingleOrDefault(s => s.Bill_Number == model.Bill_Number); if (billDet != null) { foreach (var f in model.MenusBillingDetailsWithBillNo) { tbl_MenusBillingDetailsWithBillNo menusdetails = new tbl_MenusBillingDetailsWithBillNo(); menusdetails.BillNo = model.Bill_Number; menusdetails.FoodName = f.FoodName; menusdetails.Price = f.Price; menusdetails.Quantity = f.Quantity; menusdetails.OldQuantity = f.Quantity; context.tbl_MenusBillingDetailsWithBillNo.Add(menusdetails); context.SaveChanges(); amtWithoutTax += (f.Price * f.Quantity); var data = context.tbl_Menu.SingleOrDefault(a => a.ID == f.ItemNameID); // && a.Price==model.Price); if (data != null) { if (data.InventoryID != 0) { tbl_InventoryUsage usage = new tbl_InventoryUsage(); usage.InventoryID = data.InventoryID; usage.Used_Qty = f.Quantity; usage.Description = "(Bill No. : " + model.Bill_Number + ") Sold to customer on " + DateFormat; usage.Used_Date = DateFormat; usage.BillNo = model.Bill_Number; usage.MenusBillingDetailsID = menusdetails.ID; usage.GST_NonGST_Bill = "GST"; context.tbl_InventoryUsage.Add(usage); context.SaveChanges(); } } var consumeItem = context.tbl_ConsumableItems.Where(s => s.MenuItem_ID == f.ItemNameID).ToList(); if (consumeItem.Count > 0) { foreach (var m in consumeItem) { string tempUsedQty = Convert.ToString(f.Quantity * m.Quantity); tbl_InventoryUsage usage = new tbl_InventoryUsage(); usage.InventoryID = m.Inventory_ID; usage.Used_Qty = Convert.ToDouble(tempUsedQty); //usage.Used_Qty = f.Quantity * m.Quantity; // Math.Round((double)(f.Quantity * m.Quantity), 2); usage.Description = "Bill No. : " + model.Bill_Number + " | " + f.FoodName; usage.Used_Date = DateFormat; usage.BillNo = model.Bill_Number; usage.MenusBillingDetailsID = menusdetails.ID; usage.GST_NonGST_Bill = "GST"; context.tbl_InventoryUsage.Add(usage); context.SaveChanges(); } } } amtWithoutTax = amtWithoutTax + billDet.PriceWithoutTax; //gst = amtWithoutTax * (2.5 / 100); //gst = (gst * 2); gst = amtWithoutTax * ((double)gstPercentFromConfig / (double)100); gst = Math.Round((double)gst, 2); amtWithoutTax = Math.Round((double)amtWithoutTax, 2); tbl_MenusBillingSection menus = new tbl_MenusBillingSection(); billDet.Price = Math.Round((double)(gst + amtWithoutTax), 2); billDet.GST = gst; billDet.PriceWithoutTax = amtWithoutTax; context.Entry(billDet).State = EntityState.Modified; context.SaveChanges(); } return(Json("Saved")); }
public JsonResult CreateOrder(MenusBillingSection model) { var gstPercentFromConfig = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["FoodGstPercent"]); double?amtWithoutTax = 0; double?gst = 0; var date = DateTime.Today; string DateFormat = date.ToString(@"MM\/dd\/yyyy"); TimeSpan time = DateTime.Now.TimeOfDay; var tableDetails = context.tbl_TablesForBooking.SingleOrDefault(v => v.ID == model.TableID && v.Table_Status == "closed"); if (tableDetails != null) { if (model.UserID == 0 && model.Customer_Name != "" && model.Customer_Name != null) { tbl_Profile prf = new tbl_Profile(); prf.F_Name = model.Customer_Name; prf.PhoneNo = model.Phone; prf.Walk_In_Member = true; prf.Status = true; prf.UserType = 3; prf.AddedBy = Request.Cookies["AddedBy"].Value; prf.NewUsrBySuperApprv = true; prf.DelUsrBySuperApprv = false; prf.Reference_Of_Walk_In = "0"; prf.EmailNotifications = true; context.tbl_Profile.Add(prf); context.SaveChanges(); model.UserID = prf.ID; } var billDet = context.tbl_MenusBillingSection.ToList().LastOrDefault(); foreach (var f in model.MenusBillingDetailsWithBillNo) { tbl_MenusBillingDetailsWithBillNo menusdetails = new tbl_MenusBillingDetailsWithBillNo(); menusdetails.BillNo = (billDet != null) ? billDet.Bill_Number + 1 : 1; menusdetails.FoodName = f.FoodName; menusdetails.Price = f.Price; menusdetails.Quantity = f.Quantity; menusdetails.OldQuantity = f.Quantity; context.tbl_MenusBillingDetailsWithBillNo.Add(menusdetails); context.SaveChanges(); amtWithoutTax += (f.Price * f.Quantity); var data = context.tbl_Menu.SingleOrDefault(a => a.ID == f.ItemNameID); // && a.Price==model.Price); if (data != null) { if (data.InventoryID != 0) { tbl_InventoryUsage usage = new tbl_InventoryUsage(); usage.InventoryID = data.InventoryID; usage.Used_Qty = f.Quantity; usage.Description = "(Bill No. : " + ((billDet != null) ? (billDet.Bill_Number + 1) : 1) + ") Sold to customer on " + DateFormat; usage.Used_Date = DateFormat; usage.BillNo = (billDet != null) ? billDet.Bill_Number + 1 : 1; usage.MenusBillingDetailsID = menusdetails.ID; usage.GST_NonGST_Bill = "GST"; context.tbl_InventoryUsage.Add(usage); context.SaveChanges(); } } var consumeItem = context.tbl_ConsumableItems.Where(s => s.MenuItem_ID == f.ItemNameID).ToList(); if (consumeItem.Count > 0) { foreach (var m in consumeItem) { string tempUsedQty = Convert.ToString(f.Quantity * m.Quantity); tbl_InventoryUsage usage = new tbl_InventoryUsage(); usage.InventoryID = m.Inventory_ID; usage.Used_Qty = Convert.ToDouble(tempUsedQty); //Math.Round((double)(f.Quantity * m.Quantity), 2); usage.Description = "Bill No. : " + ((billDet != null) ? (billDet.Bill_Number + 1) : 1) + " | " + f.FoodName; usage.Used_Date = DateFormat; usage.BillNo = (billDet != null) ? billDet.Bill_Number + 1 : 1; usage.MenusBillingDetailsID = menusdetails.ID; usage.GST_NonGST_Bill = "GST"; context.tbl_InventoryUsage.Add(usage); context.SaveChanges(); } } } //gst = amtWithoutTax * (2.5 / 100); //gst = (gst * 2); gst = amtWithoutTax * ((double)gstPercentFromConfig / (double)100); gst = Math.Round((double)gst, 2); amtWithoutTax = Math.Round((double)amtWithoutTax, 2); tbl_MenusBillingSection menus = new tbl_MenusBillingSection(); menus.Bill_Number = (billDet != null) ? billDet.Bill_Number + 1 : 1; menus.Customer_Name = model.Customer_Name; menus.Phone = model.Phone; menus.Price = Math.Round((double)(gst + amtWithoutTax), 2); menus.UserID = model.UserID; menus.GST = gst; menus.PriceWithoutTax = amtWithoutTax; menus.TableID = model.TableID; menus.OrderTakenBy = model.OrderTakenBy; menus.Table_Status = "opened"; menus.menubillno = GetBillNO(); menus.PaymentDate = DateFormat; menus.Order_Time = time; context.tbl_MenusBillingSection.Add(menus); context.SaveChanges(); var tblOrder = context.tbl_TablesForBooking.SingleOrDefault(d => d.ID == model.TableID); if (tblOrder != null) { tblOrder.Table_Status = "opened"; context.Entry(tblOrder).State = EntityState.Modified; context.SaveChanges(); } return(Json("Saved")); } return(Json("Already opened")); }
public JsonResult addNewItem(Inventory newItem) { var date = DateTime.Today; string DateFormat = date.ToString(@"MM\/dd\/yyyy"); //double? usedQty = 0; var data = context.tbl_Inventory.SingleOrDefault(s => s.Item_Name == newItem.Item_Name && s.Type == newItem.Type); if (data != null) { //var usage = context.tbl_InventoryUsage.Where(a => a.InventoryID == data.ID).ToList(); //foreach (var q in usage) //{ // usedQty = usedQty + q.Used_Qty; //} data.Price = newItem.Price; //if (usage.Count() != 0) //{ // double? qty = data.Quantity - usedQty; // if (qty >= 0) // { // data.Quantity = qty + newItem.Quantity; // } // else // { // data.Quantity = newItem.Quantity; // } // foreach (var ug in usage) // { // context.Entry(ug).State = EntityState.Deleted; // context.SaveChanges(); // } //} //else //{ data.Quantity = newItem.Quantity + data.Quantity; //} data.Added_Date = DateFormat; data.VendorID = newItem.VendorID; context.Entry(data).State = EntityState.Modified; context.SaveChanges(); tbl_InventoryUsage usg = new tbl_InventoryUsage(); usg.InventoryID = data.ID; usg.Used_Qty = 0; usg.Description = newItem.Quantity + " " + data.Measurement + " added."; usg.Used_Date = DateFormat; context.tbl_InventoryUsage.Add(usg); context.SaveChanges(); return(Json("Modified")); } else { tbl_Inventory inventory = new tbl_Inventory(); inventory.Item_Name = newItem.Item_Name; inventory.Type = newItem.Type; inventory.Price = newItem.Price; inventory.Quantity = newItem.Quantity; inventory.VendorID = newItem.VendorID; inventory.Added_Date = DateFormat; inventory.Measurement = newItem.Measurement; context.tbl_Inventory.Add(inventory); context.SaveChanges(); return(Json("Added")); } }
public JsonResult UpdateQuantity(int InventoryID, double Instock) { var date = DateTime.Today; string DateFormat = date.ToString(@"MM\/dd\/yyyy"); var data = context.tbl_Inventory.SingleOrDefault(s => s.ID == InventoryID); if (data != null) { var r = context.tbl_InventoryUsage.Where(a => a.InventoryID == data.ID).ToList(); double?usedStock = 0; if (r.Count() > 0) { foreach (var a in r) { usedStock = usedStock + a.Used_Qty; } } usedStock = Math.Round(Convert.ToDouble(usedStock), 2); double OldStock = Convert.ToDouble(data.Quantity) - Convert.ToDouble(usedStock); OldStock = Math.Round(OldStock, 2); Instock = Math.Round(Instock, 2); if (OldStock < Instock) { double Quantity = Instock - OldStock; Quantity = Math.Round(Quantity, 2); data.Quantity = data.Quantity + Quantity; data.Added_Date = DateFormat; context.Entry(data).State = EntityState.Modified; context.SaveChanges(); tbl_InventoryUsage usg = new tbl_InventoryUsage(); usg.InventoryID = data.ID; usg.Used_Qty = 0; usg.Description = Quantity + " " + data.Measurement + " added."; usg.Used_Date = DateFormat; context.tbl_InventoryUsage.Add(usg); context.SaveChanges(); return(Json("updated")); } else if (OldStock > Instock) { double Quantity = OldStock - Instock; Quantity = Math.Round(Quantity, 2); data.Quantity = data.Quantity - Quantity; data.Added_Date = DateFormat; context.Entry(data).State = EntityState.Modified; context.SaveChanges(); tbl_InventoryUsage usg = new tbl_InventoryUsage(); usg.InventoryID = data.ID; usg.Used_Qty = 0; usg.Description = Quantity + " " + data.Measurement + " removed."; usg.Used_Date = DateFormat; context.tbl_InventoryUsage.Add(usg); context.SaveChanges(); return(Json("updated")); } return(Json("both equal")); } return(Json("")); }