private void btnSaveNew_Click_1(object sender, EventArgs e) // populate the save new button and text box to be passed to enable data creation
{
PersonalContact personalContact = new PersonalContact();
personalContact.ContactFname = tbFname.Text;
personalContact.ContactLname = tbLname.Text;
personalContact.ContactEmail = tbEmail.Text;
personalContact.ContactAddr1 = tbAddr1.Text;
personalContact.ContactAddr2 = tbAddr2.Text;
personalContact.ContactCity = tbCity.Text;
personalContact.ContactPostcode = tbPostcode.Text;
personalContact.PersonalTel = tbTel.Text;
dbConn.InsertPersonal(personalContact); // 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
tbTel.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
dGVPersonalRecords.DataSource = dbConn.GetAllPersonal(); // Passed objects and enable them in the database
}
public async void UpdatePersonal(PersonalContact personalContact) // added async method for multi threading
// duplicate of insert personal but changed codes to update version.
{
using (var conn = new MySqlConnection(connString))
{
await conn.OpenAsync(); // openness connection to asyn
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "CALL updatePersonal(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9);"; // call stored procedure
cmd.Parameters.AddWithValue("p1", personalContact.ContactID);
cmd.Parameters.AddWithValue("p2", personalContact.ContactFname);
cmd.Parameters.AddWithValue("p3", personalContact.ContactLname);
cmd.Parameters.AddWithValue("p4", personalContact.ContactEmail);
cmd.Parameters.AddWithValue("p5", personalContact.ContactAddr1);
cmd.Parameters.AddWithValue("p6", personalContact.ContactAddr2);
cmd.Parameters.AddWithValue("p7", personalContact.ContactCity);
cmd.Parameters.AddWithValue("p8", personalContact.ContactPostcode);
cmd.Parameters.AddWithValue("p9", personalContact.PersonalTel);
await cmd.ExecuteNonQueryAsync(); // statement accomplished
}
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
int index = Int32.Parse(dGVPersonalRecords.SelectedCells[0].Value.ToString()); // get index of current selected for contact ID
PersonalContact personalContact = new PersonalContact();
personalContact.ContactID = index;
personalContact.ContactFname = tbFname.Text;
personalContact.ContactLname = tbLname.Text;
personalContact.ContactEmail = tbEmail.Text;
personalContact.ContactAddr1 = tbAddr2.Text;
personalContact.ContactAddr2 = tbAddr2.Text;
personalContact.ContactCity = tbCity.Text;
personalContact.ContactPostcode = tbPostcode.Text;
personalContact.PersonalTel = tbTel.Text;
dbConn.UpdatePersonal(personalContact);
dGVPersonalRecords.DataSource = dbConn.GetAllPersonal(); // refreshing the data when insert any record
tbFname.Enabled = false;
tbLname.Enabled = false;
tbEmail.Enabled = false;
tbAddr1.Enabled = false;
tbAddr2.Enabled = false;
tbCity.Enabled = false;
tbPostcode.Enabled = false;
tbTel.Enabled = false;
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
btnAddNew.Enabled = true;
btnSave.Enabled = false;
}
public async void InsertPersonal(PersonalContact personalContact) // Inolve asynchronise method
{
using (var conn = new MySqlConnection(connString)) // INSERT PERSONAL TAKES PERSONAL CONTACT AS A PERIMETER And enable connection
{
await conn.OpenAsync(); // openness connection to asyn
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "CALL insertPersonal(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8);"; // call stored procedure in heidi
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(); // await command shows parameters are passed and query will be awaited to complete
}
}
}