private static void PrepareCommand(SqlCommand command, Liga_hracu liga)
{
command.Parameters.AddWithValue("@Nazev", liga.Nazev_ligy);
command.Parameters.AddWithValue("@pozadavek", liga.Pozadavek);
command.Parameters.AddWithValue("@poc_tymu", liga.Pocet_hracu);
command.Parameters.AddWithValue("@status", liga.Status);
command.Parameters.AddWithValue("@vyhra", liga.Vyhra);
command.Parameters.AddWithValue("@Datum_zacatku", liga.Datum_zacatku);
command.Parameters.AddWithValue("@Datum_konce", liga.Datum_konce);
}
private static Collection <Liga_hracu> Read(SqlDataReader reader)
{
Collection <Liga_hracu> polozky = new Collection <Liga_hracu>();
while (reader.Read())
{
Liga_hracu polozka = new Liga_hracu();
int i = -1;
polozka.Nazev_ligy = reader.GetString(++i);
polozka.Pozadavek = reader.GetString(++i);
polozka.Pocet_hracu = reader.GetInt32(++i);
polozka.Status = reader.GetString(++i);
polozka.Vyhra = reader.GetString(++i);
polozka.Datum_zacatku = reader.GetDateTime(++i);
polozka.Datum_konce = reader.GetDateTime(++i);
polozky.Add(polozka);
}
return(polozky);
}
