Beispiel #1
0
        public Page(string u)
        {
            InitializeComponent();
            this.user = u;
            this.hideAllGrids();
            CPNNotification.Visibility  = Visibility.Hidden;
            CPoNNotification.Visibility = Visibility.Hidden;
            Int32 rdv = RDVS.NombreTotalPatient();

            TotalPatiente.Content = Convert.ToString(rdv);
            rdv = RDVS.NombreTotalPatientStatut("En attente");
            PatienteEnAttente.Content = rdv.ToString();
            rdv = RDVS.NombreTotalPatientStatut("Effectué");
            ConsultationEffectuees.Content = rdv.ToString();
            rdv = RDVS.NombreTotalPatientType("cpn");
            Prenatale.Content = rdv.ToString();
            rdv = RDVS.NombreTotalPatientType("cpon");
            Postnatale.Content = rdv.ToString();
            rdv = RDVS.NombreTotalPatientType("echo");
            Echographie.Content    = rdv.ToString();
            AcceuilGrid.Visibility = Visibility.Visible;
            if (DateTime.Today.Day.ToString() == "1")
            {
                CPNNotification.Visibility  = Visibility.Visible;
                CPoNNotification.Visibility = Visibility.Visible;
                RapportCPN.CreerRapport();
                RapportCPoN.CreerRapport();
            }
        }
Beispiel #2
0
        private void chercherRapportCPoN_click(object sender, RoutedEventArgs e)
        {
            string selectedItem = "";

            switch (comboBoxRapportCPoN.SelectionBoxItem.ToString())
            {
            case "Mois":
                selectedItem = "Mois";
                break;
            }
            try
            {
                if (DatePickerRapportCPoN.SelectedDate.ToString().Equals(""))
                {
                    rapportCPoNDataGrid.ItemsSource = RapportCPoN.chercherRapportCPoN(selectedItem, RapportCPoNSearchText.Text.Replace("'", "''")).DefaultView;
                }
                else
                {
                    rapportCPoNDataGrid.ItemsSource = RapportCPoN.chercherRapportCPoNAvecDate(selectedItem, RapportCPoNSearchText.Text.Replace("'", "''"), (DateTime)DatePickerRapportCPoN.SelectedDate).DefaultView;
                }
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show(ex.Message);
            }
        }
Beispiel #3
0
        private void DeleteRapportCPoN_Click(object sender, RoutedEventArgs e)
        {
            DataRowView dtr = (DataRowView)rapportCPoNDataGrid.SelectedItem;

            RapportCPoN.deleteRapport(dtr["id"].ToString());
            this.PageWindow_Loaded(sender, e);
        }
Beispiel #4
0
        public static void persistRapport(RapportCPoN r)
        {
            SqlConnection c = Connexion.connect();
            SqlCommand    command;
            DateTime      d   = DateTime.Today;
            string        tab = "rapportCPoN(Mois,date_creation,precoce,tardive,autre_type,hemorragie,infection,eclampsie,phlebite,mammaire,anemie,autre_complication,pec,referee,fer)";
            string        v   = "values('" + r.Mois + "','" + r.DateCreation.Date + "'," + Convert.ToInt32(r.Precoce) + "," + Convert.ToInt32(r.Tardive) + "," + Convert.ToInt32(r.Autre) + "," + Convert.ToInt32(r.Hemorragie) + "," + Convert.ToInt32(r.Infection) + "," + Convert.ToInt32(r.Eclampsie) + "," + Convert.ToInt32(r.Phlebite) + "," + Convert.ToInt32(r.Mammaire) + "," + Convert.ToInt32(r.Anemie) + "," + Convert.ToInt32(r.AutreComplication) + "," + Convert.ToInt32(r.PEC) + "," + Convert.ToInt32(r.Referee) + "," + Convert.ToInt32(r.Fer) + ")";
            string        q   = "insert into " + tab + " " + v;

            try
            {
                c.Open();
                command = new SqlCommand(q, c);
                command.ExecuteNonQuery();
                command.Dispose();
                c.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Beispiel #5
0
        public static void CreerRapport()
        {
            try
            {
                RapportCPoN r = new RapportCPoN();
                System.IO.Directory.CreateDirectory("C:/Users/HP/Desktop/RapportCPoN");
                var      yr       = DateTime.Today.Year;
                var      mth      = DateTime.Today.Month;
                DateTime firstDay = new DateTime(yr, mth, 1).AddMonths(-1);
                DateTime lastDay  = new DateTime(yr, mth, 1).AddDays(-1);
                r.DateCreation = DateTime.Today;
                r.Mois         = DateTime.Now.AddMonths(-1).ToString("MMMM", CultureInfo.CreateSpecificCulture("fr"));

                r.Precoce = RapportCPoN.NombreCPoN("Précoce", firstDay, lastDay).ToString();
                r.Tardive = RapportCPoN.NombreCPoN("Tardive", firstDay, lastDay).ToString();
                r.Autre   = RapportCPoN.NombreCPoN("Autre", firstDay, lastDay).ToString();

                r.Hemorragie        = RapportCPoN.NombreCPoNComplication("hemorragie", firstDay, lastDay).ToString();
                r.Infection         = RapportCPoN.NombreCPoNComplication("infection", firstDay, lastDay).ToString();
                r.Eclampsie         = RapportCPoN.NombreCPoNComplication("eclampsie", firstDay, lastDay).ToString();
                r.Phlebite          = RapportCPoN.NombreCPoNComplication("phlebite", firstDay, lastDay).ToString();
                r.Mammaire          = RapportCPoN.NombreCPoNComplication("mammaire", firstDay, lastDay).ToString();
                r.Anemie            = RapportCPoN.NombreCPoNComplication("anemie", firstDay, lastDay).ToString();
                r.AutreComplication = RapportCPoN.NombreCPoNComplication("autre", firstDay, lastDay).ToString();

                r.PEC     = RapportCPoN.NombreCponGar("PEC", firstDay, lastDay).ToString();
                r.Referee = RapportCPoN.NombreCponGar("Référée", firstDay, lastDay).ToString();

                r.Fer = RapportCPoN.NombreCPoNFer(firstDay, lastDay).ToString();

                if (!RapportCPoN.Exist(r.Mois, r.DateCreation))
                {
                    Document  doc = new Document(PageSize.A4);
                    PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream("C:/Users/HP/Desktop/RapportCPoN/" + r.DateCreation.Day.ToString() + "-" + r.DateCreation.Month.ToString() + "-" + r.DateCreation.Year.ToString() + ".pdf", FileMode.Create));
                    doc.Open();
                    Paragraph titre = new Paragraph("\nCONSULTATION POSTNATALE\n\n");
                    titre.Alignment = Element.ALIGN_CENTER;
                    Paragraph creation = new Paragraph("Rapport du mois de : " + r.Mois.ToUpper() + "\nDate de création" + r.DateCreation.Date.ToString());
                    creation.Alignment = Element.ALIGN_RIGHT;
                    Paragraph mois = new Paragraph("Date début :" + firstDay.Date + "\nDate fin :" + lastDay.Date);
                    mois.Alignment = Element.ALIGN_LEFT;
                    doc.Add(creation);
                    doc.Add(mois);
                    doc.Add(titre);
                    PdfPTable table = new PdfPTable(4);
                    PdfPCell  cell  = new PdfPCell(new Phrase("Performances\n"));
                    cell.Colspan = 3;
                    table.AddCell(cell);
                    table.AddCell("Urbain");

                    cell         = new PdfPCell(new Phrase("Nombre de femmes\nexaminées en consultation\ndu post partum"));
                    cell.Rowspan = 3;
                    table.AddCell(cell);
                    cell         = new PdfPCell(new Phrase("Précoce"));
                    cell.Colspan = 2;
                    table.AddCell(cell);
                    table.AddCell(r.Precoce);
                    cell         = new PdfPCell(new Phrase("Tardif"));
                    cell.Colspan = 2;
                    table.AddCell(cell);
                    table.AddCell(r.Tardive);
                    cell         = new PdfPCell(new Phrase("Autres"));
                    cell.Colspan = 2;
                    table.AddCell(cell);
                    table.AddCell(r.Autre);

                    cell                     = new PdfPCell(new Phrase("Nombre de cas compliqués\n"));
                    cell.Rowspan             = 9;
                    cell.HorizontalAlignment = Element.ALIGN_CENTER;
                    cell.VerticalAlignment   = Element.ALIGN_CENTER;
                    table.AddCell(cell);
                    cell                     = new PdfPCell(new Phrase("Complications\n"));
                    cell.Rowspan             = 7;
                    cell.HorizontalAlignment = Element.ALIGN_CENTER;
                    cell.VerticalAlignment   = Element.ALIGN_CENTER;
                    cell.Rotation            = 90;
                    table.AddCell(cell);
                    table.AddCell("Hémorragie");
                    table.AddCell(r.Hemorragie);
                    table.AddCell("Infection puerpérale");
                    table.AddCell(r.Infection);
                    table.AddCell("Eclampsie");
                    table.AddCell(r.Eclampsie);
                    table.AddCell("Phlébite");
                    table.AddCell(r.Phlebite);
                    table.AddCell("Complications mammaires");
                    table.AddCell(r.Mammaire);
                    table.AddCell("Anémie");
                    table.AddCell(r.Anemie);
                    table.AddCell("Autres\n");
                    table.AddCell(r.AutreComplication);
                    cell         = new PdfPCell(new Phrase("Nombre de cas compliqués PEC"));
                    cell.Colspan = 2;
                    table.AddCell(cell);
                    table.AddCell(r.PEC);
                    cell         = new PdfPCell(new Phrase("Nombre de cas compliqués Référés\n"));
                    cell.Colspan = 2;
                    table.AddCell(cell);
                    table.AddCell(r.Referee);

                    cell         = new PdfPCell(new Phrase("Nombre de femmes ayant reçu le Fer"));
                    cell.Colspan = 3;
                    table.AddCell(cell);
                    table.AddCell(r.Fer);

                    doc.Add(table);
                    doc.Close();
                    RapportCPoN.persistRapport(r);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }