public void addItemToCart(String[] items)
{
Database obj = new Database();
itemsoncart = obj.cartDetails(items);
Session["CurrentCart"] = itemsoncart;
//rePopulate();
obj.closeConnection();
}
protected void Page_Load(object sender, EventArgs e)
{
//HtmlGenericControl nc = new HtmlGenericControl();
try
{
ProjectUtilities o = new ProjectUtilities();
Panel q1;
Database dobj = new Database();
SqlDataReader r = dobj.getHotDeals();
// Hot Deals
if (r != null)
{
while (r.Read())
{
Panel p = new Panel();
p.CssClass = "ProdList";
Image i = new Image();
i.ImageUrl = r["ImageLocation"].ToString();
//r["Image"].ToString();
var h3 = new HtmlGenericControl("h3");
// h3.Attributes.Add("class", "details");
h3.InnerHtml = r["Name"].ToString();
HyperLink a = new HyperLink();
a.Controls.Add(i);
a.Controls.Add(h3);
Panel cr = crPrice(r);
cr.Style.Add("margin-top", "5px");
cr.Style.Add("text-align", "center");
a.Controls.Add(cr);
a.NavigateUrl = "ViewProduct.aspx?pid=" + r["Id"].ToString();
//p.Controls.Add(i);
p.Controls.Add(a);
//p.Controls.Add(h4);
hd.Controls.Add(p);
}
q1 = new Panel();
q1.CssClass = "clearf";
HyperLink a1 = new HyperLink();
a1.NavigateUrl = "HotDeals.aspx";
a1.CssClass = "morebtn";
hd.Controls.Add(a1);
hd.Controls.Add(q1);
// <a href="HotDeals.aspx" style="height:100%;width:30px;float:right;margin-top:150px;">
// <img src="images/rarrow.png" style="display:block;margin:auto" alt="" />
//</a>
r.Close();
}
else
hd.Visible = false;
// RETEIVE BEST SELLERS
// r = new Database().bestSeller();
r = null;
if (r != null)
{
while (r.Read())
{
Panel p = new Panel();
p.CssClass = "ProdList";
Image i = new Image();
i.ImageUrl = r["ImageLocation"].ToString();
//r["Image"].ToString();
var h3 = new HtmlGenericControl("h3");
h3.InnerHtml = r["Name"].ToString();
HyperLink a = new HyperLink();
a.Controls.Add(i);
a.Controls.Add(h3);
Panel cr = crPrice(r);
cr.Style.Add("margin-top", "5px");
cr.Style.Add("text-align", "center");
a.Controls.Add(cr);
a.NavigateUrl = "ViewProduct.aspx?pid=" + r["PId"].ToString();
//p.Controls.Add(i);
p.Controls.Add(a);
//p.Controls.Add(h4);
bs.Controls.Add(p);
}
q1 = new Panel();
q1.CssClass = "clearf";
HyperLink a1 = new HyperLink();
a1.NavigateUrl = "HotDeals.aspx";
a1.CssClass = "morebtn";
bs.Controls.Add(a1);
bs.Controls.Add(q1);
}
else
//bs.Visible = false;
bs.Parent.Visible = false;
// New Arrivals
r = dobj.newArrivals();
if (r != null)
{
while (r.Read())
{
Panel p = new Panel();
p.CssClass = "ProdList";
Image i = new Image();
i.ImageUrl = r["ImageLocation"].ToString();
//r["Image"].ToString();
var h3 = new HtmlGenericControl("h3");
h3.InnerHtml = r["Name"].ToString();
HyperLink a = new HyperLink();
a.Controls.Add(i);
a.Controls.Add(h3);
Panel cr = crPrice(r);
cr.Style.Add("margin-top", "5px");
cr.Style.Add("text-align", "center");
a.Controls.Add(cr);
a.NavigateUrl = "ViewProduct.aspx?pid=" + r["Id"].ToString();
//p.Controls.Add(i);
p.Controls.Add(a);
//p.Controls.Add(h4);
na.Controls.Add(p);
}
q1 = new Panel();
q1.CssClass = "clearf";
//na.Controls.Add(q1);
HyperLink a1 = new HyperLink();
a1.NavigateUrl = "NewArrivals.aspx";
a1.CssClass = "morebtn";
na.Controls.Add(a1);
na.Controls.Add(q1);
}
else
na.Parent.Visible = false;
// Brands on Sale
r = dobj.brandsOnSale();
if (r != null)
{
while (r.Read())
{
Panel p = new Panel();
p.CssClass = "ProdList-brands";
Image i = new Image();
i.ImageUrl = r["Image_Location"].ToString();
//r["Image"].ToString();
//var h3 = new HtmlGenericControl("h3");
// var h4 = new HtmlGenericControl("h4");
// h4.InnerHtml = r["Cost"].ToString();
//h3.InnerHtml = r["Brand_Name"].ToString();
//HyperLink a = new HyperLink();
//a.Controls.Add(i);
//a.Controls.Add(h3);
//a.NavigateUrl = "ViewProduct.aspx?pid=" + r["Id"].ToString();
//p.Controls.Add(i);
p.Controls.Add(i);
//p.Controls.Add(h4);
bos.Controls.Add(p);
}
//q1 = new Panel();
//q1.CssClass = "clearf";
// bos.Controls.Add(q1);
}
else
bos.Parent.Visible = false;
// RETRIEVE COOKIES FOR RECENTLY VIEWED
HttpCookie c = Request.Cookies["Viewed"];
if (c == null )
Div1.Visible = false;
else
{
List<String> pid = new List<String>();
foreach (String key in c.Values.Keys)
{
pid.Add(key);
}
r = new Database().recentlyViewed(pid);
if (r == null)
Div1.Visible = false;
else
{
try {
while (r.Read())
{
Panel p = new Panel();
p.CssClass = "ProdList";
Image i = new Image();
i.ImageUrl = r["ImageLocation"].ToString();
//r["Image"].ToString();
var h3 = new HtmlGenericControl("h3");
h3.InnerHtml = r["Name"].ToString();
HyperLink a = new HyperLink();
a.Controls.Add(i);
a.Controls.Add(h3);
Panel cr = crPrice(r);
cr.Style.Add("margin-top", "5px");
cr.Style.Add("text-align", "center");
a.Controls.Add(cr);
a.NavigateUrl = "ViewProduct.aspx?pid=" + r["Id"].ToString();
p.Controls.Add(a);
Div1.Controls.Add(p);
}
HyperLink a1 = new HyperLink();
a1.NavigateUrl = "HotDeals.aspx";
a1.CssClass = "morebtn";
Div1.Controls.Add(a1);
}
catch (SqlException se)
{ }
finally
{
dobj.closeConnection();
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
