public void LoadProductPriceDetails() { int numberOfItems = Convert.ToInt32(ddlNumberOfItems.SelectedItem.Value); int productId = Convert.ToInt32(ddlProducts.SelectedItem.Value); if (productId > 0 && numberOfItems > 0) { InventoryBL bl = new InventoryBL(); var product = bl.GetProducts(productId).FirstOrDefault(); if (product != null) { if (product.Supplier_Id > 0) { var supplier = bl.GetSuppliers(product.Supplier_Id).FirstOrDefault(); if (supplier != null) { txtCost.Text = product.Price.ToString(); txtAmount.Text = (product.Price * numberOfItems).ToString(); txtGrossAmount.Text = (product.Price * numberOfItems).ToString(); txtServiceCharge.Text = supplier.Service_Charge_Value; txtVat.Text = supplier.Vat_Charge_Value; txtNetAmount.Text = ((product.Price * numberOfItems) + Convert.ToInt32(supplier.Service_Charge_Value) + Convert.ToInt32(supplier.Vat_Charge_Value)).ToString(); } } } } }
public void LoadDropdowns() { InventoryBL bl = new InventoryBL(); var products = bl.GetProducts(0); ddlProducts.Items.Add(new ListItem("Select", "0")); foreach (var item in products) { ddlProducts.Items.Add(new ListItem(item.Product_Name, item.Product_ID.ToString())); } }
public static dynamic GetProducts(int productId) { InventoryBL bl = new InventoryBL(); var result = bl.GetProducts(productId); return(result.Select(products => new { Product_ID = products.Product_ID, Product_Name = products.Product_Name, SKU = products.SKU, Supplier_Id = products.Supplier_Id, Product_Description = products.Product_Description, Product_Quantity = products.Product_Quantity, Price = products.Price, ExpiryDate = products.ExpiryDate.GetValueOrDefault().ToShortDateString(), Availability = products.Availability }).ToList()); }