private void btnSaveNew_Click(object sender, EventArgs e)
{
BusinessContact businessContact = new BusinessContact();//creates a new instance of Business Contacts
//insert records present in text boxes into BusinessContact table in the database
businessContact.ContactFname = tbFname.Text;
businessContact.ContactLname = tbLname.Text;
businessContact.ContactEmail = tbEmail.Text;
businessContact.BusinessTel = tbBusTel.Text;
businessContact.ContactAddr1 = tbAddress1.Text;
businessContact.ContactAddr2 = tbAddress2.Text;
businessContact.ContactCity = tbCity.Text;
businessContact.ContactPostcode = tbPostcode.Text;
dbConn.InsertBusiness(businessContact);//inserts business Contacts to the record
//accessiblity of text boxes when save new is clicked
tbFname.Enabled = false;
tbLname.Enabled = false;
tbEmail.Enabled = false;
tbBusTel.Enabled = false;
tbAddress1.Enabled = false;
tbAddress2.Enabled = false;
tbCity.Enabled = false;
tbPostcode.Enabled = false;
//accessiblity of buttons when SaveNew is clicked
btnUpdate.Enabled = true; //enable update button
btnDelete.Enabled = true; //enable delete button
btnSaveNew.Enabled = false; //disable save new button
}
//UPDATE BUSINESS RECORDS
private void btnSave_Click(object sender, EventArgs e)
{
int index = Int32.Parse(dGVBusinessRecords.SelectedCells[0].Value.ToString());
BusinessContact businessContact = new BusinessContact();//creates new busines contact instance
//populate businesscontact through records in the text box
businessContact.ContactID = index;
businessContact.ContactFname = tbFname.Text;
businessContact.ContactLname = tbLname.Text;
businessContact.ContactEmail = tbEmail.Text;
businessContact.BusinessTel = tbBusTel.Text;
businessContact.ContactAddr1 = tbAddress1.Text;
businessContact.ContactAddr2 = tbAddress2.Text;
businessContact.ContactCity = tbCity.Text;
businessContact.ContactPostcode = tbPostcode.Text;
dbConn.UpdateBusinessContact(businessContact); //updates business contact in the database with new populated instace
dGVBusinessRecords.DataSource = dbConn.GetAllBusiness(); //gets BusinessRecords from database into the datagridview
//Accessiblity of textboxes when save button is clicked
tbFname.Enabled = false;
tbLname.Enabled = false;
tbEmail.Enabled = false;
tbBusTel.Enabled = false;
tbAddress1.Enabled = false;
tbAddress2.Enabled = false;
tbCity.Enabled = false;
tbPostcode.Enabled = false;
//Accessiblity of buttons when Save button is clicked
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
btnAddNew.Enabled = true;
btnSave.Enabled = false;
}
public async void InsertBusiness(BusinessContact businessContact) //INSERT BUSINESS CONTACT
{
using (var conn = new MySqlConnection(connString)) //accessing private class with connString
{
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);//inserting the value for ContactFname from business contacts in parameter 1
cmd.Parameters.AddWithValue("p2", businessContact.ContactLname);
cmd.Parameters.AddWithValue("p3", businessContact.ContactEmail);
cmd.Parameters.AddWithValue("p4", businessContact.BusinessTel);
cmd.Parameters.AddWithValue("p5", businessContact.ContactAddr1);
cmd.Parameters.AddWithValue("p6", businessContact.ContactAddr2);
cmd.Parameters.AddWithValue("p7", businessContact.ContactCity);
cmd.Parameters.AddWithValue("p8", businessContact.ContactPostcode);
await cmd.ExecuteNonQueryAsync();
}
}
}
public async void UpdateBusinessContact(BusinessContact businessContact) //UPDATE BUSINESS CONTACT
{
using (var conn = new MySqlConnection(connString)) //accessing private class with 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);";//update parameter through contact ID
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.BusinessTel);
cmd.Parameters.AddWithValue("p6", businessContact.ContactAddr1);
cmd.Parameters.AddWithValue("p7", businessContact.ContactAddr2);
cmd.Parameters.AddWithValue("p8", businessContact.ContactCity);
cmd.Parameters.AddWithValue("p9", businessContact.ContactPostcode);
await cmd.ExecuteNonQueryAsync();
}
}
}
