Beispiel #1
0
 private void FBTN_Fermer_Click(object sender, EventArgs e)
 {
     DGV_Circuit.Hide();
     BTN_ModifierCircuit.Hide();
     BTN_SupprimerMonument.Hide();
     DGV_Monuments.Hide();
     FBTN_More.Enabled = false;
 }
Beispiel #2
0
 private void AfficherMonument()
 {
     DesactiverButton();
     mDGV_MonumentActive = true;
     mDataSetMonument.Reset();
     DGV_Circuit.Hide();
     DGV_Monuments.Show();
     mSqlCommand = "SELECT NOM, DATEDECReATION, NBETOILES, HISTOIRE FROM MONUMENTS";
     AfficherDGV2();
 }
Beispiel #3
0
 private void Rechercher()
 {
     DGV_Monuments.Show();
     DGV_Circuit.Hide();
     mSqlCommand = "SELECT DISTINCT C.NOMCIRCUIT, V.NOMVILLE AS DEPART, V2.NOMVILLE AS ARRIVEE, C.PRIX AS PRICE, CM.ORDREDEVISITE FROM CIRCUITMONUMENTS CM" +
                   " INNER JOIN MONUMENTS M ON M.IDMONUMENT = CM.IDMONUMENT" +
                   " INNER JOIN CIRCUIT C ON C.NOMCIRCUIT = CM.NOMCIRCUIT" +
                   " INNER JOIN VILLE V ON C.CODEVILLEDEPART = V.CODEVILLE" +
                   " INNER JOIN VILLE V2 ON C.CODEVILLEARRIVÉE = V2.CODEVILLE" +
                   " WHERE NOM = '" + CBB_Monument.SelectedItem.ToString() + "' ORDER BY CM.ORDREDEVISITE";
     AfficherDGV2();
 }
Beispiel #4
0
        private void BTN_MeilleurMonument_Click(object sender, EventArgs e)
        {
            DLG_NbEtoiles dlg       = new DLG_NbEtoiles();
            int           NbEtoiles = 0;

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                DGV_Circuit.Hide();
                DGV_Monuments.Show();
                NbEtoiles   = dlg.mNbEtoiles;
                mSqlCommand = "select nomcircuit, nom ,ORDREDEVISITE from monuments inner join circuitmonuments on monuments.idmonument = circuitmonuments.idmonument where nbetoiles = '" + NbEtoiles + "' order by nomcircuit, ORDREDEVISITE";
                AfficherDGV2();
            }
        }
Beispiel #5
0
        private void AfficherParPrix()
        {
            DesactiverButton();
            DLG_Prix dlg = new DLG_Prix();

            mDataSetCircuit.Reset();
            DGV_Circuit.Hide();
            DGV_Monuments.Show();
            if (dlg.ShowDialog() == DialogResult.OK)
            {
                mDataSetCircuit.Reset();
                mPrix       = dlg.mPrix;
                mSqlCommand = "SELECT *FROM AfficherCircuitContraintePrix WHERE PRIX <= '" + mPrix + "' ORDER BY NOMCIRCUIT";
                AfficherDGV2();
            }
        }