// bring up edit form for Airport // links: // docLink: http://sql2x.org/documentationLink/d7ff032d-3bcf-438f-9850-900ca0ebca98 public void ShowAsEdit(System.Guid airportId) { var service = new CrudeAirportServiceClient(); _isNew = false; try { _contract = service.FetchByAirportId(airportId); textBoxAirportName.Text = _contract.AirportName; airportTypeRefCombo.Text = _contract.AirportTypeRcd != null ? _contract.AirportTypeRcd : String.Empty; cityPicker.SelectedValue = _contract.CityId; maskedTextBoxUtcOffset.Text = _contract.UtcOffset.ToString(); maskedTextBoxElevationInMeters.Text = _contract.ElevationInMeters.ToString(); maskedTextBoxRunwayInMeters.Text = _contract.RunwayInMeters.ToString(); textBoxLatitude.Text = _contract.Latitude; textBoxLongitude.Text = _contract.Longitude; textBoxVariation.Text = _contract.Variation; textBoxAttendance.Text = _contract.Attendance; checkBoxControlTowerFlag.Checked = _contract.ControlTowerFlag; dateTimePickerActivationDateTime.Value = _contract.ActivationDateTime != DateTime.MinValue ? _contract.ActivationDateTime : dateTimePickerActivationDateTime.MinDate; dateTimePickerActivationDateTime.Checked = _contract.ActivationDateTime != DateTime.MinValue; userPicker.SelectedValue = _contract.UserId; _contract.DateTime = DateTime.UtcNow; dateTimePickerDateTime.Text = _contract.DateTime.ToString(); RefreshAirport(); Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { service.Close(); } }
// save and close Airport // links: // docLink: http://sql2x.org/documentationLink/d71519ff-fa27-4f64-9194-56886e4070ba private void buttonSave_Click(object sender, EventArgs e) { var service = new CrudeAirportServiceClient(); try { _contract.AirportName = textBoxAirportName.Text; _contract.AirportTypeRcd = airportTypeRefCombo.Text; _contract.CityId = (Guid)cityPicker.SelectedValue; _contract.UtcOffset = maskedTextBoxUtcOffset.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxUtcOffset.Text); _contract.ElevationInMeters = maskedTextBoxElevationInMeters.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxElevationInMeters.Text); _contract.RunwayInMeters = maskedTextBoxRunwayInMeters.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxRunwayInMeters.Text); _contract.Latitude = textBoxLatitude.Text; _contract.Longitude = textBoxLongitude.Text; _contract.Variation = textBoxVariation.Text; _contract.Attendance = textBoxAttendance.Text; _contract.ControlTowerFlag = Convert.ToBoolean(checkBoxControlTowerFlag.Checked); _contract.ActivationDateTime = dateTimePickerActivationDateTime.Checked ? Convert.ToDateTime(dateTimePickerActivationDateTime.Value): DateTime.MinValue; _contract.UserId = (Guid)userPicker.SelectedValue; if (_isNew) { service.Insert(_contract); } else { service.Update(_contract); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { service.Close(); } Close(); }
// refresh the grid // links: // docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f public void RefreshCrudeAirport() { var airport = new CrudeAirportServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = airport.FetchWithFilter( Guid.Empty , textBoxAirportName.Text , airportTypeRefCombo.Text , cityPicker.SelectedValue , Guid.Empty , maskedTextBoxUtcOffset.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxUtcOffset.Text) , maskedTextBoxElevationInMeters.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxElevationInMeters.Text) , maskedTextBoxRunwayInMeters.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxRunwayInMeters.Text) , textBoxLatitude.Text , textBoxLongitude.Text , Guid.Empty , textBoxVariation.Text , textBoxAttendance.Text , Convert.ToBoolean(checkBoxControlTowerFlag.Checked) , dateTimePickerActivationDateTime.Checked ? Convert.ToDateTime(dateTimePickerActivationDateTime.Value): DateTime.MinValue , Guid.Empty , DateTime.MinValue ); dataGridViewCrudeAirport.AutoGenerateColumns = false; dataGridViewCrudeAirport.DataSource = bindingSource; dataGridViewCrudeAirport.AutoResizeColumns(); dataGridViewCrudeAirport.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { airport.Close(); } }
// populates the Picker with the first match from the SOAP service // links: // docLink: http://sql2x.org/documentationLink/3e8b9e1a-39eb-444f-9632-ce3406db3534 private void txtAirportCode_Validating(object sender, CancelEventArgs e) { if (!DesignMode) { // empty picker on no code if (string.IsNullOrEmpty(txtAirportCode.Text)) { _airportId = Guid.Empty; txtAirportName.Text = string.Empty; txtAirportCode.Text = string.Empty; return; } CrudeAirportServiceClient airport = null; try { airport = new CrudeAirportServiceClient(); CrudeAirportContract contract = airport.FetchByAirportName(txtAirportCode.Text); if (contract != null) { txtAirportCode.Text = contract.AirportName; txtAirportName.Text = contract.AirportName; _airportId = contract.AirportId; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (airport != null) { airport.Close(); } } if (this.Picked != null) { this.Picked(new object(), new EventArgs()); } } }