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