public virtual DesignerDrogCategoryContainer DesignerDrogCategorySelectAll()
 {
     TraceCallEnterEvent.Raise();
       try
       {
     DesignerDrogCategoryContainer result;
     DataSet entitySet = m_DataContext.ndihdDesignerDrogCategorySelectAll();
     result = new DesignerDrogCategoryContainer(entitySet.Tables[0]);
     TraceCallReturnEvent.Raise();
     return result;
       }
       catch (Exception ex)
       {
     ExceptionManager.Publish(ex);
     TraceCallReturnEvent.Raise(false);
     throw;
       }
 }
        public DesignerDrogCategoryContainer DesignerDrogCategorySelectFiltered( DBString cName, DBInt isActive )
        {
            //check permission: Admin
            PrincipalPermission permAdm = new PrincipalPermission( Thread.CurrentPrincipal.Identity.Name, "Administrator" );
            permAdm.Demand();

            TraceCallEnterEvent.Raise();
            try
            {
            if (isActive == null)
            {
                isActive = DBInt.Null;
            }
            DesignerDrogCategoryContainer result;
            DataSet entitySet = m_DataContext.ndihdDesignerDrogCategorySelectFiltered( cName, isActive );
            result = new DesignerDrogCategoryContainer( entitySet.Tables[0] );
            TraceCallReturnEvent.Raise();
            return result;
            }
            catch (Exception ex)
            {
            ExceptionManager.Publish( ex );
            TraceCallReturnEvent.Raise( false );
            throw;
            }
        }