public string OptionValidity(string optName, long?OptionId, long QuestionId)
{
List <QuestionOptionMappingEntity> usrList = new List <QuestionOptionMappingEntity>();
QuestionOptionMappingEntity Question = new QuestionOptionMappingEntity();
if (OptionId != null)
{
Question = db.tblQuestionOptionMappings.Where(x => x.QuestionOptionText.ToLower() == optName.ToLower() && x.OptionId != OptionId).Select(x => new QuestionOptionMappingEntity()
{
QuestionOptionText = x.QuestionOptionText,
}).FirstOrDefault();
}
else
{
Question = db.tblQuestionOptionMappings.Where(x => x.QuestionOptionText.ToLower() == optName.ToLower() && x.QuestionId == QuestionId).Select(x => new QuestionOptionMappingEntity()
{
QuestionOptionText = x.QuestionOptionText,
}).FirstOrDefault();
}
if (Question != null)
{
return("Question already exist.");
}
else
{
return("Success");
}
}
//POST: Save Option
public JsonResult AddOption(QuestionOptionMappingEntity queOp)
{
try
{
if (ModelState.IsValid)
{
ValidationFactory VF = new ValidationFactory();
QuestionOptionMappingFactory AddOption = new QuestionOptionMappingFactory();
DataLayer.tblQuestionOptionMapping NewQO = new DataLayer.tblQuestionOptionMapping();
DataLayer.tblQuiz NewQuiz = new DataLayer.tblQuiz();
string Message = VF.OptionValidity(queOp.QuestionOptionText, null, queOp.QuestionId);
if (Message != "Success")
{
ModelState.AddModelError("Question", Message);
GetQuiz();
return(Json("Option Already Exist.", JsonRequestBehavior.AllowGet));
}
else
{
NewQO.QuestionId = queOp.QuestionId;
NewQO.QuestionOptionText = queOp.QuestionOptionText;
NewQO.IsTrue = queOp.IsTrue;
NewQO.CreatedDate = DateTime.Now;
NewQO.CreatedBy = null;
NewQO.UpdatedDate = null;
NewQO.UpdatedBy = null;
NewQO.IsActive = true;
AddOption.SaveOption(NewQO);
return(Json("Record added sucessfully", JsonRequestBehavior.AllowGet));
}
}
else
{
GetQuiz();
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception Ex)
{
return(Json("Something went wrong.", JsonRequestBehavior.AllowGet));
}
finally
{
GetQuiz();
}
}
public bool IsTrueAnswer(string OptionText, long QuestionID)
{
QuestionOptionMappingEntity ansMapping = new QuestionOptionMappingEntity();
if (OptionText != null)
{
ansMapping = db.tblQuestionOptionMappings.Where(x => x.QuestionOptionText.Trim() == OptionText.Trim() && x.IsActive == true).Select(x => new QuestionOptionMappingEntity
{
IsTrue = x.IsTrue
}).SingleOrDefault();
if (ansMapping.IsTrue)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
