// 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 CrudeDefaultPerformanceTimeRollupServiceClient(); try { _contract.CommandName = textBoxCommandName.Text; _contract.Milliseconds = maskedTextBoxMilliseconds.Text == String.Empty ? 0 : Convert.ToInt64(maskedTextBoxMilliseconds.Text); _contract.Hits = maskedTextBoxHits.Text == String.Empty ? 0 : Convert.ToInt64(maskedTextBoxHits.Text); _contract.DateTime = dateTimePickerDateTime.Checked ? Convert.ToDateTime(dateTimePickerDateTime.Value): DateTime.MinValue; 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 RefreshCrudeDefaultPerformanceTimeRollup() { var defaultPerformanceTimeRollup = new CrudeDefaultPerformanceTimeRollupServiceClient(); try { var bindingSource = new BindingSource(); bindingSource.DataSource = defaultPerformanceTimeRollup.FetchWithFilter( Guid.Empty , textBoxCommandName.Text , maskedTextBoxMilliseconds.Text == String.Empty ? 0 : Convert.ToInt64(maskedTextBoxMilliseconds.Text) , maskedTextBoxHits.Text == String.Empty ? 0 : Convert.ToInt64(maskedTextBoxHits.Text) , Guid.Empty , dateTimePickerDateTime.Checked ? Convert.ToDateTime(dateTimePickerDateTime.Value): DateTime.MinValue ); dataGridViewCrudeDefaultPerformanceTimeRollup.AutoGenerateColumns = false; dataGridViewCrudeDefaultPerformanceTimeRollup.DataSource = bindingSource; dataGridViewCrudeDefaultPerformanceTimeRollup.AutoResizeColumns(); dataGridViewCrudeDefaultPerformanceTimeRollup.Refresh(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { defaultPerformanceTimeRollup.Close(); } }
// shows the form in edit modus // links: // docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77 public void ShowAsEdit(System.Guid defaultPerformanceTimeRollupId, System.Guid defaultUserId) { var service = new CrudeDefaultPerformanceTimeRollupServiceClient(); _isNew = false; try { _contract = service.FetchByDefaultPerformanceTimeRollupId(defaultPerformanceTimeRollupId); textBoxCommandName.Text = _contract.CommandName; maskedTextBoxMilliseconds.Text = _contract.Milliseconds.ToString(); maskedTextBoxHits.Text = _contract.Hits.ToString(); _contract.DefaultUserId = defaultUserId; dateTimePickerDateTime.Value = _contract.DateTime != DateTime.MinValue ? _contract.DateTime : dateTimePickerDateTime.MinDate; dateTimePickerDateTime.Checked = _contract.DateTime != DateTime.MinValue; Show(); } catch (Exception ex) { if (ex == null) { } else { System.Diagnostics.Debugger.Break(); } } finally { service.Close(); } }