private void FindProductQuery()
{
StringBuilder q = new StringBuilder();
if (TxtIdCategory.Text.Length > 0)
{
string c = String.Empty;
FillQueryCategories(int.Parse(TxtIdCategory.Text), ref c);
c = c.Substring(0, c.Length - 3);
string listquery = string.Empty;
if (ViewState["ListPrice"] != null && ViewState["ListPrice"].ToString() != "0")
{
listquery = string.Format("(EXCLUDELIST IS NULL OR (EXCLUDELIST NOT LIKE '%|{0}|%')) AND ", ViewState["ListPrice"].ToString());
}
q.AppendFormat("SELECT * FROM CATALOGPRODUCTS WHERE {1}({0}) AND (", c, listquery);
q.AppendFormat("SHORTDESCRIPTION LIKE '{0}%' OR LONGDESCRIPTION LIKE '{0}%' OR CODE LIKE '{0}%') ", DatabaseConnection.FilterInjection(Search.Text));
q.Append("AND ACTIVE=1 ORDER BY CATEGORY");
}
else
{
q.Append("SELECT * FROM CATALOGPRODUCTS WHERE (");
q.AppendFormat("SHORTDESCRIPTION LIKE '{0}%' OR LONGDESCRIPTION LIKE '{0}%' OR CODE LIKE '{0}%') ", DatabaseConnection.FilterInjection(Search.Text));
q.AppendFormat("AND ACTIVE=1 ORDER BY CATEGORY");
}
ProductRepeater.DataSource = DatabaseConnection.CreateDataset(q.ToString());
ProductRepeater.DataBind();
ProductRepeater.Visible = (ProductRepeater.Items.Count > 0);
}
private void PopulatePopularProductsRepeater()
{
var connectionString = ConfigurationManager.ConnectionStrings["AdventureWorksLT2012"].ConnectionString;
SqlConnection sqlConnection =
new SqlConnection(connectionString);
SqlCommand sqlCommand = new SqlCommand("select top 16 * from(select *, row_number() over(partition by ProductCategoryID order by ProductCategoryID) as row_number from AdventureWorksLT2012.dbo.CustomView) as rows where row_number = 1", sqlConnection);
SqlDataReader sqlDataReader = null;
try
{
sqlConnection.Open();
sqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.SequentialAccess);
ProductRepeater.DataSource = sqlDataReader;
ProductRepeater.DataBind();
}
catch (Exception hh)
{
//Label1.Text = "Failed to get items from data base";
//Label1.Visible = true;
Response.Write(hh);
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
sqlDataReader.Dispose();
}
sqlCommand.Dispose();
sqlConnection.Close();
sqlConnection.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//var productObj = new Product();
ProductRepeater.DataSource = Product.GetProducts();
ProductRepeater.DataBind();
}
private void FindProductQuery()
{
StringBuilder q = new StringBuilder();
if (TxtIdCategory.Text.Length > 0)
{
string c = String.Empty;
FillQueryCategories(int.Parse(TxtIdCategory.Text), ref c);
c = c.Substring(0, c.Length - 3);
q.AppendFormat("SELECT * FROM CATALOGPRODUCTS WHERE ({0}) AND (", c);
q.AppendFormat("SHORTDESCRIPTION LIKE '{0}%' OR LONGDESCRIPTION LIKE '{0}%' OR CODE LIKE '{0}%') ", DatabaseConnection.FilterInjection(Search.Text));
q.Append("AND ACTIVE=1 ORDER BY CATEGORY");
}
else
{
q.Append("SELECT * FROM CATALOGPRODUCTS WHERE (");
q.AppendFormat("SHORTDESCRIPTION LIKE '{0}%' OR LONGDESCRIPTION LIKE '{0}%' OR CODE LIKE '{0}%') ", DatabaseConnection.FilterInjection(Search.Text));
q.AppendFormat("AND ACTIVE=1 ORDER BY CATEGORY");
}
ProductRepeater.DataSource = DatabaseConnection.CreateDataset(q.ToString());
ProductRepeater.DataBind();
ProductRepeater.Visible = (ProductRepeater.Items.Count > 0);
}
public void FillSchema()
{
DataTable dtProduct = QuoteProducts();
ProductRepeater.DataSource = dtProduct;
ProductRepeater.DataBind();
}
private void LoadData()
{
if (!string.IsNullOrEmpty(Request.QueryString["p"]))
{
ProductId = Convert.ToInt32(Request.QueryString["p"]);
ViewState["ProductId"] = ProductId;
new ProductAdapter().AddLastViewedProduct(ProductId, DateTime.Now, Request.ServerVariables["REMOTE_ADDR"]);
}
ProductRepeater.DataSource = new ProductAdapter().GetDetailedProduct(ProductId);
ProductRepeater.DataBind();
}
protected void DataBindProducts()
{
ProductRepeater.ItemDataBound += new RepeaterItemEventHandler(ProductRepeater_ItemDataBound);
string connectionString = ConfigurationManager.ConnectionStrings["ProductStoreConnectionString"].ConnectionString;
DbConnection connection = SqlHelper.Current.GetConnection(connectionString);
using (ProductStore dataStore = new ProductStore(connection))
{
var products = from p in dataStore.Product
select p;
ProductRepeater.DataSource = products;
ProductRepeater.DataBind();
}
}
//Dis Product List
protected void Page_Load(object sender, EventArgs e)
{
requestSeachProduct = Request.QueryString["search"];
requestQuery = Request.QueryString["category"];
if (requestQuery == null)
{
ProductRepeater.DataSource = aProductManager.DisplayProductManager();
ProductRepeater.DataBind();
}
else
{
ProductRepeater.DataSource = aProductManager.DisplayProductManagerByCategory(requestQuery);
ProductRepeater.DataBind();
}
if (requestQuery == null && requestSeachProduct != null)
{
ProductRepeater.DataSource = aProductManager.DisplayProductManagerBySearch(requestSeachProduct);
ProductRepeater.DataBind();
}
}