public double IndustrialActivityTestE()
{
DateTime testStartTime;
DateTime testEndTime;
TimeSpan testDelta;
IndustrialActivitySearchFilter filter = new IndustrialActivitySearchFilter();
filter.ActivityFilter = new ActivityFilter();
filter.ActivityFilter.SectorIds.Add(3);
filter.ActivityFilter.ActivityIds.Add(26);
filter.ActivityFilter.SubActivityIds.Add(-1);
filter.AreaFilter = new AreaFilter();
filter.AreaFilter.AreaGroupID = 1;
filter.AreaFilter.CountryID = 74;
filter.AreaFilter.RegionID = -1;
filter.MapFilter = new MapFilter();
filter.MapFilter.SqlWhere = "((((ReportingYear) = 2007) And (LOV_CountryID = 74)) And ((LOV_IAActivityID) = 26))";
filter.YearFilter = new YearFilter();
filter.YearFilter.Year = 2007;
testStartTime = DateTime.Now;
IEnumerable <PollutantReleases.ReleasesActivityAreaRow> actual = IndustrialActivity.GetPollutantReleases(filter);
testEndTime = DateTime.Now;
testDelta = testEndTime - testStartTime;
return(testDelta.TotalSeconds);
}
public double IndustrialActivityTestA()
{
DateTime testStartTime;
DateTime testEndTime;
TimeSpan testDelta;
IndustrialActivitySearchFilter filter = new IndustrialActivitySearchFilter();
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)))";
filter.YearFilter = new YearFilter();
filter.YearFilter.Year = 2007;
testStartTime = DateTime.Now;
IEnumerable <PollutantReleases.ReleasesActivityAreaRow> actual = IndustrialActivity.GetPollutantReleases(filter);
testEndTime = DateTime.Now;
testDelta = testEndTime - testStartTime;
return(testDelta.TotalSeconds);
}
public void DoSaveCSV(object sender, EventArgs e)
{
try
{
CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request);
CSVFormatter csvformat = new CSVFormatter(csvCulture);
// Create Header
IndustrialActivitySearchFilter filter = SearchFilter;
bool isConfidentialityAffected = IndustrialActivity.IsPollutantReleaseAffectedByConfidentiality(filter);
Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetIndustrialActivitySearchHeader(
filter,
isConfidentialityAffected);
// Create Body
var rows = IndustrialActivity.GetPollutantReleases(filter);
// dump to file
string topheader = csvformat.CreateHeader(header);
string rowHeader = csvformat.GetIndustrialActivityPollutantReleasesHeader();
Response.WriteUtf8FileHeader("EPRTR_Industrial_Activity_Pollutant_Releases_List");
Response.Write(topheader + rowHeader);
foreach (var item in rows)
{
string row = csvformat.GetIndustrialActivityPollutantReleasesRow(item);
Response.Write(row);
}
Response.End();
}
catch
{
}
}