public Collection <IPisnickaGateway> Read(SqlDataReader reader) { Collection <IPisnickaGateway> Pisnicky = new Collection <IPisnickaGateway>(); while (reader.Read()) { IPisnickaGateway p = new PisnickaGateway(); IZanrGateway z = new ZanrGateway(); IAlbumGateway a = new AlbumGateway(); IInterpretGateway i = new InterpretGateway(); p.Nazev = reader.GetString(0); p.Delka = reader.GetString(1); p.Hodnoceni = reader.GetFloat(2); i.UmeleckeJmeno = reader.GetString(3); a.Nazev = reader.GetString(4); z.Nazev = reader.GetString(5); p.Id = reader.GetInt32(6); p.Zanr = z; p.Album = a; p.Interpret = i; Pisnicky.Add(p); } return(Pisnicky); }
private Collection <IAlbumGateway> Read2(SqlDataReader reader2) { Collection <IAlbumGateway> Alba = new Collection <IAlbumGateway>(); while (reader2.Read()) { IAlbumGateway Album = new AlbumGateway(); Album.Nazev = reader2.GetString(0); Alba.Add(Album); } return(Alba); }
private Collection <IAlbumGateway> Read(SqlDataReader reader) { Collection <IAlbumGateway> Alba = new Collection <IAlbumGateway>(); while (reader.Read()) { IAlbumGateway Album = new AlbumGateway(); //Album.setIdAlba(reader.GetInt32(0)); Album.Nazev = reader.GetString(0); Album.DatumVydani = reader.GetDateTime(1); Album.PocetPisnicek = reader.GetInt32(2); Alba.Add(Album); } return(Alba); }
public Collection <IPisnickaGateway> ReadFiltrAlbum(SqlDataReader reader) { Collection <IPisnickaGateway> Pisnicky = new Collection <IPisnickaGateway>(); while (reader.Read()) { IPisnickaGateway p = new PisnickaGateway(); IAlbumGateway a = new AlbumGateway(); IInterpretGateway i = new InterpretGateway(); p.Id = reader.GetInt32(0); p.Nazev = reader.GetString(1); p.Delka = reader.GetString(2); i.UmeleckeJmeno = reader.GetString(3); a.Nazev = reader.GetString(4); a.Id = reader.GetInt32(5); p.Album = a; p.Interpret = i; Pisnicky.Add(p); } return(Pisnicky); }