// refresh the grid // links: // docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f public void RefreshCrudeAircraftMeasurement() { var aircraftMeasurement = new CrudeAircraftMeasurementServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = aircraftMeasurement.FetchWithFilter( Guid.Empty , maskedTextBoxLength.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxLength.Text) , maskedTextBoxHeight.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxHeight.Text) , maskedTextBoxWeight.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxWeight.Text) , maskedTextBoxWingspan.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxWingspan.Text) , maskedTextBoxWidth.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxWidth.Text) , maskedTextBoxPayload.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxPayload.Text) , maskedTextBoxTakeoffWeightInKilo.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxTakeoffWeightInKilo.Text) , maskedTextBoxSpeed.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxSpeed.Text) , Guid.Empty , DateTime.MinValue ); dataGridViewCrudeAircraftMeasurement.AutoGenerateColumns = false; dataGridViewCrudeAircraftMeasurement.DataSource = bindingSource; dataGridViewCrudeAircraftMeasurement.AutoResizeColumns(); dataGridViewCrudeAircraftMeasurement.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { aircraftMeasurement.Close(); } }
// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(System.Guid aircraftMeasurementId) { var service = new CrudeAircraftMeasurementServiceClient(); _isNew = false; try { _contract = service.FetchByAircraftMeasurementId(aircraftMeasurementId); maskedTextBoxLength.Text = _contract.Length.ToString(); maskedTextBoxHeight.Text = _contract.Height.ToString(); maskedTextBoxWeight.Text = _contract.Weight.ToString(); maskedTextBoxWingspan.Text = _contract.Wingspan.ToString(); maskedTextBoxWidth.Text = _contract.Width.ToString(); maskedTextBoxPayload.Text = _contract.Payload.ToString(); maskedTextBoxTakeoffWeightInKilo.Text = _contract.TakeoffWeightInKilo.ToString(); maskedTextBoxSpeed.Text = _contract.Speed.ToString(); userPicker.SelectedValue = _contract.UserId; _contract.DateTime = DateTime.UtcNow; dateTimePickerDateTime.Text = _contract.DateTime.ToString(); Show(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { service.Close(); } }
// saves the form // links: // docLink: http://sql2x.org/documentationLink/c9522930-91f8-4468-a936-8030bb2a6482 private void buttonSave_Click(object sender, EventArgs e) { var service = new CrudeAircraftMeasurementServiceClient(); try { _contract.Length = maskedTextBoxLength.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxLength.Text); _contract.Height = maskedTextBoxHeight.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxHeight.Text); _contract.Weight = maskedTextBoxWeight.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxWeight.Text); _contract.Wingspan = maskedTextBoxWingspan.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxWingspan.Text); _contract.Width = maskedTextBoxWidth.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxWidth.Text); _contract.Payload = maskedTextBoxPayload.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxPayload.Text); _contract.TakeoffWeightInKilo = maskedTextBoxTakeoffWeightInKilo.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxTakeoffWeightInKilo.Text); _contract.Speed = maskedTextBoxSpeed.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxSpeed.Text); _contract.UserId = (Guid)userPicker.SelectedValue; if (_isNew) { service.Insert(_contract); } else { service.Update(_contract); } } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { service.Close(); } Close(); }