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;
}
}
public IActionResult Insert([FromBody] CrudViewModel <Product> payload)
{
Product product = payload.value;
_context.Product.Add(product);
_context.SaveChanges();
return(Ok(product));
}
public IActionResult Insert([FromBody] CrudViewModel <PurchaseType> payload)
{
PurchaseType purchaseType = payload.value;
_context.PurchaseType.Add(purchaseType);
_context.SaveChanges();
return(Ok(purchaseType));
}
public IActionResult Insert([FromBody] CrudViewModel <Branch> payload)
{
Branch branch = payload.value;
_context.Branch.Add(branch);
_context.SaveChanges();
return(Ok(branch));
}
public IActionResult Insert([FromBody] CrudViewModel <CustomerType> payload)
{
CustomerType customerType = payload.value;
_context.CustomerType.Add(customerType);
_context.SaveChanges();
return(Ok(customerType));
}
public IActionResult Insert([FromBody] CrudViewModel <BillType> payload)
{
BillType billType = payload.value;
_context.BillType.Add(billType);
_context.SaveChanges();
return(Ok(billType));
}
public IActionResult Insert([FromBody] CrudViewModel <UnitOfMeasure> payload)
{
UnitOfMeasure unitOfMeasure = payload.value;
_context.UnitOfMeasure.Add(unitOfMeasure);
_context.SaveChanges();
return(Ok(unitOfMeasure));
}
public IActionResult Insert([FromBody] CrudViewModel <VendorType> payload)
{
VendorType vendorType = payload.value;
_context.VendorType.Add(vendorType);
_context.SaveChanges();
return(Ok(vendorType));
}
public IActionResult Insert([FromBody] CrudViewModel <Currency> payload)
{
Currency currency = payload.value;
_context.Currency.Add(currency);
_context.SaveChanges();
return(Ok(currency));
}
public IActionResult Insert([FromBody] CrudViewModel <ShipmentType> payload)
{
ShipmentType shipmentType = payload.value;
_context.ShipmentType.Add(shipmentType);
_context.SaveChanges();
return(Ok(shipmentType));
}
public IActionResult Insert([FromBody] CrudViewModel <InvoiceType> payload)
{
InvoiceType invoiceType = payload.value;
_context.InvoiceType.Add(invoiceType);
_context.SaveChanges();
return(Ok(invoiceType));
}
public IActionResult Insert([FromBody] CrudViewModel <Warehouse> payload)
{
Warehouse warehouse = payload.value;
_context.Warehouse.Add(warehouse);
_context.SaveChanges();
return(Ok(warehouse));
}
public IActionResult Insert([FromBody] CrudViewModel <CashBank> payload)
{
CashBank cashBank = payload.value;
_context.CashBank.Add(cashBank);
_context.SaveChanges();
return(Ok(cashBank));
}
public IActionResult Insert([FromBody] CrudViewModel <Bill> payload)
{
Bill bill = payload.value;
bill.BillName = _numberSequence.GetNumberSequence("BILL");
_context.Bill.Add(bill);
_context.SaveChanges();
return(Ok(bill));
}
public IActionResult Insert([FromBody] CrudViewModel <PaymentReceive> payload)
{
PaymentReceive paymentReceive = payload.value;
paymentReceive.PaymentReceiveName = _numberSequence.GetNumberSequence("PAYRCV");
_context.PaymentReceive.Add(paymentReceive);
_context.SaveChanges();
return(Ok(paymentReceive));
}
public IActionResult Insert([FromBody] CrudViewModel <Shipment> payload)
{
Shipment shipment = payload.value;
shipment.ShipmentName = _numberSequence.GetNumberSequence("DO");
_context.Shipment.Add(shipment);
_context.SaveChanges();
return(Ok(shipment));
}
public IActionResult Insert([FromBody] CrudViewModel <GoodsReceivedNote> payload)
{
GoodsReceivedNote goodsReceivedNote = payload.value;
goodsReceivedNote.GoodsReceivedNoteName = _numberSequence.GetNumberSequence("GRN");
_context.GoodsReceivedNote.Add(goodsReceivedNote);
_context.SaveChanges();
return(Ok(goodsReceivedNote));
}
public IActionResult Insert([FromBody] CrudViewModel <Invoice> payload)
{
Invoice invoice = payload.value;
invoice.InvoiceName = _numberSequence.GetNumberSequence("INV");
_context.Invoice.Add(invoice);
_context.SaveChanges();
return(Ok(invoice));
}
public IActionResult Insert([FromBody] CrudViewModel <PaymentVoucher> payload)
{
PaymentVoucher paymentVoucher = payload.value;
paymentVoucher.PaymentVoucherName = _numberSequence.GetNumberSequence("PAYVCH");
_context.PaymentVoucher.Add(paymentVoucher);
_context.SaveChanges();
return(Ok(paymentVoucher));
}