public JsonResult DeleteBillItems(SalesBillItems salesBillItems)
{
_context.SalesBillItems.Remove(_context.SalesBillItems.Find(salesBillItems.SalesBillItemsId));
_context.SaveChanges();
return(Json("Success"));
}
public JsonResult CreateSalesBillItems(SalesBillItems salesBillItems)
{
_context.SalesBillItems.Add(salesBillItems);
_context.SaveChanges();
var SalesBillItemsFilter = _context.SalesBillItems.Where(x => x.SalesBillId == salesBillItems.SalesBillId);
var salesBillItemsViewModels = from SalesBillItems in SalesBillItemsFilter
join ItemMaster in _context.ItemMaster on SalesBillItems.ItemMasterId equals ItemMaster.ItemMasterId
select new SalesBillItemsViewModel
{
SalesBillItemsId = SalesBillItems.SalesBillItemsId,
ItemMasterName = ItemMaster.ItemMasterName,
Description = SalesBillItems.Description,
Qty = SalesBillItems.Qty,
Weight = SalesBillItems.Weight,
Amount = SalesBillItems.Amount
};
var totals = new
{
TotalWeight = SalesBillItemsFilter.Sum(x => x.Weight),
TotalAmount = SalesBillItemsFilter.Sum(x => x.Amount)
};
var JsonResult = new
{
BillItems = salesBillItemsViewModels,
Totals = totals
};
return(Json(JsonResult));
}
public JsonResult UpdateBillItems(SalesBillItems salesBillItems)
{
_context.Entry(salesBillItems).Property(x => x.Qty).IsModified = true;
_context.Entry(salesBillItems).Property(x => x.Weight).IsModified = true;
_context.Entry(salesBillItems).Property(x => x.Amount).IsModified = true;
_context.SaveChanges();
return(Json("Success"));
}
