private void TeamAddButton_Click(object sender, EventArgs e) { string timestamp = SqlUpdater.CreateTimestamp(); string userName = SqlUpdater.GetCurrentUserName(); if (string.IsNullOrEmpty(TeamNameText.Text) || string.IsNullOrEmpty(TeamPhoneText.Text) || string.IsNullOrEmpty(TeamCityText.Text) || string.IsNullOrEmpty(TeamCountryText.Text) || string.IsNullOrEmpty(TeamZipText.Text) || string.IsNullOrEmpty(TeamAddressText.Text)) { MessageBox.Show("Please complete all fields"); } else { int countryId = SqlUpdater.CreateRecord(timestamp, userName, "country", $"'{TeamCountryText.Text}'"); int cityId = SqlUpdater.CreateRecord(timestamp, userName, "city", $"'{TeamCityText.Text}', '{countryId}'"); int addressId = SqlUpdater.CreateRecord(timestamp, userName, "address", $"'{TeamAddressText.Text}', '', '{cityId}', '{TeamZipText.Text}', '{TeamPhoneText.Text}'"); SqlUpdater.CreateRecord(timestamp, userName, "customer", $"'{TeamNameText.Text}', '{addressId}', '1'"); MessageBox.Show("Team created."); Close(); } }