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