public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
LiquidationSummary_PS rpt = new LiquidationSummary_PS();
rpt.Site = this.Site;
return(rpt);
}
internal void PrintLiquidationReportForProfitShare()
{
try
{
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
ConnectionInfo connectionInfo = new ConnectionInfo();
DbConnectionDetails.DatabaseName = "Exchange";
connectionInfo.ServerName = DbConnectionDetails.ServerName;
connectionInfo.UserID = DbConnectionDetails.UserName;
connectionInfo.Password = DbConnectionDetails.Password;
connectionInfo.DatabaseName = DbConnectionDetails.DatabaseName;
var rLiquidationReportForProfitShare = new LiquidationSummary_PS();
crDatabase = rLiquidationReportForProfitShare.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = rLiquidationReportForProfitShare;
crystalReportViewer.Show();
crystalReportViewer.PrintReport();
AuditReports();
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
public void ShowLiquidationReportForRead(int? iBatchId, int? iReadId)
{
try
{
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
var rptLiquidation = new LiquidationSummary_PS();
string sVersion, sSiteName;
GetVersion_SiteName(out sVersion, out sSiteName);
rptLiquidation.SetParameterValue("@CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol());
rptLiquidation.SetParameterValue("@BatchId", iBatchId);
rptLiquidation.SetParameterValue("@ReadId", iReadId);
rptLiquidation.SetParameterValue("BMCVersion", sVersion);
rptLiquidation.SetParameterValue("@BatchId", iBatchId, "Liquidation_Summary_PS_Sub.rpt");
rptLiquidation.SetParameterValue("@ReadId", iReadId, "Liquidation_Summary_PS_Sub.rpt");
rptLiquidation.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture);
rptLiquidation.SetParameterValue("@CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol(), "Liquidation_Summary_PS_Sub.rpt");
rptLiquidation.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture);
IReports objReports = String.IsNullOrEmpty(_ExchangeConnectionString) ? ReportsBusinessObject.CreateInstance() : ReportsBusinessObject.CreateInstance(_ExchangeConnectionString, _TicketingConnectionString);
List<ServerDetails> DbConnectionInfo = String.IsNullOrEmpty(_ExchangeConnectionString) ? objReports.GetDataBaseConnectionString() : objReports.GetDataBaseConnectionString(_ExchangeConnectionString);
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 = rptLiquidation.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = rptLiquidation;
AuditReports();
strReportName = "Report Liquidation Summary";
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
LiquidationSummary_PS rpt = new LiquidationSummary_PS();
rpt.Site = this.Site;
return rpt;
}
