protected void btnAdd_Click(object sender, EventArgs e)
{
if (IsValid)
{
SqlProducts.InsertParameters["SKU"].DefaultValue =
txtSkuNum.Text;
SqlProducts.InsertParameters["Item_Description"].DefaultValue =
txtItemDesc.Text;
SqlProducts.InsertParameters["Item_Price"].DefaultValue =
txtItemPrice.Text;
//SqlProducts.InsertParameters["Cat_Num"].DefaultValue =
// txtCatNum.Text;
try
{
SqlProducts.Insert();
txtSkuNum.Text = "";
// txtCatNum.Text = "";
txtItemDesc.Text = "";
txtItemPrice.Text = "";
}
catch (Exception ex)
{
lblErrorMessage.Text = DatabaseErrorMessage(ex.Message);
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Control mainContent = Form.FindControl("mainContent");
IEnumerable <TextBox> NewProductInsertForm = mainContent.Controls.OfType <TextBox>();
if (IsValid)
{
foreach (Parameter param in SqlProducts.InsertParameters)
{
foreach (TextBox input in NewProductInsertForm)
{
if (input.ID == $"txt{param.Name}")
{
param.DefaultValue = input.Text;
}
}
}
try
{
SqlProducts.Insert();
foreach (TextBox input in NewProductInsertForm)
{
if (input.ID != txtReleaseDate.ID)
{
input.Text = "";
}
}
txtReleaseDate.Text = "mm/dd/yyyy";
lblErrorMessage.Text = "Product was added successfully";
}
catch (Exception ex)
{
lblErrorMessage.Text = DatabaseErrorMessage(ex.Message);
}
}
}
protected void btnInsertProduct_Click(object sender, EventArgs e)
{
SqlProducts.Insert();
GridView1.DataBind();
}
