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); }