private void GetByBaseCategoryId()
{
if (!string.IsNullOrEmpty(Request.QueryString["bc"]))
{
int baseCatId = Convert.ToInt32(Business.Encryption.Encryption64.Decrypt(Request.QueryString["bc"], "!#$a54?3"));
if (baseCatId != 0)
{
CategoryEntity category = new CategoryAdapter().GetCategoryById(baseCatId);
BaseCategoryNameLabel.Text = category.Name;
CategoryNameLabel.Text = category.Name;
SubCategoriesRepeater.DataSource = new CategoryAdapter().GetSubCategories(baseCatId);
SubCategoriesRepeater.DataBind();
ProductListRepeater.DataSource = new ProductAdapter().GetProductsByMainCategoryId(baseCatId);
ProductCollection productList = (ProductCollection)ProductListRepeater.DataSource;
Session["ProductList"] = productList;
ProductListRepeater.DataBind();
}
else
{
Response.Redirect("~/Default.aspx");
}
}
}
protected void SortBy_Click(object sender, EventArgs e)
{
LinkButton lnkButton = (LinkButton)sender;
ProductCollection productList = (ProductCollection)Session["ProductList"];
switch (lnkButton.ID)
{
case "SortByTitleAscending":
ProductListRepeater.DataSource = new ProductAdapter().SortProductsByTitle(productList, true);
break;
case "SortByTitleDescending":
ProductListRepeater.DataSource = new ProductAdapter().SortProductsByTitle(productList, false);
break;
case "SortByPriceAscending":
ProductListRepeater.DataSource = new ProductAdapter().SortProductsByPrice(productList, true);
break;
case "SortByPriceDescending":
ProductListRepeater.DataSource = new ProductAdapter().SortProductsByPrice(productList, false);
break;
case "SortByRateDescending":
ProductListRepeater.DataSource = productList;
break;
case "SortByRateAscending":
ProductListRepeater.DataSource = productList;
break;
default:
ProductListRepeater.DataSource = productList;
break;
}
ProductListRepeater.DataBind();
DataPager1.DataBind();
//ScriptManager.RegisterStartupScript(this, this.GetType(), "shoppica.js", " <script type='text/javascript' src='/Assets/js/shoppica.js'></script>", true);
//ScriptManager.RegisterStartupScript(this, this.GetType(), "shoppica.js", "alert('aasd')", false);
}
private void GetByBrandId()
{
if (!string.IsNullOrEmpty(Request.QueryString["b"]))
{
int brandId = Convert.ToInt32(Business.Encryption.Encryption64.Decrypt(Request.QueryString["b"], "!#$a54?3"));
BaseCategoryNameLabel.Text = new BrandAdapter().GetBrandById(brandId).Name;
CategoryNameLabel.Text = new BrandAdapter().GetBrandById(brandId).Name;
//Disable CategorySlider
SubCategoriesRepeater.Visible = false;
ProductListRepeater.DataSource = new ProductAdapter().GetProductsByBrandId(brandId);
ProductCollection productList = (ProductCollection)ProductListRepeater.DataSource;
Session["ProductList"] = productList;
ProductListRepeater.DataBind();
}
else
{
Response.Redirect("~/Default.aspx");
}
}
private void GetByKeyword()
{
if (!string.IsNullOrEmpty(Request.QueryString["k"]))
{
string keyword = Business.Encryption.Encryption64.Decrypt(Request.QueryString["k"], "12345678").Replace("+", " ");
BaseCategoryNameLabel.Text = keyword;
CategoryNameLabel.Text = keyword;
//Disable CategorySlider
SubCategoriesRepeater.Visible = false;
ProductListRepeater.DataSource = new ProductAdapter().GetProductsByKeyword(keyword);
ProductCollection productList = (ProductCollection)ProductListRepeater.DataSource;
Session["ProductList"] = productList;
ProductListRepeater.DataBind();
}
else
{
Response.Redirect("~/Default.aspx");
}
}
private void GetByKeywordAndBaseCategory()
{
if (!string.IsNullOrEmpty(Request.QueryString["k"]) && !string.IsNullOrEmpty(Request.QueryString["bc"]))
{
string keyword = Business.Encryption.Encryption64.Decrypt(Request.QueryString["k"], "12345678").Replace("+", " ");
int baseCatId = Convert.ToInt32(Business.Encryption.Encryption64.Decrypt(Request.QueryString["bc"], "!#$a54?3"));
if (baseCatId != 0)
{
CategoryEntity category = new CategoryAdapter().GetCategoryById(baseCatId);
BaseCategoryNameLabel.Text = category.Name;
CategoryNameLabel.Text = keyword;
SubCategoriesRepeater.DataSource = new CategoryAdapter().GetSubCategories(baseCatId);
SubCategoriesRepeater.DataBind();
ProductListRepeater.DataSource = new ProductAdapter().GetProductsByKeywordAndBaseCatId(keyword, baseCatId);
ProductCollection productList = (ProductCollection)ProductListRepeater.DataSource;
Session["ProductList"] = productList;
ProductListRepeater.DataBind();
}
else
{
BaseCategoryNameLabel.Text = keyword;
CategoryNameLabel.Text = keyword;
ProductCollection products = new ProductAdapter().GetProductsByKeyword(keyword);
Session["ProductList"] = products;
//Disable CategorySlider
SubCategoriesRepeater.Visible = false;
ProductListRepeater.DataSource = products;
ProductListRepeater.DataBind();
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
private void GetData(int storeId)
{
ProductListRepeater.DataSource = new ProductSearchEngine.Business.Adapters.ProductAdapter().GetProductsByStoreId(storeId);
ProductListRepeater.DataBind();
}
private void GetData()
{
ProductListRepeater.DataSource = new ProductSearchEngine.Business.Adapters.ProductAdapter().GetAllProducts();
ProductListRepeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
// We check to see that this page loads without any postback on the page because it is unnessary to
// to run this code if there only is a postback on the page like a click on a button.
if (!Page.IsPostBack)
{
// We select all products from the "Products" table and sort the list by "ProductName" in ascending order.
// The data for the products are supplied to the "ProductListRepeater" repeater control and we split up the
// product list in pages with next and previous links for navigation.
// Declare variables for a connection string and a SELECT statement.
string ConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
string sql = "SELECT ProductID, ProductName, Description, PriceExSaleTax, CAST(PriceExSaleTax * "
+ "SaleTaxPercent as decimal(18,2)) As SaleTaxMoney, SaleTaxPercent, CAST(PriceExSaleTax * "
+ "(1 + SaleTaxPercent) as decimal(18,2)) As TotalPrice FROM Products ORDER BY ProductName ASC";
// Create a SqlConnection. The using block is used to call dispose (close) automatically even
// if there are an exception.
using (SqlConnection cn = new SqlConnection(ConnString))
{
// Create a SqlDataAdapter.
SqlDataAdapter sad = new SqlDataAdapter();
// Create a SqlCommand.
SqlCommand cmd = new SqlCommand(sql, cn);
// Create a DataTable.
DataTable dt = new DataTable();
// Create a PagedDataSource.
PagedDataSource objPds = new PagedDataSource();
// The Try/Catch/Finally block is used to handle exceptions.
try
{
// Open the SqlConnection.
cn.Open();
// Assign the select command to the SqlDataAdapter.
sad.SelectCommand = cmd;
// Fill the data table "dt" with data from the SqlDataAdapter
sad.Fill(dt);
// Populate the repeater control with the datatable
objPds.DataSource = dt.DefaultView;
// Indicate that the data should be paged
objPds.AllowPaging = true;
// Set the pagesize
objPds.PageSize = 10;
// The current page (curpage) is declared as an integer
Int32 curpage;
// We set the page number for the current page from the page parameter in the url
// or to 1 if there are no page parameter in the url
if (Request.QueryString["page"] != null)
{
curpage = Convert.ToInt32(Request.QueryString["page"]);
}
else
{
curpage = 1;
}
// The current page index is equal to the current page minus 1 and we need to know this
// to show the right page to the user.
objPds.CurrentPageIndex = curpage - 1;
// We set the text in the middle to show the current pagenumber and the last pagenumber
lblCurrentPage.Text = "| Page: " + curpage.ToString() + " of " + objPds.PageCount.ToString() + " |";
// This is code for the link to the previous page, we don't show this link on the first page
if (!objPds.IsFirstPage)
{
lnkPrev.Visible = true;
lnkPrev.NavigateUrl = "~/Default1.aspx?" + "page=" + Convert.ToString(curpage - 1);
}
// This is code for the link to the next page, we don't show this link on the last page
if (!objPds.IsLastPage)
{
lnkNext.Visible = true;
lnkNext.NavigateUrl = "~/Default1.aspx?" + "page=" + Convert.ToString(curpage + 1);
}
// This code is used to bind data to the repeater control.
ProductListRepeater.DataSource = objPds;
ProductListRepeater.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
// Dispose of objects to avoid memory leakage.
sad.Dispose();
cmd.Dispose();
dt.Dispose();
}
}
}
}
