public void updatePageHit(String pageName, String userName)
{
var pageCount = db.PageHitsEntity.Where(x => x.PageName == pageName && x.Username == userName).Count();
if (pageCount > 0)
{
PageHits pageHitsModel = new PageHits();
pageHitsModel.PageName = pageName;
pageHitsModel.Username = userName;
PageHits updateHit = db.PageHitsEntity.Where(f => f.PageName == pageHitsModel.PageName && f.Username == pageHitsModel.Username).FirstOrDefault();
updateHit.Hit += 1;
updateHit.LastVisitStamp = hitTimeStamp;
db.Entry(updateHit).State = EntityState.Modified;
db.SaveChanges();
}
else
{
PageHits pageHitsModel = new PageHits();
pageHitsModel.PageName = pageName;
pageHitsModel.Username = userName;
pageHitsModel.Hit = 1;
pageHitsModel.LastVisitStamp = hitTimeStamp;
db.PageHitsEntity.Add(pageHitsModel);
db.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "Id,CourseName,Coursecredits,LecturerId")] Courses courses)
{
if (ModelState.IsValid)
{
Users user = db.UserEntity.Where(x => x.Id == courses.LecturerId).FirstOrDefault();
Courses newCourse = new Courses();
newCourse.CourseName = courses.CourseName;
newCourse.CourseCredits = courses.CourseCredits;
newCourse.LecturerName = user.Name;
newCourse.LecturerLastname = user.Lastname;
newCourse.LecturerId = courses.LecturerId;
db.CoursesEntity.Add(newCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(courses));
}
public ActionResult Login(Users users)
{
var userCount = db.UserEntity.Where(x => x.Username == users.Username && x.Password == users.Password).Count();
if (userCount == 0)
{
ViewBag.errorMsg = "Error: Invalid Users or Credentials";
return(View());
}
else
{
pageHits.updatePageHit("Account/Login", users.Username);
Users updateLastLogin = db.UserEntity.Where(x => x.Username == users.Username).FirstOrDefault();
updateLastLogin.LastLogin = lastLoginStamp;
db.Entry(updateLastLogin).State = EntityState.Modified;
db.SaveChanges();
FormsAuthentication.SetAuthCookie(users.Username, false);
return(RedirectToAction("Index", "Home"));
}
}
public void updateSearchHit(String Keyword)
{
var query = db.SearchEntity.Where(x => x.Keyword == Keyword).Count();
if (query > 0)
{
//search keyword exists
Search search = db.SearchEntity.Where(x => x.Keyword == Keyword).FirstOrDefault();
search.Hit += 1;
search.SearchTimeStamp = hitTimeStamp;
db.Entry(search).State = EntityState.Modified;
db.SaveChanges();
}
else
{
Search search = new Search();
search.Keyword = Keyword;
search.Hit = 1;
search.SearchTimeStamp = hitTimeStamp;
db.SearchEntity.Add(search);
db.SaveChanges();
//search keyword does not exist
}
}
public void collectVisitorData(String browserName, String ipAddr, String userAgent, bool isMobileDev, bool isLocalCon, String sessionID)
{
HertsOnlineEntities db = new HertsOnlineEntities();
VisitorStatistics visitorStatisticsModel = new VisitorStatistics();
String visitStamp = DateTime.Now.ToString("dd/MM/yyyy H:mm");
visitorStatisticsModel.UserSession = sessionID;
if (isLocalCon)
{
//local connection
visitorStatisticsModel.IPAddress = ipAddr;
visitorStatisticsModel.Country = "localhost";
}
else
{
//external connection
visitorStatisticsModel.IPAddress = ipAddr;
visitorStatisticsModel.Country = getVisitorCountry(ipAddr);
}
if (isMobileDev)
{
//Mobile device
visitorStatisticsModel.OperatingSystem = getMobileOS(userAgent);
visitorStatisticsModel.Device = getMobileDevice(userAgent);
}
else
{
//Desktop Device
visitorStatisticsModel.OperatingSystem = getDesktopOS(userAgent);
visitorStatisticsModel.Device = "Desktop";
}
visitorStatisticsModel.VisitTimeStamp = visitStamp;
visitorStatisticsModel.BrowserName = browserName;
db.VisitorStatisticsEntity.Add(visitorStatisticsModel);
db.SaveChanges();
}
