public Dictionary <string, object> RunCustomReport(int reportID, bool isTurnOffPageBreak, bool includeTitlePage, int formatTypeId, int reportLayoutStyleID, object parameters, bool isSummaryOnly, object fields, object summarizeFields)
{
Dictionary <string, object> resultDictionary = new Dictionary <string, object>();
try
{
List <RptParameter> list = JavaScriptConvert.DeserializeObject <List <RptParameter> >(JavaScriptConvert.SerializeObject(parameters));
List <RptField> listFields = JavaScriptConvert.DeserializeObject <List <RptField> >(JavaScriptConvert.SerializeObject(fields));
List <RptField> summFields = JavaScriptConvert.DeserializeObject <List <RptField> >(JavaScriptConvert.SerializeObject(summarizeFields));
ReportGenerationService reportGenerationService = new ReportGenerationService();
GenerateCustomReportRequest generateCustomReportRequest = new GenerateCustomReportRequest();
generateCustomReportRequest.UserID = UserContext.ID;
generateCustomReportRequest.AssociationNumber = UserContext.AssociationNumber;
generateCustomReportRequest.FormatTypeId = formatTypeId;
generateCustomReportRequest.ReportID = reportID;
generateCustomReportRequest.ReportLayoutStyleID = reportLayoutStyleID;
generateCustomReportRequest.Parameters = list;
generateCustomReportRequest.IncludeTitlePage = includeTitlePage;
generateCustomReportRequest.Fields = listFields;
generateCustomReportRequest.UserSummarizeRptField = summFields;
generateCustomReportRequest.IsSummaryOnly = isSummaryOnly;
resultDictionary.Add("Result", reportGenerationService.GenerateReportExecute((new Guid()).ToString(), generateCustomReportRequest));
}
catch (Exception e)
{
Logger.Write(e, MethodBase.GetCurrentMethod(), e.Message, "-1");
throw;
}
return(resultDictionary);
}
/*
* private delegate void generateReportDelegate(string sessionID, GenerateReportRequest reportRequest);
*
* private void cancelReport(CancelReportRequest request)
* {
* GenerateReportResponse response = new GenerateReportResponse();
* response.Status = ReportRequestStatus.Cancelled;
* try
* {
* if (!_reportRequestQueue.ContainsKey(request.ReportRequestGuid))
* {
* // report probably already completed or may have errored out, so do nothing
* System.Diagnostics.Debug.WriteLine(String.Format("No report request in queue to cancel | Request ID: {0} | {1}",
* request.ReportRequestGuid.ToString(), DateTime.Now.TimeOfDay.ToString()));
* return;
* }
*
* GenerateReportRequest rptRequest = _reportRequestQueue[request.ReportRequestGuid];
* System.Diagnostics.Debug.WriteLine(String.Format("Report request being cancelled | Request ID: {0} | Status: {1} | {2}",
* request.ReportRequestGuid.ToString(), rptRequest.Status.ToString(), DateTime.Now.TimeOfDay.ToString()));
*
* if (rptRequest.Status == RunningReportStatus.Rendering)
* {
* rptRequest.Status = RunningReportStatus.Cancelled;
* RdlManager mgr = new RdlManager();
* mgr.CancelReport(rptRequest);
* }
* else
* {
* rptRequest.Status = RunningReportStatus.Cancelled;
* }
*
* }
* catch (Exception ex)
* {
* handleReportRequestException(ex, response);
* System.Diagnostics.Debug.WriteLine("Non-critical failure cancelling a report: " + ex.ToString());
*
* // just log and then go on--this is not a critical error because the report will just run to completion and then be ignored
* Logger.Write("Non-critical failure cancelling a report: " + ex.ToString(), "SLLog");
* }
* }
*/
public GenerateReportResponse GenerateReportExecute(string sessionID, GenerateReportRequest reportRequest)
{
int userReportID = -1;
bool includeTitlePage = true;
List <RptParameter> parameters = null;
UserReport userReport = null;
ReportProjectDBEntities entities = new ReportProjectDBEntities();
GenerateReportResponse response = new GenerateReportResponse();
response.ReportRequestGuid = reportRequest.ReportRequestGuid;
try
{
// Get the user report ID (first creating a transient user report, if necessary)
if (reportRequest is GenerateUserReportRequest)
{
GenerateUserReportRequest request = (GenerateUserReportRequest)reportRequest;
userReportID = request.UserReportID;
}
else if (reportRequest is GenerateStandardReportRequest)
{
GenerateStandardReportRequest request = (GenerateStandardReportRequest)reportRequest;
ReportBuilderService reportBuilderService = new ReportBuilderService();
int reportID = request.ReportID;
int reportLayoutStyleID = request.ReportLayoutStyleID;
int formatTypeID = request.FormatTypeId;
bool isTurnOffPageBreak = request.IsTurnOffPageBreak;
includeTitlePage = request.IncludeTitlePage;
parameters = request.Parameters;
userReportID = reportBuilderService.SaveStandardUserReport(request.UserID, reportID,
reportLayoutStyleID, formatTypeID,
parameters.Where(
p =>
p.Name.ToLower() == "userreportname")
.FirstOrDefault().DefaultValue,
parameters, request.AssociationNumber,
true, isTurnOffPageBreak,
includeTitlePage);
}
else if (reportRequest is GenerateCustomReportRequest)
{
GenerateCustomReportRequest request = (GenerateCustomReportRequest)reportRequest;
ReportBuilderService reportBuilderService = new ReportBuilderService();
int reportID = request.ReportID;
int reportLayoutStyleID = request.ReportLayoutStyleID;
int formatTypeID = request.FormatTypeId;
parameters = request.Parameters;
bool isSummaryOnly = request.IsSummaryOnly;
includeTitlePage = request.IncludeTitlePage;
List <RptField> fields = request.Fields;
List <RptField> userSummarizeRptField = request.UserSummarizeRptField;
userReportID = reportBuilderService.SaveCustomUserReport(request.UserID, reportID, formatTypeID,
reportLayoutStyleID,
parameters.Where(
p =>
p.Name.ToLower() == "userreportname").
FirstOrDefault().DefaultValue,
isSummaryOnly, fields,
userSummarizeRptField, parameters,
request.AssociationNumber, true,
includeTitlePage);
}
// Read the user report and the user report parameters (if necessary)
userReport = (from ur in entities.UserReport
.Include("ReportLayoutStyle")
.Include("FormatType")
.Include("Report")
where ur.UserReportID == userReportID
select ur).FirstOrDefault();
if (userReport.FormatTypeID == (int)FormatTypeEnum.Grid)
{
reportRequest.Status = RunningReportStatus.Rendering;
try
{
ReportDomainService domainService = new ReportDomainService();
if (parameters == null)
{
parameters =
domainService.GetUserReportParameters(userReportID, userReport.ReportID).ToList();
}
List <Dictionary <string, object> > resultDictionary = new List <Dictionary <string, object> >();
DBHelper dbHelper =
new DBHelper(ConfigurationManager.ConnectionStrings["Store1Connection"].ConnectionString);
List <object> myParams = new List <object>();
foreach (RptParameter rptParam in parameters.Where(p => p.IsQueryParameter).ToList())
{
myParams.Add("@" + rptParam.Name);
if (rptParam.DataType == DataTypeEnum.Bool && !string.IsNullOrEmpty(rptParam.DefaultValue))
{
myParams.Add(
Convert.ToInt32(rptParam.DefaultValue.ToLower().Replace("false", "0").Replace(
"true", "1")));
}
else if (rptParam.DataType == DataTypeEnum.Integer &&
!string.IsNullOrEmpty(rptParam.DefaultValue))
{
myParams.Add(Convert.ToInt32(rptParam.DefaultValue));
}
else
{
myParams.Add(rptParam.DefaultValue);
}
}
if (dbHelper.IsExistsCommandParameter(userReport.Report.VerifyRowCountSP.Replace("_Count", "_Report"),
CommandType.StoredProcedure, "@IsCustom"))
{
var isCustomParameterIndex = myParams.IndexOf("@IsCustom");
if (isCustomParameterIndex != -1)
{
myParams[isCustomParameterIndex + 1] = 1;
}
else
{
myParams.Add("@IsCustom");
myParams.Add(1);
}
}
if (userReport.Report.VerifyRowCountSP.Replace("_Count", "_Report") == "rb_PAndIRembursableReport_Report")
{
var index = 0;
foreach (var myParam in myParams)
{
if (myParam.ToString().ToLower() == "@claimtype")
{
break;
}
index++;
}
myParams[index] = "@ClaimTypes";
}
if (userReport.Report.VerifyRowCountSP.Replace("_Count", "_Report") == "rb_LossRunSummary_Report")
{
myParams.Add("@AssnName");
myParams.Add("Test");
}
List <RptField> fields =
domainService.GetUserReportFields(userReportID, userReport.ReportID, userReport.ClientNumber)
.ToList();
DataTable recordDataTable = dbHelper.GetDataTable(userReport.Report.VerifyRowCountSP.Replace("_Count", "_Report"),
CommandType.StoredProcedure,
myParams.ToArray());
if (recordDataTable != null && recordDataTable.Rows != null && recordDataTable.Rows.Count != 0)
{
int i = 0;
foreach (DataRow row in recordDataTable.Rows)
{
Dictionary <string, object> drow = new Dictionary <string, object>();
foreach (RptField field in fields)
{
if (!string.IsNullOrEmpty(field.SQLName) && field.ColumnOrder > 0)
{
if (!drow.ContainsKey(field.SQLName))
{
if (field.DataType == DataTypeEnum.Date)
{
drow.Add(field.SQLName,
row[field.SQLName] != DBNull.Value
? DateTime.Parse(
DateTime.Parse(row[field.SQLName].ToString()).
ToShortDateString()).ToString("MM/dd/yyyy")
: new DateTime().ToString("MM/dd/yyyy"));
}
else if (field.DataType == DataTypeEnum.Money)
{
IFormatProvider provider = new CultureInfo("en-US");
drow.Add(field.SQLName,
row[field.SQLName] != DBNull.Value ? String.Format(provider, "{0:C}", row[field.SQLName]) : "$0.00");
}
else
{
drow.Add(field.SQLName,
row[field.SQLName] != DBNull.Value ? row[field.SQLName] : null);
}
}
}
else
{
///parser drow.Add(field.CustomName, CustomValue);
}
}
i++;
drow.Add("ID", i.ToString());
resultDictionary.Add(drow);
}
}
response.UserReportFields = fields;
response.GridData = resultDictionary;
response.Status = ReportRequestStatus.Completed;
}
catch (Exception ex)
{
if (ex.Message.Contains("Report processing has been canceled by the user"))
{
System.Diagnostics.Debug.WriteLine(
String.Format(
"Report processing cancelled by user during render | Request ID: {0} | {1}",
reportRequest.ReportRequestGuid.ToString(), DateTime.Now.TimeOfDay.ToString()));
response.Status = ReportRequestStatus.Cancelled;
}
else
{
throw;
}
}
}
else
{
if (parameters == null)
{
ReportDomainService reportDomainService = new ReportDomainService();
parameters =
reportDomainService.GetUserReportParameters(userReportID, userReport.ReportID).ToList();
}
//TODO: remove this. The userReportName can't be used any longer to cancel a job.
/*if (!_reportNameGuidQueue.ContainsKey(reportRequest.ReportRequestGuid))
* {
* _reportNameGuidQueue.Add(reportRequest.ReportRequestGuid, userReport.UserReportName);
* }*/
System.Diagnostics.Debug.WriteLine(String.Format("Rendering report | Request ID: {0} | {1}",
reportRequest.ReportRequestGuid.ToString(),
DateTime.Now.TimeOfDay.ToString()));
reportRequest.Status = RunningReportStatus.Rendering;
try
{
RdlManager rdlManager = new RdlManager();
byte[] rpt = rdlManager.RenderReport(userReport, parameters);
// save the rendered report to the file system and send the url back to the client
string fileName = createFileName(userReport.UserReportName, userReport.FormatType.Extension);
System.IO.File.WriteAllBytes(_ReportFolderPath + fileName, rpt);
response.ReportUrl = ConfigurationManager.AppSettings["ReportFolder"] + fileName;
response.Status = ReportRequestStatus.Completed;
if ((int)FormatTypeEnum.HTML == userReport.FormatTypeID)
{
StreamReader streamReader = new StreamReader(new MemoryStream(rpt));
response.Content = Processing(streamReader.ReadToEnd(), "IMG", "SRC");
//var str = Processing(Regex.Replace(response.Content, @"<META(.|\n)*?>", string.Empty), "IMG", "SRC");
}
}
catch (Exception ex)
{
if (ex.Message.Contains("Report processing has been canceled by the user"))
{
System.Diagnostics.Debug.WriteLine(
String.Format(
"Report processing cancelled by user during render | Request ID: {0} | {1}",
reportRequest.ReportRequestGuid.ToString(), DateTime.Now.TimeOfDay.ToString()));
response.Status = ReportRequestStatus.Cancelled;
}
else
{
Logger.Write(ex, MethodBase.GetCurrentMethod(), ex.Message, "-1");
throw;
}
}
}
}
catch (Exception ex)
{
Logger.Write(ex, MethodBase.GetCurrentMethod(), ex.Message, "-1");
}
finally
{
// push the response back to the requestor. If succeeds includes the url to the completed report,
// if fails includes a user friendly failure message.
System.Diagnostics.Debug.WriteLine(string.Format("Pushing message to client | Request ID: {0} | Status: {1} | {2} ",
reportRequest.ReportRequestGuid.ToString(), response.Status.ToString(), DateTime.Now.TimeOfDay.ToString()));
//this.PushMessageToClient(sessionID, response);
// do the non-essential things here -- we don't want a failure on any of these things to prevent
// the client from getting the report
try
{
/*_reportRequestQueue.Remove(reportRequest.ReportRequestGuid);
* //TODO: remove this?
* if (_reportNameGuidQueue.ContainsKey(reportRequest.ReportRequestGuid))
* {
* _reportNameGuidQueue.Remove(reportRequest.ReportRequestGuid);
* }*/
if (userReport != null && userReport.IsTransient)
{
deleteTransientUserReport(userReport, entities);
}
cleanUpTempFiles();
}
catch (Exception ex)
{
Logger.Write(ex, MethodBase.GetCurrentMethod(), ex.Message, "-1");
}
}
return(response);
}