public IList<ReferenceData> ListRegions()
{
using (MDSEntities context = new MDSEntities())
{
return context.REGION_SV
.Select(r => new ReferenceData()
{
Name = r.Name,
Code = r.Code
}).ToList();
}
}
public List<ReferenceData> ListGlobalChallenges()
{
using (MDSEntities context = new MDSEntities())
{
return context.PROJECT_SV
.Where(r => r.RecordType_Code == "P-GLOBCHAL" && r.Hub_Status_Code == "1")
.Select(r => new ReferenceData()
{
Name = r.Name,
Code = r.Code
}).ToList();
}
}
private void Prefetch()
{
using (MDSEntities db = new MDSEntities())
{
_projects = db.PROJECT_SV
.Where(r => !String.IsNullOrEmpty(r.Hub_ID))
.ToList().Select(MapProject)
.ToDictionary(r => r.HubId);
}
}
