public override string[] GetRolesForUser(string username) { using (MyEshop_DBEntities db = new MyEshop_DBEntities()) { return(db.Users.Where(u => u.UserName == username).Select(u => u.Roles.RoleName).ToArray()); } }
protected void Session_Start() { int online = int.Parse(HttpContext.Current.Application["Online"].ToString()); online += 1; HttpContext.Current.Application["Online"] = online; string ip = Request.UserHostAddress; using (MyEshop_DBEntities db = new MyEshop_DBEntities()) { DateTime dtNow = DateTime.Now.Date; if (!db.SiteVisit.Any(v => v.IP == ip && v.Date == dtNow)) { db.SiteVisit.Add(new SiteVisit() { Date = DateTime.Now, IP = ip }); } } }