public void ddlSubCategory_SelectedIndexChanged(object sender, EventArgs e)
{
using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
{
var pro = (from a in db.tbl_ProductListDtls
where a.IsDelete == false & a.SubCatId == int.Parse(ddlSubCategory.SelectedItem.Value)
select new
{
a.ProductId,
a.ProductName
}).ToList();
ddlProduct.DataSource = pro;
ddlProduct.DataTextField = "ProductName";
ddlProduct.DataValueField = "ProductId";
ddlProduct.DataBind();
db.Dispose();
ddlProduct.Items.Insert(0, new ListItem("--Select Product--", "0"));
//var value = int.Parse(ddlProduct.SelectedItem.Value);
//var value = int.Parse(ddlSubCategory.SelectedItem.Value);
//var getData = (from s in db.stockItemList(value) select s).ToList();
//gvItemList.DataSource = getData;
//gvItemList.DataBind();
//gvItemList.Visible = true;
}
}
protected void ddlAddCategory_SelectedIndexChanged(object sender, EventArgs e)
{
using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
{
var Subcat = (from a in db.tbl_SubCategoryDtls
where a.IsDelete == false & a.CatId == int.Parse(ddlAddCategory.SelectedItem.Value)
select new { a.SubCatId, a.SubCatName, }).ToList();
ddlSubCategoryPnlProd.DataSource = Subcat;
ddlSubCategoryPnlProd.DataTextField = "SubCatName";
ddlSubCategoryPnlProd.DataValueField = "SubCatId";
ddlSubCategoryPnlProd.DataBind();
db.Dispose();
ddlSubCategoryPnlProd.Items.Insert(0, new ListItem("--Select Sub-Category--", "0"));
}
}
protected void ddlSubCat_SelectedIndexChanged(object sender, EventArgs e)
{
using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
{
var product = (from a in db.tbl_ProductListDtls
where a.IsDelete == false & a.SubCatId == int.Parse(ddlSubCat.SelectedItem.Value)
select new
{
a.ProductId,
a.ProductName
}).ToList();
ddlProduct.DataSource = product;
ddlProduct.DataTextField = "ProductName";
ddlProduct.DataValueField = "ProductId";
ddlProduct.DataBind();
db.Dispose();
ddlProduct.Items.Insert(0, new ListItem("--Select Sub-Product--", "0"));
}
}
protected void BindCategory()
{
using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
{
var cat = (from a in db.mstCategories
where a.IsDelete == false
select new
{
a.CatId,
a.CategoryName
}).ToList();
ddlCategory.DataSource = cat;
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataValueField = "CatId";
ddlCategory.DataBind();
db.Dispose();
ddlCategory.Items.Insert(0, new ListItem("--Select Category--", "0"));
}
}