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