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