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 })); }