// bring up add form for Airport
// links:
// docLink: http://sql2x.org/documentationLink/c0944961-8179-40a2-a561-c8873b691f2c
public void ShowAsAdd()
{
_contract = new CrudeAirportContract();
_isNew = true;
RefreshAirport();
Show();
}
// 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();
}
}
// bring up add form for Airport by foreign key Timezone
// links:
// docLink: http://sql2x.org/documentationLink/2461e69c-dd05-47db-8f32-27ac1641a8d9
public void ShowAsAddByTimezone(System.Guid timezoneId)
{
_contract = new CrudeAirportContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.TimezoneId = timezoneId;
RefreshAirport();
Show();
}
// bring up add form for Airport by foreign key AirportType
// links:
// docLink: http://sql2x.org/documentationLink/2461e69c-dd05-47db-8f32-27ac1641a8d9
public void ShowAsAddByAirportType(string airportTypeRcd)
{
_contract = new CrudeAirportContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.AirportTypeRcd = airportTypeRcd;
airportTypeRefCombo.Text = _contract.AirportTypeRcd != null ? _contract.AirportTypeRcd : String.Empty;
RefreshAirport();
Show();
}
// bring up add form for Airport by foreign key City
// links:
// docLink: http://sql2x.org/documentationLink/2461e69c-dd05-47db-8f32-27ac1641a8d9
public void ShowAsAddByCity(System.Guid cityId)
{
_contract = new CrudeAirportContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.CityId = cityId;
cityPicker.SelectedValue = _contract.CityId;
RefreshAirport();
Show();
}
// bring up add form for Airport with rules
// links:
// docLink: http://sql2x.org/documentationLink/6018e96e-28a1-4df4-879b-01a6bda81cc7
public void ShowAsAddByRules(System.Guid userId)
{
_contract = new CrudeAirportContract();
_isNew = true;
_contract.UserId = userId;
userPicker.SelectedValue = _contract.UserId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
RefreshAirport();
Show();
}
public ActionResult CrudeAirportCreate([Bind()] CrudeAirportContract contract)
{
if (ModelState.IsValid)
{
new CrudeAirportServiceClient().Insert(contract);
return(RedirectToAction("CrudeAirportIndex"));
}
return(View(
"~/Views/Crude/Airport/CrudeAirport/CrudeAirportCreate.cshtml",
contract
));
}
// shows the form with default values for comboboxes and pickers
// links:
// docLink: http://sql2x.org/documentationLink/f5685d96-a0bb-4f7b-beaa-b3d578c7cf28
public void ShowAsAdd(string airportName, string airportTypeRcd, System.Guid cityId, System.Guid productId, decimal utcOffset, decimal elevationInMeters, decimal runwayInMeters, string latitude, string longitude, System.Guid timezoneId, string variation, string attendance, bool controlTowerFlag, System.DateTime activationDateTime, System.Guid userId)
{
try {
_contract = new CrudeAirportContract();
_isNew = true;
_contract.AirportName = airportName;
textBoxAirportName.Text = _contract.AirportName;
_contract.AirportTypeRcd = airportTypeRcd;
airportTypeRefCombo.Text = _contract.AirportTypeRcd != null ? _contract.AirportTypeRcd : String.Empty;
_contract.CityId = cityId;
cityPicker.SelectedValue = _contract.CityId;
_contract.ProductId = productId;
_contract.UtcOffset = utcOffset;
maskedTextBoxUtcOffset.Text = _contract.UtcOffset.ToString();
_contract.ElevationInMeters = elevationInMeters;
maskedTextBoxElevationInMeters.Text = _contract.ElevationInMeters.ToString();
_contract.RunwayInMeters = runwayInMeters;
maskedTextBoxRunwayInMeters.Text = _contract.RunwayInMeters.ToString();
_contract.Latitude = latitude;
textBoxLatitude.Text = _contract.Latitude;
_contract.Longitude = longitude;
textBoxLongitude.Text = _contract.Longitude;
_contract.TimezoneId = timezoneId;
_contract.Variation = variation;
textBoxVariation.Text = _contract.Variation;
_contract.Attendance = attendance;
textBoxAttendance.Text = _contract.Attendance;
_contract.ControlTowerFlag = controlTowerFlag;
checkBoxControlTowerFlag.Checked = _contract.ControlTowerFlag;
_contract.ActivationDateTime = activationDateTime;
dateTimePickerActivationDateTime.Value = _contract.ActivationDateTime != DateTime.MinValue ? _contract.ActivationDateTime : dateTimePickerActivationDateTime.MinDate;
dateTimePickerActivationDateTime.Checked = _contract.ActivationDateTime != DateTime.MinValue;
_contract.UserId = userId;
userPicker.SelectedValue = userId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
public ActionResult CrudeAirportEdit([Bind()] CrudeAirportContract contract)
{
if (ModelState.IsValid)
{
contract.DateTime = DateTime.UtcNow;
new CrudeAirportServiceClient().Update(contract);
return(RedirectToAction("CrudeAirportIndex"));
}
return(View(
"~/Views/Crude/Airport/CrudeAirport/CrudeAirportEdit.cshtml",
contract
));
}
// shows the form with default values for comboboxes and pickers
// links:
// docLink: http://sql2x.org/documentationLink/e04d0806-55ef-41cc-8669-acf0ddd850c7
public void ShowAsAdd()
{
try {
_contract = new CrudeAirportContract();
_isNew = true;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// shows by foreign keys
// links:
// docLink: http://sql2x.org/documentationLink/f21e72c1-2d57-44c1-a9c1-1b80bad6a391
public void ShowAsAddByTimezone(System.Guid timezoneId)
{
try {
_contract = new CrudeAirportContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.TimezoneId = timezoneId;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// shows the form with default values for comboboxes and pickers
// links:
// docLink: http://sql2x.org/documentationLink/599dcb45-f71b-4672-bb18-46975a4fe9b3
public void ShowAsAddByRules(System.Guid userId)
{
try {
_contract = new CrudeAirportContract();
_isNew = true;
_contract.UserId = userId;
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();
}
}
}
// shows by foreign keys
// links:
// docLink: http://sql2x.org/documentationLink/f21e72c1-2d57-44c1-a9c1-1b80bad6a391
public void ShowAsAddByAirportType(string airportTypeRcd)
{
try {
_contract = new CrudeAirportContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.AirportTypeRcd = airportTypeRcd;
airportTypeRefCombo.Text = _contract.AirportTypeRcd != null ? _contract.AirportTypeRcd : String.Empty;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// 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());
}
}
}
public ActionResult CrudeAirportCreate(System.Guid?cityId, System.Guid?productId, System.Guid?timezoneId, System.Guid?userId)
{
var contract = new CrudeAirportContract();
if (cityId != null)
{
contract.CityId = (System.Guid)cityId;
}
if (productId != null)
{
contract.ProductId = (System.Guid)productId;
}
if (timezoneId != null)
{
contract.TimezoneId = (System.Guid)timezoneId;
}
if (userId != null)
{
contract.UserId = (System.Guid)userId;
}
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
);
contract.ActivationDateTime = DateTime.UtcNow;
if (userId == null)
{
contract.UserId = new System.Guid("{FFFFFFFF-5555-5555-5555-FFFFFFFFFFFF}");
}
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
contract.DateTime = DateTime.UtcNow;
return(View(
"~/Views/Crude/Airport/CrudeAirport/CrudeAirportCreate.cshtml",
contract
));
}
