//tickettypes ophalen
public static ObservableCollection <TicketType> GetTicketTypes()
{
ObservableCollection <TicketType> ticketTypes = new ObservableCollection <TicketType>();
string sSQL = "Select * FROM TicketType";
DbDataReader reader = Database.GetData(sSQL);
while (reader.Read())
{
TicketType t = new TicketType();
int ID = (int)reader["ID"];
t._ID = Convert.ToString(ID);
t.Name = !Convert.IsDBNull((string)reader["Name"]) ? (string)reader["Name"] : "";
t.Price = Convert.ToInt32(!Convert.IsDBNull((decimal)reader["Price"]) ? (decimal)reader["Price"] : 0);
t.AvailableTickets = !Convert.IsDBNull((int)reader["AvailableTickets"]) ? (int)reader["AvailableTickets"] : 0;
ticketTypes.Add(t);
}
return(ticketTypes);
}
public static TicketType GetTicketByName(String TicketName)
{
ObservableCollection <TicketType> TicketNames = TicketType.GetTicketTypes();
return(TicketNames.Where(tt => tt._Name == TicketName).SingleOrDefault());
}
public static TicketType GetTicketTypeByID(String TicketTypeID)
{
ObservableCollection <TicketType> TicketID = TicketType.GetTicketTypes();
return(TicketID.Where(tt => tt._ID == TicketTypeID).SingleOrDefault());
}