Exemple #1
0
        private void Delete()
        {
            SqlConnection cnn = new SqlConnection(DbConnString);

            cnn.Open();
            SqlTransaction sqlTransaction = cnn.BeginTransaction();

            try
            {
                SqlHelper.ExecuteNonQuery(sqlTransaction, this.GetCmdDelete());
                ReportAuth ra = new ReportAuth();
                ra.DeleteViewColFromDatabase(this.DataCnn, sqlTransaction, this._ID);
                _Parent.Remove(this);
                sqlTransaction.Commit();
            }
            catch (Exception e)
            {
                sqlTransaction.Rollback();
                throw e;
            }
            finally
            {
                if (cnn.State == ConnectionState.Open)
                {
                    cnn.Close();
                }
            }
        }