private void lbActivite_SelectedIndexChanged(object sender, EventArgs e) { if (lbActivite.SelectedItem != null) { Activite activite1 = (Activite)lbActivite.SelectedItem; Nom_act.Text = activite1.GetNomAct(); } }
public static List <Activite> GetRechercheAct(string typeAct) { List <Activite> listeActivite = new List <Activite>(); MySqlCommand cmd = null; MySqlDataReader data = null; string req = "SELECT* FROM activité A, type_activité TA WHERE A.ID_TC = TA.ID_TC AND NOM_TC = '" + typeAct + "'"; cmd = conn.CreateCommand(); cmd.CommandText = req; data = cmd.ExecuteReader(); while (data.Read()) { Activite activite = new Activite((int)(data["ID_ACT"]), (string)(data["ID_TC"]), (string)(data["CD_UTI"]), (string)(data["NOM_ACT"]), (string)(data["DATE_ACT"]), (string)(data["DATE_FIN_ACT"]), (int)(data["TARIF"]), (int)(data["nbrPerso"])); listeActivite.Add(activite); } data.Close(); return(listeActivite); }
public static List <Activite> GetToutesActivites() // liste toutes les activités de la BD { MySqlCommand cmd = null; MySqlDataReader data = null; string req = "SELECT* FROM activité"; cmd = conn.CreateCommand(); cmd.CommandText = req; data = cmd.ExecuteReader(); int i = 0; while (data.Read()) { i++; Activite activite = new Activite((int)(data["ID_ACT"]), (string)(data["ID_TC"]), (string)(data["CD_UTI"]), (string)(data["NOM_ACT"]), (string)(data["DATE_ACT"]), (string)(data["DATE_FIN_ACT"]), (int)(data["TARIF"]), (int)(data["nbrPerso"])); contenuAct.Add(activite); } data.Close(); return(contenuAct); }
private void button2_Click(object sender, EventArgs e) // valider resa { if (FformulaireCo.connecte == true) { if (lbActivite.SelectedIndex == -1) { MessageBox.Show("Choisir une actvité"); } else { AccesBd.connexion(); //int Place_disponible = activite.GetnbrPersoMax() - nbrTotal; //PlaceDisponible.Text = Convert.ToString(Place_disponible); Activite activite = (Activite)lbActivite.SelectedItem; Donnees.SetNomAct(activite.GetNomAct()); int reste = activite.GetnbrPersoMax() - int.Parse(nbrParticipants.Text); if (reste >= 0) { if (AccesBd.resa(activite.GetID_ACT(), Donnees.getUtilistauer(), int.Parse(nbrParticipants.Text))) { reste -= int.Parse(nbrParticipants.Text); Donnees.setDateActivite(dateAct.Text); MessageBox.Show(" vous avez réservé !"); } } else { MessageBox.Show("Place complete"); } } } else { MessageBox.Show("Vous devez être connecté afin de réserver une activité"); } }