/// <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)); }
/// <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); }