protected void filterproduct()
{
string stractive;
if (chk_activefilter.Checked == true)
{
stractive = "";
}
string strcln = " SELECT distinct WebsiteMaster.ID as WebsiteMaster_ID,VersionInfoMaster.VersionInfoId,MasterPageMaster.MasterPageId, ProductMaster.ProductName + ':' + VersionInfoMaster.VersionInfoName + ' : ' + WebsiteMaster.WebsiteName + ':' + WebsiteSection.SectionName + ':' + MasterPageMaster.MasterPageName as MasterPage_Name FROM ProductMaster inner join VersionInfoMaster on ProductMaster.ProductId=VersionInfoMaster.ProductId inner join ProductDetail on ProductDetail.ProductId=ProductMaster.ProductId inner join WebsiteMaster on WebsiteMaster.VersionInfoId=VersionInfoMaster.VersionInfoId inner join WebsiteSection on WebsiteSection.WebsiteMasterId=WebsiteMaster.ID inner join MasterPageMaster on MasterPageMaster.WebsiteSectionId=WebsiteSection.WebsiteSectionId where VersionInfoMaster.VersionInfoId='32' order by MasterPage_Name";
SqlCommand cmdcln = new SqlCommand(strcln, con);
DataTable dtcln = new DataTable();
SqlDataAdapter adpcln = new SqlDataAdapter(cmdcln);
adpcln.Fill(dtcln);
FilterProduct.DataSource = dtcln;
FilterProduct.DataValueField = "MasterPageId";
FilterProduct.DataTextField = "MasterPage_Name";
FilterProduct.DataBind();
//FilterProduct.Items.Insert(0, "All");
//FilterProduct.Items[0].Value = "0";
if (dtcln.Rows.Count > 0)
{
ViewState["versioninfo"] = dtcln.Rows[0]["VersionInfoId"].ToString();
FilterProduct.SelectedValue = dtcln.Rows[0]["MasterPageId"].ToString();
FillterCategorysearch();
filtermainmenu();
filtersubmenu();
functionality();
FilterGrid();
}
//string strcln1 = " SELECT * From TheLastSearchedPageMasterTBL where UserID='" + Session["EmpId"] + "' and Pagename='PageMasterNew' Order By ID Desc";
//SqlCommand cmdcln1 = new SqlCommand(strcln1, con);
//DataTable dtcln1 = new DataTable();
//SqlDataAdapter adpcln1 = new SqlDataAdapter(cmdcln1);
//adpcln1.Fill(dtcln1);
//if (dtcln1.Rows.Count > 0)
//{
// FilterProduct.SelectedValue = dtcln1.Rows[0]["ProductID"].ToString();
//}
}
protected void filterproduct()
{
string strcln = " SELECT distinct WebsiteMaster.ID as WebsiteMaster_ID,VersionInfoMaster.VersionInfoId,MasterPageMaster.MasterPageId, ProductMaster.ProductName + ':' + VersionInfoMaster.VersionInfoName + ' : ' + WebsiteMaster.WebsiteName + ':' + WebsiteSection.SectionName + ':' + MasterPageMaster.MasterPageName as MasterPage_Name FROM ProductMaster inner join VersionInfoMaster on ProductMaster.ProductId=VersionInfoMaster.ProductId inner join ProductDetail on ProductDetail.ProductId=ProductMaster.ProductId inner join WebsiteMaster on WebsiteMaster.VersionInfoId=VersionInfoMaster.VersionInfoId inner join WebsiteSection on WebsiteSection.WebsiteMasterId=WebsiteMaster.ID inner join MasterPageMaster on MasterPageMaster.WebsiteSectionId=WebsiteSection.WebsiteSectionId where ProductMaster.ClientMasterId='" + Session["ClientId"] + "' and VersionInfoMaster.Active ='True' and ProductDetail.Active='1' order by MasterPage_Name";
SqlCommand cmdcln = new SqlCommand(strcln, con);
DataTable dtcln = new DataTable();
SqlDataAdapter adpcln = new SqlDataAdapter(cmdcln);
adpcln.Fill(dtcln);
FilterProduct.DataSource = dtcln;
FilterProduct.DataValueField = "MasterPageId";
FilterProduct.DataTextField = "MasterPage_Name";
FilterProduct.DataBind();
FilterProduct.Items.Insert(0, "All");
FilterProduct.Items[0].Value = "0";
if (dtcln.Rows.Count > 0)
{
ViewState["versioninfo"] = dtcln.Rows[0]["VersionInfoId"].ToString();
}
FilterProduct.SelectedValue = "12";
}