public JsonResult AddItemToSession(string request)
{
TblItemStock UIinput = JsonConvert.DeserializeObject <TblItemStock>(request);
//_context.Configuration.ProxyCreationEnabled = false;
UIinput.Item = _context.TblItems.FirstOrDefault(q => q.Id == UIinput.Id);
SalesItemStock.Add(UIinput);
ViewBag.TblItemStock = SalesItemStock;
//Session["SalesItemStock"] = SalesItemStock;
//var TotalAmountBeforeTax = SalesItemStock.Select(q => q.TotalPriceBeforeTax).Sum();
//var TaxAmount = SalesItemStock.Select(q => q.Gst).Sum();
//var TotalAmountAfterTax = SalesItemStock.Select(q => q.TotalPriceAfterTax).Sum();
var total = (from p in SalesItemStock
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 { SalesItemStock, total }));
}
public async Task <IActionResult> Edit(string id, [Bind("AutoId,Id,StockType,PurchaseId,SaleId,InvoiceNo,ItemId,Qty,PricePerUnit,ItemwiseDiscount,PricePerUnitAfterDiscount,TotalPriceBeforeTax,Sgst,Cgst,Igst,Gst,TotalPriceAfterTax,Mrp,ManufactureDate,Expirydate,BatchNo,CreatedDatetime")] TblItemStock tblItemStock)
{
if (id != tblItemStock.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tblItemStock);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblItemStockExists(tblItemStock.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ItemId"] = new SelectList(_context.TblItems, "Id", "Id", tblItemStock.ItemId);
ViewData["PurchaseId"] = new SelectList(_context.TblPurchase, "Id", "Id", tblItemStock.PurchaseId);
ViewData["SaleId"] = new SelectList(_context.TblSale, "SaleId", "SaleId", tblItemStock.SaleId);
return(View(tblItemStock));
}
public async Task <IActionResult> Create([Bind("AutoId,Id,StockType,PurchaseId,SaleId,InvoiceNo,ItemId,Qty,PricePerUnit,ItemwiseDiscount,PricePerUnitAfterDiscount,TotalPriceBeforeTax,Sgst,Cgst,Igst,Gst,TotalPriceAfterTax,Mrp,ManufactureDate,Expirydate,BatchNo,CreatedDatetime")] TblItemStock tblItemStock)
{
if (ModelState.IsValid)
{
_context.Add(tblItemStock);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ItemId"] = new SelectList(_context.TblItems, "Id", "Id", tblItemStock.ItemId);
ViewData["PurchaseId"] = new SelectList(_context.TblPurchase, "Id", "Id", tblItemStock.PurchaseId);
ViewData["SaleId"] = new SelectList(_context.TblSale, "SaleId", "SaleId", tblItemStock.SaleId);
return(View(tblItemStock));
}
public async Task <IActionResult> Create(
[Bind(
"Id,Name,HsnSacNo,Type,MeasuringUnit,Manufacture,BarCode,ItemUniqueDescription,Supplier,Photo,UseBatchNo,UseMfgDate,UseExpiryDate,CreatedDatetime,Gst")]
TblItems items, [Bind("OpeningStock")] int?openingStock)
{
if (ModelState.IsValid)
{
var saved = false;
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_context.Add(items);
//await _context.SaveChangesAsync();
_context.UpdateNextSequence(SequenceTable.tbl_Items);
//TblSequence NewSequenceValue = Helper.GenericHelper.GetNextUpdatedData("tbl_Items");
//_context.Entry(NewSequenceValue).State = EntityState.Modified;
//await _context.SaveChangesAsync();
if (openingStock > 0)
{
TblItemStock tbl_ItemStock = new TblItemStock()
{
Id = items.Id + "-" + Helper.GenericHelper.GetMaxValue("tbl_ItemStock") + "-1",
StockType = "IN",
InvoiceNo = "Opening Stock",
ItemId = items.Id,
Qty = openingStock,
CreatedDatetime = items.CreatedDatetime.ToString() ??
DateTime.Now.Date.ToString(CultureInfo.InvariantCulture)
};
_context.TblItemStock.Add(tbl_ItemStock);
//await _context.SaveChangesAsync();
_context.UpdateNextSequence(SequenceTable.tbl_ItemStock);
}
await _context.SaveChangesAsync();
saved = true;
}
catch (Exception e)
{
throw new InvalidOperationException(e.Message);
}
finally
{
if (saved)
{
transaction.Commit();
}
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["Gst"] = new SelectList(_context.TblGst, "Id", "Name", items.Gst);
ViewData["MeasuringUnit"] = new SelectList(_context.TblItemUnits, "MeasurintUnitId", "MeasuringUnits",
items.MeasuringUnit);
ViewData["Supplier"] = new SelectList(_context.TblVendor, "Id", "Name", items.Supplier);
ViewData["Type"] = new SelectList(_context.TblItemType, "ItemTypeId", "ItemType", items.Type);
return(View(items));
}
