private static void PrepareCommand(SqlCommand command, Historia_pristupu historia_pristupu)
{
command.Parameters.AddWithValue("@id_historia", historia_pristupu.RecordId);
command.Parameters.AddWithValue("@datum", historia_pristupu.Date);
command.Parameters.AddWithValue("@id_hardware", historia_pristupu.IdHardware);
command.Parameters.AddWithValue("@id_zamestnanca", historia_pristupu.IdEmp);
}
private Collection <T> Read(SqlDataReader reader, bool withItemsCount = false)
{
Collection <T> historia_pristupus = new Collection <T>();
while (reader.Read())
{
Historia_pristupu historia_pristupu = new Historia_pristupu();
int i = -1;
historia_pristupu.RecordId = reader.GetInt32(++i);
historia_pristupu.Date = reader.GetDateTime(++i);
historia_pristupu.IdEmp = reader.GetInt32(++i);
historia_pristupu.IdHardware = reader.GetInt32(++i);
historia_pristupus.Add((T)historia_pristupu);
}
return(historia_pristupus);
}
private void gridAktivita_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (gridAktivita.Columns[e.ColumnIndex].Name == "Pritomny")
{
ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory();
ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec();
zamestananec = zg.Select();
Active t = GetSelectedData();
DateTime date1 = DateTime.Now;
foreach (var i in zamestananec)
{
if (t.Name.Equals(i.Name, StringComparison.Ordinal) && t.Surname.Equals(i.LastName, StringComparison.Ordinal))
{
Historia_pristupuFactory historia_pristupuFactory = new Historia_pristupuFactory();
Historia_pristupuGateway <Historia_pristupu> hg = (Historia_pristupuGateway <Historia_pristupu>)historia_pristupuFactory.GetHistoria_pristupu();
Historia_pristupu h = new Historia_pristupu(date1, i.RecordId, 37);
hg.Insert(h);
show();
}
}
}
}
