public List <Tilmeldinger> readList()
{
List <Tilmeldinger> tilmeldingerList = new List <Tilmeldinger>();
openConnection();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format("select arrangementId, brugerId, createTs, erTilmeldt, spiser from Tilmeldinger");
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Tilmeldinger tilmeldinger = new Tilmeldinger();
tilmeldinger.arrangementId = reader.GetInt64("arrangementId");
tilmeldinger.brugerId = reader.GetString("brugerId");
tilmeldinger.createTs = reader.GetDateTime("createTs");
tilmeldinger.erTilmeldtChar = reader.GetChar("erTilmeldt");
tilmeldinger.spiserChar = reader.GetChar("spiser");
tilmeldingerList.Add(tilmeldinger);
}
closeConnection();
return(tilmeldingerList);
}
public Tilmeldinger read(long arrangementId, string brugerId)
{
openConnection();
Tilmeldinger tilmeldinger = new Tilmeldinger();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format("select arrangementId, brugerId, createTs, erTilmeldt, spiser from Tilmeldinger where arrangementId={0} and brugerId='{1}'", arrangementId, brugerId);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
tilmeldinger.arrangementId = reader.GetInt64("arrangementId");
tilmeldinger.brugerId = reader.GetString("brugerId");
tilmeldinger.createTs = reader.GetDateTime("createTs");
tilmeldinger.erTilmeldtChar = reader.GetChar("erTilmeldt");
tilmeldinger.spiserChar = reader.GetChar("spiser");
}
closeConnection();
return(tilmeldinger);
}
