private static void PrepareCommand(SqlCommand command, Liga_Tymu liga)
{
command.Parameters.AddWithValue("@Nazev", liga.Nazev_ligy);
command.Parameters.AddWithValue("@pozadavek", liga.Pozadavek);
command.Parameters.AddWithValue("@poc_tymu", liga.Poc_tymu);
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_Tymu> Read(SqlDataReader reader)
{
Collection <Liga_Tymu> polozky = new Collection <Liga_Tymu>();
while (reader.Read())
{
Liga_Tymu polozka = new Liga_Tymu();
int i = -1;
polozka.Nazev_ligy = reader.GetString(++i);
polozka.Pozadavek = reader.GetString(++i);
polozka.Poc_tymu = 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);
}
