public void LoadDropdowns()
{
InventoryBL bl = new InventoryBL();
var supplier = bl.GetSuppliers(0);
var categories = bl.GetCategories();
var brands = bl.GetBrands();
var stores = bl.GetStores();
ddlSupplier.Items.Add(new ListItem("Select", "0"));
ddlCategory.Items.Add(new ListItem("Select", "0"));
ddlBrand.Items.Add(new ListItem("Select", "0"));
ddlStore.Items.Add(new ListItem("Select", "0"));
foreach (var sup in supplier)
{
ddlSupplier.Items.Add(new ListItem(sup.Supplier_Name, sup.Supplier_Id.ToString()));
}
foreach (var item in categories)
{
ddlCategory.Items.Add(new ListItem(item.Category_Name, item.Category_Id.ToString()));
}
foreach (var item in brands)
{
ddlBrand.Items.Add(new ListItem(item.Brand_Name, item.Brand_Id.ToString()));
}
foreach (var item in stores)
{
ddlStore.Items.Add(new ListItem(item.Store_Name, item.Store_Id.ToString()));
}
}
public static dynamic GetStores()
{
InventoryBL bl = new InventoryBL();
var result = bl.GetStores().Select(x => new
{
Store_Id = x.Store_Id,
Store_Name = x.Store_Name,
Store_Status = x.Store_Status
}).ToList();
return(result);
}
