public JsonResult AddItemToSession(string request)
{
tbl_ItemStock UIinput = JsonConvert.DeserializeObject <tbl_ItemStock>(request);
db.Configuration.ProxyCreationEnabled = false;
UIinput.tbl_Items = db.tbl_Items.Where(q => q.ID == UIinput.ItemID).FirstOrDefault();
PurchaseItemStock.Add(UIinput);
ViewBag.tbl_ItemStock = PurchaseItemStock;
Session["PurchaseItemStock"] = PurchaseItemStock;
var TotalAmountBeforeTax = PurchaseItemStock.Select(q => q.TotalPriceBeforeTax).Sum();
var TaxAmount = PurchaseItemStock.Select(q => q.GST).Sum();
var TotalAmountAfterTax = PurchaseItemStock.Select(q => q.TotalPriceAfterTax).Sum();
var total = (from p in PurchaseItemStock
group p by 1 into g
select(
new
{
TotalAmountBeforeTax = g.Sum(q => q.TotalPriceBeforeTax),
TaxAmount = g.Sum(q => q.GST),
TotalAmountAfterTax = g.Sum(q => q.TotalPriceAfterTax),
}
)).FirstOrDefault();
return(Json(new { PurchaseItemStock, total }, JsonRequestBehavior.AllowGet));
}
//public async Task<ActionResult> Create([Bind(Include = "ID,Name,HSN_SAC_NO,Type,MeasuringUnit,Manufacture,BarCode,ItemUniqueDescription,Supplier,Photo,UseBatchNo,UseMfgDate,UseExpiryDate,CreatedDatetime")] tbl_Items tbl_Items)
public async Task <ActionResult> Create([Bind(Include = "ID,Name,HSN_SAC_NO,Type,MeasuringUnit,Manufacture,BarCode,ItemUniqueDescription,Supplier,Photo,UseBatchNo,UseMfgDate,UseExpiryDate,CreatedDatetime,GST")] tbl_Items tbl_Items, [Bind(Include = "OpeningStock")] int?OpeningStock)
{
if (ModelState.IsValid)
{
db.tbl_Items.Add(tbl_Items);
await db.SaveChangesAsync();
tbl_Sequence NewSequenceValue = Helper.GenericHelper.GetNextUpdatedData("tbl_Items");
db.Entry(NewSequenceValue).State = EntityState.Modified;
await db.SaveChangesAsync();
if (OpeningStock > 0)
{
tbl_ItemStock tbl_ItemStock = new tbl_ItemStock()
{
ID = tbl_Items.ID + "-" + Helper.GenericHelper.GetMaxValue("tbl_ItemStock") + "-1",
StockType = "IN",
InvoiceNo = "Opening Stock",
ItemID = tbl_Items.ID,
Qty = OpeningStock,
CreatedDatetime = tbl_Items.CreatedDatetime.ToString() ?? DateTime.Now.Date.ToString()
};
db.tbl_ItemStock.Add(tbl_ItemStock);
await db.SaveChangesAsync();
}
return(RedirectToAction("Index"));
}
ViewBag.Type = new SelectList(db.tbl_ItemType, "ItemTypeId", "ItemType", tbl_Items.Type);
ViewBag.MeasuringUnit = new SelectList(db.tbl_ItemUnits, "MeasurintUnitID", "MeasuringUnits", tbl_Items.MeasuringUnit);
ViewBag.Supplier = new SelectList(db.tbl_vendor, "ID", "Name", tbl_Items.Supplier);
ViewBag.GST = new SelectList(db.tbl_GST, "ID", "GST", tbl_Items.GST);
return(View(tbl_Items));
}
public async Task <ActionResult> Create([Bind(Include = "AutoID,ID,PartyInvoiceDate,PurchaseDate,PartyInvoiceNo,PartyName,PaymentDueAfter,ReverseCharge,tbl_ItemStock,Remark,DiscountAmount,OtherCharge,TotalAmountBeforeTax,TaxAmount,TotalAmountAfterTax,RoundOff,GrandTotal,PurchaseBook,PaymentMode,ScanCopy,CreatedDatetime")] tbl_Purchase tbl_Purchase, tbl_ItemStock tbl_ItemStock)
{
if (ModelState.IsValid)
{
var t = JsonConvert.SerializeObject(tbl_Purchase);
db.tbl_Purchase.Add(tbl_Purchase);
await db.SaveChangesAsync();
tbl_Sequence NewSequenceValue = Helper.GenericHelper.GetNextUpdatedData("tbl_Purchase");
db.Entry(NewSequenceValue).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.PaymentMode = new SelectList(db.tbl_PaymentMode, "ID", "Mode", tbl_Purchase.PaymentMode);
ViewBag.PartyName = new SelectList(db.tbl_vendor, "ID", "Name", tbl_Purchase.PartyName);
return(View(tbl_Purchase));
}
