public List <Visitor> AllVisitors() { using (var te = new TurnstileDbEntities()) { te.Configuration.ProxyCreationEnabled = false; return(te.Visitors.Include("Visits").ToList()); } }
private bool InsertVisit(int enterType, int visitorId) { var visit = new Visit() { Visitor_Id = visitorId, VisitDate = DateTime.Now, VisitType = enterType }; using (var te = new TurnstileDbEntities()) { te.Visits.Add(visit); te.SaveChanges(); return(true); } }
private static Dictionary <int, Visitor> GetChechedData() { var cache = MemoryCache.Default; if (cache.Contains(CacheKey)) { return((Dictionary <int, Visitor>)cache.Get(CacheKey)); } using (var te = new TurnstileDbEntities()) { var visitors = te.Visitors.ToDictionary(p => p.PermitId, p => p); // Store data in the cache var cacheItemPolicy = new CacheItemPolicy { AbsoluteExpiration = DateTime.Now.AddHours(12.0) }; cache.Add(CacheKey, visitors, cacheItemPolicy); return(visitors); } }