private void listClubs_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
var nb = listClubs.Rows[e.RowIndex].Cells[0].Value.ToString();
panel1.Visible = false;
panelListAdherents.Visible = false;
panel2.Visible = true;
idClub.Text = nb;
BDD club1 = new BDD();
Club leClub = club1.ReadClub(int.Parse(nb));
pageClub.Text = leClub.nomClub;
textBoxModifNameClub.Text = leClub.nomClub;
textBoxModifAdresseClub.Text = leClub.adresseClub;
textBoxModifCPClub.Text = leClub.CPClub.ToString();
textBoxModifVilleClub.Text = leClub.villeClub;
textBoxModifTelClub.Text = leClub.telephone;
textBoxModifMailClub.Text = leClub.mail;
textBoxModifURLClub.Text = leClub.siteClub;
}
private void buttonCreateEvent_Click(object sender, EventArgs e)
{
int CP;
DateTime thisDay = DateTime.Today;
if (dateTimePickerNewDebutEvent.Value >= thisDay && dateTimePickerNewFinEvent.Value > dateTimePickerNewDebutEvent.Value &&
!string.IsNullOrEmpty(textBoxNewNomEvent.Text) && !string.IsNullOrEmpty(textBoxNewAdresseEvent.Text) &&
!string.IsNullOrEmpty(textBoxNewCPEvent.Text) && !string.IsNullOrEmpty(textBoxNewVilleEvent.Text) &&
!string.IsNullOrEmpty(textBoxNewTypeEvent.Text) && !string.IsNullOrEmpty(textBoxNewStieEvent.Text) &&
int.TryParse(textBoxNewCPEvent.Text, out CP))
{
BDD newEvent = new BDD();
Evenement nouvelEvenement = new Evenement(0, textBoxNewTypeEvent.Text, textBoxNewNomEvent.Text, textBoxNewAdresseEvent.Text, CP, textBoxNewVilleEvent.Text, textBoxNewStieEvent.Text, dateTimePickerNewDebutEvent.Value, dateTimePickerNewFinEvent.Value, 0, idClub);
newEvent.InsertEvent(nouvelEvenement);
Close();
}
else
{
erreur = new ErrAjout();
erreur.ShowDialog();
}
}
private void buttonConfirmSuppr_Click(object sender, EventArgs e)
{
BDD Delete = new BDD();
if (leObjet.GetType() == typeof(Evenement))
{
Delete.DeleteEvent(((Evenement)leObjet).id);
typedeleted = "event";
}
else if (leObjet.GetType() == typeof(Club))
{
Delete.DeleteClub(((Club)leObjet).id);
typedeleted = "club";
}
else if (leObjet.GetType() == typeof(Adherent))
{
Delete.DeleteAdherent(((Adherent)leObjet).id);
typedeleted = "adh";
}
deleted = true;
Close();
}
public void AfficheList()
{
listClubs.Rows.Clear();
BDD liste1 = new BDD();
List <Club> ListClub = liste1.SelectAllClub();
listClubs.ColumnCount = 8;
listClubs.Columns[0].Name = "Id";
listClubs.Columns[1].Name = "Nom du Club";
listClubs.Columns[2].Name = "Adresse";
listClubs.Columns[3].Name = "Code Postal";
listClubs.Columns[4].Name = "Ville";
listClubs.Columns[5].Name = "Telephone";
listClubs.Columns[6].Name = "Contact";
listClubs.Columns[7].Name = "Liens";
foreach (Club list in ListClub)
{
listClubs.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
listClubs.Rows.Add(list.id, list.nomClub, list.adresseClub, list.CPClub, list.villeClub, list.telephone, list.mail, list.siteClub);
}
}
private void textBoxRecherche_TextChanged(object sender, EventArgs e)
{
listClubs.Rows.Clear();
BDD liste1 = new BDD();
List <Club> ListClub = liste1.SearchClub(textBoxRecherche.Text);
listClubs.ColumnCount = 8;
listClubs.Columns[0].Name = "Id";
listClubs.Columns[1].Name = "Nom du Club";
listClubs.Columns[2].Name = "Adresse";
listClubs.Columns[3].Name = "Code Postal";
listClubs.Columns[4].Name = "Ville";
listClubs.Columns[5].Name = "Telephone";
listClubs.Columns[6].Name = "Contact";
listClubs.Columns[7].Name = "Liens";
foreach (Club list in ListClub)
{
listClubs.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
listClubs.Rows.Add(list.id, list.nomClub, list.adresseClub, list.CPClub, list.villeClub, list.telephone, list.mail, list.siteClub);
}
}
private void dataGridViewListEvent_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
var LaCellule = dataGridViewListEvent.Rows[e.RowIndex].Cells[0].Value.ToString();
panelConsultEvent.Visible = false;
panelModifEvent.Visible = true;
BDD UnEvent = new BDD();
Evenement ThisEvent = UnEvent.ReadEvent(int.Parse(LaCellule));
Club clubDeLEvent = UnEvent.ReadClub(ThisEvent.id_club);
labelShowIdEvent.Text = ThisEvent.id.ToString();
labelNomDuClubModifEvent.Text = clubDeLEvent.nomClub;
labelNbParticpant.Text = ThisEvent.nbParticipants.ToString();
textBoxModifNomEvent.Text = ThisEvent.nomEvent;
textBoxModifAdresseEvent.Text = ThisEvent.adresseEvent;
textBoxModifCPEvent.Text = ThisEvent.CPEvent.ToString();
textBoxModifVilleEvent.Text = ThisEvent.villeEvent;
textBoxModifTypeEvent.Text = ThisEvent.typeEvent;
textBoxModifSiteEvent.Text = ThisEvent.siteEvent;
dateTimePickerModifDateDebutEvent.Value = ThisEvent.dateDebutEvent;
dateTimePickerModifDateFinEvent.Value = ThisEvent.dateFinEvent;
labelIdClubEvent.Text = ThisEvent.id_club.ToString();
}
public void AfficheListEvent(int leClub)
{
dataGridViewListEvent.Rows.Clear();
BDD listeEvents = new BDD();
List <Evenement> listeEvenement = listeEvents.SelectAllEvent(leClub);
dataGridViewListEvent.ColumnCount = 10;
dataGridViewListEvent.Columns[0].Name = "Id";
dataGridViewListEvent.Columns[1].Name = "Type d'évènement";
dataGridViewListEvent.Columns[2].Name = "Nom évènement";
dataGridViewListEvent.Columns[3].Name = "Adresse évènement";
dataGridViewListEvent.Columns[4].Name = "Code Postal";
dataGridViewListEvent.Columns[5].Name = "Ville évènement";
dataGridViewListEvent.Columns[6].Name = "Liens";
dataGridViewListEvent.Columns[7].Name = "Début";
dataGridViewListEvent.Columns[8].Name = "Fin";
dataGridViewListEvent.Columns[9].Name = "Participants";
foreach (Evenement Event in listeEvenement)
{
dataGridViewListEvent.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dataGridViewListEvent.Rows.Add(Event.id, Event.typeEvent, Event.nomEvent, Event.adresseEvent, Event.CPEvent, Event.villeEvent, Event.siteEvent, Event.dateDebutEvent, Event.dateFinEvent, Event.nbParticipants);
}
}
public void AfficheListAdherent(int leClub)
{
dataGridViewListAdherents.Rows.Clear();
BDD listeAdherents = new BDD();
List <Adherent> ListeAdherent = listeAdherents.SelectAllAdherent(leClub);
dataGridViewListAdherents.ColumnCount = 10;
dataGridViewListAdherents.Columns[0].Name = "Id";
dataGridViewListAdherents.Columns[1].Name = "Nom Adhérent";
dataGridViewListAdherents.Columns[2].Name = "Prénom Adhérent";
dataGridViewListAdherents.Columns[3].Name = "Naissance";
dataGridViewListAdherents.Columns[4].Name = "Sexe";
dataGridViewListAdherents.Columns[5].Name = "Licence";
dataGridViewListAdherents.Columns[6].Name = "Adresse";
dataGridViewListAdherents.Columns[7].Name = "Code postal";
dataGridViewListAdherents.Columns[8].Name = "ville";
dataGridViewListAdherents.Columns[9].Name = "Cotisation";
foreach (Adherent adherent in ListeAdherent)
{
dataGridViewListAdherents.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dataGridViewListAdherents.Rows.Add(adherent.id, adherent.nomAdh, adherent.prenomAdh, adherent.naissance, adherent.sexe, adherent.numLicence, adherent.adresseAdh, adherent.CPAdh, adherent.villeAdh, adherent.cotisation);
}
}
private void textBoxSearchEvent_TextChanged(object sender, EventArgs e)
{
dataGridViewListEvent.Rows.Clear();
BDD listeEvents = new BDD();
List <Evenement> listeEvenement = listeEvents.SearchEvent(textBoxSearchEvent.Text, int.Parse(idClub.Text));
dataGridViewListEvent.ColumnCount = 10;
dataGridViewListEvent.Columns[0].Name = "Id";
dataGridViewListEvent.Columns[1].Name = "Type d'évènement";
dataGridViewListEvent.Columns[2].Name = "Nom évènement";
dataGridViewListEvent.Columns[3].Name = "Adresse évènement";
dataGridViewListEvent.Columns[4].Name = "Code Postal";
dataGridViewListEvent.Columns[5].Name = "Ville évènement";
dataGridViewListEvent.Columns[6].Name = "Liens";
dataGridViewListEvent.Columns[7].Name = "Début";
dataGridViewListEvent.Columns[8].Name = "Fin";
dataGridViewListEvent.Columns[9].Name = "Participants";
foreach (Evenement Event in listeEvenement)
{
dataGridViewListEvent.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dataGridViewListEvent.Rows.Add(Event.id, Event.typeEvent, Event.nomEvent, Event.adresseEvent, Event.CPEvent, Event.villeEvent, Event.siteEvent, Event.dateDebutEvent, Event.dateFinEvent, Event.nbParticipants);
}
}
private void textBoxRechercheAdherent_TextChanged(object sender, EventArgs e)
{
dataGridViewListAdherents.Rows.Clear();
BDD listeAdherents = new BDD();
List <Adherent> ListeAdherent = listeAdherents.SearchAdherent(textBoxRechercheAdherent.Text, int.Parse(idClub.Text));
dataGridViewListAdherents.ColumnCount = 10;
dataGridViewListAdherents.Columns[0].Name = "Id";
dataGridViewListAdherents.Columns[1].Name = "Nom Adhérent";
dataGridViewListAdherents.Columns[2].Name = "Prénom Adhérent";
dataGridViewListAdherents.Columns[3].Name = "Naissance";
dataGridViewListAdherents.Columns[4].Name = "Sexe";
dataGridViewListAdherents.Columns[5].Name = "Licence";
dataGridViewListAdherents.Columns[6].Name = "Adresse";
dataGridViewListAdherents.Columns[7].Name = "Code postal";
dataGridViewListAdherents.Columns[8].Name = "ville";
dataGridViewListAdherents.Columns[9].Name = "Cotisation";
foreach (Adherent adherent in ListeAdherent)
{
dataGridViewListAdherents.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dataGridViewListAdherents.Rows.Add(adherent.id, adherent.nomAdh, adherent.prenomAdh, adherent.naissance, adherent.sexe, adherent.numLicence, adherent.adresseAdh, adherent.CPAdh, adherent.villeAdh, adherent.cotisation);
}
}
