public void DoSaveCSV(object sender, EventArgs e)
{
CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request);
CSVFormatter csvformat = new CSVFormatter(csvCulture);
// Create Header
IndustrialActivitySearchFilter filter = SearchFilter;
bool isConfidentialityAffected = IndustrialActivity.IsWasteAffectedByConfidentiality(filter);
Dictionary <string, string> header = EPRTR.HeaderBuilders.CsvHeaderBuilder.GetIndustrialActivitySearchHeader(
filter,
isConfidentialityAffected);
// Create Body
var rows = IndustrialActivity.GetWasteTransfers(filter);
// dump to file
string topheader = csvformat.CreateHeader(header);
string rowHeader = csvformat.GetIndustrialActivityWasteTransfersHeader();
Response.WriteUtf8FileHeader("EPRTR_Industrial_Activity_Waste_Transfer_List");
Response.Write(topheader + rowHeader);
foreach (var item in rows)
{
string row = csvformat.GetIndustrialActivityWasteTransfersRow(item);
Response.Write(row);
}
Response.End();
}
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 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);
}
//returns confidential indicator for waste trasnfers. If not calculated yet, it will be calculated and stored in viewstate
protected int getTotalCount()
{
if (TotalCount == null)
{
TotalCount = IndustrialActivity.GetFacilityCount(SearchFilter);
}
return((int)TotalCount);
}
//returns confidential indicator for waste transfers. If not calculated yet, it will be calculated and stored in viewstate
protected bool getWasteTransferConfidentialityAffected()
{
if (WasteTransferConfidentialityAffected == null)
{
WasteTransferConfidentialityAffected = IndustrialActivity.IsWasteAffectedByConfidentiality(SearchFilter);
}
return((bool)WasteTransferConfidentialityAffected);
}
//returns confidential indicator for pollutant transfers. If not calculated yet, it will be calculated and stored in viewstate
protected bool getPollutantTransferConfidentialityAffected()
{
if (PollutantTransferConfidentialityAffected == null)
{
PollutantTransferConfidentialityAffected = IndustrialActivity.IsPollutantTransferAffectedByConfidentiality(SearchFilter);
}
return((bool)PollutantTransferConfidentialityAffected);
}
/// <summary>
/// method to populate the listview
/// </summary>
/// <param name="filter">The filter.</param>
public void Populate(IndustrialActivitySearchFilter filter)
{
SearchFilter = filter;
this.lvIndustrialWasteTransfers.Items.Clear();
IEnumerable <Summary.WasteSummaryTreeListRow> data = IndustrialActivity.GetWasteTransfers(filter);
this.lvIndustrialWasteTransfers.DataSource = data;
this.lvIndustrialWasteTransfers.DataBind();
ChartsUtils.ShowWastePieCharts(data, this.upindustrialWasteSummeryPanel, this.UniqueID.ToString());
}
/// <summary>
/// return Transfers Facility Data
/// </summary>
private IEnumerable <IndustrialActivity.ConfidentialTransfersRow> GetConfidentialTransfersFacilityData()
{
IEnumerable <IndustrialActivity.ConfidentialTransfersRow> data = null;
if (ViewState[TRANSFER_FACILITIES] == null)
{
data = IndustrialActivity.GetConfidentialTransfersFacility(SearchFilter);
ViewState[TRANSFER_FACILITIES] = data;
}
else
{
data = ViewState[TRANSFER_FACILITIES] as IEnumerable <IndustrialActivity.ConfidentialTransfersRow>;
}
return(data);
}
/// <summary>
/// Get Confidential Releases Data
/// </summary>
private IEnumerable <IndustrialActivity.ConfidentialReleasesRow> GetConfidentialReleasesFacilityData()
{
IEnumerable <IndustrialActivity.ConfidentialReleasesRow> data = null;
if (ViewState[RELEASES_FACILITIES] == null)
{
data = IndustrialActivity.GetConfidentialReleasesFacility(SearchFilter);
ViewState[RELEASES_FACILITIES] = data;
}
else
{
data = ViewState[RELEASES_FACILITIES] as IEnumerable <IndustrialActivity.ConfidentialReleasesRow>;
}
return(data);
}
/// <summary>
/// update sheet
/// </summary>
/// <param name="value"></param>
private void updateSheet(string value)
{
hideAllControls();
// pollutant releases
if (value.Equals("releases"))
{
this.lvPollutantReleasesFacility.DataSource = GetConfidentialReleasesFacilityData();
this.lvPollutantReleasesFacility.DataBind();
this.lvPollutantReleasesReason.DataSource = IndustrialActivity.GetConfidentialReleasesReason(SearchFilter);
this.lvPollutantReleasesReason.DataBind();
// hide or show data
bool noDataFound = this.lvPollutantReleasesReason.Items.Count == 0 && this.lvPollutantReleasesFacility.Items.Count == 0;
this.divPollutantReleases.Visible = !noDataFound;
this.litNoDataFoundConfidentialityInfo.Visible = noDataFound;
}
// pollutant transfers
else if (value.Equals("transfers"))
{
this.lvPollutantTransfersFacility.DataSource = GetConfidentialTransfersFacilityData();
this.lvPollutantTransfersFacility.DataBind();
this.lvPollutantTransfersReason.DataSource = QueryLayer.IndustrialActivity.GetConfidentialTransfersReason(SearchFilter);
this.lvPollutantTransfersReason.DataBind();
// hide or show data
bool noDataFound = this.lvPollutantTransfersFacility.Items.Count == 0 && this.lvPollutantTransfersReason.Items.Count == 0;
this.divPollutantTransfers.Visible = !noDataFound;
this.litNoDataFoundConfidentialityInfo.Visible = noDataFound;
}
// waste transfers
else if (value.Equals("waste"))
{
this.lvWasteFacilities.DataSource = QueryLayer.IndustrialActivity.GetWasteConfidentialFacilities(SearchFilter);
this.lvWasteFacilities.DataBind();
this.lvWasteReason.DataSource = QueryLayer.IndustrialActivity.GetWasteConfidentialReason(SearchFilter).OrderBy(w => w.WasteTypeCode, new WasteTypeComparer()).ThenBy(w => w.ReasonCode);
this.lvWasteReason.DataBind();
// hide or show data
bool noDataFound = this.lvWasteFacilities.Items.Count == 0 && this.lvWasteReason.Items.Count == 0;
this.divWasteTransfers.Visible = !noDataFound;
this.litNoDataFoundConfidentialityInfo.Visible = noDataFound;
}
}
