public IQueryable<ResourceSites> GetActiveSites() { ResourceSitesDataContext dc = new ResourceSitesDataContext(); IQueryable<ResourceSites> Result = from s in dc.ResourceSites where s.Active.Equals(true) select s; return Result; }
public object GetActiveList() { HttpContext context = HttpContext.Current; if (context.Cache["ActiveResourceList" ] == null) { ResourceSitesDataContext dc = new ResourceSitesDataContext(); IQueryable<vActiveResourceSites> Result = dc.vActiveResourceSites.OrderBy(p => p.Name); context.Cache.Insert("ActiveResourceList", Result, null, DateTime.Now.AddMinutes(CachingTime), TimeSpan.Zero); } return (IQueryable<vActiveResourceSites>)context.Cache["ActiveResourceList" ]; }
public IQueryable <vResourseSiteCats> GetActiveSites() { ResourceSitesDataContext dc = new ResourceSitesDataContext(); return(dc.vResourseSiteCats.Where(p => p.ActiveCat.Equals(true))); }
public vResourseSiteCats GetSingleSite(int SiteCatCode) { ResourceSitesDataContext dc = new ResourceSitesDataContext(); return(dc.vResourseSiteCats.SingleOrDefault(p => p.Code.Equals(SiteCatCode))); }
public object GetRandResources() { ResourceSitesDataContext dc = new ResourceSitesDataContext(); return dc.vRandDataResources; }
public BaseBOLResourseSiteCats(params int[] MCodes) { MasterCode = Convert.ToInt32(MCodes[0]); dataContext = new ResourceSitesDataContext(); }
public BaseBOLResourceSites() { dataContext = new ResourceSitesDataContext(); }