Exemplo n.º 1
0
        // 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();
            }
        }
Exemplo n.º 2
0
        // 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();
        }
Exemplo n.º 3
0
        // 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();
            }
        }
Exemplo n.º 4
0
        // 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());
                }
            }
        }