// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(System.Guid bookingServiceRequestId) { var service = new CrudeBookingServiceRequestServiceClient(); _isNew = false; try { _contract = service.FetchByBookingServiceRequestId(bookingServiceRequestId); serviceTypeRefCombo.Text = _contract.ServiceTypeRcd != null ? _contract.ServiceTypeRcd : String.Empty; serviceSpecialServiceRequestPicker.SelectedValue = _contract.ServiceSpecialServiceRequestId; serviceRequestStatusRefCombo.Text = _contract.ServiceRequestStatusRcd != null ? _contract.ServiceRequestStatusRcd : String.Empty; serviceCarRentalPicker.SelectedValue = _contract.ServiceCarRentalId; 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 CrudeBookingServiceRequestServiceClient(); try { _contract.ServiceTypeRcd = serviceTypeRefCombo.Text; _contract.ServiceSpecialServiceRequestId = (Guid)serviceSpecialServiceRequestPicker.SelectedValue; _contract.ServiceRequestStatusRcd = serviceRequestStatusRefCombo.Text; _contract.ServiceCarRentalId = (Guid)serviceCarRentalPicker.SelectedValue; _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 RefreshCrudeBookingServiceRequest() { var bookingServiceRequest = new CrudeBookingServiceRequestServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = bookingServiceRequest.FetchWithFilter( Guid.Empty , Guid.Empty , serviceTypeRefCombo.Text , serviceSpecialServiceRequestPicker.SelectedValue , serviceRequestStatusRefCombo.Text , Guid.Empty , serviceCarRentalPicker.SelectedValue , Guid.Empty , DateTime.MinValue , Guid.Empty ); dataGridViewCrudeBookingServiceRequest.AutoGenerateColumns = false; dataGridViewCrudeBookingServiceRequest.DataSource = bindingSource; dataGridViewCrudeBookingServiceRequest.AutoResizeColumns(); dataGridViewCrudeBookingServiceRequest.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { bookingServiceRequest.Close(); } }