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