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