// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid aircraftId)
{
var service = new CrudeAircraftServiceClient();
_isNew = false;
try {
_contract = service.FetchByAircraftId(aircraftId);
textBoxAircraftName.Text = _contract.AircraftName;
aircraftTypeRefCombo.Text = _contract.AircraftTypeRcd != null ? _contract.AircraftTypeRcd : String.Empty;
aircraftConfigurationRefCombo.Text = _contract.AircraftConfigurationRcd != null ? _contract.AircraftConfigurationRcd : String.Empty;
aircraftBodyRefCombo.Text = _contract.AircraftBodyRcd != null ? _contract.AircraftBodyRcd : String.Empty;
dateTimePickerOperationalDateTime.Value = _contract.OperationalDateTime != DateTime.MinValue ? _contract.OperationalDateTime : dateTimePickerOperationalDateTime.MinDate;
dateTimePickerOperationalDateTime.Checked = _contract.OperationalDateTime != DateTime.MinValue;
dateTimePickerFirstFlightDateTime.Value = _contract.FirstFlightDateTime != DateTime.MinValue ? _contract.FirstFlightDateTime : dateTimePickerFirstFlightDateTime.MinDate;
dateTimePickerFirstFlightDateTime.Checked = _contract.FirstFlightDateTime != DateTime.MinValue;
textBoxEngineType.Text = _contract.EngineType;
maskedTextBoxPassengerCapacity.Text = _contract.PassengerCapacity.ToString();
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();
}
}
// save and close Aircraft
// links:
// docLink: http://sql2x.org/documentationLink/d71519ff-fa27-4f64-9194-56886e4070ba
private void buttonSave_Click(object sender, EventArgs e)
{
var service = new CrudeAircraftServiceClient();
try {
_contract.AircraftName = textBoxAircraftName.Text;
_contract.AircraftTypeRcd = aircraftTypeRefCombo.Text;
_contract.AircraftConfigurationRcd = aircraftConfigurationRefCombo.Text;
_contract.AircraftBodyRcd = aircraftBodyRefCombo.Text;
_contract.OperationalDateTime = dateTimePickerOperationalDateTime.Checked ? Convert.ToDateTime(dateTimePickerOperationalDateTime.Value): DateTime.MinValue;
_contract.FirstFlightDateTime = dateTimePickerFirstFlightDateTime.Checked ? Convert.ToDateTime(dateTimePickerFirstFlightDateTime.Value): DateTime.MinValue;
_contract.EngineType = textBoxEngineType.Text;
_contract.PassengerCapacity = maskedTextBoxPassengerCapacity.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxPassengerCapacity.Text);
_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();
}
public ActionResult CrudeAircraftEdit(
System.Guid aircraftId
)
{
CrudeAircraftContract contract = new CrudeAircraftServiceClient().FetchByAircraftId(aircraftId);
ViewBag.AircraftTypeRcd =
new SelectList(new CrudeAircraftTypeRefServiceClient().FetchAll(),
"AircraftTypeRcd",
"AircraftTypeName",
contract.AircraftTypeRcd
);
ViewBag.AircraftConfigurationRcd =
new SelectList(new CrudeAircraftConfigurationRefServiceClient().FetchAll(),
"AircraftConfigurationRcd",
"AircraftConfigurationName",
contract.AircraftConfigurationRcd
);
ViewBag.AircraftBodyRcd =
new SelectList(new CrudeAircraftBodyRefServiceClient().FetchAll(),
"AircraftBodyRcd",
"AircraftBodyName",
contract.AircraftBodyRcd
);
ViewBag.ProductId =
new SelectList(new CrudeProductServiceClient().FetchAll(),
"ProductId",
"ProductName",
contract.ProductId
);
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
return(View(
"~/Views/Crude/Aircraft/CrudeAircraft/CrudeAircraftEdit.cshtml",
contract
));
}
public ActionResult AircraftMeasurementEdit(
System.Guid aircraftId
)
{
ViewBag.AircraftId = aircraftId;
// get right-side primary key from left-side entity
System.Guid aircraftMeasurementId = new CrudeAircraftServiceClient().FetchByAircraftId(aircraftId).AircraftMeasurementId;
// get right-side entity
CrudeAircraftMeasurementContract contract = new CrudeAircraftMeasurementServiceClient().FetchByAircraftMeasurementId(aircraftMeasurementId);
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
return(View(
"~/Views/Templates/Aircraft/AircraftMeasurement/AircraftMeasurementEdit.cshtml",
contract
));
}
// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeAircraft()
{
var aircraft = new CrudeAircraftServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = aircraft.FetchWithFilter(
Guid.Empty
, textBoxAircraftName.Text
, aircraftTypeRefCombo.Text
, aircraftConfigurationRefCombo.Text
, aircraftBodyRefCombo.Text
, Guid.Empty
, Guid.Empty
, dateTimePickerOperationalDateTime.Checked ? Convert.ToDateTime(dateTimePickerOperationalDateTime.Value): DateTime.MinValue
, dateTimePickerFirstFlightDateTime.Checked ? Convert.ToDateTime(dateTimePickerFirstFlightDateTime.Value): DateTime.MinValue
, textBoxEngineType.Text
, maskedTextBoxPassengerCapacity.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxPassengerCapacity.Text)
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeAircraft.AutoGenerateColumns = false;
dataGridViewCrudeAircraft.DataSource = bindingSource;
dataGridViewCrudeAircraft.AutoResizeColumns();
dataGridViewCrudeAircraft.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
aircraft.Close();
}
}
public ActionResult AircraftMeasurementEdit(
[Bind()] CrudeAircraftMeasurementContract contract,
System.Guid aircraftId
)
{
ViewBag.AircraftId = aircraftId;
if (ModelState.IsValid)
{
contract.DateTime = DateTime.UtcNow;
if (contract.AircraftMeasurementId == Guid.Empty)
{
// insert right-side entity
contract.AircraftMeasurementId = Guid.NewGuid();
contract.UserId = new System.Guid("{FFFFFFFF-5555-5555-5555-FFFFFFFFFFFF}");
new CrudeAircraftMeasurementServiceClient().Insert(contract);
// update left-side with right-side id
CrudeAircraftContract aircraftContract = new CrudeAircraftServiceClient().FetchByAircraftId(aircraftId);
aircraftContract.AircraftMeasurementId = contract.AircraftMeasurementId;
aircraftContract.DateTime = DateTime.UtcNow;
aircraftContract.UserId = new System.Guid("{FFFFFFFF-5555-5555-5555-FFFFFFFFFFFF}");
new CrudeAircraftServiceClient().Update(aircraftContract);
}
else
{
// update right-side entity
new CrudeAircraftMeasurementServiceClient().Update(contract);
}
}
return(View(
"~/Views/Templates/Aircraft/AircraftMeasurement/AircraftMeasurementEdit.cshtml",
contract
));
}