protected void Remv_Click(object sender, EventArgs e)
{
bool t = true;
ShoppingDbEntities2 db = new ShoppingDbEntities2();
User user = new User();
var us = from u in db.Users select u;
List <User> users = us.ToList();
foreach (var r in users)
{
if (r.email == em.Value.ToString())
{
t = false;
db.Users.Attach(r);
db.Users.Remove(r);
db.SaveChanges();
Lab.ForeColor = System.Drawing.Color.Green;
Lab.Text = "User Successfully Removed";
break;
}
}
if (t == true)
{
Lab.ForeColor = System.Drawing.Color.Red;
Lab.Text = "User not Found";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
ShoppingDbEntities2 db = new ShoppingDbEntities2();
bool t = false;
var users = from user in db.Users select user;
List <User> us = users.ToList();
foreach (var r in us)
{
if (r.email == em.Value.ToString())
{
r.groupid = 1;
t = true;
Lab.ForeColor = System.Drawing.Color.Green;
db.SaveChanges();
Lab.Text = "User Successfully Become Admin";
break;
}
}
if (t == false)
{
Lab.ForeColor = System.Drawing.Color.Red;
Lab.Text = "Sorry It is not an Existing Email";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (Page.IsValid)//should pass all validation controls
{
ShoppingDbEntities2 db = new ShoppingDbEntities2();
var users = from user in db.Users select user;
List <User> us = users.ToList();
foreach (var r in us)
{
if (r.email == Text1.Value.ToString() && r.password == Password1.Value.ToString())
{
if (r.groupid == 1)
{
Label1.ForeColor = System.Drawing.Color.Green;
Label1.Text = "Successfully Data Saved Admin";
}
else
{
Label1.ForeColor = System.Drawing.Color.Green;
Label1.Text = "Successfully Data Saved user";
}
Session["username"] = r.username;
Session["Funuser"] = r.groupid;
Response.Redirect("~/default.aspx");
//FormsAuthentication.RedirectFromLoginPage(r.username, true);
break;
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid) //shoud pass all validation controls
{
ShoppingDbEntities2 db = new ShoppingDbEntities2();
User user = new User();
user.username = Text1.Value.ToString();
user.fullname = Text2.Value.ToString();
user.email = Text3.Value.ToString();
user.password = Password1.Value.ToString();
user.groupid = 0;
db.Users.Add(user);
db.SaveChanges();
Label1.ForeColor = System.Drawing.Color.Green;
Label1.Text = "Successfully Data Saved";
Text1.Value = "";
Text2.Value = "";
Text3.Value = "";
}
else //not run because javascript run in browser should disabled
{
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = "Sorry Data not Saved";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
bool t = true;
ShoppingDbEntities2 db = new ShoppingDbEntities2();
Product prod = new Product();
if (DropDownList1.SelectedValue.ToString() == "T-Shirts")
{
prod.catID = 1;
}
else if (DropDownList1.SelectedValue.ToString() == "Shirts")
{
prod.catID = 2;
}
else if (DropDownList1.SelectedValue.ToString() == "Trousers")
{
prod.catID = 3;
}
else if (DropDownList1.SelectedValue.ToString() == "Shorts")
{
prod.catID = 4;
}
prod.price = Convert.ToDecimal(pricc.Value.ToString());
prod.imageName = Tex1.Value.ToString();
var Prod = from pro in db.Products select pro;
List <Product> prodc = Prod.ToList();
foreach (var r in prodc)
{
if (r.price == prod.price && r.imageName == prod.imageName && r.catID == prod.catID)
{
t = false;
db.Products.Attach(r);
db.Products.Remove(r);
db.SaveChanges();
Labe.ForeColor = System.Drawing.Color.Green;
Labe.Text = "Product Successfully Removed";
break;
}
}
if (t == true)
{
Labe.ForeColor = System.Drawing.Color.Red;
Labe.Text = "Product not Removed";
}
}
protected void Page_Load(object sender, EventArgs e)
{
ShoppingDbEntities2 db = new ShoppingDbEntities2();
t.InnerHtml = "";
var Prod = from pro in db.Products select pro;
List <Product> prodc = Prod.ToList();
foreach (var r in prodc)
{
if (r.catID == 1)
{
t.InnerHtml += "<div class='join-button' style='float:left; width:200px;height:250px;margin-bottom:100px' runat='server '>";
t.InnerHtml += ("<asp:Button runat='server' Class='btn btn-default' id='tshirt" + r.productID + "'><img src=Images/" + r.imageName + " style='width:200px; height:200px' runat='server'> <br/>");
t.InnerHtml += r.description + "<br/>Price : " + r.price + "$</Button></div>";
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/Images/") + FileUpload1.FileName);
ShoppingDbEntities2 db = new ShoppingDbEntities2();
Product prod = new Product();
prod.description = Tex1.Value.ToString();
if (DropDownList1.SelectedValue.ToString() == "T-Shirts")
{
prod.catID = 1;
}
else if (DropDownList1.SelectedValue.ToString() == "Shirts")
{
prod.catID = 2;
}
else if (DropDownList1.SelectedValue.ToString() == "Trousers")
{
prod.catID = 3;
}
else if (DropDownList1.SelectedValue.ToString() == "Shorts")
{
prod.catID = 4;
}
prod.price = Convert.ToDecimal(pricc.Value.ToString());
prod.imageName = FileUpload1.FileName.ToString();
db.Products.Add(prod);
db.SaveChanges();
Labe.ForeColor = System.Drawing.Color.Green;
Labe.Text = "Product Successfully Added";
}
else
{
Labe.ForeColor = System.Drawing.Color.Red;
Labe.Text = "Sorry no file uploaded";
}
}
