public int Update(Ex_Answer model)
{
return((int)SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("Ex_Answer_Update")
, model.Id, CommonHelper.Null.GetNull(model.SubQuestionId), CommonHelper.Null.GetNull(model.Answer), CommonHelper.Null.GetNull(model.CorrectAnswer)
, model.Orders, model.UsedState,
model.CreatedBy, model.CreatedDate,
CommonHelper.Null.GetNull(model.ModifiedBy), CommonHelper.Null.GetNull(model.ModifiedDate)));
}
public int Insert(Ex_Answer model)
{
var deciResult = SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("Ex_Answer_Insert")
, CommonHelper.Null.GetNull(model.SubQuestionId), CommonHelper.Null.GetNull(model.Answer), CommonHelper.Null.GetNull(model.CorrectAnswer)
, model.Orders, model.UsedState,
model.CreatedBy, model.CreatedDate,
CommonHelper.Null.GetNull(model.ModifiedDate), CommonHelper.Null.GetNull(model.ModifiedBy));
return(CommonHelper.Convert.ConvertToInt32(deciResult));
}
public ActionResult GetQuestion(int cauHoi)
{
try
{
if (cauHoi > 0)
{
var question = new SysAdminAction <Ex_Question>().GetById(cauHoi);
var subQuestion = new List <Ex_SubQuestion>();
var answerObjectJson = new List <AnswerObjectJson>();
if (question.Id > 0)
{
subQuestion = new SysAdminAction <Ex_SubQuestion>().List("a.QuestionId=" + question.Id, "a.Orders asc", 0, 100);
if (subQuestion.Count > 0)
{
for (int i = 0; i < subQuestion.Count; i++)
{
var model = new AnswerObjectJson();
model.Id = subQuestion[i].Id;
model.QuestionId = subQuestion[i].QuestionId;
model.SubQuestionName = subQuestion[i].SubQuestionName;
var listAnswer = new List <Ex_Answer>();
var answer = new SysAdminAction <Ex_Answer>().List("a.SubQuestionId=" + subQuestion[i].Id, "a.Orders asc", 0, 100);
if (answer.Count > 0)
{
for (int j = 0; j < answer.Count; j++)
{
var sAnswer = new Ex_Answer();
sAnswer.Answer = answer[j].Answer;
sAnswer.CorrectAnswer = answer[j].CorrectAnswer;
sAnswer.Id = answer[j].Id;
listAnswer.Add(sAnswer);
}
}
model.ListOfAnswer = listAnswer;
answerObjectJson.Add(model);
}
}
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Question = question, SubQuestion = answerObjectJson }));
}
return(Json(new { status = "waring", Message = Ultity.Constant.Ajax_Success }));
}
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
}
public ActionResult EditAnswer(string sysModel)
{
try
{
int succcess = 0;
var listObject = JsonConvert.DeserializeObject <List <AnswerObjectJson> >(sysModel);
#region Update số lượng câu hỏi con vào bảng Question
new SysAdminAction <Ex_Question>().Updates("SubQuestion=" + listObject.Count, "Id=" + listObject[0].QuestionId);
#endregion
if (listObject.Count > 0)
{
#region Xoa nhung cau hoi con cu va dap an cu
try
{
_sysAction.DeleteSubQuestionAnswer(listObject[0].QuestionId);
}
catch (Exception e)
{
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
#endregion
#region Them moi cau hoi con va dap an moi
for (int i = 0; i < listObject.Count; i++)
{
var subQModel = new Ex_SubQuestion();
subQModel.QuestionId = listObject[i].QuestionId;
subQModel.SubQuestionName = listObject[i].SubQuestionName;
subQModel.Orders = (i + 1);
subQModel.UsedState = Ultity.Constant.Active;
subQModel.CreatedBy = WebSecurity.CurrentUserId;
subQModel.CreatedDate = DateTime.Now;
var sub = new Ex_SubQuestionAction().Insert(subQModel);
if (sub > 0)
{
for (int j = 0; j < listObject[i].ListOfAnswer.Count; j++)
{
var answer = new Ex_Answer();
answer.SubQuestionId = sub;
answer.Answer = listObject[i].ListOfAnswer[j].Answer;
answer.CorrectAnswer = listObject[i].ListOfAnswer[j].CorrectAnswer;
answer.Orders = (j + 1);
answer.UsedState = Ultity.Constant.Active;
answer.CreatedBy = WebSecurity.CurrentUserId;
answer.CreatedDate = DateTime.Now;
var ans = new Ex_AnswerAction().Insert(answer);
}
}
}
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success }));
#endregion Redirect Request
}
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
}
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
