protected override Collection <Material> Read(SqlDataReader reader) { Collection <Material> materialy = new Collection <Material>(); PredmetTable predmetTable = new PredmetTable(); UzivatelTable uzivatelTable = new UzivatelTable(); while (reader.Read()) { int i = -1; Material material = new Material(); material.MId = reader.GetInt32(++i); material.Typ = reader.GetString(++i); material.Dokument = reader.GetString(++i); material.Datum = reader.GetDateTime(++i); material.Okruh = reader.GetString(++i); material.Overeny = reader.GetInt32(++i); material.Predmet = predmetTable.SelectByID(reader.GetInt32(++i)); material.Uzivatel = uzivatelTable.SelectByID(reader.GetInt32(++i)); materialy.Add(material); } return(materialy); }
protected override Collection <Upozorneni> Read(SqlDataReader reader) { Collection <Upozorneni> upozorneni = new Collection <Upozorneni>(); UzivatelTable UzivatelTable = new UzivatelTable(); while (reader.Read()) { int i = -1; Upozorneni u = new Upozorneni(); u.UId = reader.GetInt32(++i); u.Predmet = reader.GetString(++i); u.Zprava = reader.GetString(++i); u.Datum = reader.GetDateTime(++i); u.Od = UzivatelTable.SelectByID(reader.GetInt32(++i)); u.Adresat = UzivatelTable.SelectByID(reader.GetInt32(++i)); upozorneni.Add(u); } return(upozorneni); }
protected override Collection <Provedl> Read(SqlDataReader reader) { Collection <Provedl> zaznamy = new Collection <Provedl>(); UzivatelTable uzivatelTable = new UzivatelTable(); RevizeTable revizeTable = new RevizeTable(); while (reader.Read()) { int i = -1; Provedl p = new Provedl(); p.Datum = reader.GetDateTime(++i); p.Uzivatel = uzivatelTable.SelectByID(reader.GetInt32(++i)); p.Revize = revizeTable.SelectByID(reader.GetInt32(++i)); zaznamy.Add(p); } return(zaznamy); }
protected override Collection <Hodnoceni> Read(SqlDataReader reader) { Collection <Hodnoceni> hodnoceni = new Collection <Hodnoceni>(); UzivatelTable uzivatelTable = new UzivatelTable(); PredmetTable predmetTable = new PredmetTable(); while (reader.Read()) { int i = -1; Hodnoceni h = new Hodnoceni(); h.Ohodnoceni = reader.GetInt32(++i); h.Popis = reader.GetString(++i); h.Datum = reader.GetDateTime(++i); h.Predmet = predmetTable.SelectByID(reader.GetInt32(++i)); h.Uzivatel = uzivatelTable.SelectByID(reader.GetInt32(++i)); hodnoceni.Add(h); } return(hodnoceni); }
protected override Collection <Predmet> Read(SqlDataReader reader) { Collection <Predmet> predmety = new Collection <Predmet>(); UzivatelTable ut = new UzivatelTable(); while (reader.Read()) { int i = -1; Predmet p = new Predmet() { PId = reader.GetInt32(++i), Nazev = reader.GetString(++i), Zkratka = reader.GetString(++i), Popis = reader.GetString(++i), Zakonceni = reader.GetString(++i), Spravce = ut.SelectByID(reader.GetInt32(++i)) }; predmety.Add(p); } return(predmety); }