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