public ActionResult CrudeFlightSegmentEdit(
System.Guid flightSegmentId
)
{
CrudeFlightSegmentContract contract = new CrudeFlightSegmentServiceClient().FetchByFlightSegmentId(flightSegmentId);
ViewBag.DepartureAirportId =
new SelectList(new CrudeAirportServiceClient().FetchAll(),
"AirportId",
"AirportName",
contract.DepartureAirportId
);
ViewBag.ArrivalAirportId =
new SelectList(new CrudeAirportServiceClient().FetchAll(),
"AirportId",
"AirportName",
contract.ArrivalAirportId
);
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
return(View(
"~/Views/Crude/Flight/CrudeFlightSegment/CrudeFlightSegmentEdit.cshtml",
contract
));
}
// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid flightSegmentId)
{
var service = new CrudeFlightSegmentServiceClient();
_isNew = false;
try {
_contract = service.FetchByFlightSegmentId(flightSegmentId);
departureAirportPicker.SelectedValue = _contract.DepartureAirportId;
arrivalAirportPicker.SelectedValue = _contract.ArrivalAirportId;
maskedTextBoxLogicalSegmentNumber.Text = _contract.LogicalSegmentNumber.ToString();
maskedTextBoxPhysicalSegmentNumber.Text = _contract.PhysicalSegmentNumber.ToString();
dateTimePickerFromDateTime.Value = _contract.FromDateTime != DateTime.MinValue ? _contract.FromDateTime : dateTimePickerFromDateTime.MinDate;
dateTimePickerFromDateTime.Checked = _contract.FromDateTime != DateTime.MinValue;
dateTimePickerUntilDateTime.Value = _contract.UntilDateTime != DateTime.MinValue ? _contract.UntilDateTime : dateTimePickerUntilDateTime.MinDate;
dateTimePickerUntilDateTime.Checked = _contract.UntilDateTime != DateTime.MinValue;
textBoxDepartureGate.Text = _contract.DepartureGate;
textBoxArrivalGate.Text = _contract.ArrivalGate;
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 CrudeFlightSegmentServiceClient();
try {
_contract.DepartureAirportId = (Guid)departureAirportPicker.SelectedValue;
_contract.ArrivalAirportId = (Guid)arrivalAirportPicker.SelectedValue;
_contract.LogicalSegmentNumber = maskedTextBoxLogicalSegmentNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxLogicalSegmentNumber.Text);
_contract.PhysicalSegmentNumber = maskedTextBoxPhysicalSegmentNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxPhysicalSegmentNumber.Text);
_contract.FromDateTime = dateTimePickerFromDateTime.Checked ? Convert.ToDateTime(dateTimePickerFromDateTime.Value): DateTime.MinValue;
_contract.UntilDateTime = dateTimePickerUntilDateTime.Checked ? Convert.ToDateTime(dateTimePickerUntilDateTime.Value): DateTime.MinValue;
_contract.DepartureGate = textBoxDepartureGate.Text;
_contract.ArrivalGate = textBoxArrivalGate.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 RefreshCrudeFlightSegment()
{
var flightSegment = new CrudeFlightSegmentServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = flightSegment.FetchWithFilter(
Guid.Empty
, Guid.Empty
, departureAirportPicker.SelectedValue
, arrivalAirportPicker.SelectedValue
, maskedTextBoxLogicalSegmentNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxLogicalSegmentNumber.Text)
, maskedTextBoxPhysicalSegmentNumber.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxPhysicalSegmentNumber.Text)
, dateTimePickerFromDateTime.Checked ? Convert.ToDateTime(dateTimePickerFromDateTime.Value): DateTime.MinValue
, dateTimePickerUntilDateTime.Checked ? Convert.ToDateTime(dateTimePickerUntilDateTime.Value): DateTime.MinValue
, textBoxDepartureGate.Text
, textBoxArrivalGate.Text
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeFlightSegment.AutoGenerateColumns = false;
dataGridViewCrudeFlightSegment.DataSource = bindingSource;
dataGridViewCrudeFlightSegment.AutoResizeColumns();
dataGridViewCrudeFlightSegment.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
flightSegment.Close();
}
}
