//festival datum + naam ophalen uit database
public static Festival GetFestival()
{
Festival festival = new Festival();
DateTime today = DateTime.Today;
String sSQL = "SELECT * FROM Festival";
DbDataReader reader = Database.GetData(sSQL);
while (reader.Read())
{
Festival fes = new Festival();
fes.Name = !Convert.IsDBNull((string)reader["FestivalName"]) ? (string)reader["FestivalName"] : "";
fes.StartDate = !Convert.IsDBNull((DateTime)reader["StartDate"]) ? (DateTime)reader["StartDate"] : today;
fes.EndDate = !Convert.IsDBNull((DateTime)reader["EndDate"]) ? (DateTime)reader["EndDate"] : today;
festival = fes;
}
if (festival.Name == null)
{
festival.StartDate = today;
festival.EndDate = today;
festival.Name = "";
}
return(festival);
}
//Festival datum + naam updaten
public static void SaveFestival(Festival editFestival)
{
String sSQL = "UPDATE Festival SET FestivalName = @Name, StartDate = @StartDate, EndDate = @EndDate";
DbParameter par1 = Database.AddParameter("@Name", editFestival.Name);
DbParameter par2 = Database.AddParameter("@StartDate", editFestival.StartDate);
DbParameter par3 = Database.AddParameter("@EndDate", editFestival.EndDate);
Database.ModifyData(sSQL, par1, par2, par3);
}