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