private void btnRptView_Click(object sender, EventArgs e)
{
try
{
frmReportViewer objRpt = new frmReportViewer();
ReportDocument objRptDoc = new ReportDocument();
ConnectionInfo objConInfo = new ConnectionInfo();
TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo();
Tables objCrTables;
objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptEmpWiseVistDet.rpt");
objConInfo.ServerName = GeneralBLL.GetSqlServerPCName();
objConInfo.DatabaseName = GeneralBLL.GetDatabaseName();
objConInfo.UserID = GeneralBLL.GetDBUserName();
objConInfo.Password = GeneralBLL.GetDBPwd();
objConInfo.IntegratedSecurity = false;
objCrTables = objRptDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table objCrTable in objCrTables)
{
objTableLogOnInfo = objCrTable.LogOnInfo;
objTableLogOnInfo.ConnectionInfo = objConInfo;
objCrTable.ApplyLogOnInfo(objTableLogOnInfo);
}
DateTime mFromDate = Convert.ToDateTime(dtpFromDate.Text);
DateTime mToDate = Convert.ToDateTime(dtpToDate.Text);
if (cboEmployee.Text != "ALL")
{
objRptDoc.RecordSelectionFormula = " Date({VISITORGATEPASS.GATEDATE})>= #" + dtpFromDate.Text + "# And Date({VISITORGATEPASS.GATEDATE})<= #" + dtpToDate.Text + "# And ({VISITORGATEPASS.TOMEET}) = '" + cboEmployee.Text + "'";
}
else
{
objRptDoc.RecordSelectionFormula = " Date({VISITORGATEPASS.GATEDATE})>= #" + dtpFromDate.Text + "# And Date({VISITORGATEPASS.GATEDATE})<= #" + dtpToDate.Text + "# ";
}
objRpt.crystalReportViewer1.ReportSource = objRptDoc;
objRpt.MdiParent = this.MdiParent;
objRpt.WindowState = FormWindowState.Maximized;
objRpt.crystalReportViewer1.Refresh();
objRpt.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
AppLogger.Error(ex.Message.ToString() + "\n" + ex.InnerException.Message.ToString());
}
}
private void printToolStripMenuItem_Click(object sender, EventArgs e)
{
//rptVisitorGatePass rptGatePass = new rptVisitorGatePass();
//frmReportViewer objRpt = new frmReportViewer();
//rptGatePass.RecordSelectionFormula = "({VISITORGATEPASS.DBID}) = " + (lvwGPs.SelectedItems[0].Name);
//objRpt.crystalReportViewer1.ReportSource = rptGatePass;
//objRpt.crystalReportViewer1.Refresh();
//objRpt.Show();
try
{
if (objUIRights.PrintRight)
{
// Ganesh Code Starts Here..
frmReportViewer objRpt = new frmReportViewer();
ReportDocument objRptDoc = new ReportDocument();
ConnectionInfo objConInfo = new ConnectionInfo();
TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo();
Tables objCrTables;
objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptVisitorGatePass.rpt");
objConInfo.ServerName = GeneralBLL.GetSqlServerPCName();
objConInfo.DatabaseName = GeneralBLL.GetDatabaseName();
objConInfo.UserID = GeneralBLL.GetDBUserName();
objConInfo.Password = GeneralBLL.GetDBPwd();
//objConInfo.ServerName = "ITProject";
//objConInfo.DatabaseName = "DTPL";
//objConInfo.UserID = "VMSUser";
//objConInfo.Password = "******";
objConInfo.IntegratedSecurity = false;
objCrTables = objRptDoc.Database.Tables;
foreach (Table objCrTable in objCrTables)
{
objTableLogOnInfo = objCrTable.LogOnInfo;
objTableLogOnInfo.ConnectionInfo = objConInfo;
objCrTable.ApplyLogOnInfo(objTableLogOnInfo);
}
objRptDoc.RecordSelectionFormula = "({VISITORGATEPASS.DBID}) = " + (lvwGPs.SelectedItems[0].Name);
objRpt.crystalReportViewer1.ReportSource = objRptDoc;
objRpt.MdiParent = this.MdiParent;
objRpt.WindowState = FormWindowState.Maximized;
objRpt.crystalReportViewer1.Refresh();
objRpt.Show();
// Ganesh Code Ends Here..
AppLogger.Error("Report displayed " + DateTime.Now);
}
else
{
throw new Exception("Not Authorised.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
AppLogger.Error(ex.Message.ToString());
AppLogger.Error(ex.InnerException.ToString());
AppLogger.Error(ex.StackTrace.ToString());
}
}
private void btnRptView_Click(object sender, EventArgs e)
{
//try
//{
// //string strRecSelect = null;
// ReportDocument objRptDoc = new ReportDocument();
// ConnectionInfo objConInfo = new ConnectionInfo();
// TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo();
// Tables objCrTables;
// objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptRetDCDetail.rpt");
// objConInfo.ServerName = GeneralBLL.GetSqlServerPCName();
// objConInfo.DatabaseName = GeneralBLL.GetDatabaseName();
// objConInfo.UserID = GeneralBLL.GetDBUserName();
// objConInfo.Password = GeneralBLL.GetDBPwd();
// objConInfo.IntegratedSecurity = false;
// objCrTables = objRptDoc.Database.Tables;
// foreach (Table objCrTable in objCrTables)
// {
// objTableLogOnInfo = objCrTable.LogOnInfo;
// objTableLogOnInfo.ConnectionInfo = objConInfo;
// objCrTable.ApplyLogOnInfo(objTableLogOnInfo);
// }
// DateTime mFromDate = Convert.ToDateTime(dtpFromDate.Text);
// DateTime mToDate = Convert.ToDateTime(dtpToDate.Text);
// //strRecSelect = " Date({RETURNABLEDC.ENTRYDATE})>= #" + mFromDate.ToString("yyyy-MM-dd") + "# And Date({RETURNABLEDC.ENTRYDATE})<= #" + mToDate.ToString("yyyy-MM-dd") + "#";
// //strRecSelect = " Date({RETURNABLEDC.ENTRYDATE})>= @mFromDate And Date({RETURNABLEDC.ENTRYDATE})<= @mToDate ";
// //if (cboParty.Text.Trim() != "ALL")
// //{
// // //objRptDoc.RecordSelectionFormula = " Date({RETURNABLEDC.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({RETURNABLEDC.ENTRYDATE})<= #" + dtpToDate.Text + "# And ({RETURNABLEDC.PARTYNAME}) = '" + cboParty.Text + "'";
// // strRecSelect += " And ({RETURNABLEDC.PARTYNAME}) = '" + cboParty.Text + "'";
// //}
// //objRptDoc.RecordSelectionFormula = strRecSelect;
// // Start
// objRptDoc.ParameterFields.Add("mFromDate");
// objRptDoc.ParameterFields.Add("mToDate");
// objRptDoc.SetParameterValue("mFromDate", mFromDate.ToShortDateString());
// objRptDoc.SetParameterValue("mToDate", mToDate.ToShortDateString());
// if (cboParty.Text.Trim() != "ALL")
// {
// objRptDoc.ParameterFields.Add("mParty");
// objRptDoc.SetParameterValue("mParty", cboParty.Text);
// }
// // End
// frmReportViewer objFrmRpt = new frmReportViewer();
// objFrmRpt.crystalReportViewer1.ReportSource = objRptDoc;
// objFrmRpt.MdiParent = this.MdiParent;
// objFrmRpt.WindowState = FormWindowState.Maximized;
// objFrmRpt.crystalReportViewer1.Refresh();
// objFrmRpt.Show();
// //objRpt.crystalReportViewer1.ReportSource = objRptDoc;
// //objRpt.MdiParent = this.MdiParent;
// //objRpt.WindowState = FormWindowState.Maximized;
// //objRpt.crystalReportViewer1.Refresh();
// //objRpt.Show();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.InnerException.ToString(), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
//}
try
{
DateTime mFromDate, mToDate;
ConnectionInfo objConInfo = new ConnectionInfo();
TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo();
Tables objCrTables;
rptRetDCReport objRptDoc = new rptRetDCReport();
frmReportViewer objFrmRpt = new frmReportViewer();
mFromDate = dtpFromDate.Value.Date;
mToDate = dtpToDate.Value.Date;
objRptDoc.SetParameterValue("@EntryType", cboEntryType.Text);
objRptDoc.SetParameterValue("@FromDate", mFromDate);
objRptDoc.SetParameterValue("@ToDate", mToDate);
objConInfo.ServerName = GeneralBLL.GetSqlServerPCName();
objConInfo.DatabaseName = GeneralBLL.GetDatabaseName();
objConInfo.UserID = GeneralBLL.GetDBUserName();
objConInfo.Password = GeneralBLL.GetDBPwd();
objConInfo.IntegratedSecurity = false;
objCrTables = objRptDoc.Database.Tables;
foreach (Table objCrTable in objCrTables)
{
objTableLogOnInfo = objCrTable.LogOnInfo;
objTableLogOnInfo.ConnectionInfo = objConInfo;
objCrTable.ApplyLogOnInfo(objTableLogOnInfo);
}
objFrmRpt.crystalReportViewer1.ReportSource = null;
objFrmRpt.crystalReportViewer1.ReportSource = objRptDoc;
objFrmRpt.MdiParent = this.MdiParent;
objFrmRpt.WindowState = FormWindowState.Maximized;
objFrmRpt.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btnRptView_Click(object sender, EventArgs e)
{
// try
// {
// frmReportViewer objRpt = new frmReportViewer();
// ReportDocument objRptDoc = new ReportDocument();
// ConnectionInfo objConInfo = new ConnectionInfo();
// TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo();
// Tables objCrTables;
// objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptVehInOutDet.rpt");
// objConInfo.ServerName = GeneralBLL.GetSqlServerPCName();
// objConInfo.DatabaseName = GeneralBLL.GetDatabaseName();
// objConInfo.UserID = GeneralBLL.GetDBUserName();
// objConInfo.Password = GeneralBLL.GetDBPwd();
// objConInfo.IntegratedSecurity = false;
// objCrTables = objRptDoc.Database.Tables;
// foreach (CrystalDecisions.CrystalReports.Engine.Table objCrTable in objCrTables)
// {
// objTableLogOnInfo = objCrTable.LogOnInfo;
// objTableLogOnInfo.ConnectionInfo = objConInfo;
// objCrTable.ApplyLogOnInfo(objTableLogOnInfo);
// }
// DateTime mFromDate = Convert.ToDateTime(dtpFromDate.Text);
// DateTime mToDate = Convert.ToDateTime(dtpToDate.Text);
// int tempValue;
// string strSelect;
// strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + mFromDate.ToString("yyyy-MM-dd") + "# And Date({VEHINOUTDETAIL.ENTRYDATE}) <= #" + mToDate.ToString("yyyy-MM-dd") + "# ";
//// CONVERT(varchar, mFromDate, 23)
// //if (cboType.Text == "ALL")
// //{
// // //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# ";
// // strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# ";
// //}
// if (cboType.Text == "COMPANY")
// {
// tempValue = 1;
// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text +
// // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text +
// // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// }
// else if (cboType.Text == "IN/OUT OTHER")
// {
// tempValue = 4;
// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text +
// // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text +
// // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// }
// objRptDoc.RecordSelectionFormula = strSelect;
// objRpt.crystalReportViewer1.ReportSource = objRptDoc;
// objRpt.MdiParent = this.MdiParent;
// objRpt.WindowState = FormWindowState.Maximized;
// objRpt.crystalReportViewer1.Refresh();
// objRpt.Show();
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// }
try
{
frmReportViewer objRpt = new frmReportViewer();
rptVehInOutDet objRptDoc = new rptVehInOutDet();
ConnectionInfo objConInfo = new ConnectionInfo();
TableLogOnInfo objTableLogOnInfo = new TableLogOnInfo();
Tables objCrTables;
if (cboType.Text == "COMPANY")
{
objRptDoc.SetParameterValue("@Type", 4);
}
else if (cboType.Text == "IN/OUT OTHER")
{
objRptDoc.SetParameterValue("@Type", 1);
}
objRptDoc.SetParameterValue("@FromDate", dtpFromDate.Value.Date);
objRptDoc.SetParameterValue("@ToDate", dtpToDate.Value.Date);
//objRptDoc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\Reports\\rptVehInOutDet.rpt");
objConInfo.ServerName = GeneralBLL.GetSqlServerPCName();
objConInfo.DatabaseName = GeneralBLL.GetDatabaseName();
objConInfo.UserID = GeneralBLL.GetDBUserName();
objConInfo.Password = GeneralBLL.GetDBPwd();
objConInfo.IntegratedSecurity = false;
objCrTables = objRptDoc.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table objCrTable in objCrTables)
{
objTableLogOnInfo = objCrTable.LogOnInfo;
objTableLogOnInfo.ConnectionInfo = objConInfo;
objCrTable.ApplyLogOnInfo(objTableLogOnInfo);
}
//DateTime mFromDate = Convert.ToDateTime(dtpFromDate.Text);
//DateTime mToDate = Convert.ToDateTime(dtpToDate.Text);
//int tempValue;
//string strSelect;
//strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + mFromDate.ToString("yyyy-MM-dd") + "# And Date({VEHINOUTDETAIL.ENTRYDATE}) <= #" + mToDate.ToString("yyyy-MM-dd") + "# ";
//// CONVERT(varchar, mFromDate, 23)
////if (cboType.Text == "ALL")
////{
//// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# ";
//// strSelect = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text + "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text + "# ";
////}
//if (cboType.Text == "COMPANY")
//{
// tempValue = 1;
// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text +
// // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text +
// // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
//}
//else if (cboType.Text == "IN/OUT OTHER")
//{
// tempValue = 4;
// //objRptDoc.RecordSelectionFormula = " Date({VEHINOUTDETAIL.ENTRYDATE})>= #" + dtpFromDate.Text +
// // "# And Date({VEHINOUTDETAIL.ENTRYDATE})<= #" + dtpToDate.Text +
// // "# And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
// strSelect += " And ({VEHINOUTDETAIL.TYPE}) = " + tempValue;
//}
//objRptDoc.RecordSelectionFormula = strSelect;
objRpt.crystalReportViewer1.ReportSource = objRptDoc;
objRpt.MdiParent = this.MdiParent;
objRpt.WindowState = FormWindowState.Maximized;
objRpt.crystalReportViewer1.Refresh();
objRpt.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
