public static IList<ReferenceEntity> GetAllReferences(string content, int reportId)
{
IList<ReferenceEntity> results = new List<ReferenceEntity>();
if (content == null)
{
return results;
}
string pattern = "{(?!IMG-[0-9]*)[^}]+}";
MatchCollection matches;
Regex referenceRegex = new Regex(pattern);
matches = referenceRegex.Matches(content);
ARTService service = new ARTService();
foreach (Match match in matches)
{
ReferenceEntity reference = service.GetReferenceByShortName(reportId, match.Value.Substring(1, match.Value.Length - 2));
ReferenceComparer comparer = new ReferenceComparer();
if (reference != null && reference.ReferenceId != 0 && !results.Contains(reference, comparer))
{
results.Add(reference);
}
}
return results;
}
public ControllerBase()
{
Service = new ARTService();
PublicService = new PublicBL();
}
public Dictionary<string, Object> FullReport(int reportId)
{
ARTService service = new ARTService();
Dictionary<string, Object> dataSources = new Dictionary<string, Object>();
dataSources.Add("TextBlockExecSummary", service.TextBlockGetDataTable(reportId, ARTService.TextBlock.ExecSummary));
dataSources.Add("TextBlockScope", service.TextBlockGetDataTable(reportId, ARTService.TextBlock.Scope));
dataSources.Add("TextBlockSpeciesOverview", service.TextBlockGetDataTable(reportId, ARTService.TextBlock.SpeciesOverview));
dataSources.Add("TextBlockProductionStatistics", service.TextBlockGetDataTable(reportId, ARTService.TextBlock.ProductionStatistics));
dataSources.Add("TextBlockImportance", service.TextBlockGetDataTable(reportId, ARTService.TextBlock.ImportanceToMarket));
dataSources.Add("TextBlockMarketNames", service.TextBlockGetDataTable(reportId, ARTService.TextBlock.CommonMarketNames));
dataSources.Add("OverallRec", OverallRec(reportId));
dataSources.Add("Criteria1Grid", service.Criteria1ReportData(reportId));
dataSources.Add("Criteria1Synthesis", service.SynthesisGet(reportId, 1));
dataSources.Add("Criteria1", Criteria1All(reportId));
dataSources.Add("Criteria2Grid", service.Criteria2ReportData(reportId));
dataSources.Add("Criteria2Synthesis", service.SynthesisGet(reportId, 2));
dataSources.Add("Criteria2", Criteria2All(reportId));
dataSources.Add("Criteria3Grid", service.Criteria3ReportData(reportId));
dataSources.Add("Criteria31Grid", service.Criteria31ReportData(reportId));
dataSources.Add("Criteria32Grid", service.Criteria32ReportData(reportId));
dataSources.Add("Criteria3Synthesis", service.SynthesisGet(reportId, 3));
dataSources.Add("Criteria31Synthesis", service.SynthesisGet(reportId, 5));
dataSources.Add("Criteria32Synthesis", service.SynthesisGet(reportId, 6));
dataSources.Add("Criteria31", Criteria31All(reportId));
dataSources.Add("Criteria32", Criteria32All(reportId));
dataSources.Add("Criteria4Grid", service.Criteria4ReportData(reportId));
dataSources.Add("Criteria4Synthesis", service.SynthesisGet(reportId, 4));
dataSources.Add("Criteria4", Criteria4All(reportId));
dataSources.Add("TextBlockAck", service.TextBlockGetDataTable(reportId, ARTService.TextBlock.Acknowledgements));
dataSources.Add("References", References(reportId));
dataSources.Add("AppendixAGrid", service.AppendixAReportData(reportId));
List<int> reportAppendixIds = DB.GetList<int>(new SQLBuilder("select Id from ReportAppendix where ReportId = @0 order by Id", reportId.ToString()));
for (int i = 0; i < reportAppendixIds.Count; i++)
{
//Add Appendix1 to AppendixN (currently capped at 7)
dataSources.Add("Appendix" + (i+1).ToString(), service.AppendixGetDataTable(reportAppendixIds[i]));
}
return dataSources;
}
public static string ParseWithImages(string content, int reportId)
{
if (content == null)
{
return "";
}
string pattern = "{(IMG-[0-9]*)[^}]+}";
MatchCollection matches;
Regex referenceRegex = new Regex(pattern);
matches = referenceRegex.Matches(content);
string idPattern = "(?<=IMG-)[0-9]+";
Regex idRegex = new Regex(idPattern);
ARTService service = new ARTService();
foreach (Match match in matches)
{
Match imageIdString = idRegex.Match(match.Value);
int imageId = Convert.ToInt16(imageIdString.Value);
ImageEntity image = service.ImageGet(reportId, imageId);
string imageHtml = "<div class='image-container'><img src='/ConstrainImage.ashx?imgUrl=" + image.Path + "&mw=780&mh=500'/><p>" + image.Description + "</p></div>";
content = content.Replace(match.Value, imageHtml);
}
return content;
}
private void DoStuff()
{
//int? score;
//score = null;
//189 = Fisheries Training report
//180 = Striped bass test report
//227 = Santi Test 2
int reportId = 208;
//new ARTService().RecalcAllReports();
new ARTService().RecalcSingleReport(reportId);
ARTService service = new ARTService();
Generator x = new Generator();
//string str = x.CreateStream(reportId);
x.CreateDoc(@"c:\temp\test.docx", reportId);
this.Close();
//service.ReferenceUpdate(189, -1, "Short Name", "", "", "", "", false);
/*
service.Criteria2Overview(reportId);
IList<Criteria31Entity> a = new List<Criteria31Entity>();
a = service.Criteria31Overview(reportId);
IList<Criteria32Entity> b = new List<Criteria32Entity>();
b = service.Criteria32Overview(reportId);
IList<Criteria3Entity> c = new List<Criteria3Entity>();
c = service.Criteria3Overview(reportId);
IList<Criteria1Entity> w = new List<Criteria1Entity>();
w = service.Criteria1Overview(reportId);
IList<Criteria2Entity> x = new List<Criteria2Entity>();
x = service.Criteria2Overview(reportId);
IList<Criteria21Entity> y = new List<Criteria21Entity>();
y = service.Criteria21Overview(reportId);
IList<Criteria24Entity> z = new List<Criteria24Entity>();
z = service.Criteria24Overview(reportId);
*/
//ART.Reporting.OverallRec rpt = new Reporting.OverallRec();
//rpt.DataSource = new ART.ReportSource().OverallRec(1);
//ART.Reporting.Criteria1 rpt = new Reporting.Criteria1();
//rpt.DataSource = new ReportSource().Criteria1(reportId)[2];
//ART.Reporting.Criteria2 rpt = new Reporting.Criteria2();
//rpt.DataSource = new ReportSource().Criteria2(reportId)[2];
//ART.Reporting.Criteria2 rpt = new Reporting.Criteria2();
//rpt.DataSource = new ReportSource().Criteria2All(reportId);
//ART.Reporting.Criteria34 rpt = new Reporting.Criteria34();
//rpt.DataSource = new ReportSource().Criteria31All(reportId);
//ART.Reporting.Criteria1Grid rpt = new Reporting.Criteria1Grid();
//rpt.DataSource = service.Criteria1ReportData(1);
//rpt.Criteria1Synthesis = service.SynthesisGet(1, 1);
//ART.Reporting.Criteria2Grid rpt = new Reporting.Criteria2Grid();
//rpt.DataSource = service.Criteria2ReportData(reportId);
//rpt.Criteria2Synthesis = service.SynthesisGet(reportId, 2);
//ART.Reporting.Criteria3Grid rpt = new Reporting.Criteria3Grid();
//rpt.DataSource = service.Criteria3ReportData(reportId);
//rpt.DataSource31 = service.Criteria31ReportData(reportId);
//rpt.DataSource32 = service.Criteria32ReportData(reportId);
//rpt.Criteria3Synthesis = service.SynthesisGet(reportId, 3);
//ART.Reporting.Criteria4Grid rpt = new Reporting.Criteria4Grid();
//rpt.DataSource = service.Criteria4ReportData(180);
//rpt.Criteria4Synthesis = service.SynthesisGet(180, 4);
//ART.Reporting.AppendixAGrid rpt = new Reporting.AppendixAGrid();
//rpt.DataSource = service.AppendixAReportData(1);
//ART.Reporting.AppendixN rpt = new Reporting.AppendixN();
//rpt.DataSource = service.AppendixGetDataTable(1, "B");
//ART.Reporting.OverallRec rpt = new Reporting.OverallRec();
//ART.Reporting.FinalRecGrid rpt = new Reporting.FinalRecGrid();
//rpt.DataSource = new ART.ReportSource().OverallRec(reportId);
//ART.Reporting.TextBlock rpt = new Reporting.TextBlock();
//rpt.DataSource = service.TextBlockGetDataTable(reportId, ARTService.TextBlock.Scope);
//ART.Reporting.References rpt = new Reporting.References();
//rpt.DataSource = new ART.ReportSource().References(reportId);
//ART.Reporting.FullReport rpt = new Reporting.FullReport();
//rpt.DataSources = new ReportSource().FullReport(reportId);
//rpt.Run();
//this.viewer1.Document = rpt.Document;
}