private void button1_Click(object sender, EventArgs e)
{
if (textNom.Text == "" || textPrenom.Text == "" || textAdr.Text == "" || textCP.Text == "" || textVille.Text == "" || textMail.Text == "" || textTel.Text == "")
{
MessageBox.Show("Veuillez renseigner tous les champs");
}
else
{
textNom.Enabled = false;
textPrenom.Enabled = false;
textAdr.Enabled = false;
textVille.Enabled = false;
textCP.Enabled = false;
textTel.Enabled = false;
textMail.Enabled = false;
button1.Hide();
buttonModif.Show();
DBConnectTest nveau = new DBConnectTest();
string nom = textNom.Text;
string prenom = textPrenom.Text;
string ville = textVille.Text;
string adr = textAdr.Text;
int cp = Int32.Parse(textCP.Text);
string tel = textTel.Text;
string mail = textMail.Text;
int id = Int32.Parse(textId.Text);
nveau.ModifAdh(nom, prenom, adr, cp, ville, tel, mail, id);
}
}
public ModifClub()
{
InitializeComponent();
groupBox1.Hide();
this.WindowState = FormWindowState.Maximized;
DBConnectTest nveau = new DBConnectTest();
// DataTable Four = nveau.club(nom);
// Set up the DataGridView.
dataGridView1.Dock = DockStyle.Fill;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
// int index= dataGridView1.CurrentCell.RowIndex;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
// Automatically generate the DataGridView columns.
dataGridView1.AutoGenerateColumns = true;
List <Ligue> ligue = nveau.ReadLigue();
foreach (Ligue item in ligue)
{
toolStripComboBox1.Items.Add(item.getnom().ToString());
}
/* dataGridView1.DataSource = Four;
* {
* listBoxmod.Items.Add(item.getId());
* listBoxmod.Items.Add(item.getNom());
*
*
*
* }*/
}
public ModifAdhClub(string nom)
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
// int test = f.getId();
DBConnectTest nveau = new DBConnectTest();
DataTable Four = nveau.data(nom);
// Set up the DataGridView.
dataGridView1.Dock = DockStyle.Fill;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
// int index= dataGridView1.CurrentCell.RowIndex;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
// Automatically generate the DataGridView columns.
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = Four;
textNom.Enabled = false;
textPrenom.Enabled = false;
textAdr.Enabled = false;
textVille.Enabled = false;
textCP.Enabled = false;
textTel.Enabled = false;
textMail.Enabled = false;
textId.Enabled = false;
button1.Hide();
textBox1.Text = nom;
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
string id2 = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
if (id2 != "")
{
textNom.Enabled = false;
textPrenom.Enabled = false;
textAdr.Enabled = false;
textVille.Enabled = false;
textCP.Enabled = false;
textTel.Enabled = false;
textMail.Enabled = false;
button1.Hide();
buttonModif.Show();
int idtest = Int32.Parse(id2);
DBConnectTest connec = new DBConnectTest();
Adherent lAdherent = connec.Adh(idtest);
textNom.Text = lAdherent.getNom();
textPrenom.Text = lAdherent.getprenom();
textAdr.Text = lAdherent.getadr();
textVille.Text = lAdherent.getville();
textCP.Text = Convert.ToString(lAdherent.getcp());
textTel.Text = lAdherent.gettel();
textMail.Text = lAdherent.getmail();
textId.Text = Convert.ToString(idtest);
}
}
private void toolStripComboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string nom = toolStripComboBox1.ComboBox.SelectedItem.ToString();
DBConnectTest con = new DBConnectTest();
DataTable test = con.club(nom);
dataGridView1.Dock = DockStyle.Fill;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
// int index= dataGridView1.CurrentCell.RowIndex;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
// Automatically generate the DataGridView columns.
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = test;
}
public AddClub()
{
InitializeComponent();
this.FormBorderStyle = FormBorderStyle.None;
this.WindowState = FormWindowState.Maximized;
DBConnectTest con = new DBConnectTest();
List <Ligue> ligue = con.ReadLigue();
foreach (Ligue item in ligue)
{
comboBoxNom.Items.Add(item.getnom().ToString());
}
// Set up the DataGridView.
}
private void button1_Click(object sender, EventArgs e)
{
DBConnectTest con = new DBConnectTest();
if (textNom.Text == "")
{
MessageBox.Show("Veuillez Entrer un nom valide");
}
else
{
string nom = textNom.Text;
DataAccesLigue nveau = new DataAccesLigue();
nveau.insertLigue(nom);
MessageBox.Show("Nouvelle Ligue Crée!");
Close();
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
string id2 = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
if (id2 != "")
{
int idtest = Int32.Parse(id2);
DBConnectTest con = new DBConnectTest();
Club test = con.Read(idtest);
textId.Text = test.getId().ToString();
textNom.Text = test.getNom();
textAdresse.Text = test.getadresse();
textCP.Text = test.getcp().ToString();
textVille.Text = test.getville();
textWeb.Text = test.getweb();
textTel.Text = test.gettel();
groupBox1.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textNom.Text == "" || textAdresse.Text == "" || textCP.Text == "" || textVille.Text == "" || textWeb.Text == "" || textTel.Text == "")
{
MessageBox.Show("Veuillez renseigner tous les champs");
}
else
{
DBConnectTest nveau = new DBConnectTest();
int id = Int32.Parse(textId.Text);
string nom = textNom.Text;
string ville = textVille.Text;
string adr = textAdresse.Text;
int cp = Int32.Parse(textCP.Text);
string tel = textTel.Text;
string web = textWeb.Text;
nveau.ModifLigue(nom, adr, cp, ville, tel, web, id);
}
}
// Set the MaximizeBox to false to remove the maximize box.
private void buttonAdd_Click(object sender, EventArgs e)
{
if (textBoxNom.Text == "" || textBoxAd.Text == "" || textBoxCP.Text == "" || textBoxTel.Text == "" || textBoxVille.Text == "" || textBoxWeb.Text == "")
{
MessageBox.Show("Veuillez remplir tous les champs");
}
else
{
string nom_ligue = comboBoxNom.SelectedValue.ToString();
string nom = textBoxNom.Text;
string ville = textBoxVille.Text;
string adr = textBoxAd.Text;
int cp = Int32.Parse(textBoxCP.Text);
string tel = textBoxTel.Text;
string web = textBoxWeb.Text;
DBConnectTest nveau = new DBConnectTest();
nveau.InsertLigue(nom, adr, cp, ville, tel, web, nom);
Close();
}
}
public Gestion()
{
InitializeComponent();
this.IsMdiContainer = true;
DBConnectTest nveau = new DBConnectTest();
List <Club> Four = nveau.ReadAll();
/* foreach (Ligue item in Four)
* {
* MnuStripItem = new ToolStripMenuItem(item.getNom().ToString());
* menuStrip1.Items.Add(MnuStripItem);
*
*
* }*/
this.MainMenuStrip = menuStrip1;
foreach (Club item in Four)
{
toolStripComboBox1.Items.Add(item.getNom().ToString());
}
}
