// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid flightEventId)
{
var service = new CrudeFlightEventServiceClient();
_isNew = false;
try {
_contract = service.FetchByFlightEventId(flightEventId);
maskedTextBoxFlightEventNumber.Text = _contract.FlightEventNumber.ToString();
dateTimeTypeRefCombo.Text = _contract.DateTimeTypeRcd != null ? _contract.DateTimeTypeRcd : String.Empty;
dateTimePickerNewDateTime.Value = _contract.NewDateTime != DateTime.MinValue ? _contract.NewDateTime : dateTimePickerNewDateTime.MinDate;
dateTimePickerNewDateTime.Checked = _contract.NewDateTime != DateTime.MinValue;
textBoxRemarks.Text = _contract.Remarks;
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 CrudeFlightEventServiceClient();
try {
_contract.FlightEventNumber = maskedTextBoxFlightEventNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxFlightEventNumber.Text);
_contract.DateTimeTypeRcd = dateTimeTypeRefCombo.Text;
_contract.NewDateTime = dateTimePickerNewDateTime.Checked ? Convert.ToDateTime(dateTimePickerNewDateTime.Value): DateTime.MinValue;
_contract.Remarks = textBoxRemarks.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 RefreshCrudeFlightEvent()
{
var flightEvent = new CrudeFlightEventServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = flightEvent.FetchWithFilter(
Guid.Empty
, Guid.Empty
, maskedTextBoxFlightEventNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxFlightEventNumber.Text)
, dateTimeTypeRefCombo.Text
, dateTimePickerNewDateTime.Checked ? Convert.ToDateTime(dateTimePickerNewDateTime.Value): DateTime.MinValue
, textBoxRemarks.Text
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeFlightEvent.AutoGenerateColumns = false;
dataGridViewCrudeFlightEvent.DataSource = bindingSource;
dataGridViewCrudeFlightEvent.AutoResizeColumns();
dataGridViewCrudeFlightEvent.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
flightEvent.Close();
}
}