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 btnAddSupplier_Click(object sender, EventArgs e)
{
Boolean validName = Validation.ValidateName(txtSupplierName.Text);
if (validName == false)
{
txtSupplierName.Clear();
txtSupplierName.Focus();
MessageBox.Show("Incorrect Name format");
}
Boolean validAdd1 = Validation.ValidateAdd(txtAddressLine1.Text);
if (validAdd1 == false)
{
txtAddressLine1.Clear();
txtAddressLine1.Focus();
MessageBox.Show("Incorrect Address Line 1");
}
Boolean validAdd2 = Validation.ValidateAdd(txtAddressLine2.Text);
if (validAdd2 == false)
{
txtAddressLine2.Clear();
txtAddressLine2.Focus();
MessageBox.Show("Incorrect Address Line 2");
}
Boolean validTown = Validation.ValidateTown(txtTown.Text);
if (validTown == false)
{
txtTown.Focus();
MessageBox.Show("Incorrect Town");
}
Boolean validCounty = Validation.ValidateCounty(txtCounty.Text);
if (validCounty == false)
{
txtCounty.Focus();
MessageBox.Show("Incorrect County");
}
Boolean validPhone = Validation.ValidatePhone(txtPhone.Text);
if (validPhone == false)
{
txtPhone.Clear();
txtPhone.Focus();
MessageBox.Show("Incorrect Phone format");
}
Boolean validEmail = Validation.ValidateEmail(txtEmail.Text);
if (validEmail == false)
{
txtEmail.Focus();
MessageBox.Show("Incorrect Email address");
}
if (validName && validAdd1 && validAdd2 && validTown && validCounty && validPhone && validEmail)
{
int supplierId = Convert.ToInt16(Supplier.getNextSupplierId());
string name = txtSupplierName.Text.ToUpper();
string add1 = txtAddressLine1.Text;
string add2 = txtAddressLine2.Text;
string town = txtTown.Text;
string county = txtCounty.Text;
string email = txtEmail.Text;
string phone = txtPhone.Text;
string status = "A";
float balance = 0;
Supplier newSupplier = new Supplier(supplierId, name, add1, add2, town, county, email, phone, status, balance);
newSupplier.AddSupplier();
MessageBox.Show("You have added a new Supplier");
txtSupplierName.Clear();
txtAddressLine1.Clear();
txtAddressLine2.Clear();
txtTown.Clear();
txtCounty.Clear();
txtEmail.Clear();
txtPhone.Clear();
txtSupplierId.Text = Supplier.getNextSupplierId().ToString("00000");
txtSupplierName.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;
}
}
private void btnUpdateSupplier_Click(object sender, EventArgs e)
{
Boolean validName = Validation.ValidateName(txtSupplierName.Text);
if (validName == false)
{
txtSupplierName.Clear();
txtSupplierName.Focus();
MessageBox.Show("Incorrect Name format");
}
Boolean validAdd1 = Validation.ValidateAdd(txtAddressLine1.Text);
if (validAdd1 == false)
{
txtAddressLine1.Clear();
txtAddressLine1.Focus();
MessageBox.Show("Incorrect Address Line 1");
}
Boolean validAdd2 = Validation.ValidateAdd(txtAddressLine2.Text);
if (validAdd2 == false)
{
txtAddressLine2.Clear();
txtAddressLine2.Focus();
MessageBox.Show("Incorrect Address Line 2");
}
Boolean validTown = Validation.ValidateTown(txtTown.Text);
if (validTown == false)
{
txtTown.Focus();
MessageBox.Show("Incorrect Town");
}
Boolean validCounty = Validation.ValidateCounty(txtCounty.Text);
if (validCounty == false)
{
txtCounty.Focus();
MessageBox.Show("Incorrect County");
}
Boolean validPhone = Validation.ValidatePhone(txtPhone.Text);
if (validPhone == false)
{
txtPhone.Clear();
txtPhone.Focus();
MessageBox.Show("Incorrect Phone format");
}
Boolean validEmail = Validation.ValidateEmail(txtEmail.Text);
if (validEmail == false)
{
txtEmail.Focus();
MessageBox.Show("Incorrect Email address");
}
if (validName && validAdd1 && validAdd2 && validTown && validCounty && validPhone && validEmail)
{
int supplierId = Convert.ToInt16(txtSupplierId.Text);
string name = txtSupplierName.Text;
string add1 = txtAddressLine1.Text;
string add2 = txtAddressLine2.Text;
string town = txtTown.Text;
string county = txtCounty.Text;
string email = txtEmail.Text;
string phone = txtPhone.Text;
//connect to the db
OracleConnection connect = new OracleConnection(DBConnect.oradb);
//define Sql Command
String strSQL = "UPDATE Supplier SET SupplierName = '" + name + "',AddressLine1 = '" + add1 + "',AddressLine2 = '" + add2 + "', Town = '" + town + "', County = +'" + county + "', Email = '" + email + "', Phone = '" + phone + "', Status = 'A' where SupplierId = " + supplierId;
//Execute Query
OracleCommand cmd = new OracleCommand(strSQL, connect);
connect.Open();
cmd.ExecuteNonQuery();
//Close Db
connect.Close();
MessageBox.Show(name + " has been updated");
txtSearch.Clear();
txtSupplierId.Clear();
txtSupplierName.Clear();
txtAddressLine1.Clear();
txtAddressLine2.Clear();
txtTown.Clear();
txtCounty.Clear();
txtEmail.Clear();
txtPhone.Clear();
txtSearch.Focus();
grdData.DataSource = null;
}
}