public IActionResult AccountPay() { var supplier = context.Supplier.GetAll().ToList(); PurchaseProductVM purchaseProductVM = new PurchaseProductVM() { SupplierItem = POSHelper.Supplier(supplier), }; return(View(purchaseProductVM)); }
public IActionResult Index(PurchaseProductVM purchaseProduct) { try { #region Pushing into Purchase Product PurchaseProduct purchase = new PurchaseProduct() { InvoiceNumber = purchaseProduct.InvoiceNumber, SupplierId = purchaseProduct.SupplierId, SubTotal = purchaseProduct.SubTotal, GrandTotal = purchaseProduct.GrandTotal, Discount = purchaseProduct.Discount, Dues = purchaseProduct.Dues, PaidAmount = purchaseProduct.PaidAmount, PaymentMode = purchaseProduct.PaymentMode, }; context.PurchaseProduct.Add(purchase); context.Save(); #endregion #region Pushing into Purchase Product Detail foreach (var item in purchaseProduct.PurchaseProductDetails) { PurchaseProductDetail purchaseProductDetail = new PurchaseProductDetail() { PurchaseProductId = purchase.Id, InvoiceNumber = item.InvoiceNumber, ProductId = item.ProductId, Quantity = item.Quantity, UnitPrice = item.UnitPrice, VatAndTaxId = item.VatAndTaxId, BasePrice = item.BasePrice, SellPrice = item.SellPrice, }; context.PurchaseProductDetail.Add(purchaseProductDetail); context.Save(); UpdateInventory(item.ProductId, item.Quantity, item.SellPrice); } #endregion return(Json(true)); } catch (Exception ex) { return(Json(ex.Message)); throw ex; } }
public IActionResult Index() { var supplierList = context.Supplier.GetAll().ToList(); var productList = context.Product.GetAll().ToList(); var vatAndTax = context.VatAndTax.GetAll().ToList(); PurchaseProductVM purchaseProduct = new PurchaseProductVM() { SupplierItem = POSHelper.Supplier(supplierList), ProductItem = POSHelper.Product(productList), VatItem = POSHelper.VatAndTax(vatAndTax), }; return(View(purchaseProduct)); }
private void dataGridBind() { try { _entities = new KBBQEntities(); int rowNo = 1; dgItemDetails.AutoGenerateColumns = false; List <PurchaseProductVM> modelList = new List <PurchaseProductVM>(); var data = _entities.purchaseProducts.OrderBy(x => x.pName); foreach (var item in data) { PurchaseProductVM model = new PurchaseProductVM(); model.rowNo = rowNo; model.id = Convert.ToInt32(item.id); model.pName = item.pName; model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy"); model.weight = item.weight + " " + item.unit; model.qty = item.qty; model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MM-yyyy hh:mm tt"); if (item.udate == null) { model.udate = "--"; } else { model.udate = Convert.ToDateTime(item.udate).ToString("dd-MM-yyyy hh:mm tt"); } modelList.Add(model); rowNo++; } dgItemDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
public IActionResult AccountPay(PurchaseProductVM purchaseProduct) { try { foreach (var item in purchaseProduct.PurchaseProducts) { var purchase = context.PurchaseProduct.Find(x => x.InvoiceNumber == item.InvoiceNumber).FirstOrDefault(); if (purchase != null) { purchase.PaidAmount = purchase.GrandTotal; purchase.Dues = 0; context.Save(); } } return(Json(true)); } catch (Exception ex) { return(Json(false)); throw ex; } }