// 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 CrudeServicePackageServiceClient(); try { _contract.ServicePackageName = textBoxServicePackageName.Text; _contract.ServiceSpecialServiceRequestId = (Guid)serviceSpecialServiceRequestPicker.SelectedValue; _contract.ServiceCarRentalId = (Guid)serviceCarRentalPicker.SelectedValue; _contract.DepartureAirportId = (Guid)departureAirportPicker.SelectedValue; _contract.ArrivalAirportId = (Guid)arrivalAirportPicker.SelectedValue; _contract.StayDurationDays = maskedTextBoxStayDurationDays.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxStayDurationDays.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 RefreshCrudeServicePackage() { var servicePackage = new CrudeServicePackageServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = servicePackage.FetchWithFilter( Guid.Empty , textBoxServicePackageName.Text , Guid.Empty , serviceSpecialServiceRequestPicker.SelectedValue , serviceCarRentalPicker.SelectedValue , departureAirportPicker.SelectedValue , arrivalAirportPicker.SelectedValue , maskedTextBoxStayDurationDays.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxStayDurationDays.Text) , Guid.Empty , DateTime.MinValue ); dataGridViewCrudeServicePackage.AutoGenerateColumns = false; dataGridViewCrudeServicePackage.DataSource = bindingSource; dataGridViewCrudeServicePackage.AutoResizeColumns(); dataGridViewCrudeServicePackage.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { servicePackage.Close(); } }
// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(System.Guid servicePackageId) { var service = new CrudeServicePackageServiceClient(); _isNew = false; try { _contract = service.FetchByServicePackageId(servicePackageId); textBoxServicePackageName.Text = _contract.ServicePackageName; serviceSpecialServiceRequestPicker.SelectedValue = _contract.ServiceSpecialServiceRequestId; serviceCarRentalPicker.SelectedValue = _contract.ServiceCarRentalId; departureAirportPicker.SelectedValue = _contract.DepartureAirportId; arrivalAirportPicker.SelectedValue = _contract.ArrivalAirportId; maskedTextBoxStayDurationDays.Text = _contract.StayDurationDays.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(); } }
// populates the Picker with the first match from the SOAP service // links: // docLink: http://sql2x.org/documentationLink/3e8b9e1a-39eb-444f-9632-ce3406db3534 private void txtServicePackageCode_Validating(object sender, CancelEventArgs e) { if (!DesignMode) { // empty picker on no code if (string.IsNullOrEmpty(txtServicePackageCode.Text)) { _servicePackageId = Guid.Empty; txtServicePackageName.Text = string.Empty; txtServicePackageCode.Text = string.Empty; return; } CrudeServicePackageServiceClient servicePackage = null; try { servicePackage = new CrudeServicePackageServiceClient(); CrudeServicePackageContract contract = servicePackage.FetchByServicePackageName(txtServicePackageCode.Text); if (contract != null) { txtServicePackageCode.Text = contract.ServicePackageName; txtServicePackageName.Text = contract.ServicePackageName; _servicePackageId = contract.ServicePackageId; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (servicePackage != null) { servicePackage.Close(); } } if (this.Picked != null) { this.Picked(new object(), new EventArgs()); } } }