protected void Button3_Click(object sender, EventArgs e)
{
try
{
for (int i = 0; i < SQLDataClass.tblCart.Rows.Count; i++)
{
if (SQLDataClass.tblCart.Rows[i][0].ToString().Equals(TextBox1.Text.ToString()))
{
try
{
string theID = TextBox1.Text;
string newName = TextBox2.Text;
double newPrice = double.Parse(TextBox3.Text.Replace("$", ""));
int newQty = int.Parse(TextBox4.Text);
double newTotal = double.Parse(TextBox7.Text.Replace("$", ""));
SQLDataClass.UpdateCart(theID, newName, newQty, newPrice, newTotal);
SQLDataClass.getAllCart();
}
catch (Exception ex)
{
TextArea1.InnerText = "Product Not Updated:" + ex.Message;
}
}
}
Guid newGuid = Guid.NewGuid();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["UWPCS3870ConnectionString"].ConnectionString);
conn.Open();
String insertQuery = "Insert into Cart(CartProdID, CartProdName, CartProdQty, CartProdUnitPrice, CartProdCost) values(@CID, @CName, @CQty, @CUnitPrice, @CTotal)";
SqlCommand comm = new SqlCommand(insertQuery, conn);
comm.Parameters.AddWithValue("@CID", TextBox1.Text);
comm.Parameters.AddWithValue("@CName", TextBox2.Text);
comm.Parameters.AddWithValue("@CQty", TextBox4.Text);
comm.Parameters.AddWithValue("@CUnitPrice", TextBox3.Text);
comm.Parameters.AddWithValue("@CTotal", TextBox7.Text);
comm.ExecuteNonQuery();
conn.Close();
Response.Redirect("Login.aspx");
}
catch (Exception ex)
{
Response.Write("Error:" + ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
SQLDataClass.getAllProducts();
SQLDataClass.getAllCart();
DisableText();
}