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(); }