private void FrmDashbord_Load(object sender, EventArgs e)
{
ImplementeConnexion.Instance.Initialise();
nbragent.Text = pro.NbreEnregistrement("Agent", "count(Id)").ToString();
NbrePatient.Text = pro.NbreEnregistrement("Patient where id is not null", "count(Id)").ToString();
NbreConsultation.Text = pro.NbreEnregistrement("Liste_consultation", "count(Id)").ToString();
examine.Text = pro.NbreEnregistrement("liste_Examen", "count(Id)").ToString();
entree.Text = pro.NbreEnregistrement("Appro_Medicament", "sum(Qte) ").ToString();
sortie.Text = pro.NbreEnregistrement("Liste_Consommation where id is not null", "sum(Qte)").ToString();
stockDispo.Text = (int.Parse(entree.Text) - int.Parse(sortie.Text)).ToString();
try
{
chart1.Series["Entree"].IsValueShownAsLabel = true;
d.Graphique(chart1, "Entree", "select Qte from Appro_Medicament ", "Produit", "Qte");
chart1.Series["Sortie"].IsValueShownAsLabel = true;
d.Graphique(chart1, "Sortie", "select Qte from Liste_Consommation ", "Patient", "Qte");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
fx.Picture_Rond(pan1);
fx.Picture_Rond(pan2);
timer1.Start();
}
private void FrmStatistique_Load(object sender, EventArgs e)
{
ImplementeConnexion.Instance.Initialise();
nbragent.Text = pro.NbreEnregistrement("Agent", "count(Id)").ToString();
NbrePatient.Text = pro.NbreEnregistrement("Patient where id is not null", "count(Id)").ToString();
NbreConsultation.Text = pro.NbreEnregistrement("Liste_consultation", "count(Id)").ToString();
examine.Text = pro.NbreEnregistrement("liste_Examen", "count(Id)").ToString();
entree.Text = pro.NbreEnregistrement("Appro_Medicament ", "sum(Qte)").ToString();
sortie.Text = pro.NbreEnregistrement("Liste_Consommation where id is not null", "sum(Qte)").ToString();
stockDispo.Text = (int.Parse(entree.Text) - int.Parse(sortie.Text)).ToString();
mtEntree.Text = pro.Montant("Liste_Paiement where id is not null and Etat=1", "sum(isnull(Paye,0)) ").ToString();
mtSortie.Text = pro.Montant("V_Depense where id is not null and Etat=1", "sum(isnull(Montant,0)) ").ToString();
mtDispo.Text = (decimal.Parse(mtEntree.Text) - decimal.Parse(mtSortie.Text)).ToString();
try
{
chart1.Series["Entree"].IsValueShownAsLabel = true;
d.Graphique(chart1, "Entree", "select Qte from Appro_Medicament ", "Produit", "Qte");
chart1.Series["Sortie"].IsValueShownAsLabel = true;
d.Graphique(chart1, "Sortie", "select Qte from Liste_Consommation ", "Patient", "Qte");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
timer1.Start();
}