public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CashierTransactionReport rpt = new CashierTransactionReport();
rpt.Site = this.Site;
return(rpt);
}
public void ShowCashierTransactionsHistoryReport(DataSet dsReportsDataSet, DateTime StartDate, DateTime EndDate, int userNo, string UserName, string sRouteName, int Route_No, string xml)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowCashierTransactionsReport method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CashierTransactionReport cashierTransactionReport = new CashierTransactionReport();
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo;
LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info);
cashierTransactionReport.SetDataSource(dsReportsDataSet);
LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info);
cashierTransactionReport.SetParameterValue("SiteCode", Settings.SiteCode);
cashierTransactionReport.SetParameterValue("@startdate", StartDate);
cashierTransactionReport.SetParameterValue("@enddate", EndDate);
cashierTransactionReport.SetParameterValue("@User", userNo);
cashierTransactionReport.SetParameterValue("@Route_No", Route_No);
//cashierTransactionReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
cashierTransactionReport.SetParameterValue("Version", sVersion);
cashierTransactionReport.SetParameterValue("SiteName", sSiteName);
cashierTransactionReport.SetParameterValue("UserName", UserName);
cashierTransactionReport.SetParameterValue("RouteName", sRouteName);
//cashierTransactionReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
cashierTransactionReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
cashierTransactionReport.SetParameterValue("@xml", xml);
IReports objReports = ReportsBusinessObject.CreateInstance();
List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString();
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = "Ticketing"; // read this information from config file.
myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file.
myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file.
crDatabase = cashierTransactionReport.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info);
crystalReportViewer.ReportSource = cashierTransactionReport;
LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info);
AuditReports();
strReportName = "Cashier Transaction History Summary";
}
catch (Exception ex)
{
throw ex;
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
CashierTransactionReport rpt = new CashierTransactionReport();
rpt.Site = this.Site;
return rpt;
}
