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()); } } }