public void RapportDepensesMonth(string month, int year)
{
try
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "GetDepensesMonth";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@month", 50, DbType.String, month));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@year", 50, DbType.Int32, year));
DataSet ds = new DataSet();
SqlDataAdapter dscmd = new SqlDataAdapter((SqlCommand)cmd);
dscmd.Fill(ds, "Affichage_Finance_Depense");
CR_Depense entree = new CR_Depense();
entree.SetDataSource(ds);
crystalReportViewer1.ReportSource = entree;
crystalReportViewer1.Refresh();
}
}
catch (Exception ex)
{
MessageBox.Show("L'erreur suivant est survenue : " + ex.Message);
}
}
public void RapportDepensesToday()
{
try
{
FrmImpression frm = new FrmImpression();
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "GetDepensesToday";
cmd.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter dscmd = new SqlDataAdapter((SqlCommand)cmd);
dscmd.Fill(ds, "Affichage_Finance_Depense");
CR_Depense entree = new CR_Depense();
entree.SetDataSource(ds);
frm.crystalReportViewer1.ReportSource = entree;
frm.crystalReportViewer1.Refresh();
frm.rapport = "Depenses";
frm.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show("L'erreur suivant est survenue : " + ex.Message);
}
}
