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