// This method calls the UpdatePersonal() method from DbConn class updating values to the table //
private void btnSave_Click(object sender, EventArgs e)
{
int index = Int32.Parse(dGVPersonalRecords.SelectedCells[0].Value.ToString());
PersonalContact personalContact = new PersonalContact();
personalContact.ContactID = index;
personalContact.ContactFname = tbFname.Text;
personalContact.ContactLname = tbLname.Text;
personalContact.ContactEmail = tbEmail.Text;
personalContact.ContactAddr1 = tbAddress1.Text;
personalContact.ContactAddr2 = tbAddress2.Text;
personalContact.ContactCity = tbCity.Text;
personalContact.ContactPostCode = tbPostCode.Text;
personalContact.PersonalTel = tbTelNumber.Text;
// UpdatePersonal method called from DbConn class with the parameter businessContact //
dbConn.UpdatePersonal(personalContact);
// repopulate datagridview by calling the GetAllPersonal() method from DbConn
dGVPersonalRecords.DataSource = dbConn.GetAllPersonal();
//text boxes disabled //
tbFname.Enabled = false;
tbLname.Enabled = false;
tbEmail.Enabled = false;
tbAddress1.Enabled = false;
tbAddress2.Enabled = false;
tbCity.Enabled = false;
tbPostCode.Enabled = false;
tbTelNumber.Enabled = false;
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
btnAddNew.Enabled = true;
btnSave.Enabled = false;
}
// This method calls the insertPersonal() store procedure using the personalContact object
// as parameter for the method and its values from each field
public async void InsertPersonal(PersonalContact personalContact)
{
using (var conn = new MySqlConnection(connString))
{
await conn.OpenAsync();
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "CALL insertPersonal(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8);";
cmd.Parameters.AddWithValue("p1", personalContact.ContactFname);
cmd.Parameters.AddWithValue("p2", personalContact.ContactLname);
cmd.Parameters.AddWithValue("p3", personalContact.ContactEmail);
cmd.Parameters.AddWithValue("p4", personalContact.ContactAddr1);
cmd.Parameters.AddWithValue("p5", personalContact.ContactAddr2);
cmd.Parameters.AddWithValue("p6", personalContact.ContactCity);
cmd.Parameters.AddWithValue("p7", personalContact.ContactPostCode);
cmd.Parameters.AddWithValue("p8", personalContact.PersonalTel);
await cmd.ExecuteNonQueryAsync();
}
}
}
// This method calls the InsertPersonal() method from DbConn class adding new values to the table //
private void btnSaveNew_Click(object sender, EventArgs e)
{
// personalContact object of the class PersonalContact to populate the class fields //
PersonalContact personalContact = new PersonalContact();
personalContact.ContactFname = tbFname.Text;
personalContact.ContactLname = tbLname.Text;
personalContact.ContactEmail = tbEmail.Text;
personalContact.ContactAddr1 = tbAddress1.Text;
personalContact.ContactAddr2 = tbAddress2.Text;
personalContact.ContactCity = tbCity.Text;
personalContact.ContactPostCode = tbPostCode.Text;
personalContact.PersonalTel = tbTelNumber.Text;
// InsertPersonal() method called with the populated fields from BusinessContact clas
dbConn.InsertPersonal(personalContact);
// datagridview repopulated with the new data from SQL table //
dGVPersonalRecords.DataSource = dbConn.GetAllPersonal();
tbFname.Enabled = false;
tbLname.Enabled = false;
tbEmail.Enabled = false;
tbAddress1.Enabled = false;
tbAddress2.Enabled = false;
tbCity.Enabled = false;
tbPostCode.Enabled = false;
tbTelNumber.Enabled = false;
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
btnSaveNew.Enabled = false;
tbFname.Text = String.Empty;
tbLname.Text = String.Empty;
tbEmail.Text = String.Empty;
tbAddress1.Text = String.Empty;
tbAddress2.Text = String.Empty;
tbCity.Text = String.Empty;
tbPostCode.Text = String.Empty;
tbTelNumber.Text = String.Empty;
}
