private static DataClassesLOVDataContext getDataContext()
{
DataClassesLOVDataContext db = new DataClassesLOVDataContext();
db.Log = new DebuggerWriter();
return(db);
}
public static List <int> GetReportingYears()
{
DataClassesLOVDataContext db = getDataContext();
IEnumerable <int> res = from r in db.REPORTINGYEARs
select r.Year;
return(res.ToList());
}
private static List <REPORTINGYEAR> getReportingYearCache()
{
if (ListOfValues.reportingYearCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
ListOfValues.reportingYearCache = db.REPORTINGYEARs.ToList <REPORTINGYEAR>();
}
return(ListOfValues.reportingYearCache);
}
private static List <LOV_AREAGROUP> getLovAreaGroupCache()
{
if (ListOfValues.lovAreaGroupCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
ListOfValues.lovAreaGroupCache = db.LOV_AREAGROUPs.ToList <LOV_AREAGROUP>();
}
return(ListOfValues.lovAreaGroupCache);
}
private static List <LOV_POLLUTANT> getLovPollutantCache()
{
if (ListOfValues.lovPollutantCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
ListOfValues.lovPollutantCache = db.LOV_POLLUTANTs.ToList <LOV_POLLUTANT>();
}
return(ListOfValues.lovPollutantCache);
}
private static List <LOV_NACEACTIVITY> getLovNaceActivityCache()
{
if (ListOfValues.lovNaceActivityCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
ListOfValues.lovNaceActivityCache = db.LOV_NACEACTIVITies.ToList <LOV_NACEACTIVITY>();
}
return(ListOfValues.lovNaceActivityCache);
}
private static List <REPORTINGCOUNTRY> getReportingCountryCache()
{
if (ListOfValues.reportingCountryCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
ListOfValues.reportingCountryCache = db.REPORTINGCOUNTRies.ToList <REPORTINGCOUNTRY>();
}
return(ListOfValues.reportingCountryCache);
}
private static List <LOV_COUNTRY> GetLovCountryCache()
{
if (ListOfValues.lovCountryCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
ListOfValues.lovCountryCache = db.LOV_COUNTRies.ToList <LOV_COUNTRY>();
}
return(ListOfValues.lovCountryCache);
}
private static IEnumerable <RECEIVINGCOUNTRY> GetReceivingCountryCache()
{
if (ListOfValues.receivingCountryCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
ListOfValues.receivingCountryCache = db.RECEIVINGCOUNTRies.ToList <RECEIVINGCOUNTRY>();
//populate list immediately
}
return(ListOfValues.receivingCountryCache);
}
/// <summary>
/// Returns a list of country ID's within the areagroup given
/// </summary>
public static IEnumerable <int> GetCountryIdsInArea(int?areaGroupId)
{
DataClassesLOVDataContext db = getLOVDataContext();
IEnumerable <int> countries = from c in getCountryAreaGroupCache()
where c.LOV_AreaGroupID == areaGroupId
select c.LOV_CountryID;
return(countries);
}
private static List <LOV_NUTSREGION> getLovNUTSRegionCache()
{
if (ListOfValues.lovNUTSRegionCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
IEnumerable <LOV_NUTSREGION> data = db.LOV_NUTSREGIONs;
ListOfValues.lovNUTSRegionCache = data.ToList <LOV_NUTSREGION>();
}
return(ListOfValues.lovNUTSRegionCache);
}
private static List <LOV_RIVERBASINDISTRICT> getLovRiverBasinDistrictCache()
{
if (ListOfValues.lovRiverBasinDistrictCache == null)
{
DataClassesLOVDataContext db = getLOVDataContext();
IEnumerable <LOV_RIVERBASINDISTRICT> data = db.LOV_RIVERBASINDISTRICTs;
ListOfValues.lovRiverBasinDistrictCache = data.ToList <LOV_RIVERBASINDISTRICT>();
}
return(ListOfValues.lovRiverBasinDistrictCache);
}
public static DateTime?GetLatestReviewDate()
{
DataClassesLOVDataContext db = getLOVDataContext();
return(db.LATEST_DATAIMPORTs.Max(x => x.ForReview));
}
public static DateTime?GetLatestPublicationDate()
{
DataClassesLOVDataContext db = getLOVDataContext();
return(db.LATEST_DATAIMPORTs.Max(x => x.Published));
}
