// save and close AircraftDocument
// links:
// docLink: http://sql2x.org/documentationLink/d71519ff-fa27-4f64-9194-56886e4070ba
private void buttonSave_Click(object sender, EventArgs e)
{
var service = new CrudeAircraftDocumentServiceClient();
try {
_contract.AircraftDocumentTypeRcd = aircraftDocumentTypeRefCombo.Text;
_contract.DocumentName = textBoxDocumentName.Text;
_contract.DocumentDateTime = dateTimePickerDocumentDateTime.Checked ? Convert.ToDateTime(dateTimePickerDocumentDateTime.Value): DateTime.MinValue;
_contract.ExpiryDateTime = dateTimePickerExpiryDateTime.Checked ? Convert.ToDateTime(dateTimePickerExpiryDateTime.Value): DateTime.MinValue;
_contract.UserId = (Guid)userPicker.SelectedValue;
if (_isNew)
{
service.Insert(_contract);
}
else
{
service.Update(_contract);
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
service.Close();
}
Close();
}
// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeAircraftDocument()
{
var aircraftDocument = new CrudeAircraftDocumentServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = aircraftDocument.FetchWithFilter(
Guid.Empty
, Guid.Empty
, aircraftDocumentTypeRefCombo.Text
, textBoxDocumentName.Text
, dateTimePickerDocumentDateTime.Checked ? Convert.ToDateTime(dateTimePickerDocumentDateTime.Value): DateTime.MinValue
, dateTimePickerExpiryDateTime.Checked ? Convert.ToDateTime(dateTimePickerExpiryDateTime.Value): DateTime.MinValue
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeAircraftDocument.AutoGenerateColumns = false;
dataGridViewCrudeAircraftDocument.DataSource = bindingSource;
dataGridViewCrudeAircraftDocument.AutoResizeColumns();
dataGridViewCrudeAircraftDocument.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
aircraftDocument.Close();
}
}
// bring up edit form for AircraftDocument
// links:
// docLink: http://sql2x.org/documentationLink/d7ff032d-3bcf-438f-9850-900ca0ebca98
public void ShowAsEdit(System.Guid aircraftDocumentId)
{
var service = new CrudeAircraftDocumentServiceClient();
_isNew = false;
try {
_contract = service.FetchByAircraftDocumentId(aircraftDocumentId);
aircraftDocumentTypeRefCombo.Text = _contract.AircraftDocumentTypeRcd != null ? _contract.AircraftDocumentTypeRcd : String.Empty;
textBoxDocumentName.Text = _contract.DocumentName;
dateTimePickerDocumentDateTime.Value = _contract.DocumentDateTime != DateTime.MinValue ? _contract.DocumentDateTime : dateTimePickerDocumentDateTime.MinDate;
dateTimePickerDocumentDateTime.Checked = _contract.DocumentDateTime != DateTime.MinValue;
dateTimePickerExpiryDateTime.Value = _contract.ExpiryDateTime != DateTime.MinValue ? _contract.ExpiryDateTime : dateTimePickerExpiryDateTime.MinDate;
dateTimePickerExpiryDateTime.Checked = _contract.ExpiryDateTime != DateTime.MinValue;
userPicker.SelectedValue = _contract.UserId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
RefreshAircraftDocument();
Show();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
service.Close();
}
}
public ActionResult CrudeAircraftDocumentEdit(
System.Guid aircraftDocumentId
)
{
CrudeAircraftDocumentContract contract = new CrudeAircraftDocumentServiceClient().FetchByAircraftDocumentId(aircraftDocumentId);
ViewBag.AircraftId =
new SelectList(new CrudeAircraftServiceClient().FetchAll(),
"AircraftId",
"AircraftName",
contract.AircraftId
);
ViewBag.AircraftDocumentTypeRcd =
new SelectList(new CrudeAircraftDocumentTypeRefServiceClient().FetchAll(),
"AircraftDocumentTypeRcd",
"AircraftDocumentTypeName",
contract.AircraftDocumentTypeRcd
);
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
return(View(
"~/Views/Crude/Aircraft/CrudeAircraftDocument/CrudeAircraftDocumentEdit.cshtml",
contract
));
}
