protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
Cart = HttpContext.Current.Session["Cart"] as ShoppingCart;
if (Cart == null)
{
Cart = new ShoppingCart("ProductsGrid");
HttpContext.Current.Session["Cart"] = Cart;
}
ProductsGrid.DataSource = Cart.ToTable();
ProductsGrid.DataBind();
if (ProductsGrid.Rows.Count > 0)
{
CartTotal.Text = "<p class='total'>Grand Total: " String.Format("{0:c}", Cart.Total) "</p>";
}
else
{
CartBody.Text = "<p>Your cart is empty!</p>";
}
}
catch (Exception ex)
{
CartBody.Text = "<p>Error: " ex.Message "</p>";
}
}
}
public void BindProducts()
{
int pageNumber = WebUtility.LoadInt32FromQueryString("Page");
if (pageNumber == -1)
{
pageNumber = 0;
}
string keyword = WebUtility.LoadStringFromQueryString("Keyword", 200, true);
string tag = WebUtility.LoadStringFromQueryString("Tag", 200, true);
if (string.IsNullOrEmpty(keyword) && string.IsNullOrEmpty(tag))
{
Response.Redirect("Default.aspx");
}
ProductsGrid.PageNumber = pageNumber;
ProductsGrid.PageSize = 4;
ProductsGrid.Columns = 3;
Products products = new Products();
if (!string.IsNullOrEmpty(keyword))
{
ProductsGrid.DataSource = products.SearchProducts(keyword, pageNumber, ProductsGrid.PageSize);
}
else if (!string.IsNullOrEmpty(tag))
{
ProductsGrid.DataSource = products.GetProductsByTags(tag, pageNumber, ProductsGrid.PageSize);
}
ProductsGrid.TotalRecords = products.ProductCount;
ProductsGrid.DataBind();
}
/// <summary>
/// If overriding don't forget to call base.Load() or make sure to
/// assign the WrappedElement.
/// </summary>
/// <returns></returns>
public override ILoadableComponent Load()
{
base.Load();
ProductsGrid.Load();
return(this);
}
/// <summary>
/// Adds the new cross sell product.
/// </summary>
/// <param name="productName">Name of the product.</param>
/// <returns></returns>
public virtual CrossSellsComponent AddNewCrossSellProduct(string productName)
{
var currentPageHandle = WrappedDriver.CurrentWindowHandle;
var windowHandles = WrappedDriver.WindowHandles;
var newWindowHandle = default(string);
AddNewCrossSellProductElement.Click();
// Wait for the new window to appear.
WrappedDriver
.Wait(TimeSpan.FromSeconds(10))
.Until(d => newWindowHandle = d.WindowHandles
.Except(windowHandles)
.FirstOrDefault());
// Switch to the new window.
WrappedDriver.SwitchTo().Window(newWindowHandle);
SearchProductPopUp.Load();
SearchProductPopUp.SearchForProduct(productName);
// Switch back.
WrappedDriver.SwitchTo().Window(currentPageHandle);
// Wait for the grid to finish loading.
WrappedDriver
.Wait(TimeSpan.FromSeconds(10))
.UntilChain(d => ProductsGrid.IsBusy())
.UntilChain(d => !ProductsGrid.IsBusy());
return(this);
}
protected void Button4_Click(object sender, EventArgs e)
{
SpecificationRList1.ClearSelection();
SpecificationRList2.ClearSelection();
SpecificationRList3.ClearSelection();
SpecificationRList4.ClearSelection();
SpecificationRList5.ClearSelection();
SpecificationRList6.ClearSelection();
SpecificationRList7.ClearSelection();
BrandList.SelectedIndex = 0;
brandchanged = false;
conn = new MySqlConnection(GetConnectionString());
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand(mainquery + condition, conn);
MySqlDataReader dr = comm.ExecuteReader();
ProductsGrid.DataSource = dr;
ProductsGrid.DataBind();
dr.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
conn.Close();
}
}
protected void searchBtn_OnClick(object sender, EventArgs e)
{
try
{
string connectionString = ConfigurationManager.ConnectionStrings["productsGrid"].ConnectionString;
statusL.Text = "Searching for " + searchTerm.Text;
string sqlQuery = "SELECT productID, productName, productPrice FROM dbo.products where 1=2";
string[] searchTerms = searchTerm.Text.Replace(';', ' ').Replace("'", "").Split(' ');
foreach (string term in searchTerms)
{
sqlQuery += " OR productID like '%" + term + "%' OR productName like '%" + term + "%' OR productPrice like '%" + term + "%' ;";
}
SqlDataAdapter productHistory = new SqlDataAdapter(sqlQuery, connectionString);
// Create and fill a DataSet.
DataSet maailmanloppu = new DataSet();
productHistory.Fill(maailmanloppu);
DataView source = new DataView(maailmanloppu.Tables[0]);
ProductsGrid.DataSource = source;
ProductsGrid.DataBind();
}
catch (Exception exc)
{
statusL.Text = exc.Message;
}
}
private void BindProductsGrid()
{
SearchResultsPanel.Visible = true;
ProductsGrid.Visible = true;
ProductsGrid.PageIndex = 0;
ProductsGrid.DataBind();
}
public void BindProducts()
{
int pageNumber = WebUtility.LoadInt32FromQueryString("Page");
if (pageNumber == -1)
{
pageNumber = 0;
}
int categoryID = WebUtility.LoadInt32FromQueryString("CategoryID");
if (categoryID == -1)
{
categoryID = 1;
}
SortOrder sortOrder = SortOrder.DontSort;
Enum.TryParse <SortOrder>(WebUtility.LoadStringFromQueryString("Sort", 200, true), out sortOrder);
ProductsGrid.PageNumber = pageNumber;
ProductsGrid.PageSize = 4;
ProductsGrid.Columns = 3;
Products products = new Products();
ProductsGrid.DataSource = products.GetProducts(categoryID, pageNumber, ProductsGrid.PageSize, sortOrder);
ProductsGrid.TotalRecords = products.ProductCount;
ProductsGrid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("ProductID");
dt.Columns.Add("ProductName");
dt.Columns.Add("ProductPrice");
dt.Columns.Add("ProductStock");
dt.Columns.Add("ProductDescription");
using (var reader = new StreamReader(@"C:\Visual Studio\ProgettoLiceo\ProgettoLiceo\data.csv"))
{
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(';');
DataRow row = dt.NewRow();
row["ProductID"] = values[0];
row["ProductName"] = values[1];
row["ProductPrice"] = values[2] + " €";
row["ProductStock"] = values[3];
row["ProductDescription"] = values[5];
dt.Rows.Add(row);
}
}
ProductsGrid.DataSource = dt;
ProductsGrid.DataBind();
}
protected void searchButton_OnClick(object sender, EventArgs e)
{
try
{
string ConnectionString = ConfigurationManager.ConnectionStrings["BenNotStallman"].ConnectionString;
statusLabel.Text = "Searching for " + searchTerm.Text;
string sqlQuery = "SELECT productNum, productName, productDesc, color, price "
+ " FROM Product "
+ " WHERE 1=2";
string[] searchTerms = searchTerm.Text.Replace(';', ' ').Replace("'", "").Split(' ');
foreach (string term in searchTerms)
{
sqlQuery += " OR productNum like '%" + term + "%' "
+ " OR productName like '%" + term + "%' "
+ " OR color like '%" + term + "%' "
+ " OR productDesc like '%" + term + "%' "
+ " OR price like '%" + term + "%' ";
}
SqlDataAdapter productRecords = new SqlDataAdapter(sqlQuery, ConnectionString);
DataSet ds = new DataSet();
productRecords.Fill(ds);
DataView source = new DataView(ds.Tables[0]);
ProductsGrid.DataSource = source;
ProductsGrid.DataBind();
}
catch (Exception exc)
{
statusLabel.Text = exc.Message;
}
}
/// <summary>
/// If overridding this don't forget to call base.Load().
/// NOTE: Will navigate to the pages url if the current drivers url
/// is empty.
/// </summary>
/// <returns></returns>
/// <remarks>
/// If the driver is an EventFiringWebDriver an event listener will
/// be added to the 'Navigated' event and uses the url to determine
/// if the page is 'stale'.
/// </remarks>
public override ILoadableComponent Load()
{
base.Load();
basePage.Load();
ProductsGrid.Load();
SearchPanel.Load();
return(this);
}
/// <summary>
/// Gets the listed products.
/// </summary>
/// <returns></returns>
/// <exception cref="NotImplementedException"></exception>
public virtual IEnumerable <ListPageProductRowComponent> GetListedProducts()
{
foreach (var rowElement in ProductsGrid.EnumerateOverAllRows())
{
yield return(pageObjectFactory.PrepareComponent(
new ListPageProductRowComponent(
new ByElement(rowElement),
pageObjectFactory,
WrappedDriver)));
}
}
protected void Page_Init(object sender, System.EventArgs e)
{
_AgreementId = AlwaysConvert.ToInt(Request.QueryString["AgreementId"]);
_Agreement = LicenseAgreementDataSource.Load(_AgreementId);
if (_Agreement == null)
{
Response.Redirect("Default.aspx");
}
Caption.Text = string.Format(Caption.Text, _Agreement.DisplayName);
InstructionText.Text = string.Format(InstructionText.Text, _Agreement.DisplayName);
BindAgreements();
ProductsGrid.DataSource = _Agreement.DigitalGoods;
ProductsGrid.DataBind();
}
protected void CategoryList_SelectedIndexChanged(object sender, EventArgs e)
{
String catid = CategoryList.SelectedValue.ToString();
//Response.Write(catid);
conn = new MySqlConnection(GetConnectionString());
Specification1.Visible = false;
SpecificationRList1.Visible = false;
Specification2.Visible = false;
SpecificationRList2.Visible = false;
Specification3.Visible = false;
SpecificationRList3.Visible = false;
Specification4.Visible = false;
SpecificationRList4.Visible = false;
Specification5.Visible = false;
SpecificationRList5.Visible = false;
Specification6.Visible = false;
SpecificationRList6.Visible = false;
Specification7.Visible = false;
SpecificationRList7.Visible = false;
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand("Select Subcategory_Name,Subcategory_ID from Subcategory where Category_ID='" + catid + "'", conn);
MySqlDataReader dr = comm.ExecuteReader();
SubcategoryList.DataSource = dr;
SubcategoryList.DataTextField = "Subcategory_Name";
SubcategoryList.DataValueField = "Subcategory_ID";
SubcategoryList.DataBind();
dr.Close();
comm.CommandText = mainquery + " and Category_ID='" + catid + "'" + condition;
MySqlDataReader dr1 = comm.ExecuteReader();
ProductsGrid.DataSource = dr1;
ProductsGrid.DataBind();
dr1.Close();
}
catch (Exception ex)
{ Response.Write("In category list"); Response.Write(ex.Message); }
finally { conn.Close(); }
SubcategoryList.Items.Insert(0, new ListItem("", "0"));
}
protected void Page_Load(object sender, EventArgs e)
{
_webpageId = AbleCommerce.Code.PageHelper.GetWebpageId();
if (!Page.IsPostBack)
{
ProductPageList.DataBind();
ListItem item = ProductPageList.Items.FindByValue(_webpageId.ToString());
if (item != null)
{
item.Selected = true;
}
ProductsGrid.DataBind();
}
}
protected void Update_Click(object sender, EventArgs e)
{
List <Object> dataKeys = ProductsGrid.GetSelectedDataKeyValues();
foreach (Object dataKey in dataKeys)
{
int productId = AlwaysConvert.ToInt(dataKey);
Product product = ProductDataSource.Load(productId);
product.Webpage = WebpageDataSource.Load(AlwaysConvert.ToInt(ProductDisplayPages.SelectedValue));
product.Save();
}
ProductsGrid.DataBind();
}
protected void Page_Init(object sender, System.EventArgs e)
{
_DigitalGoodId = AlwaysConvert.ToInt(Request.QueryString["DigitalGoodId"]);
_DigitalGood = DigitalGoodDataSource.Load(_DigitalGoodId);
if (_DigitalGood == null)
{
Response.Redirect("Default.aspx");
}
Caption.Text = string.Format(Caption.Text, _DigitalGood.Name);
InstructionText.Text = string.Format(InstructionText.Text, _DigitalGood.Name);
ProductsGrid.DataSource = _DigitalGood.ProductDigitalGoods;
ProductsGrid.DataBind();
//GET ALL ORDER ITEMS ASSOCIATED WITH DIGITAL GOOD
IList <OrderItemDigitalGood> oidgs = OrderItemDigitalGoodDataSource.LoadForDigitalGood(_DigitalGoodId);
//BUILD DISTINCT LIST OF ORDERS
List <CommerceBuilder.Orders.Order> orders = new List <CommerceBuilder.Orders.Order>();
foreach (OrderItemDigitalGood oidg in oidgs)
{
CommerceBuilder.Orders.Order order = oidg.OrderItem.Order;
if (orders.IndexOf(order) < 0)
{
orders.Add(order);
}
}
//BIND TO GRID
OrderGrid.DataSource = orders;
OrderGrid.DataBind();
if (!String.IsNullOrEmpty(_DigitalGood.FileName))
{
ICriteria criteria = NHibernateHelper.CreateCriteria <DigitalGood>();
criteria.Add(Restrictions.Eq("FileName", StringHelper.SafeSqlString(_DigitalGood.FileName)));
IList <DigitalGood> dgc = DigitalGoodDataSource.LoadForCriteria(criteria);
if (dgc != null && dgc.Count > 1)
{
DeleteAllowedPanel.Visible = false;
DeletePreventedPanel.Visible = true;
NoDeleteFileText.Text = string.Format(NoDeleteFileText.Text, _DigitalGood.FileName);
}
else
{
DeleteAllowedPanel.Visible = true;
DeletePreventedPanel.Visible = false;
DeleteFile.Text = string.Format(DeleteFile.Text, _DigitalGood.FileName);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Cart = HttpContext.Current.Session["Cart"] as ShoppingCart;
if (Cart == null)
{
Cart = new ShoppingCart("ProductsGrid");
HttpContext.Current.Session["Cart"] = Cart;
}
if (int.TryParse(Request.QueryString["productID"], out productID))
{
try
{
string retString = "Select productID, productName, productPrice from products where productID = @productID;";
using (SqlConnection dbConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["productsGrid"].ConnectionString))
using (SqlCommand sqlCmd = new SqlCommand(retString, dbConnection))
{
sqlCmd.Parameters.Add(new SqlParameter("@productID", System.Data.SqlDbType.Int)).Value = productID;
dbConnection.Open();
dbConnection.ChangeDatabase("productsGrid");
SqlDataAdapter productHistory = new SqlDataAdapter(sqlCmd);
DataSet maailmanloppu = new DataSet();
productHistory.Fill(maailmanloppu);
DataView source = new DataView(maailmanloppu.Tables[0]);
ProductsGrid.DataSource = source;
ProductsGrid.DataBind();
PageTitle.Text = "<h1>" + maailmanloppu.Tables[0].Rows[0][1] + "</h1>";
}
}
catch (Exception exc)
{
statusL.Text = exc.Message;
}
}
else
{
statusL.Text = "Invalid Product ID";
}
}
}
public void PopulateDatagrid()
{
try
{
SqlConnection dbConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["productsGrid"].ConnectionString);
dbConnection.Open();
dbConnection.ChangeDatabase("productsGrid");
string retString = "Select productID, productName, productPrice from products order by productID";
SqlDataAdapter productHistory = new SqlDataAdapter(retString, dbConnection);
DataSet maailmanloppu = new DataSet();
productHistory.Fill(maailmanloppu);
DataView source = new DataView(maailmanloppu.Tables[0]);
ProductsGrid.DataSource = source;
ProductsGrid.DataBind();
dbConnection.Close();
}
catch (Exception) { Response.Write("NO"); }
}
protected void Button5_Click(object sender, EventArgs e)
{
String pname = TextBox2.Text;
conn = new MySqlConnection(GetConnectionString());
try
{
conn.Open();
String sql = " and Product_Name like '%" + pname + "%'";
MySqlCommand comm = new MySqlCommand(mainquery + sql + condition, conn);
MySqlDataReader dr = comm.ExecuteReader();
ProductsGrid.DataSource = dr;
ProductsGrid.DataBind();
dr.Close();
}
catch (Exception ex)
{ Response.Write(ex.Message); }
finally { conn.Close(); }
}
protected void ProductSearch_Click(object sender, EventArgs e)
{
String product_id = TextBox1.Text;
conn = new MySqlConnection(GetConnectionString());
try
{
conn.Open();
String sql = mainquery + " and Product_ID='" + product_id + "'" + condition;
MySqlCommand comm = new MySqlCommand(sql, conn);
MySqlDataReader dr = comm.ExecuteReader();
ProductsGrid.DataSource = dr;
ProductsGrid.DataBind();
}
catch (Exception ex)
{ Response.Write(ex.Message); }
finally { conn.Close(); }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
string ConnectionString = ConfigurationManager.ConnectionStrings["BenNotStallman"].ConnectionString;
string sqlQuery = "SELECT productNum, productName, productDesc, color, price "
+ " FROM Product; ";
SqlDataAdapter productRecords = new SqlDataAdapter(sqlQuery, ConnectionString);
DataSet ds = new DataSet();
productRecords.Fill(ds);
DataView source = new DataView(ds.Tables[0]);
ProductsGrid.DataSource = source;
ProductsGrid.DataBind();
}
catch (Exception exc)
{
statusLabel.Text += exc.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
brandchanged = false;
spec1changed = false;
spec2changed = false;
spec3changed = false;
spec4changed = false;
spec5changed = false;
spec6changed = false;
spec7changed = false;
Button4.Visible = false;
// Label15.Text = DateTime.Now.ToString();
if (!IsPostBack)
{
Specification1.Visible = false;
SpecificationRList1.Visible = false;
Specification2.Visible = false;
SpecificationRList2.Visible = false;
Specification3.Visible = false;
SpecificationRList3.Visible = false;
Specification4.Visible = false;
SpecificationRList4.Visible = false;
Specification5.Visible = false;
SpecificationRList5.Visible = false;
Specification6.Visible = false;
SpecificationRList6.Visible = false;
Specification7.Visible = false;
SpecificationRList7.Visible = false;
conn = new MySqlConnection(GetConnectionString());
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand("Select Category_Name,Category_ID from Category", conn);
MySqlDataReader dr = comm.ExecuteReader();
CategoryList.DataSource = dr;
CategoryList.DataTextField = "Category_Name";
CategoryList.DataValueField = "Category_ID";
CategoryList.DataBind();
dr.Close();
comm.CommandText = mainquery + condition;
MySqlDataReader dr1 = comm.ExecuteReader();
ProductsGrid.DataSource = dr1;
ProductsGrid.DataBind();
dr1.Close();
}
catch (Exception em)
{ Response.Write("in page load"); Response.Write(em.Message); }
finally { conn.Close(); }
}
CategoryList.Items.Insert(0, new ListItem("", "0"));
}
protected void SpecificationRList7_SelectedIndexChanged(object sender, EventArgs e)
{
String catid = CategoryList.SelectedValue.ToString();
String subcatid = SubcategoryList.SelectedValue.ToString();
String spec1 = SpecificationRList1.SelectedValue.ToString();
String spec2 = SpecificationRList2.SelectedValue.ToString();
String spec3 = SpecificationRList3.SelectedValue.ToString();
String spec4 = SpecificationRList4.SelectedValue.ToString();
String spec5 = SpecificationRList5.SelectedValue.ToString();
String spec6 = SpecificationRList6.SelectedValue.ToString();
String spec7 = SpecificationRList7.SelectedValue.ToString();
String query1 = " and Sp10_Value='" + spec7 + "' and Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
if (!BrandList.SelectedValue.ToString().Equals("0"))
{
String brandname = BrandList.SelectedValue.ToString();
query1 += "and Company_Name='" + brandname + "'";
}
//brandchanged = false;
if (spec2 != "")
{
query1 += "and Sp5_Value='" + spec2 + "'";
}
if (spec3 != "")
{
query1 += "and Sp6_Value='" + spec3 + "'";
}
if (spec4 != "")
{
query1 += "and Sp7_Value='" + spec4 + "'";
}
if (spec5 != "")
{
query1 += "and Sp8_Value='" + spec5 + "'";
}
if (spec6 != "")
{
query1 += "and Sp9_Value='" + spec6 + "'";
}
if (spec1 != "")
{
query1 += "and Sp4_Value='" + spec1 + "'";
}
conn = new MySqlConnection(GetConnectionString());
try
{
conn.Open();
String sql = mainquery + query1 + condition;
MySqlCommand comm = new MySqlCommand(sql, conn);
MySqlDataReader dr1 = comm.ExecuteReader();
ProductsGrid.DataSource = dr1;
ProductsGrid.DataBind();
dr1.Close();
}
catch (Exception ex)
{ Response.Write(ex.Message); }
finally { conn.Close(); }
Button4.Visible = true;
}
protected void ProductsGrid_Sorting(object sender, GridViewSortEventArgs e)
{
if (searchTerm.Text == null) //This triggers if no search terms are entered
{
string sortExpression = e.SortExpression;
string direction = string.Empty;
if (SortDirection == SortDirection.Ascending)
{
SortDirection = SortDirection.Descending;
direction = " DESC";
}
else
{
SortDirection = SortDirection.Ascending;
direction = " ASC";
}
try
{
string ConnectionString = ConfigurationManager.ConnectionStrings["BenNotStallman"].ConnectionString;
string sqlQuery = "SELECT productNum, productName, productDesc, color, price "
+ " FROM Product "
+ " ORDER BY " + sortExpression + " " + direction;
SqlDataAdapter productRecords = new SqlDataAdapter(sqlQuery, ConnectionString);
DataSet ds = new DataSet();
productRecords.Fill(ds);
DataView source = new DataView(ds.Tables[0]);
ProductsGrid.DataSource = source;
ProductsGrid.DataBind();
}
catch (Exception exc)
{
statusLabel.Text = exc.Message;
}
}
else //Keeps search query while allowing sorting
{
string sortExpression = e.SortExpression;
string direction = string.Empty;
if (SortDirection == SortDirection.Ascending)
{
SortDirection = SortDirection.Descending;
direction = " DESC";
}
else
{
SortDirection = SortDirection.Ascending;
direction = " ASC";
}
try
{
string ConnectionString = ConfigurationManager.ConnectionStrings["BenNotStallman"].ConnectionString;
string sqlQuery = "SELECT productNum, productName, productDesc, color, price "
+ " FROM Product "
+ " WHERE 1=2";
string[] searchTerms = searchTerm.Text.Replace(';', ' ').Replace("'", "").Split(' ');
foreach (string term in searchTerms)
{
sqlQuery += " OR productNum like '%" + term + "%' "
+ " OR productName like '%" + term + "%' "
+ " OR color like '%" + term + "%' "
+ " OR productDesc like '%" + term + "%' "
+ " OR price like '%" + term + "%' ";
}
sqlQuery += " ORDER BY " + sortExpression + " " + direction;
SqlDataAdapter productRecords = new SqlDataAdapter(sqlQuery, ConnectionString);
DataSet ds = new DataSet();
productRecords.Fill(ds);
DataView source = new DataView(ds.Tables[0]);
ProductsGrid.DataSource = source;
ProductsGrid.DataBind();
}
catch (Exception exc)
{
statusLabel.Text = exc.Message;
}
}
}
protected void SubcategoryList_SelectedIndexChanged(object sender, EventArgs e)
{
String catid = CategoryList.SelectedValue.ToString();
String subcatid = SubcategoryList.SelectedValue.ToString();
//Response.Write(catid);
//Response.Write(subcatid);
conn = new MySqlConnection(GetConnectionString());
Specification1.Visible = false;
SpecificationRList1.Visible = false;
Specification2.Visible = false;
SpecificationRList2.Visible = false;
Specification3.Visible = false;
SpecificationRList3.Visible = false;
Specification4.Visible = false;
SpecificationRList4.Visible = false;
Specification5.Visible = false;
SpecificationRList5.Visible = false;
Specification6.Visible = false;
SpecificationRList6.Visible = false;
Specification7.Visible = false;
SpecificationRList7.Visible = false;
try
{
conn.Open();
String query1 = mainquery + " and Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'" + condition;
MySqlCommand comm = new MySqlCommand(query1, conn);
MySqlDataReader dr1 = comm.ExecuteReader();
//ProductsList.ClearSelection();
ProductsGrid.DataSource = dr1;
ProductsGrid.DataBind();
dr1.Close();
comm.CommandText = "Select DISTINCT(Company_Name) from Master_Products where Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
MySqlDataReader dr2 = comm.ExecuteReader();
BrandList.DataSource = dr2;
BrandList.DataTextField = "Company_Name";
BrandList.DataValueField = "Company_Name";
BrandList.DataBind();
dr2.Close();
BrandList.Visible = true;
Label4.Visible = true;
comm.CommandText = "Select Specification4,Specification5,Specification6,Specification7,Specification8,Specification9,Specification10 from Specifications where Category_ID='" + catid + "' and Subcategory_ID = '" + subcatid + "'";
MySqlDataReader dr3 = comm.ExecuteReader();
String[] Specs = new String[7];
dr3.Read();
for (int i = 0; i < 7; i++)
{
Specs[i] = dr3.GetValue(i).ToString();
}
dr3.Close();
if (Specs[0] != "")
{
Specification1.Text = Specs[0];
Specification1.Visible = true;
}
if (Specs[1] != "")
{
Specification2.Text = Specs[1];
Specification2.Visible = true;
}
if (Specs[2] != "")
{
Specification3.Text = Specs[2];
Specification3.Visible = true;
}
if (Specs[3] != "")
{
Specification4.Text = Specs[3];
Specification4.Visible = true;
}
if (Specs[4] != "")
{
Specification5.Text = Specs[4];
Specification5.Visible = true;
}
if (Specs[5] != "")
{
Specification6.Text = Specs[5];
Specification6.Visible = true;
}
if (Specs[6] != "")
{
Specification7.Text = Specs[6];
Specification7.Visible = true;
}
if (Specification1.Visible)
{
comm.CommandText = "Select DISTINCT(Sp4_Value) from Master_Products where Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
MySqlDataReader dr4 = comm.ExecuteReader();
SpecificationRList1.DataSource = dr4;
SpecificationRList1.DataTextField = "Sp4_Value";
SpecificationRList1.DataValueField = "Sp4_Value";
SpecificationRList1.DataBind();
SpecificationRList1.Visible = true;
dr4.Close();
}
if (Specification2.Visible)
{
comm.CommandText = "Select DISTINCT(Sp5_Value) from Master_Products where Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
MySqlDataReader dr4 = comm.ExecuteReader();
SpecificationRList2.DataSource = dr4;
SpecificationRList2.DataTextField = "Sp5_Value";
SpecificationRList2.DataValueField = "Sp5_Value";
SpecificationRList2.DataBind();
SpecificationRList2.Visible = true;
dr4.Close();
}
if (Specification3.Visible)
{
comm.CommandText = "Select DISTINCT(Sp6_Value) from Master_Products where Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
MySqlDataReader dr4 = comm.ExecuteReader();
SpecificationRList3.DataSource = dr4;
SpecificationRList3.DataTextField = "Sp6_Value";
SpecificationRList3.DataValueField = "Sp6_Value";
SpecificationRList3.DataBind();
SpecificationRList3.Visible = true;
dr4.Close();
}
if (Specification4.Visible)
{
comm.CommandText = "Select DISTINCT(Sp7_Value) from Master_Products where Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
MySqlDataReader dr4 = comm.ExecuteReader();
SpecificationRList4.DataSource = dr4;
SpecificationRList4.DataTextField = "Sp7_Value";
SpecificationRList4.DataValueField = "Sp7_Value";
SpecificationRList4.DataBind();
SpecificationRList4.Visible = true;
dr4.Close();
}
if (Specification5.Visible)
{
comm.CommandText = "Select DISTINCT(Sp8_Value) from Master_Products where Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
MySqlDataReader dr4 = comm.ExecuteReader();
SpecificationRList5.DataSource = dr4;
SpecificationRList5.DataTextField = "Sp8_Value";
SpecificationRList5.DataValueField = "Sp8_Value";
SpecificationRList5.DataBind();
SpecificationRList5.Visible = true;
dr4.Close();
}
if (Specification6.Visible)
{
comm.CommandText = "Select DISTINCT(Sp9_Value) from Master_Products where Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
MySqlDataReader dr4 = comm.ExecuteReader();
SpecificationRList6.DataSource = dr4;
SpecificationRList6.DataTextField = "Sp9_Value";
SpecificationRList6.DataValueField = "Sp9_Value";
SpecificationRList6.DataBind();
SpecificationRList6.Visible = true;
dr4.Close();
}
if (Specification7.Visible)
{
comm.CommandText = "Select DISTINCT(Sp10_Value) from Master_Products where Category_ID='" + catid + "' and Subcategory_ID='" + subcatid + "'";
MySqlDataReader dr4 = comm.ExecuteReader();
SpecificationRList7.DataSource = dr4;
SpecificationRList7.DataTextField = "Sp10_Value";
SpecificationRList7.DataValueField = "Sp10_Value";
SpecificationRList7.DataBind();
SpecificationRList7.Visible = true;
dr4.Close();
}
}
catch (Exception ex)
{ Response.Write(ex.Message); }
finally
{
conn.Close();
}
BrandList.Items.Insert(0, new ListItem("", "0"));
}
protected void Page_Init()
{
MetaTable table = MetaTable.GetTable(typeof(Product));
ProductsGrid.SetMetaTable(table);
}
protected void ProductPageList_SelectedIndexChanged(object sender, EventArgs e)
{
ProductsGrid.DataBind();
}
