Web Tech snippets

AddProduct.aspx.cs

fuImage.SaveAs(Request.PhysicalApplicationPath +"./images/"+ fuImage.FileName.ToString());
b = "./images/" + fuImage.FileName.ToString();

SqlCommand cmd = new SqlCommand("INSERT INTO Fruits (FruitName, FruitPrice, FruitImage) VALUES (@FruitName, @FruitPrice, @FruitImagePath)", con);
cmd.Parameters.AddWithValue("@FruitName", txtFruitName.Text);
cmd.Parameters.AddWithValue("@FruitPrice", txtFruitPrice.Text);
cmd.Parameters.AddWithValue("@FruitImagePath", b.ToString());
cmd.ExecuteNonQuery();

gvFruits.DataBind();

AddToCart.aspx.cs

int rowIndex = ((sender as Button).NamingContainer as GridViewRow).RowIndex;
int fID = Convert.ToInt32(gvFruits.DataKeys[rowIndex].Values[0]);

SqlCommand cmd = new SqlCommand("INSERT INTO Cart (FruitName, FruitPrice, FruitImage) SELECT FruitName, FruitPrice, FruitImage FROM Fruits WHERE fruitID = '" + fID + "'", con);
cmd.ExecuteNonQuery();

CheckOut.aspx.cs

SqlCommand cmd = new SqlCommand("TRUNCATE TABLE Cart", con);
cmd.ExecuteNonQuery();
gvCart.DataBind();

DeleteFromCart.aspx.cs

int rowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex;
int mID = Convert.ToInt32(gvCart.DataKeys[rowIndex].Values[0]);

SqlCommand cmd = new SqlCommand("DELETE FROM Cart WHERE CartID = '" + mID + "'", con);
cmd.ExecuteNonQuery();

Login.aspx.cs

SqlCommand cmd = new SqlCommand("SELECT * FROM users WHERE username=@username AND password=@password", con);
cmd.Parameters.AddWithValue("@Username", Username.Text);
cmd.Parameters.AddWithValue("@Password", Password.Text);

int count = (int) cmd.ExecuteScalar();
if (count > 0) {
  Session["Username"] = Username.Text;
} else {
 // shit
}

Register.aspx.cs

SqlCommand cmd = new SqlCommand("INSERT INTO MemberLogin (Username, Password) VALUES (@Username, @Password)", con);
cmd.Parameters.AddWithValue("@Username", Username.Text);
cmd.Parameters.AddWithValue("@Password", Password.Text);
cmd.ExecuteNonQuery();