private void UpdatePurchaseOrder(int purchaseOrderId) { try { PurchaseOrder purchaseOrder = new PurchaseOrder(); purchaseOrder = _context.PurchaseOrder .Where(x => x.PurchaseOrderId.Equals(purchaseOrderId)) .FirstOrDefault(); if (purchaseOrder != null) { List <PurchaseOrderLine> lines = new List <PurchaseOrderLine>(); lines = _context.PurchaseOrderLine.Where(x => x.PurchaseOrderId.Equals(purchaseOrderId)).ToList(); //update master data by its lines purchaseOrder.Amount = lines.Sum(x => x.Amount); purchaseOrder.SubTotal = lines.Sum(x => x.SubTotal); purchaseOrder.Discount = lines.Sum(x => x.DiscountAmount); purchaseOrder.Tax = lines.Sum(x => x.TaxAmount); purchaseOrder.Total = purchaseOrder.Freight + lines.Sum(x => x.Total); _context.Update(purchaseOrder); _context.SaveChanges(); } } catch (Exception) { throw; } }
private void UpdateSalesOrder(int salesOrderId) { try { SalesOrder salesOrder = new SalesOrder(); salesOrder = _context.SalesOrder .Where(x => x.SalesOrderId.Equals(salesOrderId)) .FirstOrDefault(); if (salesOrder != null) { List <SalesOrderLine> lines = new List <SalesOrderLine>(); lines = _context.SalesOrderLine.Where(x => x.SalesOrderId.Equals(salesOrderId)).ToList(); //update master data by its lines salesOrder.Amount = lines.Sum(x => x.Amount); salesOrder.SubTotal = lines.Sum(x => x.SubTotal); salesOrder.Discount = lines.Sum(x => x.DiscountAmount); salesOrder.Tax = lines.Sum(x => x.TaxAmount); salesOrder.Total = salesOrder.Freight + lines.Sum(x => x.Total); _context.Update(salesOrder); _context.SaveChanges(); } } catch (Exception) { throw; } }