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