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";
}
