private void Remplir_DGV()
{
string A;
DT_Section = new DataTable();
DT_Section.Columns.Add(new DataColumn("ID", System.Type.GetType("System.Int32")));
DT_Section.Columns.Add("Nom");
DT_Section.Columns.Add("Age minimum", System.Type.GetType("System.Int32"));
DT_Section.Columns.Add("Age maximum", System.Type.GetType("System.Int32"));
DT_Section.Columns.Add("Sexe");
DT_Section.Columns.Add("Complet");
List <C_T_Section> lTmp_S = new G_T_Section(S_Ch_Conn).Lire("ID");
foreach (C_T_Section Tmp in lTmp_S)
{
if (Tmp.S_Complet == true)
{
A = "oui";
}
else
{
A = "non";
}
DT_Section.Rows.Add(Tmp.Id_Section, Tmp.S_Nom, Tmp.S_Age_Min, Tmp.S_Age_Max, Tmp.S_Sexe, A);
}
BS_Section = new BindingSource
{
DataSource = DT_Section
};
DGV_Section.DataSource = BS_Section;
}
private void Btn_Edit_Click(object sender, EventArgs e)
{
if (DGV_Section.SelectedRows.Count > 0)
{
Activer(false);
C_T_Section Tmp = new G_T_Section(S_Ch_Conn).Lire_ID(int.Parse(DGV_Section.SelectedRows[0].Cells["ID"].Value.ToString()));
TB_Nom.Text = Tmp.S_Nom;
TB_Prenom.Text = Tmp.S_Age_Min.ToString();
Tb_Section.Text = Tmp.S_Age_Max.ToString();
//Affichage du sexe
if (Tmp.S_Sexe == "Homme")
{
CB_Homme.Checked = true;
CB_Femme.Checked = false;
CB_Mixte.Checked = false;
}
else if (Tmp.S_Sexe == "Femme")
{
CB_Homme.Checked = false;
CB_Homme.Checked = true;
CB_Mixte.Checked = false;
}
else if (Tmp.S_Sexe == "Mixte")
{
CB_Homme.Checked = false;
CB_Homme.Checked = false;
CB_Mixte.Checked = true;
}
else
{
CB_Homme.Checked = false;
CB_Femme.Checked = false;
CB_Mixte.Checked = false;
}
CB_Complete_OK.Checked = Tmp.S_Complet;
CB_Complete_No.Checked = !Tmp.S_Complet;
Ajout = false;
}
}
public void Remplir_DGV() //Affichage membre et section
{
DT_Membre = new DataTable();
DT_Section = new DataTable();
DT_ActiviteMembre = new DataTable();
DT_ActiviteSection = new DataTable();
List <C_T_Membre> lTmp_M = new G_T_Membre(S_Ch_Conn).Lire("Nom");
List <C_T_Section> lTmp_S = new G_T_Section(S_Ch_Conn).Lire("ID");
DT_Membre.Columns.Add(new DataColumn("ID", System.Type.GetType("System.Int32")));
DT_Membre.Columns.Add("Nom");
DT_Membre.Columns.Add("Prénom");
DT_Membre.Columns.Add("Section");
DT_Membre.Columns.Add("Cotisation");
foreach (C_T_Membre Tmp in lTmp_M)
{
DT_Membre.Rows.Add(Tmp.Id_Membre, Tmp.M_Nom, Tmp.M_Prenom, Tmp.M_Section, Tmp.M_Cotisation);
}
DT_Section.Columns.Add(new DataColumn("ID", System.Type.GetType("System.Int32")));
DT_Section.Columns.Add("Nom");
DT_Section.Columns.Add("Complet");
foreach (C_T_Section Tmp in lTmp_S)
{
DT_Section.Rows.Add(Tmp.Id_Section, Tmp.S_Nom, Tmp.S_Complet);
}
BS_Membre = new BindingSource();
BS_Section = new BindingSource();
BS_ActiviteMembre = new BindingSource();
BS_ActiviteSection = new BindingSource();
BS_Membre.DataSource = DT_Membre;
BS_Section.DataSource = DT_Section;
DGV_Membres.DataSource = BS_Membre;
DGV_Section.DataSource = BS_Section;
//Préparation des DGV activité
DT_ActiviteMembre.Columns.Add(new DataColumn("ID", System.Type.GetType("System.Int32")));
DT_ActiviteMembre.Columns.Add("Nom");
DT_ActiviteMembre.Columns.Add("Date");
DT_ActiviteMembre.Columns.Add("Section");
BS_ActiviteMembre.DataSource = DT_ActiviteMembre;
DT_ActiviteSection.Columns.Add(new DataColumn("ID", System.Type.GetType("System.Int32")));
DT_ActiviteSection.Columns.Add("Nom");
DT_ActiviteSection.Columns.Add("Date");
DT_ActiviteSection.Columns.Add("Chef");
DT_ActiviteSection.Columns.Add("Autre chef");
BS_ActiviteSection.DataSource = DT_ActiviteSection;
//Remplir ComboBox
List <C_T_Membre> lTmp = new G_T_Membre(S_Ch_Conn).Lire("ID");
DataTable DT_CB = new DataTable();
BindingSource BS_CB = new BindingSource();
DT_CB.Columns.Add("Prenom");
foreach (var Tmp in lTmp)
{
if (Tmp.M_Statut.Trim() == "Chef")
{
DT_CB.Rows.Add(Tmp.M_Prenom.ToString() + " " + Tmp.M_Nom.ToString());
}
}
BS_CB.DataSource = DT_CB;
CB_Chef.DataSource = BS_CB;
CB_Chef.DisplayMember = "Prenom";
// SQL :
// go
//WITH bb(cpt, chf)
//as
//(SELECT COUNT(Id_Activite)AS cc, A_Chef2 FROM T_Activite GROUP BY A_Chef2 UNION
//SELECT COUNT(Id_Activite) as cc, A_Chef as A_Chef2 FROM T_Activite GROUP BY A_Chef)
//select sum(cpt),chf from bb group by chf
}
private void Btn_Listing_Click(object sender, EventArgs e)//Liste de la section en PDF
{
if (DGV_ActiviteSection.Rows.Count > 1)
{
//Liste des membres
List <C_T_Membre> lTmp_M = new G_T_Membre(S_Ch_Conn).Lire("ID");
List <C_T_Activite> lTmp_A = new G_T_Activite(S_Ch_Conn).Lire("ID");
List <C_T_Section> lTmp_S = new G_T_Section(S_Ch_Conn).Lire("ID");
DateTime datetime = Convert.ToDateTime(DGV_ActiviteSection.SelectedRows[0].Cells["Date"].Value.ToString());
string Section = "", Nom = DGV_ActiviteSection.SelectedRows[0].Cells["Nom"].Value.ToString().Trim();
string Date = datetime.ToShortDateString();
int? i = 0;
foreach (var Tmp in lTmp_A)
{
if (int.Parse(DGV_Section.SelectedRows[0].Cells["ID"].Value.ToString()) == Tmp.Id_Activite)
{
i = Tmp.A_Section;
}
}
foreach (var Tmp in lTmp_S)
{
if (i == Tmp.Id_Section)
{
Section = Tmp.S_Nom.Trim();
}
}
//Création du PDF
var PDF = new Document();
string Path = @"C:\Users\juju_\source\repos\Projet_DB_Scout_JC";
string Chemin = Path + "\\Liste_" + Section.Trim() + "_" + Nom + "_" + Date + ".pdf";
PdfWriter.GetInstance(PDF, new FileStream(Chemin, FileMode.Create));
PDF.Open();
//Ecriture du titre + ajout logo
iTextSharp.text.Image Pic1 = iTextSharp.text.Image.GetInstance(@"C:\Users\juju_\source\repos\Projet_DB_Scout_JC\packages\Scouts.png");
Pic1.Alignment = iTextSharp.text.Image.TEXTWRAP | iTextSharp.text.Image.ALIGN_RIGHT;
Pic1.ScaleAbsolute(50f, 50f);
PDF.Add(Pic1);
string s1 = "Liste des présences à l'activité " + DGV_ActiviteSection.SelectedRows[0].Cells["Nom"].Value.ToString().Trim();
Paragraph Texte1 = new Paragraph(s1)
{
Alignment = Element.ALIGN_CENTER
};
PDF.Add(Texte1);
//Récupération des noms des membres de la section + ajout au PDF
iTextSharp.text.List Liste = new iTextSharp.text.List(iTextSharp.text.List.UNORDERED);
string s = "";
foreach (var Tmp in lTmp_M)
{
if (Tmp.M_Section == Section)
{
string Membre = "0" + " " + Tmp.M_Nom.Trim() + " " + Tmp.M_Prenom.Trim();
Liste.Add(Membre);
}
}
PDF.Add(Liste);
PDF.Close();
MessageBox.Show("Le fichier PDF a été généré dans le dossier " + Path);
}
}
private void Btn_Conf_Click(object sender, EventArgs e)
{
if (TB_Nom.Text.Length == 0 || TB_Prenom.Text.Length == 0 || Tb_Section.Text.Length == 0)
{
MessageBox.Show("Veuillez remplir tous les champs");
}
else if (CB_Complete_OK.Checked == false && CB_Complete_No.Checked == false)
{
MessageBox.Show("Veuillez remplir tous les champs");
}
else if (CB_Complete_OK.Checked == true && CB_Complete_No.Checked == true)
{
MessageBox.Show("La section ne peut être complète et incomplète en même temps");
}
else if (CB_Homme.Checked == false && CB_Femme.Checked == false && CB_Mixte.Checked == false)
{
MessageBox.Show("Veuillez remplir tous les champs");
}
else if ((CB_Homme.Checked == true && CB_Femme.Checked == true) || (CB_Homme.Checked == true && CB_Mixte.Checked == true) || (CB_Mixte.Checked == true && CB_Femme.Checked == true))
{
MessageBox.Show("Veuillez cocher un seul sexe");
}
else
{
string Sexe;
if (CB_Homme.Checked == true)
{
Sexe = "Homme";
}
else if (CB_Femme.Checked == true)
{
Sexe = "Femme";
}
else
{
Sexe = "Mixte";
}
string s;
if (CB_Complete_OK.Checked)
{
s = "Oui";
}
else
{
s = "Non";
}
if (Ajout == true) //Mode ajout
{
int N_ID = new G_T_Section(S_Ch_Conn).Ajouter(TB_Nom.Text, int.Parse(TB_Prenom.Text), int.Parse(Tb_Section.Text), Sexe, CB_Complete_OK.Checked);
DT_Section.Rows.Add(N_ID, TB_Nom.Text, TB_Prenom.Text, Tb_Section.Text, Sexe, s);
}
else //Mode édition
{
int N_ID = int.Parse(DGV_Section.SelectedRows[0].Cells["ID"].Value.ToString());
new G_T_Section(S_Ch_Conn).Ajouter(TB_Nom.Text, int.Parse(TB_Prenom.Text), int.Parse(Sexe), Tb_Section.Text, CB_Complete_OK.Checked);
DGV_Section.SelectedRows[0].Cells["ID"].Value = N_ID;
DGV_Section.SelectedRows[0].Cells["Section"].Value = TB_Nom.Text;
DGV_Section.SelectedRows[0].Cells["Age minimum"].Value = TB_Prenom.Text;
DGV_Section.SelectedRows[0].Cells["Age maximum"].Value = Tb_Section.Text;
DGV_Section.SelectedRows[0].Cells["Sexe"].Value = Sexe;
DGV_Section.SelectedRows[0].Cells["Cotisation"].Value = s;
BS_Section.EndEdit();
}
Activer(true);
}
}
