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