private Collection <T> Read(SqlDataReader reader, bool withItemsCount = false)
{
Collection <T> nepritomnosts = new Collection <T>();
while (reader.Read())
{
Nepritomnost nepritomnost = new Nepritomnost();
int i = -1;
nepritomnost.RecordId = reader.GetInt32(++i);
nepritomnost.Zamestnanec = reader.GetInt32(++i);
nepritomnost.Datum = reader.GetDateTime(++i);
nepritomnosts.Add((T)nepritomnost);
}
return(nepritomnosts);
}
private void button1_Click_2(object sender, EventArgs e)
{
string a;
Collection <Active> active = new Collection <Active>();
foreach (var i in pracovisko)
{
if (i.Name.Equals(pracoviskoCombo.Text, StringComparison.Ordinal))
{
ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory();
ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec();
a = zg.AktualnePritomny(i.RecordId, null);
string[] words = a.Split(';');
foreach (var word in words)
{
string[] words2 = word.Split(',');
int counter = 0;
bool b = false;
Active t = new Active();
foreach (var word1 in words2)
{
if (counter == 0)
{
t.Name = word1;
}
if (counter == 1)
{
t.Surname = word1;
}
if (counter == 2)
{
t.State = word1;
if (t.State == "Nepritomny")
{
NepritomnostFactory nepritomnostFactory = new NepritomnostFactory();
NepritomnostGateway <Nepritomnost> ng = (NepritomnostGateway <Nepritomnost>)nepritomnostFactory.GetNepritomnost();
Zamestnanec z = zg.Select_name(t.Name, t.Surname);
Collection <Nepritomnost> za = ng.Select();
int id = 0;
foreach (var nep in za)
{
if (nep.RecordId > id)
{
id = nep.RecordId;
}
}
id++;
Nepritomnost n = new Nepritomnost(id, z.RecordId, DateTime.Now);
ng.Insert(n);
}
b = true;
}
counter++;
}
if (b)
{
active.Add(t);
}
}
}
}
}
private void PrepareCommand(SqlCommand command, Nepritomnost nepritomnost)
{
command.Parameters.AddWithValue("@id_nepritomnost", nepritomnost.RecordId);
command.Parameters.AddWithValue("@datum", nepritomnost.Datum);
command.Parameters.AddWithValue("@zamestnanec", nepritomnost.Zamestnanec);
}
