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 <ZanrGateway> Read3(SqlDataReader reader3)
{
Collection <ZanrGateway> Zanry = new Collection <ZanrGateway>();
while (reader3.Read())
{
ZanrGateway Zanr = new ZanrGateway();
Zanr.Nazev = reader3.GetString(0);
Zanr.Popis = reader3.GetString(1);
Zanry.Add(Zanr);
}
return(Zanry);
}
private Collection <ZanrGateway> Read2(SqlDataReader reader2)
{
Collection <ZanrGateway> Zanry = new Collection <ZanrGateway>();
while (reader2.Read())
{
ZanrGateway Zanr = new ZanrGateway();
Zanr.Id = reader2.GetInt32(0);
Zanr.Nazev = reader2.GetString(1);
Zanry.Add(Zanr);
}
return(Zanry);
}
public Collection <IPisnickaGateway> ReadFiltrZanr(SqlDataReader reader)
{
Collection <IPisnickaGateway> Pisnicky = new Collection <IPisnickaGateway>();
while (reader.Read())
{
IPisnickaGateway p = new PisnickaGateway();
IZanrGateway z = new ZanrGateway();
p.Id = reader.GetInt32(0);
p.Nazev = reader.GetString(1);
p.Zanr = z;
Pisnicky.Add(p);
}
return(Pisnicky);
}
public ZanrGateway SelectId(int id)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(selectZanr);
command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int));
command.Parameters["@id"].Value = id;
SqlDataReader reader3 = db.Select(command);
Collection <ZanrGateway> Zanry = Read3(reader3);
ZanrGateway Zanr = null;
if (Zanry.Count == 1)
{
Zanr = Zanry[0];
}
reader3.Close();
db.Close();
return(Zanr);
}
