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é");
}
}
