private void bunifuFlatButton2_Click(object sender, EventArgs e)
{
string da1 = txtdate.Value.ToString("dd/MM/yyyy");
try
{
RapportPresence cr = new RapportPresence();
dao.InitialiserConnexion();
if (!dao.conn.State.ToString().ToLower().Equals("open"))
{
dao.conn.Open();
}
string rqt = "select* from V_SELECT_PRESENCE where CONVERT(date, DATE_PRESENCE, 103) = CONVERT(date, '" + da1 + "', 103)";
dao.daset = new DataSet();
dao.dp = new SqlDataAdapter(rqt, dao.conn);
dao.dp.Fill(dao.daset, "V_SELECT_PRESENCE");
cr.SetDataSource(dao.daset.Tables["V_SELECT_PRESENCE"]);
crystalReportViewer1.ReportSource = cr;
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void simpleButton4_Click(object sender, EventArgs e)
{
if (txtdate1.Text == "" || txtdate2.Text == "")
{
MessageBox.Show("Entrez les date svp !!!");
}
else
{
try
{
RapportPresence be = new RapportPresence();
be.DataSource = clreport.GetInstance().get_Report_Trier("viewPresence", "DatePresnce", DateTime.Parse(txtdate1.Text.Trim()), DateTime.Parse(txtdate2.Text.Trim()));
using (ReportPrintTool printTool = new ReportPrintTool(be))
{
printTool.ShowPreviewDialog();
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
}
