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();
}
}
private void chercherRapportCPN_click(object sender, RoutedEventArgs e)
{
string selectedItem = "";
switch (comboBoxRapportCPN.SelectionBoxItem.ToString())
{
case "Mois":
selectedItem = "Mois";
break;
}
try
{
if (DatePickerRapportCPN.SelectedDate.ToString().Equals(""))
{
rapportCPNDataGrid.ItemsSource = RapportCPN.chercherRapportCPN(selectedItem, RapportCPNSearchText.Text.Replace("'", "''")).DefaultView;
}
else
{
rapportCPNDataGrid.ItemsSource = RapportCPN.chercherRapportCPNAvecDate(selectedItem, RapportCPNSearchText.Text.Replace("'", "''"), (DateTime)DatePickerRapportCPN.SelectedDate).DefaultView;
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
}
private void DeleteRapportCPN_Click(object sender, RoutedEventArgs e)
{
DataRowView dtr = (DataRowView)rapportCPNDataGrid.SelectedItem;
RapportCPN.deleteRapport(dtr["id"].ToString());
this.PageWindow_Loaded(sender, e);
}
public static void persistRapport(RapportCPN r)
{
SqlConnection c = Connexion.connect();
SqlCommand command;
DateTime d = DateTime.Today;
string tab = "rapportCPN(Mois,date_creation,cpn1,cpn2,cpn3_8,cpn3_9,autre_cpn,cpn_medicalise,metrorragie,hta,diabete,cardiopathie,infection,autre_risque,gar_pec,gar_referee,fer,vitamine_d,anemie,cpn2_ni,cpn2_ai,cpn3_8_ni,cpn3_8_ai,cpn3_9_ni,cpn3_9_ai,autre_cpn_ni,autre_cpn_ai)";
string v = "values('" + r.Mois + "','" + r.DateCreation.Date + "'," + Convert.ToInt32(r.NbreCPN1) + "," + Convert.ToInt32(r.NbreCPN2) + "," + Convert.ToInt32(r.NbreCPN3_8) + "," + Convert.ToInt32(r.NbreCPN3_9) + "," + Convert.ToInt32(r.NbreAutreCPN) + "," + Convert.ToInt32(r.NbreCPNMedicalise) + "," + Convert.ToInt32(r.NbreMetrorragie) + "," + Convert.ToInt32(r.NbreHTA) + "," + Convert.ToInt32(r.NbreDiabete) + "," + Convert.ToInt32(r.NbreCardiopathie) + "," + Convert.ToInt32(r.NbreInfection) + "," + Convert.ToInt32(r.NbreAutreRisque) + "," + Convert.ToInt32(r.NbreGarPec) + "," + Convert.ToInt32(r.NbreGarReferee) + "," + Convert.ToInt32(r.NbreFer) + "," + Convert.ToInt32(r.NbreVitamineD) + "," + Convert.ToInt32(r.NbreAnemie) + "," + Convert.ToInt32(r.NbreCpn2Ni) + "," + Convert.ToInt32(r.NbreCpn2Ai) + "," + Convert.ToInt32(r.NbreCPN3_8NI) + "," + Convert.ToInt32(r.NbreCPN3_8AI) + "," + Convert.ToInt32(r.NbreCPN3_9NI) + "," + Convert.ToInt32(r.NbreCPN3_9AI) + "," + Convert.ToInt32(r.NbreAutreCPNNI) + "," + Convert.ToInt32(r.NbreAutreCPNAI) + ")";
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);
}
}
public static void CreerRapport()
{
try
{
RapportCPN r = new RapportCPN();
System.IO.Directory.CreateDirectory("C:/Users/HP/Desktop/RapportCPN");
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.NbreCPN1 = RapportCPN.NombreCPN("CPN1", firstDay, lastDay).ToString();
r.NbreCPN2 = RapportCPN.NombreCPN("CPN2", firstDay.Date, lastDay.Date).ToString();
r.NbreCpn2Ni = RapportCPN.NombreCPNInscription("CPN2", firstDay.Date, lastDay.Date, "NI").ToString();
r.NbreCpn2Ai = RapportCPN.NombreCPNInscription("CPN2", firstDay.Date, lastDay.Date, "AI").ToString();
r.NbreCPN3_8 = RapportCPN.NombreCPN3("8", firstDay.Date, lastDay.Date).ToString();
r.NbreCPN3_8NI = RapportCPN.NombreCPN3Inscription("8", firstDay.Date, lastDay.Date, "NI").ToString();
r.NbreCPN3_8AI = RapportCPN.NombreCPN3Inscription("8", firstDay.Date, lastDay.Date, "AI").ToString();
r.NbreCPN3_9 = RapportCPN.NombreCPN3("9", firstDay.Date, lastDay.Date).ToString();
r.NbreCPN3_9NI = RapportCPN.NombreCPN3Inscription("9", firstDay.Date, lastDay.Date, "NI").ToString();
r.NbreCPN3_9AI = RapportCPN.NombreCPN3Inscription("9", firstDay.Date, lastDay.Date, "AI").ToString();
r.NbreAutreCPN = RapportCPN.NombreCPN("Autre", firstDay.Date, lastDay.Date).ToString();
r.NbreAutreCPNNI = RapportCPN.NombreCPNInscription("Autre", firstDay.Date, lastDay.Date, "NI").ToString();
r.NbreAutreCPNAI = RapportCPN.NombreCPNInscription("Autre", firstDay.Date, lastDay.Date, "AI").ToString();
r.NbreCPNMedicalise = RapportCPN.NombreCPNMedicalise(firstDay.Date, lastDay.Date).ToString();
r.NbreMetrorragie = RapportCPN.NombreCPNRisque("metrorragie", firstDay.Date, lastDay.Date).ToString();
r.NbreHTA = RapportCPN.NombreCPNRisque("hta", firstDay.Date, lastDay.Date).ToString();
r.NbreAnemie = RapportCPN.NombreCPNRisque("anemie", firstDay.Date, lastDay.Date).ToString();
r.NbreDiabete = RapportCPN.NombreCPNRisque("diabete", firstDay.Date, lastDay.Date).ToString();
r.NbreCardiopathie = RapportCPN.NombreCPNRisque("cardiopathie", firstDay.Date, lastDay.Date).ToString();
r.NbreInfection = RapportCPN.NombreCPNRisque("infection", firstDay.Date, lastDay.Date).ToString();
r.NbreAutreRisque = RapportCPN.NombreCPNRisque("autres", firstDay.Date, lastDay.Date).ToString();
r.NbreGarPec = RapportCPN.NombreCpnGar("PEC", firstDay.Date, lastDay.Date).ToString();
r.NbreGarReferee = RapportCPN.NombreCpnGar("Référée", firstDay.Date, lastDay.Date).ToString();
r.NbreFer = RapportCPN.NombreSupplement("fer", firstDay.Date, lastDay.Date).ToString();
r.NbreVitamineD = RapportCPN.NombreSupplement("vitamine_d", firstDay.Date, lastDay.Date).ToString();
if (!RapportCPN.Exist(r.Mois, r.DateCreation))
{
Document doc = new Document(PageSize.A4);
PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream("C:/Users/HP/Desktop/RapportCPN/" + r.DateCreation.Day.ToString() + "-" + r.DateCreation.Month.ToString() + "-" + r.DateCreation.Year.ToString() + ".pdf", FileMode.Create));
doc.Open();
Paragraph titre = new Paragraph("\nCONSULTATION PRENATALE\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("CPN du 1er trimestre\n(<= 15 SA)\n"));
cell.Colspan = 2;
table.AddCell(cell);
table.AddCell("NI\n");
table.AddCell(r.NbreCPN1);
cell = new PdfPCell(new Phrase("CPN du 2ème trimestre (24 à 28 SA)\n"));
cell.Rowspan = 2;
cell.Colspan = 2;
table.AddCell(cell);
table.AddCell("NI\n");
table.AddCell(r.NbreCpn2Ni);
table.AddCell("AI\n");
table.AddCell(r.NbreCpn2Ai);
cell = new PdfPCell(new Phrase("CPN du 3ème\ntrimestre\n"));
cell.Rowspan = 4;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("8ème mois\n(32 à 34 SA)\n"));
cell.Rowspan = 2;
table.AddCell(cell);
table.AddCell("NI\n");
table.AddCell(r.NbreCPN3_8NI);
table.AddCell("AI\n");
table.AddCell(r.NbreCPN3_8AI);
cell = new PdfPCell(new Phrase("9ème mois\n(>36 SA)\n"));
cell.Rowspan = 2;
table.AddCell(cell);
table.AddCell("NI\n");
table.AddCell(r.NbreCPN3_9NI);
table.AddCell("AI\n");
table.AddCell(r.NbreCPN3_9AI);
cell = new PdfPCell(new Phrase("Autres consultations prénatales\n"));
cell.Rowspan = 2;
cell.Colspan = 2;
table.AddCell(cell);
table.AddCell("NI\n");
table.AddCell(r.NbreAutreCPNNI);
table.AddCell("AI\n");
table.AddCell(r.NbreAutreCPNAI);
cell = new PdfPCell(new Phrase("Nombre de CPN médicalisées\n"));
cell.Colspan = 3;
table.AddCell(cell);
table.AddCell(r.NbreCPNMedicalise);
cell = new PdfPCell(new Phrase("Grossesses à risque\n"));
cell.Rowspan = 9;
cell.Rotation = 90;
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.VerticalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Nombre de risques\ndépistées\n"));
cell.Rowspan = 7;
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.VerticalAlignment = Element.ALIGN_CENTER;;
table.AddCell(cell);
table.AddCell("Métrorragie\n");
table.AddCell(r.NbreMetrorragie);
table.AddCell("HTA\n");
table.AddCell(r.NbreHTA);
table.AddCell("Anémie\n");
table.AddCell(r.NbreAnemie);
table.AddCell("Diabète\n");
table.AddCell(r.NbreDiabete);
table.AddCell("Cardiopathie\n");
table.AddCell(r.NbreCardiopathie);
table.AddCell("Infection\n");
table.AddCell(r.NbreInfection);
table.AddCell("Autres\n");
table.AddCell(r.NbreAutreRisque);
cell = new PdfPCell(new Phrase("Nbre GAR Prises en charge\n"));
cell.Colspan = 2;
table.AddCell(cell);
table.AddCell(r.NbreGarPec);
cell = new PdfPCell(new Phrase("Nbre GAR Référées\n"));
cell.Colspan = 2;
table.AddCell(cell);
table.AddCell(r.NbreGarReferee);
cell = new PdfPCell(new Phrase("Suplémentation\n"));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.VerticalAlignment = Element.ALIGN_CENTER;
cell.Rowspan = 2;
cell.Rotation = 90;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Nombre de femmes ayant reçu le\nfer\n"));
cell.Colspan = 2;
table.AddCell(cell);
table.AddCell(r.NbreFer);
cell = new PdfPCell(new Phrase("Nombre de femmes ayant reçu la\nvitamine D\n"));
cell.Colspan = 2;
table.AddCell(cell);
table.AddCell(r.NbreVitamineD);
doc.Add(table);
doc.Close();
RapportCPN.persistRapport(r);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
