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