/// <summary>
/// Get similar report, recommend report, report detail
/// </summary>
/// <param name="reportId"></param>
/// <param name="topSimilarCompany"></param>
/// <param name="topRecommended"></param>
/// <returns></returns>
public ReportPageDetail GetSimilarReportAndRecommendReportAndDetailReport(int reportId, int topSimilarCompany, int topRecommended)
{
IMultipleResultSet multipleResult = DbContext.QueryMultipleResult("spReportSelectDetailAndSimilarCompanyAndRecommendReport", new { reportId, topSimilarCompany, topRecommended });
Report _report = multipleResult.GetSingle<Report>();
List<Report> lstSimilarReport = multipleResult.Get<Report>().ToList();
List<Report> lstRecommendedReport = multipleResult.Get<Report>().ToList();
TotalReport totalReport = multipleResult.GetSingle<TotalReport>();
ReportPageDetail reportPageDetail = new ReportPageDetail();
reportPageDetail.ReportDetail = _report;
reportPageDetail.SimilarReports = lstSimilarReport;
reportPageDetail.RecommendedReports = lstRecommendedReport;
reportPageDetail.TotalCompanyReport = totalReport.TotalSameCompanyReport;
return reportPageDetail;
}
/// <summary>
/// Get company detail for company page
/// </summary>
/// <param name="companyCode"></param>
/// <returns></returns>
public CompanyPageDetail GetCompanyDetail(string companyCode)
{
IMultipleResultSet multipleResult = DbContext.QueryMultipleResult("spCompanySelectDetail", new { companyCode });
Company _company = multipleResult.GetSingle <Company>();
Report latestReport = multipleResult.GetSingle <Report>();
List <Instrument> lstInstruments = multipleResult.Get <Instrument>().ToList();
CompanyPageDetail companyPageDetail = new CompanyPageDetail();
companyPageDetail.Company = _company;
companyPageDetail.LatestReport = latestReport;
companyPageDetail.Instruments = lstInstruments;
return(companyPageDetail);
}
