protected void Page_Load(object sender, EventArgs e)
{
SqlDataReader r = new Database().getAllHotDeals();
litems.DataSource = r;
litems.DataBind();
}
// get all data
//
// populate div
private void startUp()
{
Database o = new Database();
String res = o.getCatName(Int32.Parse(category));
String[] c = res.Split(',');
String cn = c[0];
String cl = c[1];
cat.InnerHtml = cn;
cat.HRef = cl;
}
public void addItemToCart(String[] items)
{
Database obj = new Database();
itemsoncart = obj.cartDetails(items);
Session["CurrentCart"] = itemsoncart;
//rePopulate();
obj.closeConnection();
}
public void DynamicClick(String id)
{
String temp = id.Substring(id.LastIndexOf('e')+1);
int tid = int.Parse(temp);
String pn = itemsoncart.Rows[tid].Field<String>(1);
String pid = new Database().getPid(pn);
itemsoncart.Rows.RemoveAt(tid);
delCookie(pid);
//rePopulate();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
//alert here
Response.Redirect("Index.aspx");
}
else
{
try
{
if(String.IsNullOrEmpty(Session["Checksum"].ToString()))
Response.Redirect("Index.aspx");
if (Session["Checksum"].ToString() == Session["Cart"].ToString())
{
// get cookie
Session.Remove("Checksum");
Session.Remove("Cart");
DataTable cart = (DataTable)Session["CurrentCart"];
if (cart.Rows.Count <= 0)
Response.Redirect("Index.aspx");
// decrypt
// compute new values
double total = 0;int k=0;
//String pname = "";
for (int j = 0; j < cart.Rows.Count; j++)
{
//pname += cart.Rows[j].Field<String>("Product") + "=" + cart.Rows[j].Field<int>("Qty") + ",";
total += (cart.Rows[j].Field<double>("Cost")-cart.Rows[j].Field<double>("Discount")) * cart.Rows[j].Field<int>("Qty");
}
//create Order ID
String ordid;
DateTime d = new DateTime();
d = DateTime.Now;
ordid = d.Year + "-" + d.Month + "-"+"0";
ordid += new Database().getOrderCount();
order_id.Value = ordid;
amount.Value = Convert.ToString(total);
merchant_id.Value = "41296";
cancel_url.Value = "http://giftdezires.com/estore/Index.aspx";
//get month's orders
//Session.Remove("CurrentCart");
// check for logged or no
Boolean b = new Boolean();
//b = (Boolean)Session["Logged"];
if (Session["Logged"] == null)
b = false;
else
b = (Boolean)Session["Logged"];
if (b == true)
{
//get and set address
}
else
{
// copy code from CCAvenue response handler
//set all forms items here and redirect or do all from related stuff here
}
//Session["ItemsSelected"] = pname;
String s = @"<script ' type='text/javascript'>document.getElementById('form1').submit();</script>";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", s, false);
}
else
{
Response.Redirect("Index.aspx");
}
}
catch (Exception ex)
{
// send email for the error
new ProjectUtilities().sendError(ex);
Response.Redirect("Index.aspx");
}
}
}
public SqlDataReader getWishlist()
{
// call DB for items with price,name,desc,disc
SqlDataReader r = new Database().getPrice(this.wishlistitems);
return r;
}
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());
}
}
protected void RegularSubmit_Click(object sender, EventArgs e)
{
String username = Username.Text;
String password = Password.Text;
if (!String.IsNullOrEmpty(username) && !String.IsNullOrEmpty(password))
{
Object[] o = new Database().isUserValid(username, password);
if ((Boolean)o[0] == true)
Session["user"] = (String)o[1];
else
{
String sb = @"<script>alert('Incorrect Username / Password !')</script>";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "script", sb, false);
}
}
else
{
String sb = @"<script>alert('Please Enter Both Details')</script>";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "script", sb, false);
return;
}
//check details and display
}
//protected void Page_Init(object sender, EventArgs e)
//{
// Button b = new Button();
// b.Click += new EventHandler(a2c_Click);
//}
//protected void Page_Load(object sender, EventArgs e)
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
NavBar.SkipLinkText = "";
//NavBar.Visible = false;
// Button11.ServerClick += new EventHandler(this.fb_Click);
// Button22.ServerClick += new EventHandler(this.fb_Click);
DataTable table = new DataTable();
string strCon;
ProjectUtilities obj = new ProjectUtilities();
strCon = obj.cons();
SqlConnection conn = new SqlConnection(strCon);
string sql = "select menu_id, menu_name, menu_parent_id, menu_url from menuMaster";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(table);
DataView view = new DataView(table);
view.RowFilter = "menu_parent_id is NULL";
foreach (DataRowView row in view)
{
MenuItem menuItem = new MenuItem(row["menu_name"].ToString(),
row["menu_id"].ToString());
menuItem.NavigateUrl = row["menu_url"].ToString();
NavBar.Items.Add(menuItem);
AddChildItems(table, menuItem);
}
conn.Close();
displayItems();
String cid = Request.QueryString["Cid"];
int temp;
if (!String.IsNullOrEmpty(cid) && int.TryParse(cid,out temp) && cid.Length<=8)
{
String temp1 = new Database().getCatName(temp);
if (temp1 == "NA")
Response.Redirect("Index.aspx");
String[] catg = temp1.Split(',');
A1.InnerHtml = catg[0];
A1.HRef = catg[1];
Page.Title = A1.InnerHtml + " | GiftDezires.com";
Image banner = new Image();
banner.Style.Add("width", "100%");
if (!catg[2].Contains("false"))
{
banner.ImageUrl = "http://giftdezires.com/estore/images/Banner/" + catg[2];
bannerdiv.Controls.Clear();
bloc = banner.ImageUrl;
bannerdiv.Controls.Add(banner);
}
else
bannerdiv.Visible = false;
}
else
{
Response.Redirect("Index.aspx");
}
}
else
{
Image banner = new Image();
banner.Style.Add("width", "100%");
banner.ImageUrl = bloc;
bannerdiv.Controls.Clear();
bannerdiv.Controls.Add(banner);
// if (filterl.Count != 0)
// FilterList.Visible = true;
if (Request.Form["__EVENTTARGET"] == "removeFilters1")
{
string passedArgument = Request.Params.Get("__EVENTARGUMENT");
removeFilters1_click(passedArgument);
}
else if (Request.Form["__EVENTTARGET"] == "Button1")
{
String[] s = Request.Params.Get("__EVENTARGUMENT").Split(',');
int s1 = Int32.Parse(s[0]);
int s2 = Int32.Parse(s[1]);
//filterPrice(s1, s2);
ll = s1;
ul = s2;
//q= createQuery();
query();
}
else if (Request.Form["__EVENTTARGET"] == "_Range")
_Range_ValueChanged();
else if (Request.Form["__EVENTTARGET"] == "_Age")
_Age_ValueChanged();
else if (Request.Form["__EVENTTARGET"].ToString().Contains("a2c"))
{
//Request.Form["__EVENTTARGET"].ToString()
a2c_Click(Request.Form["__EVENTTARGET"].ToString(), null);
//Response.Redirect(Request.Url.AbsoluteUri);
}
// else
// Response.Redirect(Request.Url.AbsoluteUri);
//Request.Form["__EVENTTARGET"]
}
}
