private void btnAddStock_Click(object sender, EventArgs e)
{
Boolean valid = Validation.ValidateAdd(txtStockName.Text);
if (valid == false)
{
txtStockName.Focus();
MessageBox.Show("Incorrect Name");
}
Boolean validDesc = Validation.ValidateAdd(txtDescription.Text);
if (validDesc == false)
{
txtDescription.Focus();
MessageBox.Show("Invalid characters used during description");
}
Boolean validSupplier = Validation.ValidateId(txtSupplier.Text);
if (validSupplier == false)
{
txtSupplier.Focus();
}
if (valid && validDesc && validSupplier)
{
int StockId = Convert.ToInt16(Stock.getNextStockId());
string name = txtStockName.Text;
string description = txtDescription.Text;
int amount = Convert.ToInt16(txtAmount.Text);
float quantity = float.Parse(txtPrice.Text);
int supplier = Convert.ToInt16(txtSupplier.Text);
string status = "A";
Stock newStock = new Stock(StockId, name, description, amount, quantity, supplier, status);
newStock.AddStock();
MessageBox.Show("You have added a new item of Stock");
txtStockId.Clear();
txtStockName.Clear();
txtDescription.Clear();
txtSupplier.Clear();
txtAmount.Value = 0;
txtPrice.Value = 0;
txtStockId.Text = Stock.getNextStockId().ToString("00000");
txtStockName.Focus();
}
}
private void btnUpdateStock_Click(object sender, EventArgs e)
{
Boolean valid = Validation.ValidateAdd(txtStockName.Text);
if (valid == false)
{
txtStockName.Focus();
MessageBox.Show("Incorrect Name");
}
Boolean validDesc = Validation.ValidateAdd(txtDescription.Text);
if (validDesc == false)
{
txtDescription.Focus();
MessageBox.Show("Invalid characters used during description");
}
Boolean validSupplier = Validation.ValidateId(txtSupplier.Text);
if (validSupplier == false)
{
txtSupplier.Focus();
}
if (valid && validDesc && validSupplier)
{
int StockId = Convert.ToInt16(txtStockId.Text);
string name = txtStockName.Text;
string description = txtDescription.Text;
int amount = Convert.ToInt16(txtAmount.Text);
float price = float.Parse(txtPrice.Text);
int supplier = Convert.ToInt16(txtSupplier.Text);
//connect to the db
OracleConnection connect = new OracleConnection(DBConnect.oradb);
//define Sql Command
String strSQL = "UPDATE Stock SET StockName = '" + name + "',Description = '" + description + "',Amount = " + amount + ", Price = " + price + ", SupplierId = " + supplier + ", Status = 'A' where StockId = " + StockId;
//Execute Query
OracleCommand cmd = new OracleCommand(strSQL, connect);
connect.Open();
cmd.ExecuteNonQuery();
//Close Db
connect.Close();
MessageBox.Show("The Stock details have been updated and saved in the stock file");
txtSearch.Clear();
txtStockId.Clear();
txtStockName.Clear();
txtDescription.Clear();
txtAmount.Clear();
txtPrice.Clear();
txtSupplier.Clear();
grdData.DataSource = null;
}
}
