protected void btnUpdate_Click(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["ID"]);
DataRow record = dsInventory.Inventory.FindByid(id);
// Find the related Record and fill the fields in the page with the data
try
{
record[1] = txtQuantity.Text;
record[2] = txtSize.Text;
record[5] = ddlProducts.SelectedValue;
record[3] = ddlMeasures.SelectedValue;
record[4] = txtPrice.Text;
daInventory.Update(record);
// Call update method on the service adapter so it updates the table in memory ( All changes made are applied - CRUD)
dsInventory.AcceptChanges();
Response.Redirect("Default.aspx");
}
catch (Exception ex)
{
lblMessage.Text = "Failed to update";
lblMessage.Visible = true;
}
}
protected void btnAddItem_Click(object sender, EventArgs e)
{
try
{
DataRow Inventorydata = dsInventory.Product.NewRow(); // Create a new row of service_order table in memory
//update record with user's input
Inventorydata[1] = this.txtProduct.Text;
Inventorydata[3] = this.ddlBrand.SelectedValue;
Inventorydata[2] = this.txtDescription.Text;
ProductTableAdapter ProductTable = new ProductTableAdapter();
dsInventory.Product.Rows.Add(Inventorydata); // add the rows to the dataset
ProductTable.Update(Inventorydata);
// Call update method on the service adapter so it updates the table in memory ( All changes made are applied - CRUD)
dsInventory.AcceptChanges();
// Call accept method on the dataset so it update the chanmges to the database
lblMessage.Text = "Created 1";
//Refresh the page to show the record being deleted
Response.Redirect("Default.aspx"); // Redirect the user to dexpage on to show created data
lblMessage.Text = "Created";
}
catch
{
lblMessage.Text = "Failed";
}
}
protected void btnDeleteConfirm_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["ID"]);
try
{
DataRow record = dsInventory.Inventory.FindByid(id); // Find the requested record
record.Delete(); // Deletes the record in memory\
daInventory.Update(record); // Call update method on the Repair adapter so it updates the table in memory ( All changes made are applied - CRUD)
dsInventory.AcceptChanges(); // Call accept method on the dataset so it update the chanmges to the database
Response.Redirect("/Inventory");
}
catch (Exception ex)
{
lblMessage.Text = "Failed: " + ex.Message;
}
}
