public EditFlightPage(Flights_Table _currentFlight) { InitializeComponent(); currentFlight = _currentFlight; Title = currentFlight.AirlineName + " " + currentFlight.FlightNumber; conn = DependencyService.Get <ITravelApp_db>().GetConnection(); }
public FlightInfoPage(Flights_Table currentFlight) { InitializeComponent(); _currentFlight = currentFlight; Title = _currentFlight.AirlineName; conn = DependencyService.Get <ITravelApp_db>().GetConnection(); }
public FlightNotesPage(Flights_Table _currentFlight) { InitializeComponent(); currentFlight = _currentFlight; conn = DependencyService.Get <ITravelApp_db>().GetConnection(); Title = $"{currentFlight.AirlineName}" + " " + $"{ currentFlight.FlightNumber}" + " Notes"; courseNotesEditor.Text = $"{currentFlight.FlightNotes}"; }
private async void SaveButton_Clicked(object sender, EventArgs e) { string dDate1 = departDatePicker.Date.ToString("MM/dd/yyyy"); string dDate2 = DateTime.Today.Add(departTimePicker.Time).ToString(departTimePicker.Format); DateTime dDate3 = Convert.ToDateTime(dDate1 + " " + dDate2); string aDate1 = arriveDatePicker.Date.ToString("MM/dd/yyyy"); string aDate2 = DateTime.Today.Add(arriveTimePicker.Time).ToString(arriveTimePicker.Format); DateTime aDate3 = Convert.ToDateTime(aDate1 + " " + aDate2); var newFlightInfo = new Flights_Table(); newFlightInfo.AirlineName = airlineNameEntry.Text; newFlightInfo.FlightNumber = flightNumberEntry.Text; newFlightInfo.DepartGate = departGateEntry.Text; newFlightInfo.DepartLocation = departLocEntry.Text; newFlightInfo.DepartTime = dDate3; newFlightInfo.ArriveLocation = arriveLocEntry.Text; newFlightInfo.ArriveTime = aDate3; newFlightInfo.FlightNotifications = notificationSwitch.IsToggled == true ? 1 : 0; newFlightInfo.TripId = currentTrip.TripId; if ((UserHelper.IsNull(airlineNameEntry.Text) || UserHelper.IsNull(flightNumberEntry.Text))) { if (newFlightInfo.DepartLocation.Length <= 3 || newFlightInfo.ArriveLocation.Length <= 3) { if (newFlightInfo.DepartTime <= newFlightInfo.ArriveTime) { conn.Insert(newFlightInfo); await DisplayAlert("Notice", "Flight added!", "Ok"); await Navigation.PopModalAsync(); } else { await DisplayAlert("Warning", "Arrival Date and Time cannot be before Departure Date and Time", "Ok"); } } else { await DisplayAlert("Warning", "Airport code may only contain 3 letters", "Ok"); } } else { await DisplayAlert("Warning", "Airline Name and Flight Number are required", "Ok"); } }
private async void Flight_Tapped(object sender, ItemTappedEventArgs e) { Flights_Table currentFlight = (Flights_Table)e.Item; await Navigation.PushAsync(new FlightInfoPage(currentFlight)); }
public MainPage() { InitializeComponent(); Title = "Welcome"; conn = DependencyService.Get <ITravelApp_db>().GetConnection(); NavigationPage.SetHasNavigationBar(this.Main, true); conn.CreateTable <Admin_Table>(); conn.CreateTable <User_Table>(); conn.CreateTable <Trips_Table>(); conn.CreateTable <Flights_Table>(); conn.CreateTable <Dining_Table>(); conn.CreateTable <Entertainment_Table>(); conn.CreateTable <Lodging_Table>(); conn.CreateTable <Transportation_Table>(); var _UserList = conn.Query <User_Table>($"SELECT * FROM User_Table"); var adminList = conn.Query <Admin_Table>($"SELECT * FROM Admin_Table"); if (!adminList.Any()) { var admin = new Admin_Table(); admin.AdminUserName = "******"; admin.AdminPassword = "******"; admin.AdminEmail = "*****@*****.**"; conn.Insert(admin); adminList.Add(admin); } if (!_UserList.Any()) { #region User Data var newUser = new User_Table(); newUser.UserName = "******"; newUser.Password = "******"; newUser.FirstName = "User"; newUser.LastName = "Test"; newUser.UserEmail = "*****@*****.**"; conn.Insert(newUser); _UserList.Add(newUser); var newUser1 = new User_Table(); newUser1.UserName = "******"; newUser1.Password = "******"; newUser1.FirstName = "John"; newUser1.LastName = "Doe"; newUser1.UserEmail = "*****@*****.**"; conn.Insert(newUser1); _UserList.Add(newUser1); #endregion #region Trips Data var newTrip2 = new Trips_Table(); newTrip2.UserName = newUser.UserName; newTrip2.TripName = "Disneyland 2021"; newTrip2.TripStart = new DateTime(2021, 11, 12); newTrip2.TripEnd = new DateTime(2021, 11, 17); newTrip2.Notes = "We're In Disneyland Evan"; newTrip2.TripNotifications = 0; newTrip2.UserId = newUser.UserId; conn.Insert(newTrip2); var newTrip3 = new Trips_Table(); newTrip3.UserName = newUser1.UserName; newTrip3.TripName = "Utah 2020"; newTrip3.TripStart = new DateTime(2020, 11, 12); newTrip3.TripEnd = new DateTime(2020, 11, 17); newTrip3.Notes = "Request time off"; newTrip3.TripNotifications = 1; newTrip3.UserId = newUser1.UserId; conn.Insert(newTrip3); #endregion #region Dining Data var newRes = new Dining_Table(); newRes.ResName = "Carnation Cafe"; newRes.ResAddress = "Disneyland Park, Anaheim, CA 92802"; newRes.ResPhone = "(714)781-3463"; newRes.ResDate = DateTime.Today; newRes.ResNotes = "Dinner with my wife"; newRes.ResNotifications = 1; newRes.TripId = newTrip2.TripId; conn.Insert(newRes); var newRes2 = new Dining_Table(); newRes2.ResName = "Rainforest Cafe"; newRes2.ResAddress = "123 Downtown Disney District, Anaheim, CA 92802"; newRes2.ResPhone = "(714)866-5555"; newRes2.ResDate = new DateTime(2020, 11, 12); newRes2.ResNotes = "Birthday Dinner"; newRes2.ResNotifications = 1; newRes2.TripId = newTrip2.TripId; conn.Insert(newRes2); #endregion #region Entertainment Data var newActivity = new Entertainment_Table(); newActivity.EntertainName = "Disneyland"; newActivity.EntertaninStart = new DateTime(2020, 11, 12, 08, 00, 00); newActivity.EntertainEnd = new DateTime(2020, 11, 12, 23, 00, 00); newActivity.EnterainAddress = "1313 Disneyland Dr, Anaheim, CA 92802"; newActivity.EntertainPhone = "(714)781-4636"; newActivity.EntertainNotes = "Get to the park at 7:00"; newActivity.EntertainNotifications = 1; newActivity.TripId = newTrip2.TripId; conn.Insert(newActivity); var newActivity2 = new Entertainment_Table(); newActivity2.EntertainName = "Disneyland"; newActivity2.EntertaninStart = new DateTime(2020, 11, 14, 07, 00, 00); newActivity2.EntertainEnd = new DateTime(2020, 11, 15, 00, 00, 00); newActivity2.EnterainAddress = "1313 Disneyland Dr, Anaheim, CA 92802"; newActivity2.EntertainPhone = "(714)781-4636"; newActivity2.EntertainNotes = "Get to the park at 6:00"; newActivity2.EntertainNotifications = 1; newActivity2.TripId = newTrip2.TripId; conn.Insert(newActivity2); #endregion #region Flights Data var newflight = new Flights_Table(); newflight.FlightNumber = "SWA123"; newflight.AirlineName = "Southwest"; newflight.DepartTime = new DateTime(2020, 11, 12, 1, 45, 00); newflight.ArriveTime = new DateTime(2020, 11, 12, 3, 30, 00); newflight.DepartLocation = "SLC"; newflight.ArriveLocation = "LAX"; newflight.DepartGate = "A5"; newflight.FlightNotifications = 1; newflight.TripId = newTrip2.TripId; conn.Insert(newflight); var newflight1 = new Flights_Table(); newflight1.FlightNumber = "SWA987"; newflight1.AirlineName = "Southwest"; newflight1.DepartTime = new DateTime(2020, 11, 17, 8, 00, 00); newflight1.ArriveTime = new DateTime(2020, 11, 17, 10, 10, 00); newflight1.DepartLocation = "LAX"; newflight1.ArriveLocation = "SLC"; newflight1.DepartGate = "G13"; newflight1.FlightNotifications = 0; newflight1.TripId = newTrip2.TripId; conn.Insert(newflight1); #endregion #region Lodging Data var newLodge = new Lodging_Table(); newLodge.LodgeName = "Best Western Plus Pavilions"; newLodge.LodgeLocation = "1176 W Katella Ave, Anaheim, CA 92802"; newLodge.LodgePhone = "(714)776-0140"; newLodge.LodgeStart = new DateTime(2020, 11, 12, 11, 00, 00); newLodge.LodgeEnd = new DateTime(2020, 11, 15, 9, 00, 00); newLodge.LodgeNotifications = 1; newLodge.TripId = newTrip2.TripId; conn.Insert(newLodge); var newLodge1 = new Lodging_Table(); newLodge1.LodgeName = "Best Western Plus Stovals"; newLodge1.LodgeLocation = "1100 W Katella Ave, Anaheim, CA 92802"; newLodge1.LodgePhone = "(714)776-5555"; newLodge1.LodgeStart = new DateTime(2020, 11, 15, 11, 00, 00); newLodge1.LodgeEnd = new DateTime(2020, 11, 17, 9, 00, 00); newLodge1.LodgeNotifications = 0; newLodge1.TripId = newTrip2.TripId; conn.Insert(newLodge1); #endregion #region Transportation Data var newRental = new Transportation_Table(); newRental.RentalName = "Hertz"; newRental.ConfNumber = "1E0C2G"; newRental.PickUpDate = new DateTime(2020, 11, 12); newRental.ReturnDate = new DateTime(2020, 11, 17); newRental.PickUpLocation = "Los Angeles International Airport"; newRental.ReturnLocation = "Los Angeles International Airport"; newRental.RentalPhone = "(555)888-5555"; newRental.RentalNotifications = 1; newRental.TripId = newTrip2.TripId; conn.Insert(newRental); #endregion } }