private void btnSaveNew_Click(object sender, EventArgs e)
{
PersonalContact personalContact = new PersonalContact();
personalContact.contactFname = tbFname.Text;
personalContact.contactLname = tbLname.Text;
personalContact.contactTel = tbTel.Text;
personalContact.contactEmail = tbEmail.Text;
personalContact.contactAddr1 = tbAddr1.Text;
personalContact.contactAddr2 = tbAddr2.Text;
personalContact.contactCity = tbCity.Text;
personalContact.contactPostcode = tbPost.Text;
personalContact.contactHomeTel = tbPTel.Text;
dbConn.InsertPersonal(personalContact);
tbFname.Enabled = false;
tbLname.Enabled = false;
tbTel.Enabled = false;
tbEmail.Enabled = false;
tbAddr1.Enabled = false;
tbAddr2.Enabled = false;
tbCity.Enabled = false;
tbPost.Enabled = false;
tbPTel.Enabled = false;
btnDelete.Enabled = true;
btnUpdate.Enabled = true;
btnSaveNew.Enabled = false;
dGVPersonalRecords.DataSource = dbConn.GetAllPersonal();
}
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.contactTel = tbTel.Text;
personalContact.contactEmail = tbEmail.Text;
personalContact.contactAddr1 = tbAddr1.Text;
personalContact.contactAddr2 = tbAddr2.Text;
personalContact.contactCity = tbCity.Text;
personalContact.contactPostcode = tbPost.Text;
personalContact.contactHomeTel = tbPTel.Text;
dbConn.UpdatePersonal(personalContact);
dGVPersonalRecords.DataSource = dbConn.GetAllPersonal();
tbFname.Enabled = false;
tbLname.Enabled = false;
tbTel.Enabled = false;
tbEmail.Enabled = false;
tbAddr1.Enabled = false;
tbAddr2.Enabled = false;
tbCity.Enabled = false;
tbPost.Enabled = false;
tbPTel.Enabled = false;
btnDelete.Enabled = true;
btnUpdate.Enabled = true;
btnSave.Enabled = false;
}
public async void InsertPersonal(PersonalContact personalContact)//another one
{
using (var conn = new MySqlConnection(connString))
{
await conn.OpenAsync();//asyncronous code for better performance
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn; //opens connection
cmd.CommandText = "CALL INSERTPersonal(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9);"; //uses the stored procedure
cmd.Parameters.AddWithValue("p1", personalContact.contactFname); //explains assignment od information
cmd.Parameters.AddWithValue("p2", personalContact.contactLname);
cmd.Parameters.AddWithValue("p3", personalContact.contactTel);
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.contactHomeTel);
await cmd.ExecuteNonQueryAsync();//makes the query run
}
}
}
public async void UpdatePersonal(PersonalContact personalContact)//update a record
{
using (var conn = new MySqlConnection(connString))
{
await conn.OpenAsync();
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "CALL updatePersonal(@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9);";
cmd.Parameters.AddWithValue("p0", personalContact.ContactID);
cmd.Parameters.AddWithValue("p1", personalContact.contactFname);
cmd.Parameters.AddWithValue("p2", personalContact.contactLname);
cmd.Parameters.AddWithValue("p3", personalContact.contactTel);
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.contactHomeTel);
await cmd.ExecuteNonQueryAsync();
}
}
}
