Пример #1
0
        public static int Update(Detail_tymu detail_tym, Database pDb = null)
        {
            Database db;

            if (pDb == null)
            {
                db = new Database();
                db.Connect();
            }
            else
            {
                db = (Database)pDb;
            }

            SqlCommand command = db.CreateCommand(SQL_UPDATE);

            PrepareCommand(command, detail_tym);
            int ret = db.ExecuteNonQuery(command);

            if (pDb == null)
            {
                db.Close();
            }

            return(ret);
        }
Пример #2
0
 private static void PrepareCommand(SqlCommand command, Detail_tymu Dtymu)
 {
     command.Parameters.AddWithValue("@dtId", Dtymu.Dtid);
     command.Parameters.AddWithValue("@pocet_her", Dtymu.Pocet_her);
     command.Parameters.AddWithValue("@pocet_vyher", Dtymu.Pocet_vyher);
     command.Parameters.AddWithValue("@popis", Dtymu.Popis);
     command.Parameters.AddWithValue("@pozice", Dtymu.Pozice);
 }