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