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 AfficherMeilleurCircuit()
{
DesactiverButton();
DGV_Monuments.Hide();
DGV_Circuit.Show();
mDataSetCircuit.Reset();
mSqlCommand = "SELECT * FROM AfficherMeilleurCircuit";
AfficherDGV();
}
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 AfficherCircuit()
{
DesactiverButton();
mDGV_CircuitActive = true;
mDataSetCircuit.Reset();
DGV_Circuit.Show();
DGV_Monuments.Hide();
mSqlCommand = "SELECT * FROM AfficherTousLesCircuits";
AfficherDGV();
}
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();
}
}
