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; }
private void AfficherMonument() { DesactiverButton(); mDGV_MonumentActive = true; mDataSetMonument.Reset(); DGV_Circuit.Hide(); DGV_Monuments.Show(); mSqlCommand = "SELECT NOM, DATEDECReATION, NBETOILES, HISTOIRE FROM MONUMENTS"; AfficherDGV2(); }
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(); }
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(); } }
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(); } }