public Object[] isUserValid(String username,String password) { bool b = false; Object[] info = new Object[2]; String name=""; password = new ProjectUtilities().hashFn(password); String q = "Select Email,Password,FirstName from SocialDB where Email=@a "; con = new SqlConnection(new ProjectUtilities().cons()); SqlCommand c = new SqlCommand(q, con); con.Open(); SqlDataReader r; try { c.Parameters.AddWithValue("@a", username); r = c.ExecuteReader(); if (r != null && r[1] == password) { b = true; name = r[2].ToString(); } else { b = false; name = ""; } } catch (Exception exx) { b = false; } finally { con.Close(); } Boolean isval = new Boolean(); isval = b; info[0] = isval; info[1] = name; return info; }
protected void Page_Load(object sender, EventArgs e) { Button11.ServerClick += new EventHandler(this.fb_Click); RegularSubmit.Click += new EventHandler(this.RegularSubmit_Click); if (Session["User"] != null) { LoginName.Visible = true; LoginName.Text = "Welcome " + Session["User"].ToString(); } //RegularSubmit //Button22.ServerClick += new EventHandler(this.gp_Click); //if (Session["user"] != null && String.IsNullOrEmpty(Session["user"].ToString()) == false) // LoginName.Text = "Welcome " + Session["user"]; if (!IsPostBack) { //NavBar.SkipLinkText = ""; 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 * from menuMaster"; 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); } recordData(); BrowsingData o = (BrowsingData)Session["BrowsingData"]; if (o != null) o.commit(o); } }
public void Button1_Click(object sender, EventArgs e) { ProjectUtilities obj = new ProjectUtilities(); try { SqlConnection con = new SqlConnection(obj.cons()); String q = "Insert into SocialDB (Email,ContactNo,Address,FirstName,LastName,DOB,Gender,Location) Values (@email,@Cno,@address,@fname,@lname,@DOB,@Gender,@Location)"; con.Open(); SqlCommand com = new SqlCommand(q, con); com.CommandText = q; com.CommandType = CommandType.Text; com.Parameters.Add(new SqlParameter("@username", username)); if(Address.Text!=null) com.Parameters.Add(new SqlParameter("@address", Address.Text)); else com.Parameters.Add(new SqlParameter("@address", DBNull.Value)); com.Parameters.Add(new SqlParameter("@email", email)); com.Parameters.Add(new SqlParameter("@fname", firstname)); com.Parameters.Add(new SqlParameter("@lname", lastname)); if(ContactNo.Text!=null) com.Parameters.Add(new SqlParameter("@Cno", ContactNo.Text)); else com.Parameters.Add(new SqlParameter("@Cno", DBNull.Value)); if(DOB.Value!=null) com.Parameters.Add(new SqlParameter("@DOB", DOB.Value)); else com.Parameters.Add(new SqlParameter("@DOB", DBNull.Value)); com.Parameters.Add(new SqlParameter("@Gender", gender)); com.Parameters.AddWithValue("@Location", location); //com.Parameters.Add(new SqlParameter("@Name", name)); int v = com.ExecuteNonQuery(); con.Close(); Session["Logged"] = "True"; Session["User"] = firstname; //Response.Redirect("Index.aspx",false); } catch (Exception ex) { new ProjectUtilities().sendError(ex); } finally { Response.Redirect("Index.aspx"); } }
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(); qr = Request.QueryString["q"]; if (!String.IsNullOrEmpty(q.Trim())) { FilterList.Visible = false; Page.Title = qr + " - Buy Best Products Online!"; } else { Response.Redirect("Index.aspx"); } } else { 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(); } } }
protected void Page_Load(object sender, EventArgs e) { string workingKey = "9237F8E78FF96C00C023857A825C0056";//put in the 32bit alpha numeric key in the quotes provided here CCACrypto ccaCrypto = new CCACrypto(); string encResponse = ccaCrypto.Decrypt(Request.Form["encResp"],workingKey); NameValueCollection Params = new NameValueCollection(); string[] segments = encResponse.Split('&'); String orderstatus = ""; foreach (string seg in segments) { string[] parts = seg.Split('='); if (parts.Length > 0) { string Key = parts[0].Trim(); string Value = parts[1].Trim(); if (Key == "order_status") orderstatus = Key; Params.Add(Key, Value); } } // order id tracking id failure msg payment mode name on card // delivary add // billing add // if(orderstatus.ToLower() == "success") // SUCCESSFUL ORDER { String orderid = "", contactno = "", paymentmode = "", name = "", currency = "", amount = "", month, year, date; int tracker = -1; ; StringBuilder billingaddress, delivaryaddress, otherdetails; StringBuilder responseObj, items; responseObj = new StringBuilder(); billingaddress = new StringBuilder(); delivaryaddress = new StringBuilder(); otherdetails = new StringBuilder(); // Processing Response month = DateTime.Now.Month.ToString(); date = DateTime.Now.Date.ToString(); year = DateTime.Now.Year.ToString(); for (int i = 0; i < Params.Count; i++) { //Response.Write(Params.Keys[i] + " = " + Params[i] + "<br>"); responseObj.Append("[" + Params.Keys[i] + "]:[" + Params[i] + "]"); responseObj.Append(","); if (Params.Keys[i].Contains("billing")) { if (Params.Keys[i].Contains("name")) name = Params[i]; else if (Params.Keys[i].Contains("tel")) contactno = Params[i]; else billingaddress.Append(Params[i] + ","); } else if (Params.Keys[i].Contains("billing")) { billingaddress.Append(Params[i] + ","); } else { if (Params.Keys[i] == "order_id") orderid = Params[i]; else if (Params.Keys[i] == "tracking_id") tracker = int.Parse(Params[i]); else if (Params.Keys[i] == "currency") currency = Params[i]; else if (Params.Keys[i] == "amount") amount = Params[i]; else if (Params.Keys[i] == "payment_mode") paymentmode = Params[i]; else { otherdetails.Append(Params.Keys[i] + ":" + Params[i]); } } } DataTable itemsoncart = (DataTable)Session["CurrentCart"]; // Processing items // name , qty , final-uc items = new StringBuilder(); String q = "Insert into OrderedProductList (OrderId,ProductName,Quantity,UnitPrice) Values(@a,@b,@c,@d)"; SqlConnection c = new SqlConnection(new ProjectUtilities().cons()); SqlCommand com = new SqlCommand(q, c); com.Parameters.AddWithValue("@a", orderid); try { c.Open(); foreach (DataRow r in itemsoncart.Rows) { String names = r.Field<String>(1); items.Append(names); items.Append(","); com.Parameters.AddWithValue("@b", names); names = r.Field<double>(2).ToString("N2"); com.Parameters.AddWithValue("@d", names); names = r.Field<int>(3).ToString(); com.Parameters.AddWithValue("@c", names); int b = com.ExecuteNonQuery(); if (b == 0) { // issue throw new Exception(); } } } catch (Exception expc) { // sends email of the entire transaction as a proof ProjectUtilities o = new ProjectUtilities(); o.sendError(expc); o.sendMail(encResponse); } finally { c.Close(); } // add to order table SqlCommand c2 = new SqlCommand(q, c); q = @"INSERT INTO Orders (OrderId,BillingAddress,DeliveryAddress,ContactNo,Payment_Mode,Name,Currency,Amount,Tracking_Id,Response,Month,Year,Items) VALUES (@a, @b, @c, @d, @e, @f, @g, @h ,@i, @j, @k, @l, @m)"; c2.Parameters.AddWithValue("@a", orderid); c2.Parameters.AddWithValue("@b", billingaddress.ToString()); c2.Parameters.AddWithValue("@c", delivaryaddress.ToString()); c2.Parameters.AddWithValue("@d", contactno); c2.Parameters.AddWithValue("@e", paymentmode); c2.Parameters.AddWithValue("@f", name); c2.Parameters.AddWithValue("@g", currency); c2.Parameters.AddWithValue("@h", amount); c2.Parameters.AddWithValue("@i", tracker.ToString()); c2.Parameters.AddWithValue("@j", encResponse); c2.Parameters.AddWithValue("@k", month); c2.Parameters.AddWithValue("@l", year); c2.Parameters.AddWithValue("@m", items.ToString()); int added = c2.ExecuteNonQuery(); if(added == 0) { new ProjectUtilities().sendMail("Data Not recorderd ! "+encResponse); } else { new ProjectUtilities().sendMail("New Order : "+encResponse); } } else if(orderstatus.ToLower() == "failure") { new ProjectUtilities().sendMail(encResponse); Response.Redirect("Failed.aspx"); } else if(orderstatus.ToLower() == "aborted") { new ProjectUtilities().sendMail(encResponse); Response.Redirect("Index.aspx"); } else { new ProjectUtilities().sendMail(encResponse); Response.Redirect("Index.aspx"); } }
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 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"] } }