//8.2
public static int Update(Hrac_Hral hrac_hral, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = pDb;
}
using (db)
using (SqlCommand command = db.CreateCommand(SQL_UPDATE))
{
PrepareCommand(command, hrac_hral);
int status = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(status);
}
}
private static Collection <Hrac_Hral> Read(SqlDataReader reader)
{
var sestava = new Collection <Hrac_Hral>();
while (reader.Read())
{
int i = -1;
Hrac_Hral hrac = new Hrac_Hral
{
IdZapas = reader.GetInt32(++i),
IdHrac = reader.GetInt32(++i)
};
sestava.Add(hrac);
}
return(sestava);
}
private static void PrepareCommand(SqlCommand command, Hrac_Hral hrac_hral)
{
command.Parameters.AddWithValue("@idHrac", hrac_hral.IdHrac);
command.Parameters.AddWithValue("@idZapas", hrac_hral.IdZapas);
}