protected void Button2_Click(object sender, EventArgs e) { int i = int.Parse(Request.QueryString["id"]); int qnty = int.Parse(TextBox1.Text); if (int.Parse(TextBox1.Text) != 0) { int cost = int.Parse(TextBox1.Text) * (int.Parse(Label6.Text)); shoppingDataContext sdc2 = new shoppingDataContext(); cart cart = new cart() { quantity = int.Parse(TextBox1.Text), total_cost = cost, cust_id = int.Parse(Session["cust"].ToString()), prod_id = int.Parse(Request.QueryString["id"]) }; sdc2.carts.InsertOnSubmit(cart); sdc2.SubmitChanges(); Label12.Text = "Successfully Added.."; } else { Label12.Text = "Plz select quntity"; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin"] != null) { int id = int.Parse(Session["admin"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.id == id select u; foreach (var n in query) { Label1.Text = n.first_name; } var query2 = from p in sdc.products join o in sdc.orders on p.id equals o.prod_id join u in sdc.users on o.cust_id equals u.id orderby o.id descending select new { CUSTOMER_NAME = u.first_name, PRODUCT_NAME = p.prod_name, QUANTITY = o.quantity, AMOUNT = o.quantity * p.discount_price, ORDER_DATE = o.order_date }; GridView1.DataSource = query2; GridView1.DataBind(); } else { Response.Redirect("/customer/login.aspx?Data=Please Login First..."); } }
protected void Button4_Click(object sender, EventArgs e) { for (int i = 0; i < GridView1.Rows.Count; i++) { RadioButton rb = (RadioButton)GridView1.Rows[i] .Cells[0].FindControl("RadioButton1"); if (rb != null) { if (rb.Checked) { rb.Checked = false; break; } } } MultiView1.ActiveViewIndex = 1; Label9.Text = ""; shoppingDataContext sdc = new shoppingDataContext(); var query3 = from p in sdc.products join c in sdc.prod_cats on p.cat_id equals c.id join d in sdc.prod_cat_2s on p.cat_id_2 equals d.Id where c.cat_name == DropDownList2.SelectedItem.Text && d.cat_name_2 == DropDownList3.SelectedItem.Text select new { Product_Id = p.id, Product_Name = p.prod_name }; GridView1.DataSource = query3; GridView1.DataBind(); }
protected void Button5_Click(object sender, EventArgs e) { if (ViewState["add"] != null) { int qty = int.Parse(Request.QueryString["qnty"]); int id = int.Parse(Session["cust"].ToString()); string addre = ViewState["add"].ToString(); shoppingDataContext sdc = new shoppingDataContext(); int i = int.Parse(Request.QueryString["data"]); order order = new order() { cust_id = id, prod_id = i, order_date = DateTime.Now.AddDays(0), quantity = qty, amount = int.Parse(ViewState["price"].ToString()) * qty, shipping_address = addre }; sdc.orders.InsertOnSubmit(order); sdc.SubmitChanges(); Response.Redirect("/customer/payment_order.aspx?pro-id=" + i + "&qnty=" + qty); } else { Label10.Text = "Plz select one address.."; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin"] != null) { int id = int.Parse(Session["admin"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.id == id select u; foreach (var n in query) { Label1.Text = n.first_name; } var query2 = from c in sdc.prod_cats select c; foreach (var q in query2) { DropDownList1.Items.Add(q.cat_name); } } else { Response.Redirect("/customer/login.aspx?Data=Please Login First..."); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin"] != null) { id = int.Parse(Session["admin"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.id == id select u; foreach (var n in query) { Label1.Text = n.first_name; } string name = this.Request.QueryString["data"]; Label2.Text = name; var query2 = from p in sdc.products join d in sdc.prod_cat_2s on p.cat_id_2 equals d.Id join c in sdc.prod_cats on p.cat_id equals c.id orderby p.prod_quantity ascending select new { Name = p.prod_name, Price = p.price, Discount_Price = p.discount_price, Quantity = p.prod_quantity, Category = c.cat_name, SubCategory = d.cat_name_2 }; GridView1.DataSource = query2; GridView1.DataBind(); } else { Response.Redirect("/customer/login.aspx?Data=Please Login First..."); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["cust"] != null) { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query2 = from u in sdc.users where u.id == id select u; foreach (var n in query2) { Label1.Text = n.first_name; } int pid = int.Parse(Request.QueryString["pro-id"]); int qty = int.Parse(Request.QueryString["qnty"]); var query = from c in sdc.orders where c.prod_id == pid && c.cust_id == id && c.quantity == qty select c; foreach (var q in query) { ViewState["o-id"] = q.id; } } else { Response.Redirect("login.aspx?Data=Please Login First..."); } }
protected void Button2_Click(object sender, EventArgs e) { if (TextBox2.Text != "") { shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.email_id == TextBox2.Text select u; if (query.Count() == 1) { foreach (var u in query) { MultiView1.ActiveViewIndex = 1; ViewState["id"] = u.id; } } var query2 = from s in sdc.users where s.id == int.Parse(ViewState["id"].ToString()) select s; foreach (var w in query) { Label2.Text = w.question; } } else { Label5.Text = "Plz fill first.."; } }
protected void Button1_Click(object sender, EventArgs e) { foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[0].FindControl("CheckBox1") as CheckBox); if (chkRow.Checked) { int id = int.Parse(row.Cells[1].Text); shoppingDataContext sdc = new shoppingDataContext(); var query = from d in sdc.products where d.id == id select d; foreach (var q in query) { sdc.products.DeleteOnSubmit(q); } sdc.SubmitChanges(); } } } GridView1.DataSource = null; GridView1.DataBind(); Label2.Text = "Delete Product Successfully"; }
protected void Page_Load(object sender, EventArgs e) { if (Session["cust"] != null) { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query2 = from u in sdc.users where u.id == id select u; foreach (var n in query2) { Label1.Text = n.first_name; } int i = int.Parse(Request.QueryString["data"]); int qty = int.Parse(Request.QueryString["qnty"]); var query = from c in sdc.products where c.id == i select c; foreach (var q in query) { ViewState["q"] = q.prod_quantity; ViewState["price"] = q.discount_price.ToString(); Label2.Text = q.prod_name; Label3.Text = q.description; Label4.Text = "₹" + q.price.ToString(); Label5.Text = "₹" + q.discount_price.ToString(); Label6.Text = "₹" + (q.price - q.discount_price).ToString() + " => " + Convert.ToInt32((((q.price - q.discount_price) * 100) / (q.price))).ToString() + "% Off"; Label7.Text = qty.ToString(); if (q.size != null) { lab_size.Visible = true; Label8.Visible = true; Label8.Text = q.size; } else { lab_size.Visible = false; Label8.Visible = false; } } var query3 = from c in sdc.addresses where c.user_id == id select new { Address = c.address1 }; GridView1.DataSource = query3; GridView1.DataBind(); Label9.Text = "₹" + int.Parse(ViewState["price"].ToString()) * qty; } else { Response.Redirect("login.aspx?Data=Please Login First..."); } }
protected void setcatid2() { shoppingDataContext sdc2 = new shoppingDataContext(); var query = from c in sdc2.prod_cat_2s where c.cat_name_2 == DropDownList2.SelectedItem.Text select c; foreach (var q in query) { cat_id_2_1 = q.Id; } }
protected void Button1_Click(object sender, EventArgs e) { shoppingDataContext sdc = new shoppingDataContext(); var query3 = from u in sdc.users where u.username == TextBox1.Text select u; if (query3.Count() == 0) { if (TextBox6.Text == TextBox7.Text) { MD5 md5 = MD5.Create(); shoppingDataContext sdc2 = new shoppingDataContext(); user user = new user() { username = TextBox1.Text, first_name = TextBox2.Text, last_name = TextBox3.Text, gender = RadioButtonList1.Text, email_id = TextBox4.Text, state = DropDownList1.SelectedItem.Text, city = DropDownList2.SelectedItem.Text, role = "customer", mob_no = long.Parse(TextBox5.Text), question = DropDownList3.SelectedItem.Text, answer = TextBox9.Text, password = GetMD5HashData(TextBox6.Text), }; sdc2.users.InsertOnSubmit(user); sdc2.SubmitChanges(); address add = new address() { address1 = TextBox8.Text, user_id = user.id }; sdc2.addresses.InsertOnSubmit(add); sdc2.SubmitChanges(); Response.Redirect("login.aspx?Data=Successfully Registered"); } else { Label1.Text = "Password does not match..Please try again.."; } } else { Label1.Text = "Username already exists... Please enter another Username..."; } }
protected void BindGrid() { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query2 = from p in sdc.products join c in sdc.carts on p.id equals c.prod_id where c.cust_id == id select new { Cart_ID = c.id, Product_Name = p.prod_name, Quantity = c.quantity, Total_Cost = c.total_cost }; GridView1.DataSource = query2; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { shoppingDataContext sdc = new shoppingDataContext(); var query2 = from c in sdc.states select c.state_name; foreach (var q in query2) { DropDownList1.Items.Add(q); } } }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { shoppingDataContext sdc = new shoppingDataContext(); var query2 = from c in sdc.prod_cat_2s join s in sdc.prod_cats on c.cat_id equals s.id where s.cat_name == DropDownList1.SelectedItem.Text select c; DropDownList2.Items.Clear(); foreach (var v in query2) { DropDownList2.Items.Add(v.cat_name_2); } }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { shoppingDataContext sdc = new shoppingDataContext(); var query2 = from c in sdc.cities join s in sdc.states on c.state_id equals s.Id where s.state_name == DropDownList1.SelectedItem.Text select c.city_name; DropDownList2.Items.Clear(); foreach (var v in query2) { DropDownList2.Items.Add(v); } }
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { shoppingDataContext sdc = new shoppingDataContext(); var query3 = from p in sdc.products join c in sdc.prod_cats on p.cat_id equals c.id join d in sdc.prod_cat_2s on p.cat_id_2 equals d.Id where c.cat_name == DropDownList1.SelectedItem.Text && d.cat_name_2 == DropDownList2.SelectedItem.Text select new { Product_Id = p.id, Product_Name = p.prod_name }; GridView1.DataSource = query3; GridView1.DataBind(); }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int index = Convert.ToInt32(e.RowIndex); shoppingDataContext sdc = new shoppingDataContext(); var query = from c in sdc.carts where c.id == int.Parse(GridView1.Rows[index].Cells[0].Text) select c; foreach (var q in query) { sdc.carts.DeleteOnSubmit(q); } sdc.SubmitChanges(); BindGrid(); }
protected void BindGrid() { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from c in sdc.products join d in sdc.orders on c.id equals d.prod_id join o in sdc.deliveries on d.id equals o.order_id where o.delivery_date >= DateTime.Now.Date && o.cust_id == id && d.cust_id == id orderby o.id descending select new { Delivery_ID = o.id, Product_Name = c.prod_name, Quantity = d.quantity, Total_Amount = d.amount, Delivery_Date = o.delivery_date }; GridView1.DataSource = query; GridView1.DataBind(); }
protected void profileinfo() { shoppingDataContext sdc = new shoppingDataContext(); int id = int.Parse(Session["admin"].ToString()); var queue = from s in sdc.users where s.id == id select s; foreach (var q in queue) { Label3.Text = q.first_name; Label4.Text = q.email_id; Label5.Text = q.mob_no.ToString(); Label6.Text = "****"; } }
protected void BindGrid() { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from o in sdc.orders join p in sdc.products on o.prod_id equals p.id join d in sdc.deliveries on o.id equals d.order_id where o.order_date <= DateTime.Now.AddDays(30) && o.cust_id == id orderby o.id descending select new { Product_Name = p.prod_name, Quantity = o.quantity, Shipping_Address = o.shipping_address, Order_Date = o.order_date, Delivery_Date = d.delivery_date }; GridView1.DataSource = query; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["cust"] != null) { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.id == id select u; foreach (var n in query) { Label1.Text = n.first_name; } Label2.Text = "For Change Your Profile Click the Radio Button"; profileinfo(); } else { Response.Redirect("/customer/login.aspx?Data=Please Login First..."); } } else { if (Session["cust"] != null) { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.id == id select u; foreach (var n in query) { Label1.Text = n.first_name; } Label2.Text = "For Change Your Profile , Click the Radio Button"; profileinfo(); } else { Response.Redirect("/customer/login.aspx?Data=Session is terminated...Please Login First..."); } } }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { shoppingDataContext sdc = new shoppingDataContext(); var query2 = from c in sdc.prod_cat_2s join s in sdc.prod_cats on c.cat_id equals s.id where s.cat_name == DropDownList1.SelectedItem.Text select c; DropDownList2.Items.Clear(); GridView1.DataSource = null; GridView1.DataBind(); DropDownList2.Items.Add("--Please Select Sub_Category--"); foreach (var v in query2) { DropDownList2.Items.Add(v.cat_name_2); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["cust"] != null) { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.id == id select u; foreach (var n in query) { Label1.Text = n.first_name; } Label2.Text = this.Request.QueryString["data"]; } else { Response.Redirect("login.aspx?Data=Please Login First..."); } } else { if (Session["cust"] != null) { int id = int.Parse(Session["cust"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.id == id select u; foreach (var n in query) { Label1.Text = n.first_name; } Label2.Text = this.Request.QueryString["data"]; } else { Response.Redirect("login.aspx?Data=Session is terminated...Please Login First..."); } } }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox6.Text != "") { shoppingDataContext sdc = new shoppingDataContext(); int id = int.Parse(Session["cust"].ToString()); address add = new address() { address1 = TextBox6.Text, user_id = id }; sdc.addresses.InsertOnSubmit(add); sdc.SubmitChanges(); } else { Label10.Text = "plz write new address"; } }
protected void Button5_Click(object sender, EventArgs e) { if (TextBox1.Text != "" && TextBox4.Text != "") { shoppingDataContext sdc = new shoppingDataContext(); var query = from u in sdc.users where u.id == int.Parse(ViewState["id"].ToString()) select u; foreach (var q in query) { q.password = GetMD5HashData(TextBox1.Text); } sdc.SubmitChanges(); Response.Redirect("login.aspx?Data=Successfully Updated"); } else { Label3.Text = "Plz fill first..."; } }
protected void Button2_Click(object sender, EventArgs e) { if (TextBox3.Text != "") { int id = int.Parse(Session["admin"].ToString()); shoppingDataContext sdc = new shoppingDataContext(); var query = from s in sdc.users where s.id == id select s; foreach (var q in query) { q.email_id = TextBox3.Text; } sdc.SubmitChanges(); Label2.Text = "Successfully changed"; } else { Label2.Text = "Please fill up first.."; } }
protected void Button3_Click(object sender, EventArgs e) { if (TextBox3.Text != "") { shoppingDataContext sdc = new shoppingDataContext(); var query2 = from s in sdc.users where s.answer == TextBox3.Text && s.id == int.Parse(ViewState["id"].ToString()) select s; if (query2.Count() == 1) { foreach (var q in query2) { MultiView1.ActiveViewIndex = 2; } } } else { Label1.Text = "Plz fill first.."; } }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox2.Text != "" && TextBox7.Text != "") { int id = int.Parse(Session["admin"].ToString()); MD5 md5 = MD5.Create(); shoppingDataContext sdc = new shoppingDataContext(); var query = from s in sdc.users where s.id == id select s; foreach (var q in query) { q.password = GetMD5HashData(TextBox2.Text); } sdc.SubmitChanges(); Label2.Text = "Successfully changed"; } else { Label2.Text = "Please fill up first.."; } }
protected void Button1_Click(object sender, EventArgs e) { setcatid(); setcatid2(); shoppingDataContext sdc = new shoppingDataContext(); product product = new product() { prod_name = TextBox1.Text, description = TextBox2.Text, price = int.Parse(TextBox3.Text), discount_price = int.Parse(TextBox4.Text), prod_quantity = int.Parse(TextBox5.Text), size = TextBox6.Text, cat_id = cat_id_1, cat_id_2 = cat_id_2_1, }; sdc.products.InsertOnSubmit(product); sdc.SubmitChanges(); Label2.Text = "Product is successfully added"; }