/// <summary> /// Gets list of reservations that belongs to a specific event /// </summary> /// <param name="EventID">EventID integer</param> /// <returns>A list of reservations</returns> public static List <Reservation> GetReservation(int EventID) { List <Reservation> ReservationList = new List <Reservation>(); Place Place; if (DatabaseConnectie.OpenConnection()) { try { DatabaseConnectie.OpenConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = DatabaseConnectie.connect; cmd.CommandText = "SELECT * FROM Reservering Where EventID = @EventID"; cmd.Parameters.Add(new SqlParameter("EventID", EventID)); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int ID = Convert.ToInt32(reader["ID"]); int PlaceID = (reader["PlaatsID"] != DBNull.Value) ? Convert.ToInt32(reader["PlaatsID"]) : 0; int Amount = Convert.ToInt32(reader["BetalingBedrag"]); bool Status = Convert.ToBoolean(reader["BetalingStatus"]); List <Account> Accountlist = DatabaseGetAccounts.GetAccountsReservation(ID); Event newEvent = DatabaseGetEvents.GetSingleEvent(EventID); if (PlaceID == 0) { Place = null; } else { Place = DatabaseGetPlace.GetPlace(PlaceID); } Reservation Reservation = new Reservation(ID, newEvent, new Payment(Amount, Status), Place, Accountlist); ReservationList.Add(Reservation); } return(ReservationList); } catch (SqlException e) { Console.WriteLine("Query Failed: " + e.StackTrace + e.Message.ToString()); } finally { DatabaseConnectie.CloseConnection(); } } return(ReservationList); }
/// <summary> /// Gets all events from the database /// </summary> /// <returns>A list with all events that are currently active</returns> public static List <Event> GetEvents() { List <Event> EventList = DatabaseGetEvents.GetEvents(); return(EventList); }