private void MCUpdateButton_Click(object sender, EventArgs e)
{//SAVE UPDATES
if (String.IsNullOrEmpty(MCNameTextbox.Text))
{
MessageBox.Show("Please enter a name.");
return;
}
if (String.IsNullOrEmpty(MCAddressTextbox.Text))
{
MessageBox.Show("Please enter an address.");
return;
}
if (String.IsNullOrEmpty(MCZipTextbox.Text))
{
MessageBox.Show("Please enter a zip code.");
return;
}
if (String.IsNullOrEmpty(MCPhoneButton.Text))
{
MessageBox.Show("Please enter a phone number.");
return;
}
string ctyslct = CityComboBox.GetItemText(CityComboBox.SelectedItem);
try
{
//UPDATE ADDRESS/CITY/COUNTRY
string Query = "Update address set address ='" + MCAddressTextbox.Text + "', cityId = '" + Globals.CtyID + "', postalCode = '" + MCZipTextbox.Text + "', phone = '" + MCPhoneButton.Text + "', lastUpdate ='" + TimeZoneInfo.ConvertTimeToUtc(DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss") + "', lastUpdateBy= '" + Globals.CurrUserName + "' Where addressId = '" + Globals.AddID + "';";
MySqlConnection con2 = new MySqlConnection(Globals.connStr);
MySqlCommand comm = new MySqlCommand(Query, con2);
con2.Open();
comm.ExecuteNonQuery();
con2.Close();
//UPDATECUSTOMER
string Queryx = "Update customer SET customerName = '" + MCNameTextbox.Text + "', lastUpdate ='" + TimeZoneInfo.ConvertTimeToUtc(DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss") + "', lastUpdateBy= '" + Globals.CurrUserName + "' WHERE customerId = '" + Globals.CustID + "';";
MySqlConnection con2x = new MySqlConnection(Globals.connStr);
MySqlCommand commx = new MySqlCommand(Queryx, con2x);
con2x.Open();
commx.ExecuteNonQuery();
MessageBox.Show("Data Saved");
}
catch (Exception)
{
MessageBox.Show("Could not update customer.", "Error");
}
this.Hide();
Dashboard db = new Dashboard();
db.ShowDialog();
}
private void CityComboBox_DropDownClosed(object sender, EventArgs e)
{
string ctyslct = CityComboBox.GetItemText(CityComboBox.SelectedItem);
using (MySqlConnection cmn = new MySqlConnection(Globals.connStr))
{
cmn.Open();
MySqlCommand mmmd = new MySqlCommand("SELECT cityId from city where city = '" + ctyslct + "';", cmn);
MySqlDataAdapter mapt = new MySqlDataAdapter(mmmd);
DataTable mdm = new DataTable();
mapt.Fill(mdm);
if (mdm.Rows.Count > 0)
{
int idc = (int)mdm.Rows[0][0];
Globals.CtyID = idc;
}
cmn.Close();
}
}
