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();
}
