Пример #1
0
        private static void editLicense(HomeViewModel vm)
        {
            //SQLServerの接続開始
            DbAccess   dbAccess = new DbAccess();
            SqlCommand cmd      = dbAccess.sqlCon.CreateCommand();

            dbAccess.beginTransaciton();
            try
            {
                HomeDao dao           = new HomeDao();
                int     deleteLicense = dao.deleteLicense(vm, cmd, dbAccess);

                int insertLicense = dao.insertLicense(vm, cmd, dbAccess);
                if ((deleteLicense > 0) && (insertLicense > 0))
                {
                    dbAccess.sqlTran.Commit();
                }
                else
                {
                    dbAccess.sqlTran.Rollback();
                }

                dbAccess.close();
            }
            catch (Exception)
            {
                dbAccess.close();
                throw;
            }
        }