private void toggleExpanded(int rowindex)
{
List <PollutantTransfers.AreaTreeListRow> data = ViewState[RESULT] as List <PollutantTransfers.AreaTreeListRow>;
PollutantTransfers.AreaTreeListRow row = data[rowindex];
//toggle expansion
row.IsExpanded = !row.IsExpanded;
//get data from database, if not already loaded
if (row.HasChildren && row.IsExpanded && !data.Any(r => r.Level == row.Level + 1 && r.ParentCode == row.Code))
{
if (row.Level == 0)
{
var subareas = PollutantTransfers.GetSubAreas(SearchFilter, new List <string> {
row.CountryCode
});
addToResult(subareas);
}
}
this.lvPollutantTransfersAreas.DataSource = data;
this.lvPollutantTransfersAreas.DataBind();
// notify that content has changed (print)
if (ContentChanged != null)
{
ContentChanged.Invoke(null, EventArgs.Empty);
}
}
/// <summary>
/// Search, fill data into summery
/// </summary>
public void Populate(PollutantTransfersSearchFilter filter)
{
SearchFilter = filter;
ConfidentialityAffected = PollutantTransfers.IsAffectedByConfidentiality(filter); //Only determine once and store in viewstate
// always show summery
showContent(Sheets.PollutantTransfers.Summary.ToString());
}
public void DoSaveCSV(object sender, EventArgs e)
{
try
{
CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request);
CSVFormatter csvformat = new CSVFormatter(csvCulture);
// Create Header
PollutantTransfersSearchFilter filter = SearchFilter;
bool isConfidentialityAffected = PollutantTransfers.IsAffectedByConfidentiality(filter);
Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetPollutantTransferSearchHeader(
filter,
isConfidentialityAffected);
// Create Body
var facilities = PollutantTransfers.GetFacilityListCSV(filter);
// dump to file
string topheader = csvformat.CreateHeader(header);
string facilityHeader = csvformat.GetPollutantTranfersFacilityHeader();
string url = Request.Url.AbsoluteUri;
url = url.Substring(0, url.LastIndexOf("/") + 1);
Response.WriteUtf8FileHeader("EPRTR_Pollutant_Transfers_Facility_List");
Response.Write(topheader + facilityHeader);
foreach (var item in facilities)
{
item.Url = String.Format("{0}/PopupFacilityDetails.aspx?FacilityReportId={1}", url, item.FacilityReportId);
string row = csvformat.GetPollutantTransfersFacilityRow(item);
Response.Write(row);
}
Response.End();
}
catch
{
}
}
public void Populate(PollutantTransfersSearchFilter filter)
{
List <PollutantTransfers.AreaComparison> compareList = PollutantTransfers.GetAreaComparison(filter);
string title = string.Empty;
// Translate area codes
translateArea(filter.AreaFilter, compareList);
// update flash
int compareListCount = compareList.Count;
if (compareListCount != 0)
{
string swfFile = EPRTR.Charts.ChartsUtils.PolluntantTransferAreaComparisonChart;
EPRTR.Charts.ChartsUtils.ChartClientScript(swfFile, title, compareList, this.compareChartPanel, this.UniqueID.ToString(), EPRTR.Charts.ChartsUtils.AreaType.Air, compareListCount);
}
else
{
//show no data control
this.NoDataReturned.Visible = true;
}
}
public double PollutantTransfersTestA()
{
DateTime testStartTime;
DateTime testEndTime;
TimeSpan testDelta;
PollutantTransfersSearchFilter filter = new PollutantTransfersSearchFilter();
filter.ActivityFilter = new ActivityFilter();
filter.ActivityFilter.SectorIds.Add(-1);
filter.ActivityFilter.ActivityIds.Add(-1);
filter.ActivityFilter.SubActivityIds.Add(-1);
filter.AreaFilter = new AreaFilter();
filter.AreaFilter.AreaGroupID = 1;
filter.AreaFilter.CountryID = -1;
filter.AreaFilter.RegionID = -1;
filter.MapFilter = new MapFilter();
filter.MapFilter.SqlWhere = "((((ReportingYear) = 2007) And ((((((((((((((((((((((((((((((((LOV_CountryID) = 15) Or ((LOV_CountryID) = 22)) Or ((LOV_CountryID) = 34)) Or ((LOV_CountryID) = 57)) Or ((LOV_CountryID) = 58)) Or ((LOV_CountryID) = 59)) Or ((LOV_CountryID) = 68)) Or ((LOV_CountryID) = 73)) Or ((LOV_CountryID) = 74)) Or ((LOV_CountryID) = 81)) Or ((LOV_CountryID) = 85)) Or ((LOV_CountryID) = 100)) Or ((LOV_CountryID) = 101)) Or ((LOV_CountryID) = 106)) Or ((LOV_CountryID) = 109)) Or ((LOV_CountryID) = 122)) Or ((LOV_CountryID) = 127)) Or ((LOV_CountryID) = 128)) Or ((LOV_CountryID) = 129)) Or ((LOV_CountryID) = 137)) Or ((LOV_CountryID) = 156)) Or ((LOV_CountryID) = 166)) Or ((LOV_CountryID) = 177)) Or ((LOV_CountryID) = 178)) Or ((LOV_CountryID) = 182)) Or ((LOV_CountryID) = 201)) Or ((LOV_CountryID) = 202)) Or ((LOV_CountryID) = 207)) Or ((LOV_CountryID) = 213)) Or ((LOV_CountryID) = 214)) Or ((LOV_CountryID) = 234))) And ((LOV_PollutantID) = 9))";
filter.PollutantFilter = new PollutantFilter();
filter.PollutantFilter.PollutantGroupID = 1;
filter.PollutantFilter.PollutantID = 9;
filter.YearFilter = new YearFilter();
filter.YearFilter.Year = 2007;
testStartTime = DateTime.Now;
List <Summary.Quantity> actual = PollutantTransfers.Summery(filter);
testEndTime = DateTime.Now;
testDelta = testEndTime - testStartTime;
return(testDelta.TotalSeconds);
}
public void DoSaveCSV(object sender, EventArgs e)
{
CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request);
CSVFormatter csvformat = new CSVFormatter(csvCulture);
// Create Header
var filter = SearchFilter;
bool isConfidentialityAffected = PollutantTransfers.IsAffectedByConfidentiality(filter);
Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetPollutantTransferSearchHeader(
filter,
isConfidentialityAffected);
// Create Body
List <PollutantTransfers.AreaTreeListRow> rows = PollutantTransfers.GetAreaTree(filter).ToList();
sortResult(rows);
// dump to file
string topheader = csvformat.CreateHeader(header);
string[] colHeaderRows = csvformat.GetPollutantTransferAreaColHeaderRows(filter);
Response.WriteUtf8FileHeader("EPRTR_Pollutant_Transfers_Area_List");
Response.Write(topheader + colHeaderRows[0] + colHeaderRows[1]);
//all rows but total
foreach (var item in rows.Where(r => r.Code != ActivityTreeListRow.CODE_TOTAL))
{
string row = csvformat.GetPollutantTransferAreaRow(item, filter);
Response.Write(row);
}
//write total row
var totalRow = rows.SingleOrDefault(r => r.Code == ActivityTreeListRow.CODE_TOTAL);
if (totalRow == null)
{
//find all rows on topLevel. if only one, use this as total row
var toplevelRows = rows.Where(r => r.Level == 0);
if (toplevelRows != null && toplevelRows.Count() == 1)
{
totalRow = toplevelRows.Single();
}
}
//write total row if any is found
if (totalRow != null)
{
Response.Write(Environment.NewLine);
Response.Write(csvformat.AddText(Resources.GetGlobal("Common", "Total")));
Response.Write(Environment.NewLine);
string[] totalColHeaderRows = csvformat.GetPollutantTransferAreaColHeaderRows(filter);
Response.Write(totalColHeaderRows[0] + totalColHeaderRows[1]);
string row = csvformat.GetPollutantTransferAreaRow(totalRow, filter);
Response.Write(row);
}
Response.End();
}
