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(); } }