public int Update(Ex_SubQuestion model)
{
return((int)SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("Ex_SubQuestion_Update")
, model.Id, CommonHelper.Null.GetNull(model.QuestionId), CommonHelper.Null.GetNull(model.SubQuestionName)
, model.Orders, model.UsedState,
model.CreatedBy, model.CreatedDate,
CommonHelper.Null.GetNull(model.ModifiedDate), CommonHelper.Null.GetNull(model.ModifiedBy)));
}
public int Insert(Ex_SubQuestion model)
{
var deciResult = SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("Ex_SubQuestion_Insert")
, CommonHelper.Null.GetNull(model.QuestionId), CommonHelper.Null.GetNull(model.SubQuestionName)
, 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 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 }));
}
