private void btnSaveNew_Click(object sender, EventArgs e)
{
BusinessContact businessContact = new BusinessContact();
businessContact.ContactFname = tbFname.Text;
businessContact.ContactLname = tbLname.Text;
businessContact.ContactEmail = tbEmail.Text;
businessContact.ContactAddr1 = tbAddr1.Text;
businessContact.ContactAddr2 = tbAddr2.Text;
businessContact.ContactCity = tbCity.Text;
businessContact.ContactPostcode = tbPostcode.Text;
businessContact.BusinessTel = tbBusinessTel.Text;
dbConn.InsertBusiness(businessContact); // INSERT PERSONAL TAKES PERSONAL CONTACT AS A PERIMETER
tbFname.Enabled = false; // changed true to false
tbLname.Enabled = false; // changed true to false
tbEmail.Enabled = false; // changed true to false
tbAddr1.Enabled = false; // changed true to false
tbAddr2.Enabled = false; // changed true to false;
tbCity.Enabled = false; // changed true to false
tbPostcode.Enabled = false; // changed true to false
tbBusinessTel.Enabled = false; // changed true to false
btnUpdate.Enabled = true; // changed false to true
btnDelete.Enabled = true; // changed FALSE to TRUE
btnSaveNew.Enabled = false; // changed true to false
dGVBusinessRecords.DataSource = dbConn.GetAllBusiness();
}
private void btnSave_Click(object sender, EventArgs e)
{
int index = Int32.Parse(dGVBusinessRecords.SelectedCells[0].Value.ToString()); // auto-generated
BusinessContact businessContact = new BusinessContact(); // call the business class for data stored
businessContact.ContactID = index; // contact id is auto-generated
businessContact.ContactFname = tbFname.Text;
businessContact.ContactLname = tbLname.Text;
businessContact.ContactEmail = tbEmail.Text;
businessContact.ContactAddr1 = tbAddr2.Text;
businessContact.ContactAddr2 = tbAddr2.Text;
businessContact.ContactCity = tbCity.Text;
businessContact.ContactPostcode = tbPostcode.Text;
businessContact.BusinessTel = tbBusinessTel.Text;
dbConn.UpdateBusiness(businessContact); // call dbconn connection for updating the business in table
dGVBusinessRecords.DataSource = dbConn.GetAllBusiness(); // call get all business from stored procedure in heidi SQL
tbFname.Enabled = false;
tbLname.Enabled = false;
tbEmail.Enabled = false;
tbAddr1.Enabled = false;
tbAddr2.Enabled = false;
tbCity.Enabled = false;
tbPostcode.Enabled = false;
tbBusinessTel.Enabled = false;
btnUpdate.Enabled = true; // enable button
btnDelete.Enabled = true; // enable button
btnAddNew.Enabled = true; // enable button
btnSave.Enabled = false; // disabled
}
public async void InsertBusiness(BusinessContact businessContact)
{
using (var conn = new MySqlConnection(connString)) // INSERT Business TAKES PERSONAL CONTACT AS A PERIMETER
{
await conn.OpenAsync();
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "CALL insertBusiness(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8);";
cmd.Parameters.AddWithValue("p1", businessContact.ContactFname);
cmd.Parameters.AddWithValue("p2", businessContact.ContactLname);
cmd.Parameters.AddWithValue("p3", businessContact.ContactEmail);
cmd.Parameters.AddWithValue("p4", businessContact.ContactAddr1);
cmd.Parameters.AddWithValue("p5", businessContact.ContactAddr2);
cmd.Parameters.AddWithValue("p6", businessContact.ContactCity);
cmd.Parameters.AddWithValue("p7", businessContact.ContactPostcode);
cmd.Parameters.AddWithValue("p8", businessContact.BusinessTel);
await cmd.ExecuteNonQueryAsync();
}
}
}
public async void UpdateBusiness(BusinessContact businessContact)
{
using (var conn = new MySqlConnection(connString))
{
await conn.OpenAsync();
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "CALL updateBusiness(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9);";
cmd.Parameters.AddWithValue("p1", businessContact.ContactID);
cmd.Parameters.AddWithValue("p2", businessContact.ContactFname);
cmd.Parameters.AddWithValue("p3", businessContact.ContactLname);
cmd.Parameters.AddWithValue("p4", businessContact.ContactEmail);
cmd.Parameters.AddWithValue("p5", businessContact.ContactAddr1);
cmd.Parameters.AddWithValue("p6", businessContact.ContactAddr2);
cmd.Parameters.AddWithValue("p7", businessContact.ContactCity);
cmd.Parameters.AddWithValue("p8", businessContact.ContactPostcode);
cmd.Parameters.AddWithValue("p9", businessContact.BusinessTel);
await cmd.ExecuteNonQueryAsync();
}
}
}
