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