public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CashDispenserTransactionDetails rpt = new CashDispenserTransactionDetails(); rpt.Site = this.Site; return(rpt); }
public void ShowVaultEventDetailReport(int Vault_Id, string Type, int No_Of_Records, string searchkey, DateTime StartDate, DateTime EndDate) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside Show Vault Event Details Report method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo = new TableLogOnInfo(); CashDispenserTransactionDetails VaultEventDet = new CashDispenserTransactionDetails(); VaultEventDet.SetParameterValue("SiteCode", Settings.SiteCode); VaultEventDet.SetParameterValue("@EventType", Type); VaultEventDet.SetParameterValue("@No_Of_Records", No_Of_Records); VaultEventDet.SetParameterValue("@SearchKey", searchkey); VaultEventDet.SetParameterValue("@StartDate", StartDate); VaultEventDet.SetParameterValue("@EndDate", EndDate); VaultEventDet.SetParameterValue("SiteName", sSiteName); VaultEventDet.SetParameterValue("Version", sVersion); VaultEventDet.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); VaultEventDet.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); VaultEventDet.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); 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 = DbConnectionInfo[0].DataBase; // 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 = VaultEventDet.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = VaultEventDet; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "Vault Event Details Report"; } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CashDispenserTransactionDetails rpt = new CashDispenserTransactionDetails(); rpt.Site = this.Site; return rpt; }