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