public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
EmpTrans_REAL_Rpt rpt = new EmpTrans_REAL_Rpt();
rpt.Site = this.Site;
return(rpt);
}
private void glassButton2_Click(object sender, EventArgs e)
{
//string sort = "";
//if (radioButton1.Checked)
//{
// sort = "Order by [NAME],[Date]";
//}
//if (radioButton2.Checked)
//{
// sort = "Order by [Card Number],[Transaction Date]";
//}
//if (radioButton3.Checked)
//{
// sort = "Order by [Transaction Date]";
//}
//if (radioButton4.Checked)
//{
// sort = "Order by Department,[Card Number],[Transaction Date]";
//}
_cmd = new SqlCommand();
_cmd.Connection = frmMainForm._MasterCon;
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.CommandText = "GET_REAL_TIME";
_cmd.CommandTimeout = 2000;
//_cmd.Parameters.Add("@FROMDATE", SqlDbType.VarChar).Value = "'"+dtpDateFrom.Value.ToString("yyyy/MM/dd")+"'";
//_cmd.Parameters.Add("@TODATE", SqlDbType.VarChar).Value = "'" + dtpDateTo.Value.ToString("yyyy/MM/dd")+"'";
//_cmd.Parameters.Add("@DEP", SqlDbType.VarChar).Value = "'" + cmbDep.SelectedValue.ToString()+"'";
//_cmd.Parameters.Add("@CARD", SqlDbType.VarChar).Value = "'" + cmbEmployee.SelectedValue.ToString()+"'";
//_cmd.Parameters.Add("@LOC", SqlDbType.VarChar).Value = "'Cairo'";
//_cmd.Parameters.Add("@COM", SqlDbType.VarChar).Value = "'PhPC'";
_cmd.Parameters.Add("@FROMDATE", SqlDbType.VarChar).Value = dtpDateFrom.Value.ToString("yyyy/MM/dd");
_cmd.Parameters.Add("@TODATE", SqlDbType.VarChar).Value = dtpDateTo.Value.ToString("yyyy/MM/dd");
_cmd.Parameters.Add("@DEP", SqlDbType.VarChar).Value = cmbDep.SelectedValue.ToString();
_cmd.Parameters.Add("@CARD", SqlDbType.VarChar).Value = cmbEmployee.SelectedValue.ToString();
_cmd.Parameters.Add("@LOC", SqlDbType.VarChar).Value = "Cairo";
_cmd.Parameters.Add("@COM", SqlDbType.VarChar).Value = "PhPC";
//Str = "select CARD,NAME,JOB,Department,DATE,[Enter Time],[Exit Time],[WORK HOURS] from VTransaction_IN_OUT_FINAL " + FilterString;
_da = new SqlDataAdapter(_cmd);
_Dt = new DataTable();
_Dt.Reset();
_da.Fill(_Dt);
/*_cmd = new SqlCommand(Str3 + sort, frmMainForm._MasterCon);
* //Str = "select [Employee Name] ,[Card Number],[Transaction Date],Time,Place,Job,Department from VTransactions " + FilterString;
* _cmd.CommandTimeout = 2000;
* _da = new SqlDataAdapter(_cmd);
* _Dt = new DataTable();
* _Dt.Reset();
*
* _da.Fill(_Dt);
*/
//////////////////////////////////////////////////////
EmpTrans_REAL_Rpt EmpTransRpt = new EmpTrans_REAL_Rpt();
//EmpTransRptAr EmpTransRptAr = new EmpTransRptAr();
/////////////////////////////////////////////////////////////////////
frmReportViewer2 Viewer = new frmReportViewer2();
if (_Dt.Rows.Count == 0)
{
MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//////////////////////////////////////////////////////
EmpTransRpt.Database.Tables["GET_REAL_TIME"].SetDataSource(_Dt);
EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text);
EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_To.ParameterFieldName, dtpDateTo.Text);
Viewer.crystalReportViewer1.ReportSource = EmpTransRpt;
Viewer.ShowDialog();
//////////////////////////////////////////////////////
//////////////////////////////////////////////////////
}
