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