private void btnMBus_Click(object sender, EventArgs e)
{
string caption = "Important";
string message = "Migrate" + " " + PersonalGrid.SelectedCells[1].Value.ToString() + " " + PersonalGrid.SelectedCells[2].Value.ToString() + "?";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result = MessageBox.Show(message, caption, buttons);
if (result == DialogResult.Yes)
{
BusinessContact businessContact = new BusinessContact();
businessContact.contactFname = txbFname.Text;
businessContact.ContactLname = txbLname.Text;
businessContact.contactEmail = txbEmail.Text;
businessContact.BusinessTel = txbPtel.Text;
businessContact.contactAddr1 = txbAddr1.Text;
businessContact.contactAddr2 = txbAddr2.Text;
businessContact.contactAddr3 = txbAddr3.Text;
businessContact.contactPostcode = txbPostcode.Text;
businessContact.contactCity = txbCity.Text;
dconn.InsertBusiness(businessContact);
dconn.DeletePersonal(Int32.Parse(PersonalGrid.SelectedCells[0].Value.ToString()));
dataRefresh();
}
}
private void btnSaveNew_Click(object sender, EventArgs e)
{
BusinessContact businessContact = new BusinessContact();
businessContact.contactFname = txbFname.Text;
businessContact.ContactLname = txbLname.Text;
businessContact.contactEmail = txbEmail.Text;
businessContact.BusinessTel = txbBtel.Text;
businessContact.contactAddr1 = txbAddr1.Text;
businessContact.contactAddr2 = txbAddr2.Text;
businessContact.contactAddr3 = txbAddr3.Text;
businessContact.contactPostcode = txbPostcode.Text;
businessContact.contactCity = txbCity.Text;
dconn.InsertBusiness(businessContact);
dataRefresh();
txbFname.Enabled = false;
txbLname.Enabled = false;
txbEmail.Enabled = false;
txbBtel.Enabled = false;
txbAddr1.Enabled = false;
txbAddr2.Enabled = false;
txbAddr3.Enabled = false;
txbPostcode.Enabled = false;
txbCity.Enabled = false;
btnUpdateSelected.Enabled = true;
btnDelete.Enabled = true;
btnSaveNew.Enabled = false;
}
private void btnSaveSelected_Click(object sender, EventArgs e)
{
int index = Int32.Parse(BusinessGrid.SelectedCells[0].Value.ToString());
BusinessContact businessContact = new BusinessContact();
businessContact.ContactID = index;
businessContact.contactFname = txbFname.Text;
businessContact.ContactLname = txbLname.Text;
businessContact.contactEmail = txbEmail.Text;
businessContact.BusinessTel = txbBtel.Text;
businessContact.contactAddr1 = txbAddr1.Text;
businessContact.contactAddr2 = txbAddr2.Text;
businessContact.contactAddr3 = txbAddr3.Text;
businessContact.contactPostcode = txbPostcode.Text;
businessContact.contactCity = txbCity.Text;
dconn.UpdatetBusiness(businessContact);
dataRefresh();
txbFname.Enabled = false;
txbLname.Enabled = false;
txbEmail.Enabled = false;
txbBtel.Enabled = false;
txbAddr1.Enabled = false;
txbAddr2.Enabled = false;
txbAddr3.Enabled = false;
txbPostcode.Enabled = false;
txbCity.Enabled = false;
btnUpdateSelected.Enabled = true;
btnDelete.Enabled = true;
btnSaveSelected.Enabled = false;
btnAddNew.Enabled = false;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public async void InsertBusiness(BusinessContact businessContact)
{
using (var conn = new MySqlConnection(connString))
{
await conn.OpenAsync();
using (var mysqlcmd = new MySqlCommand())
{
mysqlcmd.Connection = conn;
mysqlcmd.CommandText = "CALL insertBusiness (@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9);";
mysqlcmd.Parameters.AddWithValue("p1", businessContact.contactFname);
mysqlcmd.Parameters.AddWithValue("p2", businessContact.ContactLname);
mysqlcmd.Parameters.AddWithValue("p3", businessContact.contactEmail);
mysqlcmd.Parameters.AddWithValue("p4", businessContact.BusinessTel);
mysqlcmd.Parameters.AddWithValue("p5", businessContact.contactAddr1);
mysqlcmd.Parameters.AddWithValue("p6", businessContact.contactAddr2);
mysqlcmd.Parameters.AddWithValue("p7", businessContact.contactAddr3);
mysqlcmd.Parameters.AddWithValue("p8", businessContact.contactPostcode);
mysqlcmd.Parameters.AddWithValue("p9", businessContact.contactCity);
await mysqlcmd.ExecuteNonQueryAsync();
}
}
}