public ActionResult CrudePassengerEdit( System.Guid passengerId ) { CrudePassengerContract contract = new CrudePassengerServiceClient().FetchByPassengerId(passengerId); ViewBag.PassengerTypeRcd = new SelectList(new CrudePassengerTypeRefServiceClient().FetchAll(), "PassengerTypeRcd", "PassengerTypeName", contract.PassengerTypeRcd ); ViewBag.DefaultStateRcd = new SelectList(new CrudeDefaultStateRefServiceClient().FetchAll(), "DefaultStateRcd", "DefaultStateName", contract.DefaultStateRcd ); ViewBag.DefaultUserName = new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName; return(View( "~/Views/Crude/Passenger/CrudePassenger/CrudePassengerEdit.cshtml", contract )); }
// refresh the grid // links: // docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f public void RefreshCrudePassenger() { var passenger = new CrudePassengerServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = passenger.FetchWithFilter( Guid.Empty , Guid.Empty , Guid.Empty , passengerTypeRefCombo.Text , textBoxPassengerName.Text , defaultStateRefCombo.Text , Guid.Empty , DateTime.MinValue ); dataGridViewCrudePassenger.AutoGenerateColumns = false; dataGridViewCrudePassenger.DataSource = bindingSource; dataGridViewCrudePassenger.AutoResizeColumns(); dataGridViewCrudePassenger.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { passenger.Close(); } }
// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(System.Guid passengerId) { var service = new CrudePassengerServiceClient(); _isNew = false; try { _contract = service.FetchByPassengerId(passengerId); passengerTypeRefCombo.Text = _contract.PassengerTypeRcd != null ? _contract.PassengerTypeRcd : String.Empty; textBoxPassengerName.Text = _contract.PassengerName; defaultStateRefCombo.Text = _contract.DefaultStateRcd != null ? _contract.DefaultStateRcd : String.Empty; 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 CrudePassengerServiceClient(); try { _contract.PassengerTypeRcd = passengerTypeRefCombo.Text; _contract.PassengerName = textBoxPassengerName.Text; _contract.DefaultStateRcd = defaultStateRefCombo.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(); }
// populates the Picker with the first match from the SOAP service // links: // docLink: http://sql2x.org/documentationLink/3e8b9e1a-39eb-444f-9632-ce3406db3534 private void txtPassengerCode_Validating(object sender, CancelEventArgs e) { if (!DesignMode) { // empty picker on no code if (string.IsNullOrEmpty(txtPassengerCode.Text)) { _passengerId = Guid.Empty; txtPassengerName.Text = string.Empty; txtPassengerCode.Text = string.Empty; return; } CrudePassengerServiceClient passenger = null; try { passenger = new CrudePassengerServiceClient(); CrudePassengerContract contract = passenger.FetchByPassengerName(txtPassengerCode.Text); if (contract != null) { txtPassengerCode.Text = contract.PassengerName; txtPassengerName.Text = contract.PassengerName; _passengerId = contract.PassengerId; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (passenger != null) passenger.Close(); } if (this.Picked != null) this.Picked(new object(), new EventArgs()); } }