public ActionResult CrudeFlightSegmentEdit( System.Guid flightSegmentId ) { CrudeFlightSegmentContract contract = new CrudeFlightSegmentServiceClient().FetchByFlightSegmentId(flightSegmentId); ViewBag.DepartureAirportId = new SelectList(new CrudeAirportServiceClient().FetchAll(), "AirportId", "AirportName", contract.DepartureAirportId ); ViewBag.ArrivalAirportId = new SelectList(new CrudeAirportServiceClient().FetchAll(), "AirportId", "AirportName", contract.ArrivalAirportId ); ViewBag.DefaultUserName = new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName; return(View( "~/Views/Crude/Flight/CrudeFlightSegment/CrudeFlightSegmentEdit.cshtml", contract )); }
// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(System.Guid flightSegmentId) { var service = new CrudeFlightSegmentServiceClient(); _isNew = false; try { _contract = service.FetchByFlightSegmentId(flightSegmentId); departureAirportPicker.SelectedValue = _contract.DepartureAirportId; arrivalAirportPicker.SelectedValue = _contract.ArrivalAirportId; maskedTextBoxLogicalSegmentNumber.Text = _contract.LogicalSegmentNumber.ToString(); maskedTextBoxPhysicalSegmentNumber.Text = _contract.PhysicalSegmentNumber.ToString(); dateTimePickerFromDateTime.Value = _contract.FromDateTime != DateTime.MinValue ? _contract.FromDateTime : dateTimePickerFromDateTime.MinDate; dateTimePickerFromDateTime.Checked = _contract.FromDateTime != DateTime.MinValue; dateTimePickerUntilDateTime.Value = _contract.UntilDateTime != DateTime.MinValue ? _contract.UntilDateTime : dateTimePickerUntilDateTime.MinDate; dateTimePickerUntilDateTime.Checked = _contract.UntilDateTime != DateTime.MinValue; textBoxDepartureGate.Text = _contract.DepartureGate; textBoxArrivalGate.Text = _contract.ArrivalGate; 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 CrudeFlightSegmentServiceClient(); try { _contract.DepartureAirportId = (Guid)departureAirportPicker.SelectedValue; _contract.ArrivalAirportId = (Guid)arrivalAirportPicker.SelectedValue; _contract.LogicalSegmentNumber = maskedTextBoxLogicalSegmentNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxLogicalSegmentNumber.Text); _contract.PhysicalSegmentNumber = maskedTextBoxPhysicalSegmentNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxPhysicalSegmentNumber.Text); _contract.FromDateTime = dateTimePickerFromDateTime.Checked ? Convert.ToDateTime(dateTimePickerFromDateTime.Value): DateTime.MinValue; _contract.UntilDateTime = dateTimePickerUntilDateTime.Checked ? Convert.ToDateTime(dateTimePickerUntilDateTime.Value): DateTime.MinValue; _contract.DepartureGate = textBoxDepartureGate.Text; _contract.ArrivalGate = textBoxArrivalGate.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(); }
// refresh the grid // links: // docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f public void RefreshCrudeFlightSegment() { var flightSegment = new CrudeFlightSegmentServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = flightSegment.FetchWithFilter( Guid.Empty , Guid.Empty , departureAirportPicker.SelectedValue , arrivalAirportPicker.SelectedValue , maskedTextBoxLogicalSegmentNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxLogicalSegmentNumber.Text) , maskedTextBoxPhysicalSegmentNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxPhysicalSegmentNumber.Text) , dateTimePickerFromDateTime.Checked ? Convert.ToDateTime(dateTimePickerFromDateTime.Value): DateTime.MinValue , dateTimePickerUntilDateTime.Checked ? Convert.ToDateTime(dateTimePickerUntilDateTime.Value): DateTime.MinValue , textBoxDepartureGate.Text , textBoxArrivalGate.Text , Guid.Empty , DateTime.MinValue ); dataGridViewCrudeFlightSegment.AutoGenerateColumns = false; dataGridViewCrudeFlightSegment.DataSource = bindingSource; dataGridViewCrudeFlightSegment.AutoResizeColumns(); dataGridViewCrudeFlightSegment.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { flightSegment.Close(); } }