//11.1 public static int Insert(Tym_Hrac tym_hrac, Database pDb = null) { Database db; if (pDb == null) { db = new Database(); db.Connect(); } else { db = pDb; } using (db) using (SqlCommand command = db.CreateCommand(SQL_INSERT)) { PrepareCommand(command, tym_hrac); int status = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(status); } }
private static Collection <Tym_Hrac> Read(SqlDataReader reader) { var hraciTymu = new Collection <Tym_Hrac>(); while (reader.Read()) { int i = -1; Tym_Hrac ht = new Tym_Hrac() { IdTym = reader.GetInt32(++i), IdHrac = reader.GetInt32(++i), Zacatek = reader.GetDateTime(++i), }; if (!reader.IsDBNull(++i)) { ht.Konec = reader.GetDateTime(i); } hraciTymu.Add(ht); } return(hraciTymu); }
private static void PrepareCommand(SqlCommand command, Tym_Hrac tym_hrac) { command.Parameters.AddWithValue("@idTym", tym_hrac.IdTym); command.Parameters.AddWithValue("@idHrac", tym_hrac.IdHrac); }