public ActionResult Delete() { Models.ncsi_site_dbEntities _db = new ncsi_site_dbEntities(); string name = Membership.GetUser().UserName; foreach (var log in _db.AccessLogs.Where(m => m.username == name)) { _db.DeleteObject(log); } _db.SaveChanges(); return RedirectToAction("Log", "Account"); }
public ActionResult Log(int id = 0) { Models.ncsi_site_dbEntities _db = new ncsi_site_dbEntities(); string name = Membership.GetUser().UserName; var accesses = _db.AccessLogs.Where(m => m.username == name).Select(m => new AccessData { Address = m.address, Time = m.datetime }).OrderByDescending(a => a.Time).Skip(id * 20).Take(20); ViewData["Accesses"] = accesses; ViewData["page"] = id; return View(); }