public void GetContext_AssesmentJustStarted_InitialDataSectionIs1()
{
Assesment a = new Assesment(DEFAULT_ID);
AssesmentContextTO context = a.GetCurrentContext();
Assert.AreEqual(1, context.SectionIndex);
}
public ActionResult GetContext()
{
Assesment assesment = Session[SESSION_ASSESMENT_OBJECT] != null ? (Assesment)Session[SESSION_ASSESMENT_OBJECT] : null;
if (assesment == null)
{
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
AssesmentContextTO ctx = assesment.GetCurrentContext();
var questions =
(from c in ctx.CurrentSectionQuestions
select new
{
Answers =
(from a in c.Answers
select new { AnswerId = a.AnswerId, Text = a.Text }),
QuestionId = c.QuestionId,
Text = c.Text,
Type = c.Type
});
return(Json(new {
SectionIndex = ctx.SectionIndex,
QuestionIndex = ctx.QuestionIndex,
MinutesLeft = ctx.MinutesLeft,
CurrentSectionQuestions = questions
}, JsonRequestBehavior.AllowGet));
}
public static void CreateContext(int assesmentID, AssesmentContextTO context)
{
string execCommand = String.Format("INSERT INTO assesment_context (AssesmentID, SectionIndex, QuestionIndex, MinutesLeft) " +
" VALUES ({0},{1},{2},{3})", assesmentID, context.SectionIndex, context.QuestionIndex, context.MinutesLeft);
ExecuteAssementExecutionCommand(execCommand);
}
public static void UpdateContext(int assesmentID, AssesmentContextTO context)
{
string execCommand = String.Format("UPDATE assesment_context " +
" SET SectionIndex={1}, QuestionIndex={2}, MinutesLeft={3} " +
" WHERE AssesmentID = {0}", assesmentID, context.SectionIndex, context.QuestionIndex, context.MinutesLeft);
ExecuteAssementExecutionCommand(execCommand);
}
private AssesmentContextTO GetDbContext(int id)
{
AssesmentContextTO context =
(from c in db.AssesmentsContexts
where c.AssesmentId == id
select c).FirstOrDefault();
return(context);
}
public void UpdateLeftTime_TimeRunOut_MinutesLeftStillZero()
{
Assesment a = new Assesment(DEFAULT_ID);
a.Start();
a.UpdateLeftTime();
AssesmentContextTO context = a.GetCurrentContext();
Assert.AreEqual(true, context.MinutesLeft >= 0);
}
private void UpdateBdContext(int id, AssesmentContextTO contextToSave)
{
AssesmentContextTO context =
(from c in db.AssesmentsContexts
where c.AssesmentId == id
select c).FirstOrDefault();
if (context != null)
{
context.SectionIndex = contextToSave.SectionIndex;
context.MinutesLeft = contextToSave.MinutesLeft;
context.QuestionIndex = contextToSave.QuestionIndex;
db.Entry(context).CurrentValues.SetValues(context);
db.SaveChanges();
}
}
private void CreateContext()
{
if (info != null)
{
if (info.Status == AssesmentStatus.Created)
{
currentContext = GetDefaultContext();
currentContext.MinutesLeft = ConvertEstimatedDurationToMinutesLeft(info.Evaluation.Sections.ElementAt(0).EstimatedDuration);
CreateDbContext(id, currentContext);
}
else
{
currentContext = GetDbContext(id);
}
UpdateSectionResponseInfo();
}
}
private void CreateContext()
{
if (info != null)
{
if (info.Status == AssesmentStatus.Created)
{
currentContext = GetDefaultContext();
currentContext.MinutesLeft = ConvertEstimatedDurationToMinutesLeft(info.Evaluation.Sections[0].EstimatedDuration);
AssesmentPersistence.CreateContext(id, currentContext);
}
else
{
currentContext = AssesmentPersistence.GetContextByAssesmentID(id);
}
UpdateSectionResponseInfo();
}
}
public static AssesmentContextTO GetContextByAssesmentID(int id)
{
AssesmentContextTO currentContext = null;
string execCommand = String.Format("SELECT SectionIndex, QuestionIndex, MinutesLeft " +
" FROM assesment_context " +
" WHERE AssesmentID = {0}", id);
DataTable table = ExecuteAssementExecutionCommand(execCommand);
if (table != null && table.Rows.Count > 0)
{
currentContext = new AssesmentContextTO();
currentContext.SectionIndex = Convert.ToInt32(table.Rows[0]["SectionIndex"]);
currentContext.QuestionIndex = Convert.ToInt32(table.Rows[0]["QuestionIndex"]);
currentContext.MinutesLeft = Convert.ToInt32(table.Rows[0]["MinutesLeft"]);
}
return(currentContext);
}
private void CreateDbContext(int id, AssesmentContextTO context)
{
context.AssesmentId = id;
db.AssesmentsContexts.Add(context);
db.SaveChanges();
}
