public AddClubForm() { InitializeComponent(); ManageClub = ManagementClub.GetManagementClub(); ManageLeague = ManagementLeague.GetManagementLeague(); }
public void ReadAllAdherents(List <Adherent> adherents) { var manageClub = ManagementClub.GetManagementClub(); adherents.Clear(); using (Connection) { Connection.Open(); var query = "SELECT * FROM adherent NATURAL JOIN club ORDER BY adh_id"; var cmd = new MySqlCommand(query, Connection); using (var datareader = cmd.ExecuteReader()) { while (datareader.Read()) { foreach (var club in manageClub.Clubs) { if ((int)datareader["club_id"] == club.Id) { var adherent = new Adherent((int)datareader["adh_id"], (int)datareader["adh_licence"], (string)datareader["adh_nom"], (string)datareader["adh_prenom"], (string)datareader["adh_cp"], (string)datareader["adh_adresse"], (string)datareader["adh_ville"], (DateTime)datareader["adh_naissance"], Convert.ToInt32(datareader["adh_cotisation"]), club); adherents.Add(adherent); break; } } } } } }
public void ReadAllEvent(List <Event> events) { var manageClub = ManagementClub.GetManagementClub(); using (Connection) { Connection.Open(); var query = "SELECT * from evenement NATURAL JOIN club"; var cmd = new MySqlCommand(query, Connection); using (var datareader = cmd.ExecuteReader()) { while (datareader.Read()) { foreach (var club in manageClub.Clubs) { if ((int)datareader["club_id"] == club.Id) { var anEvent = new Event((int)datareader["even_id"], (string)datareader["even_nom"], (DateTime)datareader["even_debut"], (DateTime)datareader["even_fin"], club); events.Add(anEvent); } } } } } }
public ModificationAdherentForm(Adherent AdherentToModify) { InitializeComponent(); this.AdherentToModify = AdherentToModify; ManageClub = ManagementClub.GetManagementClub(); ManageAdherent = ManagementAdherent.GetManagementAdherent(); }
public HomePage() { InitializeComponent(); ManageLeague = ManagementLeague.GetManagementLeague(); ManageClub = ManagementClub.GetManagementClub(); ManageAdherent = ManagementAdherent.GetManagementAdherent(); ManageEvent = ManagementEvent.GetManageEvent(); }
private void AddAdherentForm_Load(object sender, EventArgs e) { ManageClub = ManagementClub.GetManagementClub(); ManageAdherent = ManagementAdherent.GetManagementAdherent(); foreach (var club in ManageClub.Clubs) { if (club.Name != null) { cmbAdherentClub.Items.Add(club.Name); } } }
private void Management_Club_Form_Load(object sender, EventArgs e) { ManageClub = ManagementClub.GetManagementClub(); DBClub = new DBClub(); DGClubs.AutoGenerateColumns = true; DGClubs.AutoResizeColumns(); foreach (var club in ManageClub.Clubs) { int numberOfAdherent = DBClub.CountAdherent(club); int numberOfEvent = DBClub.CountEvent(club); DGClubs.Rows.Add(club.Id, club.Name, club.ZipCode, club.City, club.Address, club.Mail, club.Telephone, club.League.Name, numberOfAdherent, numberOfEvent); } }
public AddEventForm() { InitializeComponent(); ManageClub = ManagementClub.GetManagementClub(); }