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