public async Task <IActionResult> PutTblQuestions([FromRoute] long id, [FromBody] TblQuestions tblQuestions)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblQuestions.FldQuestionsId)
{
return(BadRequest());
}
_context.Entry(tblQuestions).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblQuestionsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
protected void CreateQuestionId()
{
var q = new TblQuestions();
ServerModel.DB.Insert(q);
_id = q.ID;
}
public static TblUserAnswers GetUserAnswerForQuestion(TblUsers user, TblQuestions question)
{
IList <TblUserAnswers> answers = ServerModel.DB.Query <TblUserAnswers>(new AndCondition(
new CompareCondition <int>(
DataObject.Schema.UserRef,
new ValueCondition <int>(user.ID), COMPARE_KIND.EQUAL),
new CompareCondition <int>(
DataObject.Schema.QuestionRef,
new ValueCondition <int>(question.ID), COMPARE_KIND.EQUAL)));
TblUserAnswers lastAnswer = null;
foreach (TblUserAnswers answer in answers)
{
if (lastAnswer == null)
{
lastAnswer = answer;
}
else
{
if (lastAnswer.Date < answer.Date)
{
lastAnswer = answer;
}
}
}
return(lastAnswer);
}
public int CreateQuestionId()
{
var q = new TblQuestions();
ServerModel.DB.Insert(q);
return q.ID;
}
public void BuildCompiledQuestionsResult(TblQuestions q, int userId)
{
var compiledQuestion = ServerModel.DB.Load <TblCompiledQuestions>((int)q.CompiledQuestionRef);
var userAnswers = ServerModel.DB.Load <TblUserAnswers>(ServerModel.DB.LookupIds <TblUserAnswers>(q, null));
var answersForCurrentUser = new List <TblUserAnswers>();
if (ServerModel.User.Current != null)
{
foreach (var uAns in userAnswers)
{
if (uAns.UserRef == userId)
{
answersForCurrentUser.Add(uAns);
}
}
}
SetHeader(q.TestName, compiledQuestion);
if (userAnswers.Count != 0)
{
SetResults(answersForCurrentUser);
}
else
{
SetNoResultStatus(q);
}
}
private static string FindAnswer(int userId, TblQuestions question)
{
var answersForQuestion =
ServerModel.DB.Load <TblUserAnswers>(ServerModel.DB.LookupIds <TblUserAnswers>(question, null));
var answers = new List <TblUserAnswers>();
foreach (var ans in answersForQuestion)
{
if (ans.UserRef == userId)
{
answers.Add(ans);
}
}
if (answers.Count > 0)
{
var lstUserAnswer = StatisticManager.FindLatestUserAnswer(answers);
if (lstUserAnswer != null)
{
return(lstUserAnswer.UserAnswer);
}
}
return(string.Empty);
}
public void BuildCompiledQuestionsResult(TblQuestions q, int userId)
{
var compiledQuestion = ServerModel.DB.Load <TblCompiledQuestions>((int)q.CompiledQuestionRef);
var answersForCurrentUser = StudentRecordFinder.GetUserAnswersForQuestion(q, userId);
SetHeader(q.TestName, compiledQuestion);
SetTableHeader();
if (answersForCurrentUser != null && answersForCurrentUser.Count != 0)
{
var lastUserAnswer = FindLatestUserAnswer(answersForCurrentUser);
var compileAnswer = StudentRecordFinder.GetCompiledAnswersForAnswer(lastUserAnswer);
if (compileAnswer != null && compileAnswer.Count != 0)
{
SetResults(compileAnswer);
}
else
{
SetNoResultStatus(q);
}
}
else
{
SetNoResultStatus(q);
}
}
public void BuildCompiledQuestionsResult(TblQuestions q, int userId)
{
var compiledQuestion = ServerModel.DB.Load<TblCompiledQuestions>((int)q.CompiledQuestionRef);
var answersForCurrentUser = StudentRecordFinder.GetUserAnswersForQuestion(q, userId);
SetHeader(q.TestName, compiledQuestion);
SetTableHeader();
if (answersForCurrentUser != null && answersForCurrentUser.Count != 0)
{
var lastUserAnswer = FindLatestUserAnswer(answersForCurrentUser);
var compileAnswer = StudentRecordFinder.GetCompiledAnswersForAnswer(lastUserAnswer);
if (compileAnswer != null && compileAnswer.Count != 0)
{
SetResults(compileAnswer);
}
else
{
SetNoResultStatus(q);
}
}
else
{
SetNoResultStatus(q);
}
}
public void ChangeDataObjectIDTest()
{
var t = new TblQuestions();
t.IsCompiled = true;
t.ID = 5;
}
protected void CreateQuestionId()
{
var q = new TblQuestions();
ServerModel.DB.Insert(q);
_id = q.ID;
}
private static TblUserAnswers GetLastUserAnswerForCompiledQuestion(TblQuestions q, TblUsers u)
{
var userAnswers = StudentRecordFinder.GetUserAnswersForQuestion(q, u.ID);
var compiledAnswers = StudentRecordFinder.ExtractCompiledAnswers(userAnswers);
return(StatisticManager.FindLatestUserAnswer(compiledAnswers));
}
public int CreateQuestionId()
{
var q = new TblQuestions();
ServerModel.DB.Insert(q);
return(q.ID);
}
public UserResultForQuestion(int userId, TblQuestions question, DateTime?date)
{
_date = date;
_question = question;
_answers = (List <TblUserAnswers>)StudentRecordFinder.GetUserAnswersForQuestion(question, userId);
_answers.Sort(new UserAnswersComparer());
}
public void CreateQuestion(TblQuestions question)
{
if (question == null)
{
throw new System.ArgumentNullException(nameof(question));
}
_context.TblQuestions.Add(question);
}
public ActionResult Edit(TblQuestions questions)
{
db.Entry(questions).State = System.Data.Entity.EntityState.Modified;
db.Entry(questions).Property(e => e.CreateBy).IsModified = false;
db.Entry(questions).Property(e => e.CreateDate).IsModified = false;
questions.ModifyBy = FullName;
questions.ModifyDate = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static string GetCorrectAnswer(int questionId)
{
TblQuestions q = GetQuestion(questionId);
if (ServerModel.User.Current.Islector())
{
return(q.CorrectAnswer);
}
return(string.Empty);
}
public async Task <IActionResult> PostTblQuestions([FromBody] TblQuestions tblQuestions)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.TblQuestions.Add(tblQuestions);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTblQuestions", new { id = tblQuestions.FldQuestionsId }, tblQuestions));
}
public ActionResult Create(TblQuestions questions)
{
if (questions.Question != null)
{
questions.CreateDate = DateTime.Now;
questions.CreateBy = FullName;
db.TblQuestions.Add(questions);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public static IList <TblUserAnswers> GetUserAnswersForQuestion(TblQuestions question, int userId)
{
var allAnswersForQuestion = GetAnswersForQuestion(question);
var result = new List <TblUserAnswers>();
foreach (var a in allAnswersForQuestion)
{
if (a.UserRef == userId)
{
result.Add(a);
}
}
return(result);
}
public void BuildCompiledQuestionsResult(TblQuestions q, int userId)
{
var compiledQuestion = ServerModel.DB.Load<TblCompiledQuestions>((int) q.CompiledQuestionRef);
var userAnswers = ServerModel.DB.Load<TblUserAnswers>(ServerModel.DB.LookupIds<TblUserAnswers>(q, null));
var answersForCurrentUser = new List<TblUserAnswers>();
if (ServerModel.User.Current != null)
{
foreach (var uAns in userAnswers)
if (uAns.UserRef == userId)
answersForCurrentUser.Add(uAns);
}
SetHeader(q.TestName, compiledQuestion);
if (userAnswers.Count != 0)
SetResults(answersForCurrentUser);
else
SetNoResultStatus(q);
}
private static string FindAnswer(int userId, TblQuestions question)
{
var answersForQuestion =
ServerModel.DB.Load<TblUserAnswers>(ServerModel.DB.LookupIds<TblUserAnswers>(question, null));
var answers = new List<TblUserAnswers>();
foreach (var ans in answersForQuestion)
{
if (ans.UserRef == userId)
answers.Add(ans);
}
if (answers.Count > 0)
{
var lstUserAnswer = StatisticManager.FindLatestUserAnswer(answers);
if (lstUserAnswer != null)
return lstUserAnswer.UserAnswer;
}
return string.Empty;
}
public static TblUserAnswers GetUserAnswerForQuestion(TblUsers user, TblQuestions question)
{
IList<TblUserAnswers> answers = ServerModel.DB.Query<TblUserAnswers>(new AndCondition(
new CompareCondition<int>(
DataObject.Schema.UserRef,
new ValueCondition<int>(user.ID), COMPARE_KIND.EQUAL),
new CompareCondition<int>(
DataObject.Schema.QuestionRef,
new ValueCondition<int>(question.ID), COMPARE_KIND.EQUAL)));
TblUserAnswers lastAnswer = null;
foreach (TblUserAnswers answer in answers)
{
if (lastAnswer == null)
{
lastAnswer = answer;
}
else
{
if (lastAnswer.Date < answer.Date)
{
lastAnswer = answer;
}
}
}
return lastAnswer;
}
private void SetNoResultStatus(TblQuestions q)
{
_compiledAnswerTable.Visible = false;
_statusLabel.Visible = true;
_statusLabel.Text = string.Format("You not compile {0} yet", q.TestName);
}
public static IList<TblUserAnswers> GetAnswersForQuestion(TblQuestions question)
{
var allUsersAnswersIdsForQuestion = ServerModel.DB.LookupIds<TblUserAnswers>(question, null);
return ServerModel.DB.Load<TblUserAnswers>(allUsersAnswersIdsForQuestion);
}
public static string GetUserAnswer(int questionId, int userId)
{
TblQuestions q = GetQuestion(questionId);
return(FindAnswer(userId, q));
}
/*
* public static IList<TblThemes> GetThemesForStage(TblStages stage)
* {
* List<int> themesIds = ServerModel.DB.LookupMany2ManyIds<TblThemes>(stage, null);
* return ServerModel.DB.Load<TblThemes>(themesIds);
* }
*
* public static IList<TblStages> GetStagesForCurriculum(TblCurriculums curriculum)
* {
* List<int> stagesIds = ServerModel.DB.LookupIds<TblStages>(curriculum, null);
* return ServerModel.DB.Load<TblStages>(stagesIds);
* }
*
* public static IList<TblQuestions> GetQuestionsForPage(int pageId)
* {
* var page = ServerModel.DB.Load<TblPages>(pageId);
* var questionsIds = ServerModel.DB.LookupIds<TblQuestions>(page, null);
*
* return ServerModel.DB.Load<TblQuestions>(questionsIds);
* }
*
* public static TblThemes GetThemeForPage(int pageId)
* {
* var page = ServerModel.DB.Load<TblPages>(pageId);
* return ServerModel.DB.Load<TblThemes>((int)page.ThemeRef);
* }
*/
public static IList <TblUserAnswers> GetAnswersForQuestion(TblQuestions question)
{
var allUsersAnswersIdsForQuestion = ServerModel.DB.LookupIds <TblUserAnswers>(question, null);
return(ServerModel.DB.Load <TblUserAnswers>(allUsersAnswersIdsForQuestion));
}
public void ChangeDataObjectIDTest()
{
var t = new TblQuestions();
t.IsCompiled = true;
t.ID = 5;
}
private static TblUserAnswers GetLastUserAnswerForCompiledQuestion(TblQuestions q, TblUsers u)
{
var userAnswers = StudentRecordFinder.GetUserAnswersForQuestion(q, u.ID);
var compiledAnswers = StudentRecordFinder.ExtractCompiledAnswers(userAnswers);
return StatisticManager.FindLatestUserAnswer(compiledAnswers);
}
public static IList<TblUserAnswers> GetUserAnswersForQuestion(TblQuestions question, int userId)
{
var allAnswersForQuestion = GetAnswersForQuestion(question);
var result = new List<TblUserAnswers>();
foreach (var a in allAnswersForQuestion)
if (a.UserRef == userId)
result.Add(a);
return result;
}
private void SetNoResultStatus(TblQuestions q)
{
_compiledAnswerTable.Visible = false;
_statusLabel.Visible = true;
_statusLabel.Text = string.Format("You not compile {0} yet", q.TestName);
}