public static DataTable GetUser(int id)
{
SqlCommand cmd = new SqlCommand("select * from Users where Id=@id");
cmd.Parameters.AddWithValue("id", id);
return(DBLayers.select(cmd));
}
//select
public static DataTable GetUserId(string name, string password)
{
SqlCommand cmd = new SqlCommand("select Id from Users where Name=@name and Password=@password");
cmd.Parameters.AddWithValue("name", name);
cmd.Parameters.AddWithValue("password", password);
return(DBLayers.select(cmd));
}
public static DataTable GetAllUsers()
{
SqlCommand cmd = new SqlCommand("select * from Users");
return(DBLayers.select(cmd));
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
ProductLayer.DeleteProduct(id);
}
}
if (Session["id"] != null)
{
SqlCommand cmd = new SqlCommand("select * from Cart c, Product p where c.ProductId = p.Id and c.UserId=@id");
cmd.Parameters.AddWithValue("id", int.Parse(Request.Cookies["user"].Values["id"]));
DataTable dt = DBLayers.select(cmd);
//DataTable dt = ProductLayer.GetAllProducts();
for (int i = 0; i < dt.Rows.Count; i++)
{
Panel productPanel = new Panel();
ImageButton imageButton = new ImageButton();
Label lblName = new Label();
Label lblPrice = new Label();
Label lblDate = new Label();
Label lblQuantity = new Label();
imageButton.ImageUrl = dt.Rows[i]["Image"].ToString();
imageButton.CssClass = "productImage";
//imageButton.PostBackUrl = "~/cart.aspx?id="+dt.Rows[i]["Id"];
Button btn = new Button();
btn.CssClass = "cardButton";
btn.Text = "Delete Order";
btn.PostBackUrl = "~/purchasedHistory.aspx?id=" + dt.Rows[i]["Id"];
lblName.Text = "Name: " + dt.Rows[i]["Name"].ToString();
lblName.CssClass = "productName";
lblDate.Text = "Purchased " + dt.Rows[i]["DatePurchased"].ToString();
lblDate.CssClass = "productPrice";
lblPrice.Text = "Price: " + dt.Rows[i]["Price"].ToString() + " $";
lblPrice.CssClass = "productPrice";
lblQuantity.Text = "Quantity: " + dt.Rows[i]["Amount"].ToString();
lblQuantity.CssClass = "productPrice";
productPanel.Controls.Add(imageButton);
productPanel.Controls.Add(new Literal {
Text = "<br/>"
});
productPanel.Controls.Add(lblName);
productPanel.Controls.Add(new Literal {
Text = "<br/>"
});
productPanel.Controls.Add(lblDate);
productPanel.Controls.Add(new Literal {
Text = "<br/>"
});
productPanel.Controls.Add(lblQuantity);
productPanel.Controls.Add(new Literal {
Text = "<br/>"
});
productPanel.Controls.Add(lblPrice);
productPanel.Controls.Add(new Literal {
Text = "<br/>"
});
productPanel.Controls.Add(btn);
productPanel.Controls.Add(new Literal {
Text = "<br/>"
});
pnl_products.Controls.Add(productPanel);
}
}
else
{
Response.Redirect("~/login.aspx");
}
}
