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