protected void btnNew_Click(object sender, EventArgs e)
{
if (btnNew.Text.Equals("New"))
{
EnableDisableButtons();
btnNew.Text = "Save New";
btnDelete.Text = "Cancel";
txtDesc.Text = "";
txtID.Text = "";
txtName.Text = "";
txtPrice.Text = "";
}
else
{
try
{
if (SQLDataClass.AddProduct(txtID.Text, txtName.Text, Convert.ToInt32(txtPrice.Text), txtDesc.Text))
{
txtMsg.Text = "Product added";
btnNew.Text = "New";
EnableDisableButtons();
//btnLast_Click(sender, e);
SQLDataClass.getAllProducts();
}
else
{
txtMsg.Text = "ProductID already exists";
}
}
catch (Exception ex)
{
txtMsg.Text = ex.Message;
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (btnDelete.Text.Equals("Delete"))
{
bool delete = false;
for (int i = 0; i < dontDelete.Length; i++)
{
if (txtID.Text.Equals(dontDelete[i]))
{
delete = true;
}
}
if (!delete)
{
SQLDataClass.DeleteProduct(txtID.Text);
txtMsg.Text = "Record deleted.";
}
else
{
txtMsg.Text = "This record can't be deleted.";
}
}
else
{
btnDelete.Text = "Delete";
btnNew.Text = "New";
DisplayRow((int)Session["Prog3_Index"]);
EnableDisableButtons();
}
}
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 = txtDesc.Text;
SQLDataClass.UpdateProduct(theID, newName, newPrice, newDesc);
txtMsg.Text = "Record updated.";
SQLDataClass.getAllProducts();
}
catch (Exception ex)
{
txtMsg.Text = "Product Not Updated: " + ex.Message;
}
}
protected void txtChange(object sender, EventArgs e)
{
if (SQLDataClass.checkID(txtID.Text))
{
for (int i = 0; i < SQLDataClass.tblProduct.Rows.Count; i++)
{
System.Data.DataRow row = SQLDataClass.tblProduct.Rows[i];
String temp1 = row[0].ToString();
String temp2 = row[1].ToString();
String temp3 = row[2].ToString();
if (txtID.Text.Trim().Equals(row[0].ToString().Trim()))
{
txtID.Text = row[0].ToString();
txtName.Text = row[1].ToString();
txtPrice.Text = row[2].ToString();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SQLDataClass.getAllProducts();
ProductGrid.DataSource = SQLDataClass.tblProduct;
ProductGrid.DataBind();
}
void Application_Start(object sender, EventArgs e)
{
SQLDataClass.setupProdAdapter();
}
