public override Task OnConnected() { var name = Context.User.Identity.Name; using (var db = new bebersohl_DBEntities()) { var user = db.Users .Include(u => u.Connections) .SingleOrDefault(u => u.UserName == name); if (user == null) { user = new User { UserName = name, EloRating = 1500, Connections = new List <Connection>() }; db.Users.Add(user); } user.Connections.Add(new Connection { ConnectionID = Context.ConnectionId, UserAgent = Context.Request.Headers["User-Agent"], Connected = true }); db.SaveChanges(); } return(base.OnConnected()); }
public override Task OnConnected() { var name = Context.User.Identity.Name; using (var db = new bebersohl_DBEntities()) { var user = db.Users .Include(u => u.Connections) .SingleOrDefault(u => u.UserName == name); if (user == null) { user = new User { UserName = name, EloRating = 1500, Connections = new List<Connection>() }; db.Users.Add(user); } user.Connections.Add(new Connection { ConnectionID = Context.ConnectionId, UserAgent = Context.Request.Headers["User-Agent"], Connected = true }); db.SaveChanges(); } return base.OnConnected(); }
public override Task OnDisconnected(bool stopCalled) { using (var db = new bebersohl_DBEntities()) { var connection = db.Connections.Find(Context.ConnectionId); db.Connections.Remove(connection); db.SaveChanges(); } return(base.OnDisconnected(stopCalled)); }
public override Task OnDisconnected(bool stopCalled) { using (var db = new bebersohl_DBEntities()) { var connection = db.Connections.Find(Context.ConnectionId); db.Connections.Remove(connection); db.SaveChanges(); } return base.OnDisconnected(stopCalled); }