//10.1 public static int Insert(Ucastnik ucastnik, 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, ucastnik); int status = db.ExecuteNonQuery(command); if (pDb == null) { db.Close(); } return(status); } }
private static Collection <Ucastnik> Read(SqlDataReader reader) { Collection <Ucastnik> ucasti = new Collection <Ucastnik>(); while (reader.Read()) { int i = -1; Ucastnik ucast = new Ucastnik(); ucast.idTym = reader.GetString(++i); ucast.idRocnik = reader.GetInt32(++i); ucast.body = reader.GetInt32(++i); ucasti.Add(ucast); } return(ucasti); }
public static int Update(Ucastnik ucast, Database pDb = null) { Database db; db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, ucast); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
public static int Insert(Ucastnik ucast) { Database db; db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_INSERT); PrepareCommand(command, ucast); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
private static Collection <Ucastnik> Read(SqlDataReader reader) { var ucastnici = new Collection <Ucastnik>(); while (reader.Read()) { int i = -1; Ucastnik ucastik = new Ucastnik(); ucastik.Tym = new Tym(); ucastik.Tym.Jmeno = reader.GetString(++i); ucastik.PocetZapasu = reader.GetInt32(++i); ucastik.Vyhry = reader.GetInt32(++i); ucastik.Remizy = reader.GetInt32(++i); ucastik.Prohry = reader.GetInt32(++i); ucastik.Body = reader.GetInt32(++i); ucastnici.Add(ucastik); } return(ucastnici); }
private static void PrepareCommand(SqlCommand command, Ucastnik ucastnik) { command.Parameters.AddWithValue("@idLiga", ucastnik.IdLiga); command.Parameters.AddWithValue("@idTym", ucastnik.IdTym); }
private static void PrepareCommand(SqlCommand command, Ucastnik ucastnik) { command.Parameters.AddWithValue("@idTym", ucastnik.idTym); command.Parameters.AddWithValue("@idRocnik", ucastnik.idRocnik); command.Parameters.AddWithValue("@body", ucastnik.body); }