public string GetMostPopularIpAddress()
{
using (var context = new LITIsEpicDataContext(_connectionString))
{
return(context.GetFiveMostFrequentIPs().First().IPAddress);
}
}
public IEnumerable <GetFiveMostFrequentIPsResult> GetFiveMostFrequentIPs()
{
using (var context = new LITIsEpicDataContext(_connectionString))
{
return(context.GetFiveMostFrequentIPs().ToList());
}
}
public int GetVisitCountForToday()
{
using (var context = new LITIsEpicDataContext(_connectionString))
{
return(context.Visits.Count(v => v.Date.Date == DateTime.Today));
}
}
public void AddVisit(string ipAddress)
{
Visit visit = new Visit
{
IPAddress = ipAddress,
Date = DateTime.Now
};
using (var context = new LITIsEpicDataContext(_connectionString))
{
context.Visits.InsertOnSubmit(visit);
context.SubmitChanges();
}
}