public ActionResult BookieSearchWithOrigin(
string originRcd
)
{
CrudeAirportContract origin = new CrudeAirportServiceClient().FetchByAirportName(originRcd);
var contract = new BookieContract();
contract.DepartureAirportId = origin.AirportId;
contract.FromDateTime = DateTime.UtcNow.Date;
contract.UntilDateTime = contract.FromDateTime.AddDays(1);
contract.Flights =
new FlightSearchService().FlightsForBookingWithFare(
contract.DepartureAirportId,
contract.ArrivalAirportId,
contract.FromDateTime,
contract.UntilDateTime
);
return(View(
MVCHelper.Resolve(Request, "Bookie", "BookieSearch"),
contract
));
}
// save and close Airport
// links:
// docLink: http://sql2x.org/documentationLink/d71519ff-fa27-4f64-9194-56886e4070ba
private void buttonSave_Click(object sender, EventArgs e)
{
var service = new CrudeAirportServiceClient();
try {
_contract.AirportName = textBoxAirportName.Text;
_contract.AirportTypeRcd = airportTypeRefCombo.Text;
_contract.CityId = (Guid)cityPicker.SelectedValue;
_contract.UtcOffset = maskedTextBoxUtcOffset.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxUtcOffset.Text);
_contract.ElevationInMeters = maskedTextBoxElevationInMeters.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxElevationInMeters.Text);
_contract.RunwayInMeters = maskedTextBoxRunwayInMeters.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxRunwayInMeters.Text);
_contract.Latitude = textBoxLatitude.Text;
_contract.Longitude = textBoxLongitude.Text;
_contract.Variation = textBoxVariation.Text;
_contract.Attendance = textBoxAttendance.Text;
_contract.ControlTowerFlag = Convert.ToBoolean(checkBoxControlTowerFlag.Checked);
_contract.ActivationDateTime = dateTimePickerActivationDateTime.Checked ? Convert.ToDateTime(dateTimePickerActivationDateTime.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();
}
// bring up edit form for Airport
// links:
// docLink: http://sql2x.org/documentationLink/d7ff032d-3bcf-438f-9850-900ca0ebca98
public void ShowAsEdit(System.Guid airportId)
{
var service = new CrudeAirportServiceClient();
_isNew = false;
try {
_contract = service.FetchByAirportId(airportId);
textBoxAirportName.Text = _contract.AirportName;
airportTypeRefCombo.Text = _contract.AirportTypeRcd != null ? _contract.AirportTypeRcd : String.Empty;
cityPicker.SelectedValue = _contract.CityId;
maskedTextBoxUtcOffset.Text = _contract.UtcOffset.ToString();
maskedTextBoxElevationInMeters.Text = _contract.ElevationInMeters.ToString();
maskedTextBoxRunwayInMeters.Text = _contract.RunwayInMeters.ToString();
textBoxLatitude.Text = _contract.Latitude;
textBoxLongitude.Text = _contract.Longitude;
textBoxVariation.Text = _contract.Variation;
textBoxAttendance.Text = _contract.Attendance;
checkBoxControlTowerFlag.Checked = _contract.ControlTowerFlag;
dateTimePickerActivationDateTime.Value = _contract.ActivationDateTime != DateTime.MinValue ? _contract.ActivationDateTime : dateTimePickerActivationDateTime.MinDate;
dateTimePickerActivationDateTime.Checked = _contract.ActivationDateTime != DateTime.MinValue;
userPicker.SelectedValue = _contract.UserId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
RefreshAirport();
Show();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
service.Close();
}
}
public ActionResult CrudeAirportEdit(
System.Guid airportId
)
{
CrudeAirportContract contract = new CrudeAirportServiceClient().FetchByAirportId(airportId);
ViewBag.AirportTypeRcd =
new SelectList(new CrudeAirportTypeRefServiceClient().FetchAll(),
"AirportTypeRcd",
"AirportTypeName",
contract.AirportTypeRcd
);
ViewBag.CityId =
new SelectList(new CrudeCityServiceClient().FetchAll(),
"CityId",
"CityName",
contract.CityId
);
ViewBag.ProductId =
new SelectList(new CrudeProductServiceClient().FetchAll(),
"ProductId",
"ProductName",
contract.ProductId
);
ViewBag.TimezoneId =
new SelectList(new CrudeTimezoneServiceClient().FetchAll(),
"TimezoneId",
"TimezoneName",
contract.TimezoneId
);
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
return(View(
"~/Views/Crude/Airport/CrudeAirport/CrudeAirportEdit.cshtml",
contract
));
}
// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeAirport()
{
var airport = new CrudeAirportServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = airport.FetchWithFilter(
Guid.Empty
, textBoxAirportName.Text
, airportTypeRefCombo.Text
, cityPicker.SelectedValue
, Guid.Empty
, maskedTextBoxUtcOffset.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxUtcOffset.Text)
, maskedTextBoxElevationInMeters.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxElevationInMeters.Text)
, maskedTextBoxRunwayInMeters.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxRunwayInMeters.Text)
, textBoxLatitude.Text
, textBoxLongitude.Text
, Guid.Empty
, textBoxVariation.Text
, textBoxAttendance.Text
, Convert.ToBoolean(checkBoxControlTowerFlag.Checked)
, dateTimePickerActivationDateTime.Checked ? Convert.ToDateTime(dateTimePickerActivationDateTime.Value): DateTime.MinValue
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeAirport.AutoGenerateColumns = false;
dataGridViewCrudeAirport.DataSource = bindingSource;
dataGridViewCrudeAirport.AutoResizeColumns();
dataGridViewCrudeAirport.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
airport.Close();
}
}
// populates the Picker with the first match from the SOAP service
// links:
// docLink: http://sql2x.org/documentationLink/3e8b9e1a-39eb-444f-9632-ce3406db3534
private void txtAirportCode_Validating(object sender, CancelEventArgs e)
{
if (!DesignMode)
{
// empty picker on no code
if (string.IsNullOrEmpty(txtAirportCode.Text))
{
_airportId = Guid.Empty;
txtAirportName.Text = string.Empty;
txtAirportCode.Text = string.Empty;
return;
}
CrudeAirportServiceClient airport = null;
try {
airport = new CrudeAirportServiceClient();
CrudeAirportContract contract = airport.FetchByAirportName(txtAirportCode.Text);
if (contract != null)
{
txtAirportCode.Text = contract.AirportName;
txtAirportName.Text = contract.AirportName;
_airportId = contract.AirportId;
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
if (airport != null)
{
airport.Close();
}
}
if (this.Picked != null)
{
this.Picked(new object(), new EventArgs());
}
}
}
