public bool CheckQuestionName(QuestionItemEntity questionItemEntity) { var questionName = questionItemEntity.QuestionName; if (!questionItemEntity.QuestionId.HasValue) { var query = _context.TB_M_QUESTION.Where(x => x.QUESTION_NAME.ToUpper().Equals(questionName.ToUpper())); var count = query.Count(); if (count > 0) { return(false); } else { return(true); } } else { var query = _context.TB_M_QUESTION.Where(x => x.QUESTION_NAME.ToUpper().Equals(questionName.ToUpper()) && x.QUESTION_ID != questionItemEntity.QuestionId); var count = query.Count(); if (count > 0) { return(false); } else { return(true); } } }
public JsonResult SaveQuestion(QuestionSaveViewModel questionSaveVM) { Logger.Info(_logMsg.Clear().SetPrefixMsg("Question Save").ToInputLogString()); try { if (ModelState.IsValid) { QuestionItemEntity questionEntity = new QuestionItemEntity { QuestionId = questionSaveVM.QuestionId, QuestionName = questionSaveVM.QuestionName, Status = questionSaveVM.Status, UserId = UserInfo.UserId, CreateUser = questionSaveVM.CreateUser, CreateDate = questionSaveVM.CreateDate }; _questionFacade = new QuestionFacade(); if (questionEntity.QuestionName.Length <= 8000 && questionEntity.QuestionName.Length > 0) { var checkQuestion = _questionFacade.CheckQuestionName(questionEntity); if (checkQuestion == false) { return(Json(new { is_success = false, message = "ชื่อ Question ซ้ำ" })); } else { var isSuccess = _questionFacade.SaveQuestion(questionEntity); return(isSuccess ? Json(new { is_success = true, message = "บันทึก Question สำเร็จ" }) : Json(new { is_success = false, message = "บันทึก Question ไม่สำเร็จ" })); } } else { return(Json(new { is_success = false, message = "ชื่อ Question ต้องมากกว่าหรือเท่ากับ 1 ตัวอักษร และไม่เกิน 100 ตัวอักษร" })); } } return(Json(new { is_success = false, message = string.Empty })); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); Logger.Info(_logMsg.Clear().SetPrefixMsg("Question Save").Add("Error Message", ex.Message).ToFailLogString()); return(Json(new { is_success = false, message = string.Format(CultureInfo.InvariantCulture, "Error : {0}", ex.Message) })); } }
public bool SaveQuestion(QuestionItemEntity questionItemEntity) { _context.Configuration.AutoDetectChangesEnabled = false; try { TB_M_QUESTION question; if (!questionItemEntity.QuestionId.HasValue) { //save question = new TB_M_QUESTION(); question.QUESTION_NAME = questionItemEntity.QuestionName; question.IS_ACTIVE = questionItemEntity.Status; question.CREATE_USER = questionItemEntity.UserId; question.CREATE_DATE = DateTime.Now; question.UPDATE_USER = questionItemEntity.UserId; question.UPDATE_DATE = DateTime.Now; _context.TB_M_QUESTION.Add(question); Save(); } else { //save question = new TB_M_QUESTION(); question.QUESTION_NAME = questionItemEntity.QuestionName; question.IS_ACTIVE = questionItemEntity.Status; question.CREATE_USER = questionItemEntity.CreateUser; question.CREATE_DATE = questionItemEntity.CreateDate; question.UPDATE_USER = questionItemEntity.UserId; question.UPDATE_DATE = DateTime.Now; question.QUESTION_ID = (int)questionItemEntity.QuestionId; SetEntryStateModified(question); Save(); } return(true); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); return(false); } finally { _context.Configuration.AutoDetectChangesEnabled = true; } }
public bool CheckQuestionName(QuestionItemEntity questionItemEntity) { _questionDataAccess = new QuestionDataAccess(_context); return(_questionDataAccess.CheckQuestionName(questionItemEntity)); }
public bool SaveQuestion(QuestionItemEntity questionItemEntity) { _questionDataAccess = new QuestionDataAccess(_context); return(_questionDataAccess.SaveQuestion(questionItemEntity)); }