// 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 CrudeAircraftCompartmentServiceClient(); try { _contract.AircraftCompartmentTypeRcd = aircraftCompartmentTypeRefCombo.Text; _contract.AircraftCompartmentName = textBoxAircraftCompartmentName.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(); }
// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(System.Guid aircraftCompartmentId) { var service = new CrudeAircraftCompartmentServiceClient(); _isNew = false; try { _contract = service.FetchByAircraftCompartmentId(aircraftCompartmentId); aircraftCompartmentTypeRefCombo.Text = _contract.AircraftCompartmentTypeRcd != null ? _contract.AircraftCompartmentTypeRcd : String.Empty; textBoxAircraftCompartmentName.Text = _contract.AircraftCompartmentName; 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(); } }
// save and close AircraftCompartment // links: // docLink: http://sql2x.org/documentationLink/d71519ff-fa27-4f64-9194-56886e4070ba private void buttonSave_Click(object sender, EventArgs e) { var service = new CrudeAircraftCompartmentServiceClient(); try { _contract.AircraftCompartmentTypeRcd = aircraftCompartmentTypeRefCombo.Text; _contract.AircraftCompartmentName = textBoxAircraftCompartmentName.Text; _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(); }
public ActionResult CrudeAircraftCompartmentEdit( System.Guid aircraftCompartmentId ) { CrudeAircraftCompartmentContract contract = new CrudeAircraftCompartmentServiceClient().FetchByAircraftCompartmentId(aircraftCompartmentId); ViewBag.AircraftId = new SelectList(new CrudeAircraftServiceClient().FetchAll(), "AircraftId", "AircraftName", contract.AircraftId ); ViewBag.AircraftCompartmentTypeRcd = new SelectList(new CrudeAircraftCompartmentTypeRefServiceClient().FetchAll(), "AircraftCompartmentTypeRcd", "AircraftCompartmentTypeName", contract.AircraftCompartmentTypeRcd ); ViewBag.DefaultUserName = new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName; return(View( "~/Views/Crude/Aircraft/CrudeAircraftCompartment/CrudeAircraftCompartmentEdit.cshtml", contract )); }
// refresh the grid // links: // docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f public void RefreshCrudeAircraftCompartment() { var aircraftCompartment = new CrudeAircraftCompartmentServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = aircraftCompartment.FetchWithFilter( Guid.Empty , Guid.Empty , Guid.Empty , aircraftCompartmentTypeRefCombo.Text , textBoxAircraftCompartmentName.Text , Guid.Empty , DateTime.MinValue ); dataGridViewCrudeAircraftCompartment.AutoGenerateColumns = false; dataGridViewCrudeAircraftCompartment.DataSource = bindingSource; dataGridViewCrudeAircraftCompartment.AutoResizeColumns(); dataGridViewCrudeAircraftCompartment.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { aircraftCompartment.Close(); } }
public ActionResult AircraftCompartmentMeasurementEdit( System.Guid aircraftCompartmentId ) { ViewBag.AircraftCompartmentId = aircraftCompartmentId; // get right-side primary key from left-side entity System.Guid aircraftCompartmentMeasurementId = new CrudeAircraftCompartmentServiceClient().FetchByAircraftCompartmentId(aircraftCompartmentId).AircraftCompartmentMeasurementId; // get right-side entity CrudeAircraftCompartmentMeasurementContract contract = new CrudeAircraftCompartmentMeasurementServiceClient().FetchByAircraftCompartmentMeasurementId(aircraftCompartmentMeasurementId); ViewBag.DefaultUserName = new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName; return(View( "~/Views/Templates/Aircraft/AircraftCompartmentMeasurement/AircraftCompartmentMeasurementEdit.cshtml", contract )); }
public ActionResult AircraftCompartmentMeasurementEdit( [Bind()] CrudeAircraftCompartmentMeasurementContract contract, System.Guid aircraftCompartmentId ) { ViewBag.AircraftCompartmentId = aircraftCompartmentId; if (ModelState.IsValid) { contract.DateTime = DateTime.UtcNow; if (contract.AircraftCompartmentMeasurementId == Guid.Empty) { // insert right-side entity contract.AircraftCompartmentMeasurementId = Guid.NewGuid(); contract.UserId = new System.Guid("{FFFFFFFF-5555-5555-5555-FFFFFFFFFFFF}"); new CrudeAircraftCompartmentMeasurementServiceClient().Insert(contract); // update left-side with right-side id CrudeAircraftCompartmentContract aircraftCompartmentContract = new CrudeAircraftCompartmentServiceClient().FetchByAircraftCompartmentId(aircraftCompartmentId); aircraftCompartmentContract.AircraftCompartmentMeasurementId = contract.AircraftCompartmentMeasurementId; aircraftCompartmentContract.DateTime = DateTime.UtcNow; aircraftCompartmentContract.UserId = new System.Guid("{FFFFFFFF-5555-5555-5555-FFFFFFFFFFFF}"); new CrudeAircraftCompartmentServiceClient().Update(aircraftCompartmentContract); } else { // update right-side entity new CrudeAircraftCompartmentMeasurementServiceClient().Update(contract); } } return(View( "~/Views/Templates/Aircraft/AircraftCompartmentMeasurement/AircraftCompartmentMeasurementEdit.cshtml", contract )); }