protected void CartButton_Click(object sender, EventArgs e)
{
List <Purchase> shoppingcart;
if (Session["cart"] == null)
{
Cart.InnerHtml = "<h1>Your Shopping Cart is Empty</h1>";
}
else
{
OrderButton.Visible = true;
shoppingcart = (List <Purchase>)Session["cart"];
Cart.InnerHtml = " ";
foreach (Purchase p in shoppingcart)
{
var price = "0.0";
decimal dec;
string ProductId = p.Productid.ToString();
string salquery = "SELECT * FROM Products where ProductId =@ProductId";
using (SqlDataReader f = SQLhelper.ExecuteQuery(salquery, CommandType.Text, new SqlParameter(parameterName: "@ProductId", value: (ProductId))))
{
while (f.Read())
{
dec = Convert.ToDecimal(f[3]);
price = f[3].ToString();
Cart.InnerHtml += f[1].ToString() + dec;
}
}
Cart.InnerHtml += " Total price is:£" + price + " ";
}
}
}
//protected void LinkButton1_Click(object sender, EventArgs e)
//{
//}
protected void Veiw_Click(object sender, EventArgs e)
{
using (SqlDataReader k = SQLhelper.ExecuteQuery("SELECT [Id],[CatagoryName] FROM [dbo].[ Catagory]"))
{
string test = " ";
string txt2 = (string)Session["s"];
while (k.Read())
{
test += $"<div runat=\"server\" style=\"background-color:cadetblue\">" +
$"<a href=WebForm3.aspx?id=" + k["Id"] + " ><big>" + k["CatagoryName"] + "</big></a><br>" +
$"<div/>";
if (HttpContext.Current.Session["s"] != null)
{
Div2.InnerHtml = "Currently Logged User is " + txt2.ToString() + "<br><div></div>";
//LogIn.Enabled = false;
}
else
{
Div2.InnerHtml = "No one Logged in" + "<br><div></div>";
}
Div4.InnerHtml = $"<a href=AllProducts.aspx><big>all products</big></a><br>";
}
PlaceHolder2.Controls.Add(new Literal {
Text = test
});
}
}
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder table = new StringBuilder();
string RequestQueryString = Request.QueryString["Id"];
string salquery = "SELECT * FROM Products where ProductId =@ProductId";
using (SqlDataReader f = SQLhelper.ExecuteQuery(salquery, CommandType.Text, new SqlParameter(parameterName: "@ProductId", value: (RequestQueryString))))
{
string x = (string)Session[name : "s"];
//table.Append(value: "< div >x</ div >");
string twenty = string.Empty;
table.Append("<table border='1'>");
table.Append("<tr><th>ID</th><th>phone</th><th>Description</th><th>price</th><th>stock</th></tr>");
var sql = "<h1> ";
while (f.Read())
{
if (f[5].ToString() != string.Empty)
{
table.Replace("<tr><th>ID</th><th>phone</th><th>Description</th><th>price</th><th>stock</th></tr>", "<tr><th>ID</th><th>phone</th><th>Description</th><th>price</th><th>stock</th><th>image</th></tr>");
}
productid = (int)f[0];
Price = f[2].ToString();
table.Append("<tr>");
table.Append("<td>" + f[0] + "</td>");
table.Append("<td>" + f[1] + "</td>");
table.Append("<td>" + f[2] + "</td>");
table.Append("<td>" + f[3] + "</td>");
table.Append("<td>" + f[4] + "</td>");
if (f[5].ToString() != string.Empty)
{
table.Append("<td>" + f[5] + "</td>");
Image1.ImageUrl = f[5].ToString();
//twenty = " <table border='1'> < asp:Image id = \"Image1\" runat=\"server\" ImageUrl = \"~" + f[5] + " \"/></table>";
} //AlternateText = "Image text"ImageAlign = "left"+" < img src =\"" + f[5].ToString() +"\" width=100 />"
table.Append("</tr>");
// sql += (f[0].ToString() +" "+ f[1].ToString() +" "+ f[2].ToString() +" "+ "</h1>");
}
table.Append("</table>");
PlaceHolder2.Controls.Add(new Literal {
Text = table.ToString()
});
PlaceHolder2.Controls.Add(new Literal {
Text = twenty
});
// PlaceHolder2.Controls.Add(new Literal { Text = sql.ToString() });
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (SqlDataReader r = SQLhelper.ExecuteQuery(query: "select * from dbo.Products"))
{
while (r.Read())
{
// HELLO.InnerHtml = (r[0]+" "+ r[1] + " " + r[2] + " " + r[3] );
// Response.Write(r[0]);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
h.Open();
SqlDataAdapter j = new SqlDataAdapter("SELECT * FROM Products where ProductId = ProductId ", h);
j.SelectCommand.ExecuteNonQuery();
DataTable dt = new DataTable();
j.Fill(dt);
h.Close();
grid.DataSource = dt;
grid.DataBind();
StringBuilder table = new StringBuilder();
string salquery = "SELECT * FROM Products where ProductId=ProductId ";
using (SqlDataReader f = SQLhelper.ExecuteQuery(salquery))
{
string x = (string)Session["s"];
table.Append("<div id=\"Div1\" runat=\"server\" style=\"color: #33CC33; background-color: violet\">" + "enjoy browsing " + x);
table.Append("<table border='1' bgcolor=\" #00ffff\" >");
table.Append("<tr><th>ID</th><th>phone</th><th>Description</th><th>price</th><th>stock</th>");
table.Append("</tr>");
var sql = "<h1> ";
while (f.Read())
{
table.Append("<tr>");
table.Append("<td>" + f[0] + "</td>");
table.Append("<td>" + f[1] + "</td>");
table.Append("<td>" + f[2] + "</td>");
table.Append("<td>" + f[3] + "</td>");
table.Append("<td>" + f[4] + "</td>");
table.Append("</tr>");
sql += (f[0].ToString() + " " + f[1].ToString() + " " + f[2].ToString() + " " + "</h1>");
}
table.Append("</table></ div >");
PlaceHolder1.Controls.Add(new Literal {
Text = table.ToString()
});
}
}
protected void Page_Load(object sender, EventArgs e)
{
// string x= "SELECT * FROM [dbo].[Products] inner join [dbo].[ProductCatagory]on Products.ProductId=ProductCatagory.ProductId and ProductCatagory.CategoryId= @CatId ";
string x = "SELECT * FROM [dbo].[Products] inner join [dbo].[ProductCatagory] on ProductCatagory.CategoryId= @CatId and Products.ProductId=ProductCatagory.ProductId";
string CatId = Request.QueryString["Id"];
using (SqlDataReader k = SQLhelper.ExecuteQuery(x, CommandType.Text, new SqlParameter("@CatId", Int32.Parse(CatId))))
{
string y = (string)Session["s"];
while (k.Read()) //&& Session["s"] != null
{
Div1.InnerHtml += $"<div background-color: violet>";
Div1.InnerHtml += $"<a href=WebForm2.aspx?id={k["ProductId"].ToString()}><big>{k["Name"]}</big></a><br>";
Div1.InnerHtml += $"<div/>";
}
}
}