//constructor public MessageListViewModel() { using (QAContext ctx = new QAContext()) { this.MessageList = ctx.Message.ToList(); } }
public IQueryable <Answer> GetAnswers([QueryString("UserId")] int?userId) { var dbContext = new QAContext(); IQueryable <Answer> query = dbContext.Answers; if (userId.HasValue && userId > 0) { query = query.Where(a => a.AuthorId == userId.Value); // sorting or filtering switch (AnswerSortValue.Value) { case "newest": query = query.OrderByDescending(a => a.CreateDate); break; case "votes": query = query.OrderByDescending(a => a.Votes.Sum(v => v.VoteValue)) .ThenByDescending(a => a.CreateDate); break; } AnswerSortButtons.Visible = query.Count() > 1; } else { query = null; } return(query); }
public IQueryable <Answer> GetAnswers([QueryString("QuestionID")] int?questionId) { var dbContext = new QAContext(); IQueryable <Answer> query = dbContext.Answers; if (questionId.HasValue && questionId > 0) { query = query.Where(a => a.QuestionId == questionId.Value); // sort if (AnswersSortValue.Value == "oldest") { query = query.OrderBy(a => a.CreateDate); } else { query = query.OrderByDescending(a => a.IsAccepted) .ThenByDescending(a => a.Votes.Sum(v => v.VoteValue)) .ThenBy(a => a.CreateDate); } } else { query = null; } return(query); }
public IQueryable <Question> GetQuestions([QueryString("search")] string search) { var dbContext = new QAContext(); IQueryable <Question> query = dbContext.Questions; // search if (!string.IsNullOrEmpty(search)) { search = HttpUtility.UrlDecode(search); query = query.Where(q => q.Title.Contains(search) || q.Body.Contains(search)); } // sorting or filtering switch (QuestionSortValue.Value) { case "newest": query = query.OrderByDescending(q => q.CreateDate); break; case "votes": query = query.OrderByDescending(q => q.Votes.Sum(v => v.VoteValue)) .ThenByDescending(q => q.Answers.Any(a => a.IsAccepted)) .ThenByDescending(q => q.Answers.Count) .ThenByDescending(q => q.CreateDate); break; case "unanswered": query = query.Where(q => q.Answers.Count == 0).OrderByDescending(q => q.CreateDate); break; } return(query); }
private EEContext CreateContext(string userId, LUInfo luInfo) { EEContext context; string intent = luInfo.Intent.intent; if (intent == "DoExam") { context = examCStore.GetContext(userId); if (context == null) { context = new ExamContext(userId); } } else if (intent == "IntelligenceRoute") { context = irCStore.GetContext(userId); if (context == null) { context = new IRContext(userId); } } else { context = new QAContext(userId, intent, luInfo.EntityList); } return(context); }
public string HandleMessage(string userId, string userInput, ref EEContext eContext) { QAContext context = (QAContext)eContext; string answer = this.mapper.GetResponse(userId, userInput, context); return(answer); }
public void SaveRecognizedNotes(string notes) { using (QAContext context = new QAContext()) { var rep = new Repository(context); rep.SaveNotes(notes); } }
public string GetHandWritingNotes(string groupKey) { using (QAContext context = new QAContext()) { var rep = new Repository(context); return(rep.GetHandWritingNote(groupKey)); } }
public List <string> GetAllHandWritingNote() { using (QAContext context = new QAContext()) { var rep = new Repository(context); return(rep.GetHandWritingNote()); } }
public List <HandWritingNoteDTO> GetHandWritingNotes() { using (QAContext context = new QAContext()) { var rep = new Repository(context); return(rep.GetHandWrittenNotes()); } }
public string GetRecognizedNotes() { using (QAContext context = new QAContext()) { var rep = new Repository(context); return(rep.GetRecognizedNotes()); } }
private void BindUserData(int userId) { var dbContext = new QAContext(); var user = dbContext.Users.Single(u => u.Id == userId); Title = UserFullName.InnerText = user.FullName; FirstNameTextBox.Text = user.FirstName; LastNameTextBox.Text = user.LastName; }
public User GetUser() { var dbContext = new QAContext(); var userIdentity = HttpContext.Current.User.Identity; IQueryable <User> query = dbContext.Users; query = userIdentity.IsAuthenticated ? query.Where(u => u.Email == userIdentity.Name) : null; return(query?.Single()); }
protected void Page_Load(object sender, EventArgs e) { var dbContext = new QAContext(); int userId; if (int.TryParse(Request.QueryString["UserId"], out userId) && userId > 0) { var user = dbContext.Users.SingleOrDefault(u => u.Id == userId); Title = user?.FullName ?? "Untitled"; } }
public void SaveHandwritingNotes(string notes) { using (QAContext context = new QAContext()) { var rep = new Repository(context); var note = new HandWritingNoteDTO { Notes = notes }; rep.SaveHandWrittenNotes(note); } }
protected void Page_Load(object sender, EventArgs e) { var dbContext = new QAContext(); int questionId; if (int.TryParse(Request.QueryString["QuestionID"], out questionId) && questionId > 0) { var question = dbContext.Questions.SingleOrDefault(q => q.Id == questionId); Title = question?.Title ?? "Untitled"; } if (IsPostBack) { ErrorDiv.Visible = false; } }
public string GetResponse(string userId, string userInput, QAContext context) { string intent = context.intent;//luInfo.intent; if (string.IsNullOrWhiteSpace(intent)) { return(null); } QueryMapInfo info = iStore.GetMapInfo(intent.ToLower()); if (info != null) { if (info.qaType == QAType.Direct) { return(info.answer); } else if (info.qaType == QAType.File) { string path = info.answer; string answer = Utils.Utils.ReadEmbeddedResourceFile(path); return(answer); } else //if (info.qaType == QAType.SQLQuery) { if (string.IsNullOrWhiteSpace(info.answer)) { return(""); } string className = info.answer; Type type = Type.GetType(className); Object obj = Activator.CreateInstance(type); MethodInfo methodInfo = type.GetMethod("GetResponse"); object[] parametersArray = new object[] { userId, intent, context.entities }; string respStr = (string)methodInfo.Invoke(obj, parametersArray); return(respStr); } } else { return(iStore.GetMapInfo("none").answer); } }
public IQueryable <Question> GetQuestion([QueryString("QuestionID")] int?questionId) { var dbContext = new QAContext(); IQueryable <Question> query = dbContext.Questions; if (questionId.HasValue && questionId > 0) { query = query.Where(q => q.Id == questionId.Value); } else { Response.Redirect("~/"); query = null; } return(query); }
public IQueryable <User> GetUser([QueryString("UserId")] int?userId) { var dbContext = new QAContext(); IQueryable <User> query = dbContext.Users; if (userId.HasValue && userId > 0) { query = query.Where(u => u.Id == userId.Value); } else { Response.Redirect("~/"); query = null; } return(query); }
protected void QuestionsCountLable_OnLoad(object sender, EventArgs e) { var dbContext = new QAContext(); IQueryable <Question> query = dbContext.Questions; var search = Request.QueryString["search"]; var prefix = ""; if (!string.IsNullOrEmpty(search)) { search = HttpUtility.UrlDecode(search); query = query.Where(q => q.Title.Contains(search) || q.Body.Contains(search)); prefix += " searched"; } if (QuestionSortValue.Value == "unanswered") { query = query.Where(q => q.Answers.Count == 0); prefix += " unanswered"; } QuestionsCountLable.Text = query.Count().ToString("N0") + prefix; }
public QARepository(QAContext qAContext) { QAContext = qAContext; }
public QuestionRepository(QAContext QAcontext) { context = QAcontext; }
public AuthRepository() { _ctx = new QAContext(); _userManager = new UserManager <User>(new UserStore <User>(_ctx)); }
public LeaderboardController(QAContext context) { _context = context; }
public TagsOperations() { databaseContext = new QAContext(); }
public Repository(DbContext ctx) { this.ctx = (QAContext)ctx; }
public void Dispose() { _dbContext?.Dispose(); _dbContext = null; }
public AnswerRepository(QAContext QAcontext) { context = QAcontext; }
public ProfileController(QAContext context, IHttpContextAccessor contextAccess, UserManager <ApplicationUser> um) { _caller = contextAccess.HttpContext.User; _context = context; _userManager = um; }
public QACategoriesController(QAContext qaContext) { _qaContext = qaContext; }