private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult = MessageBox.Show("DO YOU WANT UPDATE STOCK?", "STOCK UPDATION", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
if (tbEditAddStock.Value == 0 || tbEditFinalStock.Text == "" || tbEditItemName.Text == "" || tbEditItemCategory.Text == "" || tbEditItemStock.Text == "" || tbEditItemDescription.Text == "" || tbEditItemNumber.Text == "")
{
MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO EDIT DATA", "DATA UPDATE ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbEditAddStock.Focus();
}
else
{
string InventoryNumber = tbEditItemNumber.Text;
string InventoryName = tbEditItemName.Text;
string InventoryDescription = tbEditItemDescription.Text;
string InventoryCategory = tbEditItemCategory.Text;
string ItemStock = tbEditFinalStock.Text;
Admin Update = new Admin();
Update.UpdateStock(InventoryNumber, InventoryName, InventoryDescription, InventoryCategory, ItemStock);
MessageBox.Show("STOCK UPDATED", "ITEM STOCK UPDATED", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbEditAddStock.Value = 0;
tbEditItemNumber.Clear();
tbEditItemName.Clear();
tbEditItemDescription.Clear();
tbEditItemCategory.Clear();
tbEditFinalStock.Clear();
tbEditItemStock.Clear();
RefreshDG();
}
}
}
catch (SqlException)
{
MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (InvalidOperationException)
{
MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}