<?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_participants.eve_id,
            inscriptions_panier_participants.par_prenom,
            inscriptions_panier_participants.par_nom,
            inscriptions_panier_participants.eta_nom_fr,
            if(inscriptions_panier_participants.par_nom_equipe=null,\'\',inscriptions_panier_participants.par_nom_equipe) as nom_equipe,
            if(inscriptions_panier_participants.par_capitaine=1,\'capitaine\',\'\') as capitaine,
            inscriptions_panier_epreuves.epr_type_fr,
            inscriptions_panier_epreuves.epr_nom_fr,
            inscriptions_panier_epreuves.epr_date,
            inscriptions_panier_epreuves.epr_heure,
            inscriptions_panier_evenements.eve_nom_fr,
            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_acheteurs.ach_total,
            inscriptions_panier_acheteurs.no_commande,
            inscriptions_paiements.pai_nom_fr,
            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_questions.par_id,
              Min( Case When inscriptions_panier_questions.que_id = 1 or inscriptions_panier_questions.que_id = 5 or inscriptions_panier_questions.que_id = 6 Then inscriptions_panier_questions.que_choix_fr End ) As Taille
              ,Min( Case When inscriptions_panier_questions.que_id = 2 Then inscriptions_panier_questions.que_choix_fr End ) As Deja
             ,Min( Case When inscriptions_panier_questions.que_id = 7 Then inscriptions_panier_questions.que_choix_fr End ) As association
            
            
            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.no_panier = inscriptions_panier_acheteurs.no_panier
            LEFT JOIN inscriptions_paiements ON inscriptions_panier_acheteurs.pai_id = inscriptions_paiements.pai_id
             left  JOIN inscriptions_panier_questions ON inscriptions_panier_acheteurs.par_id = inscriptions_panier_questions.par_id
            GROUP BY inscriptions_panier_participants.par_id';
            $insertQuery = array();
            $updateQuery = array();
            $deleteQuery = array();
            $this->dataset = new QueryDataset(
              new MyConnectionFactory(), 
              GetConnectionOptions(),
              $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'Participants');
            $field = new StringField('eve_id');
            $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('nom_equipe');
            $this->dataset->AddField($field, false);
            $field = new StringField('capitaine');
            $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 DateField('epr_date');
            $this->dataset->AddField($field, false);
            $field = new TimeField('epr_heure');
            $this->dataset->AddField($field, false);
            $field = new StringField('eve_nom_fr');
            $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 IntegerField('ach_total');
            $this->dataset->AddField($field, false);
            $field = new StringField('no_commande');
            $this->dataset->AddField($field, false);
            $field = new StringField('pai_nom_fr');
            $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('par_id');
            $this->dataset->AddField($field, true);
            $field = new StringField('Taille');
            $this->dataset->AddField($field, false);
            $field = new StringField('Deja');
            $this->dataset->AddField($field, false);
            $field = new StringField('association');
            $this->dataset->AddField($field, false);
            $this->dataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '(eve_id=1 or eve_id=13 or eve_id=14) and sta_id=3'));
        }
    
        protected function CreatePageNavigator()
        {
            $result = new CompositePageNavigator($this);
            
            $partitionNavigator = new CustomPageNavigator('partition', $this, $this->dataset, $this->RenderText('test'), $result);
            $partitionNavigator->OnGetPartitionCondition->AddListener('partition' . '_GetPartitionConditionHandler', $this);
            $partitionNavigator->OnGetPartitions->AddListener('partition' . '_GetPartitionsHandler', $this);
            $partitionNavigator->SetAllowViewAllRecords(false);
            $partitionNavigator->SetNavigationStyle(NS_LIST);
            $result->AddPageNavigator($partitionNavigator);
            
            $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'), 'Participants.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('eve_nom_fr', 'epr_type_fr', 'epr_nom_fr', 'eta_nom_fr', 'nom_equipe', 'capitaine', 'epr_date', 'epr_heure', 'par_nom', 'par_prenom', 'par_naissance', 'par_age', 'par_sexe', 'par_adresse', 'par_ville', 'par_codepostal', 'par_telephone1', 'par_courriel', 'par_prix', 'pai_nom_fr', 'par_frais_tvq', 'par_frais_tps', 'par_frais_montant', 'ach_maj', 'Taille', 'Deja', 'association', 'TransactionID', 'no_panier', 'no_commande'),
                array($this->RenderText('�venement'), $this->RenderText('�preuve'), $this->RenderText('�preuve d�tails'), $this->RenderText('�tapes'), $this->RenderText('Nom Equipe'), $this->RenderText('Capitaine'), $this->RenderText(' Date'), $this->RenderText('Heure'), $this->RenderText('Nom'), $this->RenderText('Prenom'), $this->RenderText('Naissance'), $this->RenderText('Age'), $this->RenderText('Sexe'), $this->RenderText('Adresse'), $this->RenderText('Ville'), $this->RenderText('Codepostal'), $this->RenderText('Telephone'), $this->RenderText('Courriel'), $this->RenderText('Prix'), $this->RenderText('Paiement'), $this->RenderText('Frais Tvq'), $this->RenderText('Frais Tps'), $this->RenderText('Frais Montant'), $this->RenderText('Data achat'), $this->RenderText('Taille de chandail'), $this->RenderText('particip� � cette �preuve ?'), $this->RenderText('code d\'association'), $this->RenderText('TransactionID'), $this->RenderText('No Panier'), $this->RenderText('No Commande')),
                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->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->CreateStringSearchInput('epr_nom_fr', $this->RenderText('�preuve d�tails')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('eta_nom_fr', $this->RenderText('�tapes')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('nom_equipe', $this->RenderText('Nom Equipe')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('capitaine', $this->RenderText('Capitaine')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('epr_date', $this->RenderText(' Date')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('epr_heure', $this->RenderText('Heure')));
            $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')));
            $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->CreateStringSearchInput('par_prix', $this->RenderText('Prix')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('pai_nom_fr', $this->RenderText('Paiement')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_tvq', $this->RenderText('Frais Tvq')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_tps', $this->RenderText('Frais Tps')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('par_frais_montant', $this->RenderText('Frais Montant')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('ach_maj', $this->RenderText('Data achat')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Taille', $this->RenderText('Taille de chandail')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('Deja', $this->RenderText('particip� � cette �preuve ?')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('association', $this->RenderText('code d\'association')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('TransactionID', $this->RenderText('TransactionID')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('no_panier', $this->RenderText('No Panier')));
            $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('no_commande', $this->RenderText('No Commande')));
        }
    
        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 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_nom_fr field
            //
            $column = new TextViewColumn('epr_nom_fr', '�preuve d�tails', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for eta_nom_fr field
            //
            $column = new TextViewColumn('eta_nom_fr', '�tapes', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for nom_equipe field
            //
            $column = new TextViewColumn('nom_equipe', 'Nom Equipe', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for capitaine field
            //
            $column = new TextViewColumn('capitaine', 'Capitaine', $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 epr_heure field
            //
            $column = new DateTimeViewColumn('epr_heure', 'Heure', $this->dataset);
            $column->SetDateTimeFormat('H:i:s');
            $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 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 par_prix field
            //
            $column = new TextViewColumn('par_prix', 'Prix', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for pai_nom_fr field
            //
            $column = new TextViewColumn('pai_nom_fr', 'Paiement', $this->dataset);
            $column->SetOrderable(true);
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_frais_tvq field
            //
            $column = new TextViewColumn('par_frais_tvq', 'Frais Tvq', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_frais_tps field
            //
            $column = new TextViewColumn('par_frais_tps', 'Frais Tps', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for par_frais_montant field
            //
            $column = new TextViewColumn('par_frais_montant', 'Frais Montant', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $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 Taille field
            //
            $column = new TextViewColumn('Taille', 'Taille de chandail', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('Taille_handler');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for Deja field
            //
            $column = new TextViewColumn('Deja', 'particip� � cette �preuve ?', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('Deja_handler');
            $column->SetDescription($this->RenderText(''));
            $column->SetFixedWidth(null);
            $grid->AddViewColumn($column);
            
            //
            // View column for association field
            //
            $column = new TextViewColumn('association', 'code d\'association', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('association_handler');
            $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 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 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);
        }
    
        protected function AddSingleRecordViewColumns(Grid $grid)
        {
            //
            // View column for eve_nom_fr field
            //
            $column = new TextViewColumn('eve_nom_fr', '�venement', $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_nom_fr field
            //
            $column = new TextViewColumn('epr_nom_fr', '�preuve d�tails', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for eta_nom_fr field
            //
            $column = new TextViewColumn('eta_nom_fr', '�tapes', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for nom_equipe field
            //
            $column = new TextViewColumn('nom_equipe', 'Nom Equipe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for capitaine field
            //
            $column = new TextViewColumn('capitaine', 'Capitaine', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for epr_date field
            //
            $column = new DateTimeViewColumn('epr_date', ' Date', $this->dataset);
            $column->SetDateTimeFormat('Y-m-d');
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for epr_heure field
            //
            $column = new DateTimeViewColumn('epr_heure', 'Heure', $this->dataset);
            $column->SetDateTimeFormat('H:i:s');
            $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 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 par_prix field
            //
            $column = new TextViewColumn('par_prix', 'Prix', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for pai_nom_fr field
            //
            $column = new TextViewColumn('pai_nom_fr', 'Paiement', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_frais_tvq field
            //
            $column = new TextViewColumn('par_frais_tvq', 'Frais Tvq', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_frais_tps field
            //
            $column = new TextViewColumn('par_frais_tps', 'Frais Tps', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for par_frais_montant field
            //
            $column = new TextViewColumn('par_frais_montant', 'Frais Montant', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddSingleRecordViewColumn($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->AddSingleRecordViewColumn($column);
            
            //
            // View column for Taille field
            //
            $column = new TextViewColumn('Taille', 'Taille de chandail', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('Taille_handler');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for Deja field
            //
            $column = new TextViewColumn('Deja', 'particip� � cette �preuve ?', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('Deja_handler');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for association field
            //
            $column = new TextViewColumn('association', 'code d\'association', $this->dataset);
            $column->SetOrderable(true);
            $column->SetMaxLength(75);
            $column->SetFullTextWindowHandlerName('association_handler');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for ach_total field
            //
            $column = new TextViewColumn('ach_total', 'Ach Total', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddSingleRecordViewColumn($column);
            
            //
            // View column for TransactionID field
            //
            $column = new TextViewColumn('TransactionID', 'TransactionID', $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 no_commande field
            //
            $column = new TextViewColumn('no_commande', 'No Commande', $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 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_nom_fr field
            //
            $column = new TextViewColumn('epr_nom_fr', '�preuve d�tails', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for eta_nom_fr field
            //
            $column = new TextViewColumn('eta_nom_fr', '�tapes', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for nom_equipe field
            //
            $column = new TextViewColumn('nom_equipe', 'Nom Equipe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for capitaine field
            //
            $column = new TextViewColumn('capitaine', 'Capitaine', $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 epr_heure field
            //
            $column = new DateTimeViewColumn('epr_heure', 'Heure', $this->dataset);
            $column->SetDateTimeFormat('H:i:s');
            $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 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 par_prix field
            //
            $column = new TextViewColumn('par_prix', 'Prix', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddPrintColumn($column);
            
            //
            // View column for pai_nom_fr field
            //
            $column = new TextViewColumn('pai_nom_fr', 'Paiement', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_frais_tvq field
            //
            $column = new TextViewColumn('par_frais_tvq', 'Frais Tvq', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_frais_tps field
            //
            $column = new TextViewColumn('par_frais_tps', 'Frais Tps', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddPrintColumn($column);
            
            //
            // View column for par_frais_montant field
            //
            $column = new TextViewColumn('par_frais_montant', 'Frais Montant', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $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 Taille field
            //
            $column = new TextViewColumn('Taille', 'Taille', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for Deja field
            //
            $column = new TextViewColumn('Deja', 'Deja', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for association field
            //
            $column = new TextViewColumn('association', 'Association', $this->dataset);
            $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 no_panier field
            //
            $column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
            
            //
            // View column for no_commande field
            //
            $column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddPrintColumn($column);
        }
    
        protected function AddExportColumns(Grid $grid)
        {
            //
            // 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_nom_fr field
            //
            $column = new TextViewColumn('epr_nom_fr', '�preuve d�tails', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for eta_nom_fr field
            //
            $column = new TextViewColumn('eta_nom_fr', '�tapes', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for nom_equipe field
            //
            $column = new TextViewColumn('nom_equipe', 'Nom Equipe', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for capitaine field
            //
            $column = new TextViewColumn('capitaine', 'Capitaine', $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 epr_heure field
            //
            $column = new DateTimeViewColumn('epr_heure', 'Heure', $this->dataset);
            $column->SetDateTimeFormat('H:i:s');
            $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 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 par_prix field
            //
            $column = new TextViewColumn('par_prix', 'Prix', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddExportColumn($column);
            
            //
            // View column for pai_nom_fr field
            //
            $column = new TextViewColumn('pai_nom_fr', 'Paiement', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for par_frais_tvq field
            //
            $column = new TextViewColumn('par_frais_tvq', 'Frais Tvq', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddExportColumn($column);
            
            //
            // View column for par_frais_tps field
            //
            $column = new TextViewColumn('par_frais_tps', 'Frais Tps', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $grid->AddExportColumn($column);
            
            //
            // View column for par_frais_montant field
            //
            $column = new TextViewColumn('par_frais_montant', 'Frais Montant', $this->dataset);
            $column->SetOrderable(true);
            $column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
            $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 Taille field
            //
            $column = new TextViewColumn('Taille', 'Taille', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for Deja field
            //
            $column = new TextViewColumn('Deja', 'Deja', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for association field
            //
            $column = new TextViewColumn('association', 'Association', $this->dataset);
            $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 no_panier field
            //
            $column = new TextViewColumn('no_panier', 'No Panier', $this->dataset);
            $column->SetOrderable(true);
            $grid->AddExportColumn($column);
            
            //
            // View column for no_commande field
            //
            $column = new TextViewColumn('no_commande', 'No Commande', $this->dataset);
            $column->SetOrderable(true);
            $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 ;
        }
        private $partitions = array(1 => array('1'), 2 => array('13'), 3 => array('14'), 4 => array('1', 
        '13', 
        '14'));
        function partition_GetPartitionsHandler(&$partitions)
        {
            $partitions[1] = 'Demi marathon de la vall�e de st-sauveur �dition d\'automne';
            $partitions[2] = 'Trail d\'automne Sentier de la presqu\'�le ';
            $partitions[3] = 'Triathlon et Duathlon en For�t';
            $partitions[4] = 'Tout';
        }
        
        function partition_GetPartitionConditionHandler($partitionName, &$condition)
            {
                $condition = '';
                if (isset($partitionName) && isset($this->partitions[$partitionName]))
                    foreach ($this->partitions[$partitionName] as $value)
                        AddStr($condition, sprintf('(eve_id = %s)', $this->PrepareTextForSQL($value)), ' OR ');
            }
    
        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 Taille field
            //
            $column = new TextViewColumn('Taille', 'Taille de chandail', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'Taille_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);
            //
            // View column for Deja field
            //
            $column = new TextViewColumn('Deja', 'particip� � cette �preuve ?', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'Deja_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);
            //
            // View column for association field
            //
            $column = new TextViewColumn('association', 'code d\'association', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'association_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);//
            // View column for Taille field
            //
            $column = new TextViewColumn('Taille', 'Taille de chandail', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'Taille_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);
            //
            // View column for Deja field
            //
            $column = new TextViewColumn('Deja', 'particip� � cette �preuve ?', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'Deja_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);
            //
            // View column for association field
            //
            $column = new TextViewColumn('association', 'code d\'association', $this->dataset);
            $column->SetOrderable(true);
            $handler = new ShowTextBlobHandler($this->dataset, $this, 'association_handler', $column);
            GetApplication()->RegisterHTTPHandler($handler);
            return $result;
        }
        
        public function OpenAdvancedSearchByDefault()
        {
            return false;
        }
    
        protected function DoGetGridHeader()
        {
            return '';
        }
    }


    try
    {
        $Page = new ParticipantsPage("Participants.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());
    }