private static Festival VerwerkRij(IDataRecord rij)
{
Festival nieuw = new Festival();
nieuw.StartDate = rij["StartDate"].ToString();
nieuw.EndDate = rij["StartDate"].ToString();
return nieuw;
}
public static Festival GetData()
{
Festival nieuw= new Festival();
string sql = "SELECT * FROM Festival";
DbDataReader reader = Database.GetData(sql);
while (reader.Read())
{
nieuw = VerwerkRij(reader);
}
return nieuw;
}
public static void AddType(Festival festi)
{
try
{
DbParameter paramstart = Database.AddParameter("@start", festi.StartDate);
DbParameter paramend = Database.AddParameter("@end", festi.EndDate);
Database.ModifyData("INSERT INTO Festival (StartDate,EndDate) values (@start,@end)",paramstart,paramend);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}