public void OnGet()
{
var optionsBuilder = new DbContextOptionsBuilder <KnowledgeShareDbContext>();
optionsBuilder.UseSqlServer(Configuration.GetConnectionString("KnowledgeShareDbContext"));
using (var context = new KnowledgeShareDbContext(optionsBuilder.Options))
{
this.Questions = context.Questions.Select(x => x).ToList();
this.Answers = context.Questions.Where(x => x.QuestionId == 1).SelectMany(x => x.Answers).ToList();
}
}
public async Task ConnectUser(string username)
{
var connectedUsers = new List <ConnectedUser>();
var optionsBuilder = new DbContextOptionsBuilder <KnowledgeShareDbContext>();
optionsBuilder.UseSqlServer(Configuration.GetConnectionString("KnowledgeShareDbContext"));
using (var context = new KnowledgeShareDbContext(optionsBuilder.Options))
{
connectedUsers = await context.ConnectedUsers.ToListAsync();
}
await Clients.All.SendAsync("UserConnected", JsonConvert.SerializeObject(connectedUsers));
}
public void OnPost()
{
var userName = Request.Form["UserName"];
if (!string.IsNullOrWhiteSpace(userName))
{
this.UserName = userName;
var optionsBuilder = new DbContextOptionsBuilder <KnowledgeShareDbContext>();
optionsBuilder.UseSqlServer(Configuration.GetConnectionString("KnowledgeShareDbContext"));
using (var context = new KnowledgeShareDbContext(optionsBuilder.Options))
{
context.ConnectedUsers.Add(new Models.ConnectedUser {
UserName = userName
});
context.SaveChanges();
}
}
}
public KnowledgeShareRHub(IConfiguration configuration, KnowledgeShareDbContext dbContext)
{
Configuration = configuration;
_db = dbContext;
}
public MessageModel(ILogger <IndexModel> logger, IConfiguration configuration, KnowledgeShareDbContext dbContext)
{
_logger = logger;
Configuration = configuration;
_db = dbContext;
}
