//creates header for Pollutant filter and adds to dictionary protected static void addPollutant(Dictionary <string, string> header, PollutantFilter filter) { if (filter != null) { string key = Resources.GetGlobal("Common", "Pollutant"); string value = string.Empty; PollutantFilter.Level level = filter.SearchLevel(); if (level == PollutantFilter.Level.All) { value = Resources.GetGlobal("Common", "AllPollutants"); } else if (level == PollutantFilter.Level.PollutantGroup) { value = LOVResources.PollutantGroupName(ListOfValues.GetPollutant(filter.PollutantGroupID).Code); } else { value = LOVResources.PollutantName(ListOfValues.GetPollutant(filter.PollutantID).Code); } header.Add(key, value); } }
/// <summary> /// Save transfers data /// </summary> protected void doSave(object sender, EventArgs e) { try { CultureInfo csvCulture = CultureResolver.ResolveCsvCulture(Request); CSVFormatter csvformat = new CSVFormatter(csvCulture); // Create Header var header = CsvHeaderBuilder.GetTsPollutantTransfersSearchHeader(SearchFilter, ConfidentialityAffected); var data = PollutantTransferTrend.GetTimeSeries(SearchFilter); var pollutant = ListOfValues.GetPollutant(SearchFilter.PollutantFilter.PollutantID); string pollutantName = LOVResources.PollutantName(pollutant.Code); // dump to file string topheader = csvformat.CreateHeader(header); string rowheaders = csvformat.GetPollutantTransfersTimeSeriesHeader(); Response.WriteUtf8FileHeader("EPRTR_Pollutant_Transfers_Time_Series"); Response.Write(topheader + rowheaders); foreach (var v in data) { string row = csvformat.GetPollutantTransfersTimeSeriesRow(v, pollutantName); Response.Write(row); } Response.End(); } catch { } }
private static List <WasteTransfers.TransboundaryHazardousWasteData> prepareBubblechartData(IEnumerable <WasteTransfers.TransboundaryHazardousWasteData> data) { List <WasteTransfers.TransboundaryHazardousWasteData> result = new List <WasteTransfers.TransboundaryHazardousWasteData>(); result.AddRange(data); //Add one dummy row for each E-PRTR country - to make sure all reporting countries are always represented in the grid IEnumerable <WasteTransfers.TransboundaryHazardousWasteData> dummies = ListOfValues.ReportingCountries() .OrderBy(x => x.Code) .Select(v => new WasteTransfers.TransboundaryHazardousWasteData() { TransferTo = v.Code, }); result.AddRange(dummies); //Add dummy row for other countries (i.e. countries outside E-PRTR) WasteTransfers.TransboundaryHazardousWasteData other = new WasteTransfers.TransboundaryHazardousWasteData(); other.TransferTo = WasteTransfers.TransboundaryHazardousWasteData.OTHER; result.Add(other); return(result); }
/// <summary> /// Gets the name of a NaceActivity (incl. code) based on the LOV_Id /// </summary> public static string NaceActivityName(int lov_id) { LOV_NACEACTIVITY a = ListOfValues.GetNaceActicvity(lov_id); string code = a != null ? a.Code : String.Empty; return(NaceActivityName(code)); }
/// <summary> /// Search, fill data into summery /// </summary> public void Populate(int facilityReportId, int searchYear, string pollutantCode, MediumFilter.Medium medium) { FacilityBasic = Facility.GetFacilityBasic(facilityReportId); PollutantCode = pollutantCode; ViewState[FACILITY_REPORTID] = facilityReportId; CurrentMedium = medium; ViewState[SEARCH_YEAR] = searchYear; // reset viewstate data ViewState[TIMESERIES_AIR] = null; ViewState[TIMESERIES_WATER] = null; ViewState[TIMESERIES_SOIL] = null; showContent(TrendReleaseContent.TimeSeries.ToString()); // set the year according to search. Include EPER List <int> years = ListOfValues.ReportYearsSeries().ToList(); if (medium == MediumFilter.Medium.Soil) { years = ListOfValues.ReportYears(showEPER).ToList(); } this.ucYearCompareSeries.Initialize(years, searchYear); }
private string groupCount(PollutantReleases.ReleasesTreeListRow row) { int total = ListOfValues.CountLeafPollutants(row.Code); int number = 0; return(String.Format("({0}/{1})", number, total)); }
/// <summary> /// GetPollutantFilter /// </summary> public static PollutantFilter GetPollutantFilter(string code, int level) { PollutantFilter filter = new PollutantFilter(); LOV_POLLUTANT pollutant = ListOfValues.GetPollutant(code); if (level == 1) { if (pollutant.ParentID != null) { filter.PollutantID = pollutant.LOV_PollutantID; filter.PollutantGroupID = pollutant.ParentID.Value; } else { // confidential in group, same id filter.PollutantID = pollutant.LOV_PollutantID; filter.PollutantGroupID = pollutant.LOV_PollutantID; } } else if (level == 0) { filter.PollutantID = PollutantFilter.AllPollutantsInGroupID; filter.PollutantGroupID = pollutant.LOV_PollutantID; } return(filter); }
public ListOfValue AddLov(string value, string parentValue) { if (string.IsNullOrEmpty(value.Trim())) { return(null); } if (ActiveListOfValues.Any(val => val.Equals(value))) { var lov = ListOfValues.FirstOrDefault(a => a.Active && a.Value.ToLower().Trim() == value.ToLower().Trim()); if (lov == null) { return(null); } if (lov.ParentValue.Trim().ToLower() != parentValue.Trim().ToLower()) { lov.ParentValue = parentValue; return(lov); } return(lov); } var listOfValue = new ListOfValue { Value = value, ParentValue = parentValue }; ListOfValues.Add(listOfValue); return(listOfValue); }
public static string Resolve(HttpRequest request) { // get list of currently allowed cultures from CMS database IEnumerable <string> allowedCultures = ListOfValues.GetAllCultureCodes(); // retrieve cookie HttpCookie cultureCookie = request.Cookies["Culture"]; // retrieve url parameter string cultureUrlParameter = request.QueryString["lang"]; string cultureDefault = "en-GB"; // set to default string cultureCode = cultureDefault; // apply url based culture if (allowedCultures.Contains(cultureUrlParameter)) { cultureCode = cultureUrlParameter; } // apply cookie based culture from dropdown else if (cultureCookie != null && !string.IsNullOrEmpty(cultureCookie.Value) && allowedCultures.Contains(cultureCookie.Value)) { cultureCode = cultureCookie.Value; } return(cultureCode); }
private string loadData() { ListOfValues lst = new ListOfValues(); lst.listaObiektow = null; var client = new HttpClient(); var task = client.GetAsync("http://mpmmtest.azurewebsites.net/api/values") .ContinueWith((taskwithresponse) => { var response = taskwithresponse.Result; var jsonString = response.Content.ReadAsStringAsync(); jsonString.Wait(); lst = JsonConvert.DeserializeObject <ListOfValues>(jsonString.Result); }); task.Wait(); string message = "<table style='width:70%'><tr><td>ID</td><td>Nazwa</td><td>Tresc</td></tr>"; foreach (var value in lst.listaObiektow.OrderBy(x => x.id)) { message += "<tr><td>" + value.id + "</td>"; message += "<td>" + value.nazwa + "</td>"; message += "<td>" + value.tresc + "</td></tr>"; } message += "</table>"; return(message); }
/// <summary> /// Gets the name of a AnnexIActivity (incl. code) based on the LOV_AnnexIId /// </summary> public static string AnnexIActivityName(int lov_id) { LOV_ANNEXIACTIVITY a = ListOfValues.GetAnnexIActicvity(lov_id); string code = a != null ? a.Code : String.Empty; return(AnnexIActivityName(code)); }
public void UncheckOnly(params string[] values) { DoVIAction("UnheckOnly: " + values.Print(), () => { Clear(); CheckGroup(ListOfValues.Except(values).ToArray()); }); }
//creates header for regulation (legal name) used in reporting and adds to dictionary protected static void addLegalRegulation(Dictionary <string, string> header, int reportingYear) { string key = Resources.GetGlobal("Common", "Regulation"); string code = ListOfValues.GetRegulationCode(reportingYear); string value = LOVResources.LegalRegulationName(code); header.Add(key, value); }
public IExtendedProperty Clone() { var extendedProperty = new ExtendedProperty <T> { Name = Name, Value = Value, ReadOnly = ReadOnly, Description = Description, FullName = FullName }; ListOfValues.Each(property => extendedProperty.AddToListOfValues(property)); return(extendedProperty); }
private void SaveGoogleMap(string googleSitemap) { XmlWriterSettings settings = new XmlWriterSettings(); settings.Indent = true; settings.Encoding = Encoding.UTF8; settings.CloseOutput = true; using (XmlWriter writer = XmlWriter.Create(googleSitemap, settings)) { writer.WriteStartDocument(); writer.WriteStartElement("urlset", "http://www.sitemaps.org/schemas/sitemap/0.9"); writer.WriteAttributeString("xmlns", "xsi", null, "http://www.w3.org/2001/XMLSchema-instance"); writer.WriteAttributeString("xsi", "schemaLocation", null, "http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd"); var languageList = ListOfValues.GetAllCultureCodes(); foreach (Url url in _urls) { writer.WriteStartElement("url"); writer.WriteElementString("loc", url.Location); writer.WriteEndElement(); //D30 START 16/05/2013 --> We don´t need languages /* if (languageList.Count() > 1) * { * foreach (var lang in languageList) * { * //RRP START 18-04-2013 * //Original code (All cultures) * //writer.WriteStartElement("url"); * //writer.WriteElementString("loc", url.Location + "?lang=" + lang); * //writer.WriteEndElement(); * * //Only for en-GB culture * //We don't need references from the sitemap to the same page in all languages. * //Only English is needed * if (lang == "en-GB") * { * writer.WriteStartElement("url"); * writer.WriteElementString("loc", url.Location + "?lang=" + lang); * writer.WriteEndElement(); * } * //RRP END 18-04-2013 * } * }*/ //D30 END 16/05/2013 } writer.WriteEndElement(); writer.WriteEndDocument(); } }
/// <summary> /// return map with reporting countries for a list of years /// [year][count] /// </summary> public static Dictionary <int, int> GetReportingYears() { Dictionary <int, int> yearContries = new Dictionary <int, int>(); var reportingyears = ListOfValues.ReportingYears(true); foreach (var v in reportingyears) { yearContries.Add(v.Year, v.Countries.HasValue ? v.Countries.Value : 0); } return(yearContries); }
public static string PollutantNameEPER(string code, string codeEPER) { if (ListOfValues.IsPollutantGroupEPER(code, codeEPER)) { return(GetResource("LOV_POLLUTANT", codeEPER + ".Confidential")); } else { return(GetResource("LOV_POLLUTANT", codeEPER)); } }
protected void lvColHeaders_OnDataBinding(object sender, EventArgs e) { Label lbActivity = ((ListView)sender).FindControl("lbActivity") as Label; int pollutantGroupID = getPollutantGroupID(); LOV_POLLUTANT group = ListOfValues.GetPollutant(pollutantGroupID); if (lbActivity != null && group != null) { lbActivity.Text = String.Format(Resources.GetGlobal("AreaOverview", "ReleasesOf"), LOVResources.PollutantGroupName(group.Code)); } }
public void AreaGroupsTest() { //IEnumerable<LOV_AREAGROUP> expected = null; // TODO: Initialize to an appropriate value IEnumerable <LOV_AREAGROUP> actual; actual = ListOfValues.AreaGroups(); // Test of the numer of entries in LOV Assert.AreEqual(5, actual.Count()); Assert.Inconclusive("Verify the correctness of this test method."); }
public static AreaFilter GetAreaFilter(AreaFilter searchAreaFilter, string areaCode, string parentCode) { //for total-rows the activityfilter corresponds to the filter from the search if (TreeListRow.CODE_TOTAL.Equals(areaCode)) { return(searchAreaFilter == null ? null : searchAreaFilter.Clone() as AreaFilter); } AreaFilter areaFilter = new AreaFilter(); areaFilter.TypeRegion = searchAreaFilter.TypeRegion; // Search for country according to code REPORTINGCOUNTRY country = ListOfValues.GetReportingCountry(areaCode); if (country != null) { //country level areaFilter.CountryID = country.LOV_CountryID; areaFilter.RegionID = AreaFilter.AllRegionsInCountryID; } else { country = ListOfValues.GetReportingCountry(parentCode); areaFilter.CountryID = country.LOV_CountryID; //NUTS or RBD level if (areaFilter.TypeRegion.Equals(AreaFilter.RegionType.RiverBasinDistrict)) { LOV_RIVERBASINDISTRICT rbd = ListOfValues.GetRiverBasinDistrict(areaCode); if (rbd != null) { areaFilter.RegionID = rbd.LOV_RiverBasinDistrictID; } } else if (areaFilter.TypeRegion.Equals(AreaFilter.RegionType.NUTSregion)) { LOV_NUTSREGION nuts = ListOfValues.GetNutsRegion(areaCode); if (nuts != null && !TreeListRow.CODE_UNKNOWN.Equals(areaCode)) { areaFilter.RegionID = nuts.LOV_NUTSRegionID; } else { areaFilter.RegionID = null; } } } return(areaFilter); }
protected static void addDatabaseDate(Dictionary <string, string> header) { string appIsReview = ConfigurationManager.AppSettings["IsReview"]; if (!String.IsNullOrEmpty(appIsReview) && appIsReview.ToLower().Equals("true")) { header.Add(Resources.GetGlobal("Common", "DatabaseDateReview"), ListOfValues.GetLatestReviewDate().Format()); } else { header.Add(Resources.GetGlobal("Common", "DatabaseDate"), ListOfValues.GetLatestPublicationDate().Format()); } }
/// <summary> /// Gets the short name of a Pollutant based on the code. /// If the code corresponds to a pollutant group, the name for confidnetiality within the group is returned /// </summary> public static string PollutantNameShort(string code) { string shortCode = code + ".short"; if (ListOfValues.IsPollutantGroup(code)) { return(GetResource("LOV_POLLUTANT", shortCode + ".Confidential")); } else { return(GetResource("LOV_POLLUTANT", shortCode)); } }
/// <summary> /// init list /// </summary> public void Initialize(bool includeEper, int?searchYear) { // get reporting years List <int> years = ListOfValues.ReportYearsSeries().ToList(); this.Visible = years.Count > 0; if (years.Count > 0) { int year = searchYear.HasValue ? searchYear.Value : years[years.Count - 1]; Initialize(years, year); } }
/// <summary> /// GetActivityFilter /// </summary> /// <param name="searchActivityFilter">Input filter is discarded after this method is run</param> /// <param name="code">Note: code can be sector, activity or subactivity code</param> /// <param name="parentCode"></param> /// <returns></returns> public static ActivityFilter GetActivityFilter(ActivityFilter searchActivityFilter, string code, string parentCode) { //for total-rows the activityfilter corresponds to the filter from the search if (TreeListRow.CODE_TOTAL.Equals(code)) { return(searchActivityFilter == null ? null : searchActivityFilter.Clone() as ActivityFilter); } ActivityFilter activityfilter = new ActivityFilter(); LOV_ANNEXIACTIVITY parent = ListOfValues.GetAnnexIActicvity(parentCode); LOV_ANNEXIACTIVITY selected = ListOfValues.GetAnnexIActicvity(code); if (parent == null) { //selected is on sectorlevel activityfilter.SectorIds.Add(selected.LOV_AnnexIActivityID); activityfilter.ActivityIds.Add(ActivityFilter.AllActivitiesInSectorID); activityfilter.SubActivityIds.Add(ActivityFilter.AllSubActivitiesInActivityID); } else { //selected is on sectorlevel or activity if (parent.ParentID == null) { //selected is on activity level activityfilter.SectorIds.Add(parent.LOV_AnnexIActivityID); activityfilter.ActivityIds.Add(selected.LOV_AnnexIActivityID); activityfilter.SubActivityIds.Add(ActivityFilter.AllSubActivitiesInActivityID); } else { //selected is on subactivity level LOV_ANNEXIACTIVITY sector = ListOfValues.GetAnnexIActicvity((int)parent.ParentID); activityfilter.SectorIds.Add(sector.LOV_AnnexIActivityID); activityfilter.ActivityIds.Add(parent.LOV_AnnexIActivityID); if (TreeListRow.CODE_UNSPECIFIED.Equals(code)) { activityfilter.SubActivityIds.Add(ActivityFilter.SubActivitiesUnspecifiedID); } else { activityfilter.SubActivityIds.Add(selected.LOV_AnnexIActivityID); } } } return(activityfilter); }
protected string GetGroupCount(object obj) { IndustrialActivity.IAReleasesTreeListRow row = (IndustrialActivity.IAReleasesTreeListRow)obj; if (row.HasChildren) { int total = ListOfValues.CountLeafPollutants(row.Code); int number = row.CountChildPollutants; return(String.Format("({0}/{1})", number, total)); } else { return(string.Empty); } }
public ListOfValue AddLov(string value) { if (ActiveListOfValues.Any(val => val.Equals(value))) { return(null); } var listOfValue = new ListOfValue { Value = value }; ListOfValues.Add(listOfValue); return(listOfValue); }
/// <summary> /// Search, fill data into summery /// </summary> public void Populate(int facilityReportId, string pollutantCode, int searchYear) { FacilityBasic = Facility.GetFacilityBasic(facilityReportId); PollutantCode = pollutantCode; SearchYear = searchYear; ViewState[TIMESERIES] = null; // first sheet is the time series sheet showContent(TrendTransferContent.TimeSeries.ToString()); // set the year according to search. Include EPER List <int> years = ListOfValues.ReportYearsSeries().ToList(); this.ucYearCompareSeries.Initialize(years, searchYear); }
/// <summary> /// Search, fill data into summery /// </summary> public void Populate(int facilityReportId, int searchYear, WasteTypeFilter.Type waste) { FacilityBasic = Facility.GetFacilityBasic(facilityReportId); ViewState[FACILITY_SPECIAL] = facilityReportId; WasteType = waste; SearchYear = searchYear; // reset viewstate data ViewState[TIMESERIES_DATA] = null; showContent(TrendWasteContent.TimeSeries.ToString()); // set the year according to search. Waste does not inclucde EPER List <int> years = years = ListOfValues.ReportYears(false).ToList(); this.ucYearCompareSeries.Initialize(years, searchYear); }
//creates header for Area and adds to dictionary protected static void addArea(Dictionary <string, string> header, AreaFilter filter) { if (filter != null) { string key = Resources.GetGlobal("Common", "Area"); string value = string.Empty; AreaFilter.Level level = filter.SearchLevel(); if (level == AreaFilter.Level.AreaGroup) { string code = ListOfValues.GetAreaGroup((int)filter.AreaGroupID).Code; value = LOVResources.AreaGroupName(code); } else if (level == AreaFilter.Level.Country) { string code = ListOfValues.GetCountry((int)filter.CountryID).Code; value = LOVResources.CountryName(code); } else if (level == AreaFilter.Level.Region) { if (filter.TypeRegion == AreaFilter.RegionType.RiverBasinDistrict) { string code = ListOfValues.GetRiverBasinDistrict((int)filter.RegionID).Code; value = LOVResources.RiverBasinDistrictName(code); } else if (filter.TypeRegion == AreaFilter.RegionType.NUTSregion) { if (filter.RegionID != null) { string code = ListOfValues.GetNUTSRegion((int)filter.RegionID).Code; value = LOVResources.NutsRegionName(code); } else { value = LOVResources.NutsRegionName(TreeListRow.CODE_UNKNOWN); } } else { throw new InvalidOperationException(string.Format("Illgegal RegionType {0}", filter.TypeRegion)); } } header.Add(key, value); } }
public static IEnumerable <TimeSeriesUtils.BarData> InsertMissingYearsTimeSeries(IEnumerable <TimeSeriesUtils.BarData> data, bool includeEPER) { IEnumerable <REPORTINGYEAR> years = ListOfValues.ReportingYearsTimeSeries(); IEnumerable <TimeSeriesUtils.BarData> bars = from y in years join c in data on y.Year equals c.Year into g from c in g.DefaultIfEmpty() orderby y.Year select new TimeSeriesUtils.BarData { Year = y.Year, Values = c != null ? c.Values : null, ToolTip = c != null ? c.ToolTip : null }; return(bars); }