public static void updatePlanesDataSet()
{
DBHandler.loadPlanes();
}
/// <summary>
/// Clears the database table. Returns False if the command did not complete.
/// </summary>
/// <returns></returns>
public static bool clearDB()
{
return(DBHandler.clearDataTables(DBHandler.PLANES_TABLE));
}
/// <summary>
/// Clears the database table. Returns False if the command did not complete.
/// </summary>
/// <returns></returns>
public static bool clearDB()
{
return DBHandler.clearDataTables(DBHandler.GUESTS_TABLE);
}
public static bool addPlane(string name, string model, int capacity, double mile_range, string currentLocation, double cruiseSpeed)
{
return(DBHandler.addPlane(name, model, capacity, mile_range, currentLocation, cruiseSpeed));
}
/// <summary>
/// Registers a guest in the database. Does not check for unique values, will retun false if the command does not complete.
/// </summary>
/// <param name="firstName">The first name.</param>
/// <param name="lastName">The last name.</param>
/// <param name="email">The email.</param>
/// <param name="phone">The phone.</param>
/// <param name="employeeID">The employee identifier.</param>
/// <returns></returns>
public static bool registerGuest(string firstName, string lastName, string email, string phone, int employeeID)
{
return DBHandler.registerGuest(firstName, lastName, email, phone, employeeID);
}
public static void updateGuestsDataTable()
{
DBHandler.loadGuests();
}
public static void updateResDataTable()
{
DBHandler.loadReservations();
}
/// <summary>
/// Clears the database table. Returns False if the command did not complete.
/// </summary>
/// <returns></returns>
public static bool clearDB()
{
return(DBHandler.clearDataTables(DBHandler.RESERVATIONS_TABLE));
}
/// <summary>
/// Registers a reservation with or without guests. Does not check for unique values, will retun false if the command does not complete.
/// </summary>
/// <param name="planeID">The plane identifier.</param>
/// <param name="employeeID">The employee identifier.</param>
/// <param name="destinationID">The destination identifier.</param>
/// <param name="date">The date.</param>
/// <param name="hasGuests">if set to <c>true</c> [has guests].</param>
/// <param name="guestsList">The guest's identifier list.</param>
/// <returns></returns>
public static bool RegisterReservation(int planeID, int employeeID, int destID, DateTime date, bool hasGuests, List <int> guestList)
{
return(DBHandler.registerReservation(planeID, employeeID, destID, date, hasGuests, guestList));
}
public static void updateGuestXResDataTable()
{
DBHandler.loadReservationsGuestsXRef();
}
/// <summary>
/// Registers a reservation without guests. Does not check for unique values, will retun false if the command does not complete.
/// </summary>
/// <param name="planeID">The plane identifier.</param>
/// <param name="employeeID">The employee identifier.</param>
/// <param name="destinationID">The destination identifier.</param>
/// <param name="date">The date.</param>
/// <returns></returns>
public static bool RegisterReservation(int planeID, int employeeID, int destID, DateTime date)
{
return(DBHandler.registerReservation(planeID, employeeID, destID, date));
}
public static void loadEmployees()
{
DBHandler.loadEmployees();
}
/// <summary>
/// Registers a new employee in the database. Does not check for unique values, will retun false if the command does not complete.
/// </summary>
/// <param name="firstName">first name.</param>
/// <param name="lastName">last name.</param>
/// <param name="email">email.</param>
/// <param name="phone">phone number.</param>
/// <param name="username">username.</param>
/// <param name="password">password.</param>
/// <returns></returns>
public static bool registerEmployee(string firstName, string lastName, string email, string phone, string username, string password)
{
return(DBHandler.registerEmployee(firstName, lastName, email, phone, username, password));
}
/// <summary>
/// Loads or reloads the destinations.
/// </summary>
public static void loadDestinations()
{
DBHandler.loadDestinations();
}
/// <summary>
/// Adds a destination to the database.
/// </summary>
/// <param name="location">The location.</param>
/// <param name="distanceFromLR">The distance from Little Rock.</param>
/// <returns>True if succesful</returns>
public static bool addDestination(string location, double distanceFromLR)
{
return(DBHandler.addDestination(location, distanceFromLR));
}
