public EcranTableMembre() { InitializeComponent(); List <C_T_Club> CbTmp = new G_T_Club(Conn).Lire("IdClub"); List <C_T_Equipe> lTmp = new G_T_Equipe(Conn).Lire("IdEquipe"); foreach (C_T_Equipe Tmp in lTmp) { C_T_Club VerifCamp = new G_T_Club(Conn).Lire_ID(Tmp.IdClub); if (VerifCamp.ClubAdverse != true) { cbRefEquipe.Items.Add(Tmp.IdEquipeDomicile + " : " + Tmp.NomEquipeDomicile); } } RemplirDGV(); if (dgvMembre.Rows.Count > 0) { Activer(true); dgvMembre.Rows[0].Selected = true; } else { Activer(false); } }
private void btnEditerClub_Click(object sender, EventArgs e) { if (dgvClub.SelectedRows.Count > 0) { Activer(false); tbIdClub.Text = dgvClub.SelectedRows[0].Cells["IdClub"].Value.ToString(); C_T_Club Tmp = new G_T_Club(Conn).Lire_ID(int.Parse(tbIdClub.Text)); tbNomClub.Text = Tmp.NomClub; tbLocaliteClub.Text = Tmp.LocaliteClub; tbAddresseClub.Text = Tmp.AdresseClub; tbClubAdverse.Text = Tmp.ClubAdverse.ToString(); } }
public EcranListesMembre() { InitializeComponent(); CbTmp = new G_T_Club(Conn).Lire("IdClub"); EquiTmp = new G_T_Equipe(Conn).Lire("IdEquipe"); RenTmp = new G_T_Rencontre(Conn).Lire("IdRencontre"); foreach (C_T_Equipe Tmp in EquiTmp) { C_T_Equipe recherche = EquiTmp.Find(X => X.IdEquipeDomicile == (Tmp.IdEquipeDomicile)); C_T_Club VerifCamp = new G_T_Club(Conn).Lire_ID(Tmp.IdClub); if (VerifCamp.ClubAdverse != true) { cbListeMembre.Items.Add(recherche.IdEquipeDomicile + " : " + Tmp.NomEquipeDomicile); } } }
private void RemplirDGV() { dtClub = new DataTable(); dtClub.Columns.Add(new DataColumn("IdClub", System.Type.GetType("System.Int32"))); dtClub.Columns.Add("NomCb"); dtClub.Columns.Add("LocaliteCb"); dtClub.Columns.Add("AdresseCb"); dtClub.Columns.Add("CbAdverse"); List <C_T_Club> lTmp = new G_T_Club(Conn).Lire("NomClub"); foreach (C_T_Club Tmp in lTmp) { dtClub.Rows.Add(Tmp.IdClub, Tmp.NomClub, Tmp.LocaliteClub, Tmp.AdresseClub, Tmp.ClubAdverse); } bsClub = new BindingSource(); bsClub.DataSource = dtClub; dgvClub.DataSource = bsClub; dgvClubBord.DataSource = bsClub; }
private void btnConfirmerClub_Click(object sender, EventArgs e) { if (tbNomClub.Text == "") { MessageBox.Show("Veuillez Renseigner le Nom Du Club"); } else { if (tbIdClub.Text == "") //mode ajout { int nID = new G_T_Club(Conn).Ajouter(tbNomClub.Text, tbLocaliteClub.Text, tbAddresseClub.Text, Convert.ToBoolean(tbClubAdverse.Text)); dtClub.Rows.Add(nID, tbNomClub.Text, tbLocaliteClub.Text, tbAddresseClub.Text, Convert.ToBoolean(tbClubAdverse.Text)); } else //mode édition { int nID = int.Parse(tbIdClub.Text); new G_T_Club(Conn).Modifier(nID, tbNomClub.Text, tbLocaliteClub.Text, tbAddresseClub.Text, Convert.ToBoolean(tbClubAdverse.Text)); for (int i = 0; i < dtClub.Rows.Count; i++) { if ((int)dtClub.Rows[i]["IdClub"] == nID) { //dtClub.Rows[i]["NomClub"] = tbNomClub.Text; dgvClub.Rows[i].Cells["NOMCb"].Value = tbNomClub.Text; dgvClub.Rows[i].Cells["Localitecb"].Value = tbLocaliteClub.Text; dgvClub.Rows[i].Cells["Adressecb"].Value = tbAddresseClub.Text; dgvClub.Rows[i].Cells["cbAdverse"].Value = tbClubAdverse.Text; break; } } } //dgvClub.SelectedRows[0].Cells["NomClub"].Value = tbNomClub.Text; bsClub.EndEdit(); Activer(true); } }
public EcranRencontre() { InitializeComponent(); #region deseign MaterialSkin.MaterialSkinManager skinManager = MaterialSkin.MaterialSkinManager.Instance; skinManager.ColorScheme = new MaterialSkin.ColorScheme(MaterialSkin.Primary.BlueGrey800, MaterialSkin.Primary.Amber900, MaterialSkin.Primary.Amber500, MaterialSkin.Accent.Green400, MaterialSkin.TextShade.WHITE); #endregion //RemplirDGV(); CbTmp = new G_T_Club(Conn).Lire("IdClub"); EquiTmp = new G_T_Equipe(Conn).Lire("IdEquipe"); foreach (C_T_Equipe Tmp in EquiTmp) { C_T_Club VerifCamp = new G_T_Club(Conn).Lire_ID(Tmp.IdClub); if (VerifCamp.ClubAdverse != true) { cbChoixEquipe.Items.Add(Tmp.NomEquipeDomicile); comboBox1.Items.Add(Tmp.NomEquipeDomicile); } //else // cbEquipeAdverse.Items.Add(Tmp.IdEquipeDomicile); } }