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