<?php
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 *                                   ATTENTION!
 * If you see this message in your browser (Internet Explorer, Mozilla Firefox, Google Chrome, etc.)
 * this means that PHP is not properly installed on your web server. Please refer to the PHP manual
 * for more details: http://php.net/manual/install.php 
 *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 */


    include_once dirname(__FILE__) . '/' . 'components/utils/check_utils.php';
    CheckPHPVersion();
    CheckTemplatesCacheFolderIsExistsAndWritable();


    include_once dirname(__FILE__) . '/' . 'phpgen_settings.php';
    include_once dirname(__FILE__) . '/' . 'database_engine/mysql_engine.php';
    include_once dirname(__FILE__) . '/' . 'components/page.php';


    function GetConnectionOptions()
    {
        $result = GetGlobalConnectionOptions();
        $result['client_encoding'] = 'utf8';
        GetApplication()->GetUserAuthorizationStrategy()->ApplyIdentityToConnectionOptions($result);
        return $result;
    }

    
    // OnBeforePageExecute event handler
    
    
    class ParticipantsPage extends Page
    {
        protected function DoBeforeCreate()
        {
            $selectQuery = 'SELECT
            inscriptions_panier_evenements.eve_nom_fr,
            
            inscriptions_panier_participants.eve_id,
            inscriptions_panier_participants.cp_details_fr,
            inscriptions_panier_participants.par_prenom,
            inscriptions_panier_participants.par_nom,
            inscriptions_panier_participants.eta_nom_fr,
            inscriptions_panier_participants.pro_id, 
            inscriptions_panier_participants.pay_id, 
            inscriptions_panier_participants.par_naissance,
            inscriptions_panier_participants.par_age,
            inscriptions_panier_participants.par_sexe,
            inscriptions_panier_participants.par_adresse,
            inscriptions_panier_participants.par_ville,
            inscriptions_panier_participants.par_codepostal,
            inscriptions_panier_participants.par_telephone1,
            inscriptions_panier_participants.par_courriel,
            inscriptions_panier_participants.par_prix,
            inscriptions_panier_participants.par_no_equipe  ,
            inscriptions_panier_participants.par_nom_equipe ,
            
            inscriptions_panier_epreuves.epr_type_fr,
            inscriptions_panier_epreuves.epr_nom_fr,
            inscriptions_panier_epreuves.epr_id,
            inscriptions_panier_epreuves.epr_date,
            inscriptions_panier_epreuves.epr_heure,
            
             
            inscriptions_panier_rabais.rab_description_fr,
            inscriptions_panier_rabais.rab_montant,
            
            
            inscriptions_panier_acheteurs.ach_total, 
            inscriptions_paiements.pai_nom_fr,
             
            inscriptions_panier_acheteurs.ach_total-(inscriptions_panier_participants.par_frais_montant+inscriptions_panier_participants.par_frais_tps+inscriptions_panier_participants.par_frais_tvq) as totalmoinsfrais,
            
             
            inscriptions_panier_participants.par_frais_tvq,
            inscriptions_panier_participants.par_frais_tps,
            inscriptions_panier_participants.par_frais_montant,
            inscriptions_panier_acheteurs.TransactionID,
            inscriptions_panier_participants.no_panier,
            inscriptions_panier_acheteurs.sta_id,
            inscriptions_panier_acheteurs.ach_maj,
            inscriptions_panier_acheteurs.ach_id,
            inscriptions_panier_participants.par_id,
            
            
            Min( Case When  inscriptions_panier_questions.que_id in (93) Then  inscriptions_panier_questions.que_choix_fr End ) As category,
             
            Min( Case When  inscriptions_panier_questions.que_id in (91) Then  inscriptions_panier_questions.que_choix_fr End ) As tshirt,
            
            (select sta_id from inscriptions_panier_acheteurs where inscriptions_panier_participants.no_panier =  no_panier ) as sta_commande, 
             
             (select no_commande from inscriptions_panier_acheteurs where inscriptions_panier_participants.no_panier =  no_panier ) as no_commande   
            
            FROM
            inscriptions_panier_participants
            LEFT JOIN inscriptions_panier_epreuves ON inscriptions_panier_participants.pep_id = inscriptions_panier_epreuves.pep_id
            LEFT JOIN inscriptions_panier_evenements ON inscriptions_panier_epreuves.pan_id = inscriptions_panier_evenements.pan_id
            LEFT JOIN inscriptions_panier_acheteurs ON inscriptions_panier_participants.par_id = inscriptions_panier_acheteurs.par_id
            LEFT JOIN inscriptions_paiements ON inscriptions_panier_acheteurs.pai_id = inscriptions_paiements.pai_id
            left  JOIN inscriptions_panier_questions ON inscriptions_panier_participants.par_id = inscriptions_panier_questions.par_id
            left  JOIN inscriptions_panier_questions q2 ON inscriptions_panier_participants.par_no_equipe = q2.par_id
            left  JOIN inscriptions_panier_rabais_acheteurs ON inscriptions_panier_acheteurs.no_panier = inscriptions_panier_rabais_acheteurs.no_panier 
            left  JOIN inscriptions_panier_rabais ON inscriptions_panier_rabais.pra_id = inscriptions_panier_rabais_acheteurs.pra_id
            
            
            where (inscriptions_panier_participants.eve_id =109)  
            
            
            GROUP BY inscriptions_panier_participants.par_id
            
            order by no_panier,  inscriptions_panier_acheteurs.ach_total DESC';
            $insertQuery = array();
            $updateQuery = array();
            $deleteQuery = array();
            $this->dataset = new QueryDataset(
              new MyConnectionFactory(), 
              GetConnectionOptions(),
              $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Participants');
            $field = new StringField('eve_nom_fr');
            $this->dataset->AddField($field, false);
            $field = new StringField('eve_id');
            $this->dataset->AddField($field, false);
            $field = new StringField('cp_details_fr');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_prenom');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_nom');
            $this->dataset->AddField($field, false);
            $field = new StringField('eta_nom_fr');
            $this->dataset->AddField($field, false);
            $field = new StringField('pro_id');
            $this->dataset->AddField($field, false);
            $field = new StringField('pay_id');
            $this->dataset->AddField($field, false);
            $field = new DateField('par_naissance');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('par_age');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_sexe');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_adresse');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_ville');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_codepostal');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_telephone1');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_courriel');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('par_prix');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_no_equipe');
            $this->dataset->AddField($field, false);
            $field = new StringField('par_nom_equipe');
            $this->dataset->AddField($field, false);
            $field = new StringField('epr_type_fr');
            $this->dataset->AddField($field, false);
            $field = new StringField('epr_nom_fr');
            $this->dataset->AddField($field, false);
            $field = new StringField('epr_id');
            $this->dataset->AddField($field, false);
            $field = new DateField('epr_date');
            $this->dataset->AddField($field, false);
            $field = new TimeField('epr_heure');
            $this->dataset->AddField($field, false);
            $field = new StringField('rab_description_fr');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('rab_montant');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('ach_total');
            $this->dataset->AddField($field, false);
            $field = new StringField('pai_nom_fr');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('totalmoinsfrais');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('par_frais_tvq');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('par_frais_tps');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('par_frais_montant');
            $this->dataset->AddField($field, false);
            $field = new StringField('TransactionID');
            $this->dataset->AddField($field, false);
            $field = new StringField('no_panier');
            $this->dataset->AddField($field, false);
            $field = new StringField('sta_id');
            $this->dataset->AddField($field, false);
            $field = new DateTimeField('ach_maj');
            $this->dataset->AddField($field, false);
            $field = new StringField('ach_id');
            $this->dataset->AddField($field, true);
            $field = new StringField('par_id');
            $this->dataset->AddField($field, false);
            $field = new StringField('category');
            $this->dataset->AddField($field, false);
            $field = new StringField('tshirt');
            $this->dataset->AddField($field, false);
            $field = new IntegerField('sta_commande');
            $this->dataset->AddField($field, false);
            $field = new StringField('no_commande');
            $this->dataset->AddField($field, false);
            $this->dataset->AddLookupField('pro_id', 'inscriptions_provinces', new IntegerField('pro_id', null, null, true), new StringField('pro_nom_fr', 'pro_id_pro_nom_fr', 'pro_id_pro_nom_fr_inscriptions_provinces'), 'pro_id_pro_nom_fr_inscriptions_provinces');
            $this->dataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), ' sta_commande=3'));
        }
    
        protected function CreatePageNavigator()
        {
            $result = new CompositePageNavigator($this);
            
            $partitionNavigator = new PageNavigator('pnav', $this, $this->dataset);
            $partitionNavigator->SetRowsPerPage(20);
            $result->AddPageNavigator($partitionNavigator);
            
            return $result;
        }
    
        public function GetPageList()
        {
            $currentPageCaption = $this->GetShortCaption();
            $result = new PageList($this);
            if (GetCurrentUserGrantForDataSource('Participants')->HasViewGrant())
                $result->AddPage(new PageLink($this->RenderText('Participants'), 'challengelacbromptonete2014.php', $this->RenderText('Participants'), $currentPageCaption == $this->RenderText('Participants')));
            
            if ( HasAdminPage() && GetApplication()->HasAdminGrantForCurrentUser() )
              $result->AddPage(new PageLink($this->GetLocalizerCaptions()->GetMessageString('AdminPage'), 'phpgen_admin.php', $this->GetLocalizerCaptions()->GetMessageString('AdminPage'), false, true));
            return $result;
        }
    
        protected function CreateRssGenerator()
        {
            return null;
        }
    
        protected function CreateGridSearchControl(Grid $grid)
        {
            $grid->UseFilter = true;
            $grid->SearchControl = new SimpleSearch('Participantsssearch', $this->dataset,
                array('no_commande', 'no_panier', 'eve_nom_fr', 'epr_type_fr', 'epr_date', 'par_nom', 'par_prenom', 'par_naissance', 'par_age', 'par_sexe', 'par_adresse', 'par_ville', 'pro_id_pro_nom_fr', 'par_codepostal', 'par_telephone1', 'par_courriel', 'ach_maj', 'TransactionID', 'cp_details_fr', 'par_nom_equipe', 'par_prix', 'totalmoinsfrais', 'tshirt', 'category', 'rab_description_fr', 'rab_montant'),
                array($this->RenderText('No Commande'), $this->RenderText('No Panier'), $this->RenderText('�venement'), $this->RenderText('�preuve'), $this->RenderText(' Date'), $this->RenderText('Nom'), $this->RenderText('Prenom'), $this->RenderText('Naissance'), $this->RenderText('Age'), $this->RenderText('Sexe'), $this->RenderText('Adresse'), $this->RenderText('Ville'), $this->RenderText('Province'), $this->RenderText('Codepostal'), $this->RenderText('Telephone'), $this->RenderText('Courriel'), $this->RenderText('Data achat'), $this->RenderText('TransactionID'), $this->RenderText('Prix'), $this->RenderText('Par Nom Equipe'), $this->RenderText('Par Prix'), $this->RenderText('Total avant frais'), $this->RenderText('Tshirt'), $this->RenderText('Category'), $this->RenderText('Rab Description Fr'), $this->RenderText('Rab Montant')),
                array(
                    '=' => $this->GetLocalizerCaptions()->GetMessageString('equals'),
                    '<>' => $this->GetLocalizerCaptions()->GetMessageString('doesNotEquals'),
                    '<' => $this->GetLocalizerCaptions()->GetMessageString('isLessThan'),
                    '<=' => $this->GetLocalizerCaptions()->GetMessageString('isLessThanOrEqualsTo'),
                    '>' => $this->GetLocalizerCaptions()->GetMessageString('isGreaterThan'),
                    '>=' => $this->GetLocalizerCaptions()->GetMessageString('isGreaterThanOrEqualsTo'),
                    'ILIKE' => $this->GetLocalizerCaptions()->GetMessageString('Like'),
                    'STARTS' => $this->GetLocalizerCaptions()->GetMessageString('StartsWith'),
                    'ENDS' => $this->GetLocalizerCaptions()->GetMessageString('EndsWith'),
                    'CONTAINS' => $this->GetLocalizerCaptions()->GetMessageString('Contains')
                    ), $this->GetLocalizerCaptions(), $this, 'CONTAINS'
                );
        }
    
        protected function CreateGridAdvancedSearchControl(Grid $grid)
        {
            $this->AdvancedSearchControl = new AdvancedSearchControl('Participantsasearch', $this->dataset, $this->GetLocalizerCaptions(), $this->GetColumnVariableContainer(), $this->CreateLinkBuilder());
            $this->AdvancedSearchControl->setTimerInterval(1000);
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('no_commande', $this->RenderText('No Commande')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('no_panier', $this->RenderText('No Panier')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('eve_nom_fr', $this->RenderText('�venement')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('epr_type_fr', $this->RenderText('�preuve')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('epr_date', $this->RenderText(' Date')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_nom', $this->RenderText('Nom')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_prenom', $this->RenderText('Prenom')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('par_naissance', $this->RenderText('Naissance')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_age', $this->RenderText('Age')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_sexe', $this->RenderText('Sexe')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_adresse', $this->RenderText('Adresse')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_ville', $this->RenderText('Ville')));
            
            $lookupDataset = new TableDataset(
                new MyConnectionFactory(),
                GetConnectionOptions(),
                '`inscriptions_provinces`');
            $field = new IntegerField('pro_id', null, null, true);
            $field->SetIsNotNull(true);
            $lookupDataset->AddField($field, true);
            $field = new StringField('pro_nom_fr');
            $lookupDataset->AddField($field, false);
            $field = new StringField('pro_nom_en');
            $lookupDataset->AddField($field, false);
            $field = new StringField('pro_iso');
            $lookupDataset->AddField($field, false);
            $field = new IntegerField('pro_defaut');
            $field->SetIsNotNull(true);
            $lookupDataset->AddField($field, false);
            $field = new IntegerField('pro_actif');
            $field->SetIsNotNull(true);
            $lookupDataset->AddField($field, false);
            $field = new StringField('pro_paypal');
            $lookupDataset->AddField($field, false);
            $field = new IntegerField('pro_trie');
            $field->SetIsNotNull(true);
            $lookupDataset->AddField($field, false);
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateLookupSearchInput('pro_id', $this->RenderText('Province'), $lookupDataset, 'pro_id', 'pro_nom_fr', false));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_codepostal', $this->RenderText('Codepostal')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_telephone1', $this->RenderText('Telephone')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_courriel', $this->RenderText('Courriel')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('ach_maj', $this->RenderText('Data achat')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('TransactionID', $this->RenderText('TransactionID')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('cp_details_fr', $this->RenderText('Prix')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_nom_equipe', $this->RenderText('Par Nom Equipe')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_prix', $this->RenderText('Par Prix')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('totalmoinsfrais', $this->RenderText('Total avant frais')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('tshirt', $this->RenderText('Tshirt')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('category', $this->RenderText('Category')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('rab_description_fr', $this->RenderText('Rab Description Fr')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('rab_montant', $this->RenderText('Rab Montant')));
        }
    
        protected function AddOperationsColumns(Grid $grid)
        {
            $actionsBandName = 'actions';
            $grid->AddBandToBegin($actionsBandName, $this->GetLocalizerCaptions()->GetMessageString('Actions'), true);
            if ($this->GetSecurityInfo()->HasViewGrant())
            {
                $column = new RowOperationByLinkColumn($this->GetLocalizerCaptions()->GetMessageString('View'), OPERATION_VIEW, $this->dataset);
                $grid->AddViewColumn($column, $actionsBandName);
                $column->SetImagePath('images/view_action.png');
            }
        }
    
        protected function AddFieldColumns(Grid $grid)
        {
            //
            // View column for no_commande field
            //
            $column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for no_panier field
            //
            $column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for eve_nom_fr field
            //
            $column = new TextViewColumn('eve_nom_fr', '�venement', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for epr_type_fr field
            //
            $column = new TextViewColumn('epr_type_fr', '�preuve', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for epr_date field
            //
            $column = new DateTimeViewColumn('epr_date', ' Date', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_nom field
            //
            $column = new TextViewColumn('par_nom', 'Nom', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_prenom field
            //
            $column = new TextViewColumn('par_prenom', 'Prenom', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_naissance field
            //
            $column = new DateTimeViewColumn('par_naissance', 'Naissance', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_age field
            //
            $column = new TextViewColumn('par_age', 'Age', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_sexe field
            //
            $column = new TextViewColumn('par_sexe', 'Sexe', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_adresse field
            //
            $column = new TextViewColumn('par_adresse', 'Adresse', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_ville field
            //
            $column = new TextViewColumn('par_ville', 'Ville', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for pro_nom_fr field
            //
            $column = new TextViewColumn('pro_id_pro_nom_fr', 'Province', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_codepostal field
            //
            $column = new TextViewColumn('par_codepostal', 'Codepostal', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_telephone1 field
            //
            $column = new TextViewColumn('par_telephone1', 'Telephone', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_courriel field
            //
            $column = new TextViewColumn('par_courriel', 'Courriel', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for ach_maj field
            //
            $column = new DateTimeViewColumn('ach_maj', 'Data achat', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d H:i:s');
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for TransactionID field
            //
            $column = new TextViewColumn('TransactionID', 'TransactionID', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for cp_details_fr field
            //
            $column = new TextViewColumn('cp_details_fr', 'Prix', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_nom_equipe field
            //
            $column = new TextViewColumn('par_nom_equipe', 'Par Nom Equipe', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_prix field
            //
            $column = new TextViewColumn('par_prix', 'Par Prix', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for totalmoinsfrais field
            //
            $column = new TextViewColumn('totalmoinsfrais', 'Total avant frais', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for tshirt field
            //
            $column = new TextViewColumn('tshirt', 'Tshirt', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('tshirt_handler');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for category field
            //
            $column = new TextViewColumn('category', 'Category', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('category_handler');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for rab_description_fr field
            //
            $column = new TextViewColumn('rab_description_fr', 'Rab Description Fr', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for rab_montant field
            //
            $column = new TextViewColumn('rab_montant', 'Rab Montant', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
        }
    
        protected function AddSingleRecordViewColumns(Grid $grid)
        {
            //
            // View column for no_commande field
            //
            $column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for no_panier field
            //
            $column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for eve_nom_fr field
            //
            $column = new TextViewColumn('eve_nom_fr', 'Eve Nom Fr', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for epr_type_fr field
            //
            $column = new TextViewColumn('epr_type_fr', '�preuve', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for epr_date field
            //
            $column = new DateTimeViewColumn('epr_date', 'Epr Date', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_nom field
            //
            $column = new TextViewColumn('par_nom', 'Nom', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_prenom field
            //
            $column = new TextViewColumn('par_prenom', 'Prenom', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_naissance field
            //
            $column = new DateTimeViewColumn('par_naissance', 'Naissance', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_age field
            //
            $column = new TextViewColumn('par_age', 'Age', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_sexe field
            //
            $column = new TextViewColumn('par_sexe', 'Sexe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_adresse field
            //
            $column = new TextViewColumn('par_adresse', 'Adresse', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_ville field
            //
            $column = new TextViewColumn('par_ville', 'Ville', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for pro_nom_fr field
            //
            $column = new TextViewColumn('pro_id_pro_nom_fr', 'Province', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_codepostal field
            //
            $column = new TextViewColumn('par_codepostal', 'Codepostal', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_telephone1 field
            //
            $column = new TextViewColumn('par_telephone1', 'Telephone', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_courriel field
            //
            $column = new TextViewColumn('par_courriel', 'Courriel', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for ach_maj field
            //
            $column = new DateTimeViewColumn('ach_maj', 'Ach Maj', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d H:i:s');
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for TransactionID field
            //
            $column = new TextViewColumn('TransactionID', 'TransactionID', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for cp_details_fr field
            //
            $column = new TextViewColumn('cp_details_fr', 'Prix', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_nom_equipe field
            //
            $column = new TextViewColumn('par_nom_equipe', 'Par Nom Equipe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_prix field
            //
            $column = new TextViewColumn('par_prix', 'Par Prix', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for totalmoinsfrais field
            //
            $column = new TextViewColumn('totalmoinsfrais', 'Total avant frais', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for tshirt field
            //
            $column = new TextViewColumn('tshirt', 'Tshirt', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('tshirt_handler');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for category field
            //
            $column = new TextViewColumn('category', 'Category', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('category_handler');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for rab_description_fr field
            //
            $column = new TextViewColumn('rab_description_fr', 'Rab Description Fr', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
        }
    
        protected function AddEditColumns(Grid $grid)
        {
    
        }
    
        protected function AddInsertColumns(Grid $grid)
        {
    
            if ($this->GetSecurityInfo()->HasAddGrant())
            {
                $grid->SetShowAddButton(false);
                $grid->SetShowInlineAddButton(false);
            }
            else
            {
                $grid->SetShowInlineAddButton(false);
                $grid->SetShowAddButton(false);
            }
        }
    
        protected function AddPrintColumns(Grid $grid)
        {
            //
            // View column for no_commande field
            //
            $column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for no_panier field
            //
            $column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for eve_nom_fr field
            //
            $column = new TextViewColumn('eve_nom_fr', '�venement', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for epr_type_fr field
            //
            $column = new TextViewColumn('epr_type_fr', '�preuve', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for epr_date field
            //
            $column = new DateTimeViewColumn('epr_date', ' Date', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_nom field
            //
            $column = new TextViewColumn('par_nom', 'Nom', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_prenom field
            //
            $column = new TextViewColumn('par_prenom', 'Prenom', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_naissance field
            //
            $column = new DateTimeViewColumn('par_naissance', 'Naissance', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_age field
            //
            $column = new TextViewColumn('par_age', 'Age', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_sexe field
            //
            $column = new TextViewColumn('par_sexe', 'Sexe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_adresse field
            //
            $column = new TextViewColumn('par_adresse', 'Adresse', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_ville field
            //
            $column = new TextViewColumn('par_ville', 'Ville', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for pro_nom_fr field
            //
            $column = new TextViewColumn('pro_id_pro_nom_fr', 'Province', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_codepostal field
            //
            $column = new TextViewColumn('par_codepostal', 'Codepostal', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_telephone1 field
            //
            $column = new TextViewColumn('par_telephone1', 'Telephone', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_courriel field
            //
            $column = new TextViewColumn('par_courriel', 'Courriel', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for ach_maj field
            //
            $column = new DateTimeViewColumn('ach_maj', 'Data achat', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d H:i:s');
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for TransactionID field
            //
            $column = new TextViewColumn('TransactionID', 'TransactionID', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for cp_details_fr field
            //
            $column = new TextViewColumn('cp_details_fr', 'Prix', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_nom_equipe field
            //
            $column = new TextViewColumn('par_nom_equipe', 'Par Nom Equipe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_prix field
            //
            $column = new TextViewColumn('par_prix', 'Par Prix', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddPrintColumn($column);
            
            //
            // View column for totalmoinsfrais field
            //
            $column = new TextViewColumn('totalmoinsfrais', 'Total avant frais', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddPrintColumn($column);
            
            //
            // View column for tshirt field
            //
            $column = new TextViewColumn('tshirt', 'Tshirt', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for category field
            //
            $column = new TextViewColumn('category', 'Category', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for rab_description_fr field
            //
            $column = new TextViewColumn('rab_description_fr', 'Rab Description Fr', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for rab_montant field
            //
            $column = new TextViewColumn('rab_montant', 'Rab Montant', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddPrintColumn($column);
        }
    
        protected function AddExportColumns(Grid $grid)
        {
            //
            // View column for no_commande field
            //
            $column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for no_panier field
            //
            $column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for eve_nom_fr field
            //
            $column = new TextViewColumn('eve_nom_fr', '�venement', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for epr_type_fr field
            //
            $column = new TextViewColumn('epr_type_fr', '�preuve', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for epr_date field
            //
            $column = new DateTimeViewColumn('epr_date', ' Date', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_nom field
            //
            $column = new TextViewColumn('par_nom', 'Nom', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_prenom field
            //
            $column = new TextViewColumn('par_prenom', 'Prenom', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_naissance field
            //
            $column = new DateTimeViewColumn('par_naissance', 'Naissance', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_age field
            //
            $column = new TextViewColumn('par_age', 'Age', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_sexe field
            //
            $column = new TextViewColumn('par_sexe', 'Sexe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_adresse field
            //
            $column = new TextViewColumn('par_adresse', 'Adresse', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_ville field
            //
            $column = new TextViewColumn('par_ville', 'Ville', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for pro_nom_fr field
            //
            $column = new TextViewColumn('pro_id_pro_nom_fr', 'Province', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_codepostal field
            //
            $column = new TextViewColumn('par_codepostal', 'Codepostal', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_telephone1 field
            //
            $column = new TextViewColumn('par_telephone1', 'Telephone', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_courriel field
            //
            $column = new TextViewColumn('par_courriel', 'Courriel', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for ach_maj field
            //
            $column = new DateTimeViewColumn('ach_maj', 'Data achat', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d H:i:s');
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for TransactionID field
            //
            $column = new TextViewColumn('TransactionID', 'TransactionID', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for cp_details_fr field
            //
            $column = new TextViewColumn('cp_details_fr', 'Prix', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_nom_equipe field
            //
            $column = new TextViewColumn('par_nom_equipe', 'Par Nom Equipe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_prix field
            //
            $column = new TextViewColumn('par_prix', 'Par Prix', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddExportColumn($column);
            
            //
            // View column for totalmoinsfrais field
            //
            $column = new TextViewColumn('totalmoinsfrais', 'Total avant frais', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddExportColumn($column);
            
            //
            // View column for tshirt field
            //
            $column = new TextViewColumn('tshirt', 'Tshirt', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for category field
            //
            $column = new TextViewColumn('category', 'Category', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for rab_montant field
            //
            $column = new TextViewColumn('rab_montant', 'Rab Montant', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddExportColumn($column);
        }
    
        public function GetPageDirection()
        {
            return null;
        }
    
        protected function ApplyCommonColumnEditProperties(CustomEditColumn $column)
        {
            $column->SetShowSetToNullCheckBox(false);
    		$column->SetVariableContainer($this->GetColumnVariableContainer());
        }
    
        function GetCustomClientScript()
        {
            return ;
        }
        
        function GetOnPageLoadedClientScript()
        {
            return ;
        }
    
        protected function CreateGrid()
        {
            $result = new Grid($this, $this->dataset, 'ParticipantsGrid');
            if ($this->GetSecurityInfo()->HasDeleteGrant())
               $result->SetAllowDeleteSelected(false);
            else
               $result->SetAllowDeleteSelected(false);   
            
            ApplyCommonPageSettings($this, $result);
            
            $result->SetUseImagesForActions(true);
            $result->SetUseFixedHeader(false);
            
            $result->SetShowLineNumbers(false);
            
            $result->SetHighlightRowAtHover(false);
            $result->SetWidth('');
            $this->CreateGridSearchControl($result);
            $this->CreateGridAdvancedSearchControl($result);
            $this->AddOperationsColumns($result);
            $this->AddFieldColumns($result);
            $this->AddSingleRecordViewColumns($result);
            $this->AddEditColumns($result);
            $this->AddInsertColumns($result);
            $this->AddPrintColumns($result);
            $this->AddExportColumns($result);
    
            $this->SetShowPageList(true);
            $this->SetHidePageListByDefault(false);
            $this->SetExportToExcelAvailable(true);
            $this->SetExportToWordAvailable(true);
            $this->SetExportToXmlAvailable(true);
            $this->SetExportToCsvAvailable(true);
            $this->SetExportToPdfAvailable(true);
            $this->SetPrinterFriendlyAvailable(true);
            $this->SetSimpleSearchAvailable(true);
            $this->SetAdvancedSearchAvailable(true);
            $this->SetFilterRowAvailable(true);
            $this->SetVisualEffectsEnabled(true);
            $this->SetShowTopPageNavigator(true);
            $this->SetShowBottomPageNavigator(true);
    
            //
            // Http Handlers
            //
            //
            // View column for tshirt field
            //
            $column = new TextViewColumn('tshirt', 'Tshirt', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'tshirt_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);
            //
            // View column for category field
            //
            $column = new TextViewColumn('category', 'Category', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'category_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);//
            // View column for tshirt field
            //
            $column = new TextViewColumn('tshirt', 'Tshirt', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'tshirt_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);
            //
            // View column for category field
            //
            $column = new TextViewColumn('category', 'Category', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'category_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);
            return $result;
        }
        
        public function OpenAdvancedSearchByDefault()
        {
            return false;
        }
    
        protected function DoGetGridHeader()
        {
            return '';
        }
    }


    try
    {
        $Page = new ParticipantsPage("challengelacbromptonete2014.php", "Participants", GetCurrentUserGrantForDataSource("Participants"), 'UTF-8');
        $Page->SetShortCaption('Participants');
        $Page->SetHeader(GetPagesHeader());
        $Page->SetFooter(GetPagesFooter());
        $Page->SetCaption('Participants');
        $Page->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource("Participants"));
        GetApplication()->SetEnableLessRunTimeCompile(GetEnableLessFilesRunTimeCompilation());
        GetApplication()->SetCanUserChangeOwnPassword(
            !function_exists('CanUserChangeOwnPassword') || CanUserChangeOwnPassword());
        GetApplication()->SetMainPage($Page);
        GetApplication()->Run();
    }
    catch(Exception $e)
    {
        ShowErrorPage($e->getMessage());
    }