protected void btnAddCategory_Click(object sender, EventArgs e)
{
try
{
query = "insert into productcategory (productCategoryName) values (@productCategoryName)";
cmd = new MySqlCommand();
cmd.Parameters.Add("@productCategoryName", MySqlDbType.VarChar, 45).Value = txtCategory.Text.Trim();
if (cf.ExecuteSQLWithparameter(query, cmd.Parameters) == "OK")
{
clearData();
}
}
catch
{
}
}
protected void btnAddProduct_Click(object sender, EventArgs e)
{
try
{
query = "insert into product (productName, productDescription, price, productCategoryID) values (@productName, @productDescription, @price, @productCategoryID)";
cmd = new MySqlCommand();
cmd.Parameters.Add("@productName", MySqlDbType.VarChar, 45).Value = txtProductName.Text.Trim();
cmd.Parameters.Add("@productDescription", MySqlDbType.VarChar, 45).Value = txtDescription.Text.Trim();
cmd.Parameters.Add("@price", MySqlDbType.Double).Value = txtPrice.Text.Trim();
cmd.Parameters.Add("@productCategoryID", MySqlDbType.Int32).Value = int.Parse(ddlCategory.SelectedValue.ToString());
if (cf.ExecuteSQLWithparameter(query, cmd.Parameters) == "OK")
{
clearData();
}
}
catch
{
}
}
