private static void PrepareCommand(SqlCommand command, Strelba Strelba)
{
command.Parameters.AddWithValue("@idStr", Strelba.idStr);
command.Parameters.AddWithValue("@Zacatek", Strelba.Zacatek);
command.Parameters.AddWithValue("@Konec", Strelba.Konec);
command.Parameters.AddWithValue("@Zbran_idZbr", Strelba.Zbran_idZbr);
command.Parameters.AddWithValue("@Zamestnanec_idZam", Strelba.Zamestnanec_idZam);
command.Parameters.AddWithValue("@Zakaznik_idZak", Strelba.Zakaznik_idZak);
command.Parameters.AddWithValue("@Prostor_idSpr", Strelba.Prostor_idSpr);
}
public static int update(Strelba Strelba)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, Strelba);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
private static Collection <Strelba> Read(SqlDataReader reader, bool withItemsCount = false)
{
Collection <Strelba> strelby = new Collection <Strelba>();
while (reader.Read())
{
Strelba strelba = new Strelba();
int i = -1;
strelba.idStr = reader.GetInt32(++i);
strelba.Zacatek = reader.GetDateTime(++i);
strelba.Konec = reader.GetDateTime(++i);
strelba.Zbran_idZbr = reader.GetInt32(++i);
strelba.Zamestnanec_idZam = reader.GetInt32(++i);
strelba.Zakaznik_idZak = reader.GetInt32(++i);
strelba.Prostor_idSpr = reader.GetInt32(++i);
strelby.Add(strelba);
}
return(strelby);
}
public static Strelba select(int idStr)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue("@idStr", idStr);
SqlDataReader reader = db.Select(command);
Collection <Strelba> strelby = Read(reader);
Strelba strelba = null;
if (strelby.Count == 1)
{
strelba = strelby[0];
}
reader.Close();
db.Close();
return(strelba);
}
static void StrTest()
{
Strelba str = new Strelba
{
idStr = 1,
Zacatek = new DateTime(2018, 10, 10, 16, 10, 0),
Konec = new DateTime(2018, 10, 10, 17, 30, 0),
Zamestnanec_idZam = 2,
Zakaznik_idZak = 2,
Zbran_idZbr = 2,
Prostor_idSpr = 2
};
Console.WriteLine("Testovani funkce Strelba Insert - Vypis poctu prvku - update - select - delete - Vypis poctu prvku.\n"
+ str.Zacatek);
StrelbaTable.insert(str);
int count = StrelbaTable.select().Count;
str.Zacatek = str.Zacatek.AddMinutes(10);
StrelbaTable.update(str);
str.Zacatek = str.Zacatek.AddMinutes(10);
Console.WriteLine("#C: " + count);
str = StrelbaTable.select(1);
Console.WriteLine(str.Zacatek);
StrelbaTable.clean();
count = StrelbaTable.select().Count;
Console.WriteLine("#C: " + count + "\n" + "Test pro tabulku Strelba ukoncen, stisknutim libovolne klavesy ukoncite aplikaci.");
Console.ReadKey();
}
