protected void btnNew_Click(object sender, EventArgs e)
{
if (btnNew.Text.Equals("Save New"))
{
try
{
string theID = txtID.Text;
string newName = txtName.Text;
double newPrice = double.Parse(txtPrice.Text.Replace("$", ""));
string newDesc = txtDescription.Text;
SQLDataClass.InsertProduct(theID, newName, newPrice, newDesc);
txtMessage.Text = "Record updated.";
SQLDataClass.getAllProducts();
}
catch (Exception ex)
{
txtMessage.Text = "Product Not Inserted: " + ex.Message;
}
}
else if (btnNew.Text.Equals("New"))
{
txtDescription.Text = "";
txtID.Text = "";
txtName.Text = "";
txtPrice.Text = "";
btnUpdate.Enabled = false;
btnFirst.Enabled = false;
btnLast.Enabled = false;
btnNext.Enabled = false;
btnPrevious.Enabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SQLDataClass.getAllProducts();
TextArea1.InnerText = "";
if (!IsPostBack)
{
DisplayRow((int)Session["Prog3_Index"]);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string theID = txtID.Text;
string newName = txtName.Text;
double newPrice = double.Parse(txtPrice.Text.Replace("$", ""));
string newDesc = txtDescription.Text;
SQLDataClass.UpdateProduct(theID, newName, newPrice, newDesc);
txtMessage.Text = "Record updated.";
SQLDataClass.getAllProducts();
}
catch (Exception ex)
{
txtMessage.Text = "Product Not Updated: " + ex.Message;
}
}
protected void Button5_Click(object sender, EventArgs e)
{
try
{
string theID = TextBox1.Text;
string newName = TextBox2.Text;
double newPrice = double.Parse(TextBox3.Text.Replace("$", ""));
string newDesc = TextBox4.Text;
SQLDataClass.UpdateProduct(theID, newName, newPrice, newDesc);
TextArea1.InnerText = "Record Updated";
SQLDataClass.getAllProducts();
}
catch (Exception ex)
{
TextArea1.InnerText = "Product Not Updated:" + ex.Message;
}
}
protected void Button7_Click(object sender, EventArgs e)
{
if (Button7.Text.Equals("Save New"))
{
try
{
string theID = TextBox1.Text;
string newName = TextBox2.Text;
double newPrice = double.Parse(TextBox3.Text.Replace("$", ""));
string newDesc = TextBox4.Text;
SQLDataClass.AddProduct(theID, newName, newPrice, newDesc);
TextArea1.InnerText = "Record Added";
SQLDataClass.getAllProducts();
ResetButtons();
}
catch (Exception ex)
{
TextArea1.InnerText = "Product Not added:" + ex.Message;
}
}
else
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
Button1.Enabled = false;
Button2.Enabled = false;
Button3.Enabled = false;
Button4.Enabled = false;
Button5.Enabled = false;
Button6.Text = "Cancel";
Button7.Text = "Save New";
}
}
protected void Page_Load(object sender, EventArgs e)
{
SQLDataClass.getAllProducts();
//dtlProduct.DataSource = SQLDataClass.tblProduct;
//dtlProduct.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
SQLDataClass.getAllProducts();
DisableText();
}