// fetch all rows from the SOAP layer and populate the ComboBox with it public void PopulateCombo() { if (!DesignMode && cboRef.DataSource == null) { CrudeClientNationalityRefServiceClient clientNationalityRef = null; try { clientNationalityRef = new CrudeClientNationalityRefServiceClient(); List <CrudeClientNationalityRefContract> contracts = clientNationalityRef.FetchAll(); cboRef.DataSource = contracts; cboRef.DisplayMember = "ClientNationalityName"; cboRef.ValueMember = "ClientNationalityRcd"; } catch (Exception ex) { if (ex != null) { } } finally { if (clientNationalityRef != null) { clientNationalityRef.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 CrudeClientNationalityRefServiceClient(); try { _contract.ClientNationalityRcd = textBoxClientNationality.Text; _contract.ClientNationalityName = textBoxClientNationalityName.Text; _contract.ClientNationalityDescription = textBoxClientNationalityDescription.Text; _contract.ActiveFlag = Convert.ToBoolean(checkBoxActiveFlag.Checked); _contract.SortOrder = maskedTextBoxSortOrder.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxSortOrder.Text); 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 RefreshCrudeClientNationalityRef() { var clientNationalityRef = new CrudeClientNationalityRefServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = clientNationalityRef.FetchWithFilter( textBoxClientNationality.Text , textBoxClientNationalityName.Text , textBoxClientNationalityDescription.Text , Convert.ToBoolean(checkBoxActiveFlag.Checked) , maskedTextBoxSortOrder.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxSortOrder.Text) , Guid.Empty , DateTime.MinValue ); dataGridViewCrudeClientNationalityRef.AutoGenerateColumns = false; dataGridViewCrudeClientNationalityRef.DataSource = bindingSource; dataGridViewCrudeClientNationalityRef.AutoResizeColumns(); dataGridViewCrudeClientNationalityRef.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { clientNationalityRef.Close(); } }
// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(string clientNationalityRcd, System.Guid userId) { var service = new CrudeClientNationalityRefServiceClient(); _isNew = false; try { _contract = service.FetchByClientNationalityRcd(clientNationalityRcd); textBoxClientNationality.Text = _contract.ClientNationalityRcd; textBoxClientNationalityName.Text = _contract.ClientNationalityName; textBoxClientNationalityDescription.Text = _contract.ClientNationalityDescription; checkBoxActiveFlag.Checked = _contract.ActiveFlag; maskedTextBoxSortOrder.Text = _contract.SortOrder.ToString(); _contract.UserId = 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(); } }