public JsonResult GetPreview(int mirroredFileID, int sectionNo = 0, int maxRows = 100)
{
using (var activity = new RFMirrorActivity(Context, Username))
{
var file = activity.GetFile(mirroredFileID);
if (file.content != null)
{
var report = RFReportParserProcessor.LoadFromStream(new System.IO.MemoryStream(file.content), new RFFileTrackedAttributes
{
FileName = file.mirroredFile.FileName,
FileSize = file.mirroredFile.FileSize,
FullPath = file.mirroredFile.MirrorPath,
ModifiedDate = file.mirroredFile.ModifiedTime
}, RFDate.Today(), new RFReportParserConfig
{
Format = RFReportParserFormat.AutoDetect,
HasHeaders = false
}, new RFSimpleReportBuilder());
if (report != null && report.Sections.Count > sectionNo)
{
var dataTable = report.Sections.Skip(sectionNo).First().AsDataTable();
if (dataTable != null)
{
dataTable.Columns["RFRowNo"].SetOrdinal(0);
dataTable.Columns["RFRowNo"].ColumnName = "#";
foreach (DataColumn c in dataTable.Columns)
{
if (Int32.TryParse(c.ColumnName, out var n))
{
c.ColumnName = Interfaces.Formats.XLS.XLSGenerator.GetExcelColumnName(n + 1);
}
}
for (var i = dataTable.Rows.Count - 1; i >= maxRows; i--)
{
dataTable.Rows[i].Delete();
}
}
var sections = new List <object>();
int sn = 0;
foreach (var s in report.Sections)
{
sections.Add(new { id = sn, name = $"[{sn + 1}] {s.Name}" });
sn++;
}
return(Json(new
{
sections = sections,
selectedSection = sectionNo,
preview = dataTable
}));
}
}
return(null);
}
}
public FileResult GetFile(int mirroredFileID)
{
using (var activity = new RFMirrorActivity(Context, Username))
{
var file = activity.GetFile(mirroredFileID);
if (file.content != null)
{
return(File(file.content, RFFileHelpers.GetContentType(file.mirroredFile.FileName), file.mirroredFile.FileName));
}
return(null);
}
}
