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