protected void Page_Load(object sender, EventArgs e)
{
if (Session["c_email"] != null)
{
ButtonLoginText.Text = "Logout";
isLogin = true;
}
else
{
ButtonLoginText.Text = "Login";
isLogin = false;
}
if (!IsPostBack)
{
if (Request.QueryString["p_cat"] != null)
{
DataListProducts.DataSourceID = null;
DataListProducts.DataSource = SqlDataSourceAllPRoductsByCat;
DataListProducts.DataBind();
}
if (Request.QueryString["p_dev"] != null)
{
DataListProducts.DataSourceID = null;
DataListProducts.DataSource = SqlDataSourceProductsByDev;
DataListProducts.DataBind();
}
if (Request.QueryString["p_plat"] != null)
{
DataListProducts.DataSourceID = null;
DataListProducts.DataSource = SqlDataSourceAllProductByPlatforms;
DataListProducts.DataBind();
}
}
}
public void DataListProducts_ItemCommand(object source, DataListCommandEventArgs e)
{
var list = (List <Tuple <string, int> >)(Session["stringList"]);
foreach (var i in list)
{
if (i.Item1 == e.CommandName)
{
list.Add(new Tuple <string, int>(e.CommandName, 1));
break;
}
}
Session["stringList"] = list;
foreach (var x in prods)
{
if (e.CommandName == x.Prodcd)
{
x.Qty++;
x.Total = x.Qty * x.Price;
DataListProducts.DataSource = prods;
DataListProducts.DataBind();
break;
}
}
}
private void GetNewProducts()
{
using (ShiningStoneDataContext Data = new ShiningStoneDataContext())
{
var Products = Data.Products.OrderByDescending(P => P.ProductDateAdded).Take(3);
DataListProducts.DataSource = Products;
DataListProducts.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
String searchKey = TextBoxSearch.Text;
//Response.Write("Search key is: "+searchKey);
if (searchKey != "")
{
DataListProducts.DataSourceID = null;
DataListProducts.DataSource = SqlDataSource1;
DataListProducts.DataBind();
}
}
private void categoryChanged()
{
//Get the selected category object
Category cat = new Category();
cat.GetCategoryByID(Convert.ToInt32(TreeViewLeftNav.SelectedValue));
//Set the title for content section
subcategoryTitle.InnerText = cat.Name.ToString();
//Get all products for this category
Product prod = new Product();
List <Product> prods = prod.GetAllProductsByCategoryID(Convert.ToInt32(TreeViewLeftNav.SelectedValue), true);
DataListProducts.DataSource = prods;
DataListProducts.DataBind();
}
//Created By Daksh Kapur
public void BindDetails()
{
SqlCommand cmdSelect = new SqlCommand("Select * from DS_Library.[dbo].Books;", conn);
try
{
conn.Open();
DataListProducts.DataSource = cmdSelect.ExecuteReader();
DataListProducts.DataBind();
}
catch
{
conn.Close();
}
}
protected void DataListSuppliers_ItemCommand(object source, DataListCommandEventArgs e)
{
for (int i = 0; i < DataListSuppliers.Items.Count; i++)
{
LinkButton x = (LinkButton)DataListSuppliers.Items[i].FindControl("lbSupplierName");
x.BackColor = System.Drawing.Color.White;
}
LinkButton l = (LinkButton)e.Item.FindControl("lbSupplierName");
l.BackColor = System.Drawing.Color.Aqua;
dsProducts.SelectParameters["SupplierID"].DefaultValue = l.CommandArgument;
DataListProducts.DataBind();
}
public void BindDetails()
{
SqlCommand cmdSelect = new SqlCommand(" select c.Title,c.Author,c.SmallImageURL, c.BookID, c.Genre ,c.[Publish year] FROM DS_Library.[dbo].[Users] a Inner JOIN DS_Library.[dbo].[Rentals] b ON a.Email = b.UserEmail and a.Email = @Email Inner JOIN DS_Library.[dbo].[Books] c ON b.BookID = c.BookID; ", conn);
cmdSelect.Parameters.Add("@Email", System.Data.SqlDbType.VarChar);
cmdSelect.Parameters["@Email"].Value = (string)(Session["Username"]);
try
{
conn.Open();
DataListProducts.DataSource = cmdSelect.ExecuteReader();
DataListProducts.DataBind();
}
catch
{
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["stringList"] != null)
{
foreach (var i in (List <Tuple <string, int> >)(Session["stringList"]))
{
bool exists = false;
foreach (var x in prods)
{
if (i.Item1 == x.Prodcd)
{
exists = true;
x.Qty++;
x.Total = x.Qty * x.Price;
break;
}
}
if (!exists)
{
var prod = new Product();
var cartItem = new CartItem();
prod.GetProductByCode(i.Item1);
cartItem.Prodcd = i.Item1;
cartItem.Name = prod.Name.ToString();
cartItem.Img = "~/Images/Product_Images/" + i.Item1 + ".jpg";
cartItem.Qty = i.Item2;
cartItem.Price = cartItem.Total = prod.Msrp;
prods.Add(cartItem);
}
}
DataListProducts.DataSource = prods;
DataListProducts.DataBind();
}
}
//another test
}
protected void Page_Load(object sender, EventArgs e)
{
//Load the slider images and details
Configuration config = new Configuration();
Product prod = new Product();
//Slide 1
config.GetConfigurationByCode("xFeaturedProduct1");
prod.GetProductByCode(config.Value.ToString());
//Attempt to display image (if it is found)
try
{
ImageFeatured1.Src = "~/Images/Product_Images/" + prod.ProductCode + ".jpg";
}
catch (Exception)
{
ImageFeatured1.Src = "";
}
LabelFeaturedBrand1.Text = prod.Brand.ToString();
LabelFeaturedName1.Text = prod.Name.ToString();
LabelFeaturedPrice1.Text = "Only $" + prod.Msrp.ToString();
LinkButtonFeatured1.PostBackUrl = "~/ProductInfo.aspx?prodcd=" + prod.ProductCode.ToString();
//Slide 2
config.GetConfigurationByCode("xFeaturedProduct2");
prod.GetProductByCode(config.Value.ToString());
//Attempt to display image (if it is found)
try
{
ImageFeatured2.Src = "~/Images/Product_Images/" + prod.ProductCode + ".jpg";
}
catch (Exception)
{
ImageFeatured2.Src = "";
}
LabelFeaturedBrand2.Text = prod.Brand.ToString();
LabelFeaturedName2.Text = prod.Name.ToString();
LabelFeaturedPrice2.Text = "Only $" + prod.Msrp.ToString();
//Slide 3
config.GetConfigurationByCode("xFeaturedProduct3");
prod.GetProductByCode(config.Value.ToString());
//Attempt to display image (if it is found)
try
{
ImageFeatured3.Src = "~/Images/Product_Images/" + prod.ProductCode + ".jpg";
}
catch (Exception)
{
ImageFeatured3.Src = "";
}
LabelFeaturedBrand3.Text = prod.Brand.ToString();
LabelFeaturedName3.Text = prod.Name.ToString();
LabelFeaturedPrice3.Text = "Only $" + prod.Msrp.ToString();
//Slide 4
config.GetConfigurationByCode("xFeaturedProduct4");
prod.GetProductByCode(config.Value.ToString());
//Attempt to display image (if it is found)
try
{
ImageFeatured4.Src = "~/Images/Product_Images/" + prod.ProductCode + ".jpg";
}
catch (Exception)
{
ImageFeatured4.Src = "";
}
LabelFeaturedBrand4.Text = prod.Brand.ToString();
LabelFeaturedName4.Text = prod.Name.ToString();
LabelFeaturedPrice4.Text = "Only $" + prod.Msrp.ToString();
//Load the data list (THIS IS A TEMPORARY WAY...CHOOSES FIRST 6 PRODUCTS)
List <Product> allProducts = new List <Product>();
allProducts = prod.GetAllProducts(true);
List <Product> frontpageProducts = new List <Product>();
for (int i = 0; i < 6; i++)
{
frontpageProducts.Add(allProducts[i]);
}
DataListProducts.DataSource = frontpageProducts;
DataListProducts.DataBind();
}
