// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(System.Guid serviceSpecialServiceRequestId) { var service = new CrudeServiceSpecialServiceRequestServiceClient(); _isNew = false; try { _contract = service.FetchByServiceSpecialServiceRequestId(serviceSpecialServiceRequestId); serviceSpecialServiceRequestGroupRefCombo.Text = _contract.ServiceSpecialServiceRequestGroupRcd != null ? _contract.ServiceSpecialServiceRequestGroupRcd : String.Empty; textBoxServiceSpecialServiceRequestCode.Text = _contract.ServiceSpecialServiceRequestCode; textBoxServiceSpecialServiceRequestName.Text = _contract.ServiceSpecialServiceRequestName; textBoxServiceDescription.Text = _contract.ServiceDescription; maskedTextBoxAmount.Text = _contract.Amount.ToString(); financialCurrencyPicker.SelectedValue = _contract.FinancialCurrencyId; checkBoxInventoryControlledFlag.Checked = _contract.InventoryControlledFlag; requestServiceSpecialServiceRequestRequirementRefCombo.Text = _contract.RequestServiceSpecialServiceRequestRequirementRcd != null ? _contract.RequestServiceSpecialServiceRequestRequirementRcd : String.Empty; replyServiceSpecialServiceRequestRequirementRefCombo.Text = _contract.ReplyServiceSpecialServiceRequestRequirementRcd != null ? _contract.ReplyServiceSpecialServiceRequestRequirementRcd : String.Empty; serviceSpecialServiceRequestOperationRuleRefCombo.Text = _contract.ServiceSpecialServiceRequestOperationRuleRcd != null ? _contract.ServiceSpecialServiceRequestOperationRuleRcd : 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(); } }
// populates the Picker with the first match from the SOAP service // links: // docLink: http://sql2x.org/documentationLink/3e8b9e1a-39eb-444f-9632-ce3406db3534 private void txtServiceSpecialServiceRequestCode_Validating(object sender, CancelEventArgs e) { if (!DesignMode) { // empty picker on no code if (string.IsNullOrEmpty(txtServiceSpecialServiceRequestCode.Text)) { _serviceSpecialServiceRequestId = Guid.Empty; txtServiceSpecialServiceRequestName.Text = string.Empty; txtServiceSpecialServiceRequestCode.Text = string.Empty; return; } CrudeServiceSpecialServiceRequestServiceClient serviceSpecialServiceRequest = null; try { serviceSpecialServiceRequest = new CrudeServiceSpecialServiceRequestServiceClient(); CrudeServiceSpecialServiceRequestContract contract = serviceSpecialServiceRequest.FetchByServiceSpecialServiceRequestCode(txtServiceSpecialServiceRequestCode.Text); if (contract != null) { txtServiceSpecialServiceRequestCode.Text = contract.ServiceSpecialServiceRequestCode; txtServiceSpecialServiceRequestName.Text = contract.ServiceSpecialServiceRequestName; _serviceSpecialServiceRequestId = contract.ServiceSpecialServiceRequestId; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (serviceSpecialServiceRequest != null) { serviceSpecialServiceRequest.Close(); } } if (this.Picked != null) { this.Picked(new object(), new EventArgs()); } } }
// 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 CrudeServiceSpecialServiceRequestServiceClient(); try { _contract.ServiceSpecialServiceRequestGroupRcd = serviceSpecialServiceRequestGroupRefCombo.Text; _contract.ServiceSpecialServiceRequestCode = textBoxServiceSpecialServiceRequestCode.Text; _contract.ServiceSpecialServiceRequestName = textBoxServiceSpecialServiceRequestName.Text; _contract.ServiceDescription = textBoxServiceDescription.Text; _contract.Amount = maskedTextBoxAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxAmount.Text); _contract.FinancialCurrencyId = (Guid)financialCurrencyPicker.SelectedValue; _contract.InventoryControlledFlag = Convert.ToBoolean(checkBoxInventoryControlledFlag.Checked); _contract.RequestServiceSpecialServiceRequestRequirementRcd = requestServiceSpecialServiceRequestRequirementRefCombo.Text; _contract.ReplyServiceSpecialServiceRequestRequirementRcd = replyServiceSpecialServiceRequestRequirementRefCombo.Text; _contract.ServiceSpecialServiceRequestOperationRuleRcd = serviceSpecialServiceRequestOperationRuleRefCombo.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 RefreshCrudeServiceSpecialServiceRequest() { var serviceSpecialServiceRequest = new CrudeServiceSpecialServiceRequestServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = serviceSpecialServiceRequest.FetchWithFilter( Guid.Empty , serviceSpecialServiceRequestGroupRefCombo.Text , textBoxServiceSpecialServiceRequestCode.Text , textBoxServiceSpecialServiceRequestName.Text , textBoxServiceDescription.Text , maskedTextBoxAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxAmount.Text) , financialCurrencyPicker.SelectedValue , Convert.ToBoolean(checkBoxInventoryControlledFlag.Checked) , requestServiceSpecialServiceRequestRequirementRefCombo.Text , replyServiceSpecialServiceRequestRequirementRefCombo.Text , serviceSpecialServiceRequestOperationRuleRefCombo.Text , Guid.Empty , DateTime.MinValue ); dataGridViewCrudeServiceSpecialServiceRequest.AutoGenerateColumns = false; dataGridViewCrudeServiceSpecialServiceRequest.DataSource = bindingSource; dataGridViewCrudeServiceSpecialServiceRequest.AutoResizeColumns(); dataGridViewCrudeServiceSpecialServiceRequest.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { serviceSpecialServiceRequest.Close(); } }