public ActionResult GetSystemMessageByCd([FromRoute] decimal id, [FromRoute] string language)
{
var query = from d in _context.M_SYSTEM_MESSAGES
where d.MESSAGE_CD == id &&
d.LANGUAGE_TYPE == language
select d;
if (!query.Any())
{
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = string.Empty
}));
}
M_SYSTEM_MESSAGE notify = query.Single();
SystemMessageEntity entity = new SystemMessageEntity();
entity.messageId = notify.MESSAGE_ID;
entity.messageCd = notify.MESSAGE_CD;
entity.languageType = notify.LANGUAGE_TYPE;
entity.message = notify.MESSAGE;
entity.messageContent = notify.MESSAGE_CONTENT;
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = entity.messageContent
}));
}
/// <summary>
/// Get system message info.
/// </summary>
/// <param name="languageType">Language type</param>
/// <param name="cd">Message cd</param>
/// <returns></returns>
public static SystemMessageEntity GetSystemMessageInfo(AloaiDataContext db, string languageType, decimal cd)
{
var query = from d in db.M_SYSTEM_MESSAGES
where d.LANGUAGE_TYPE.Equals(languageType) &&
d.MESSAGE_CD == cd
select d;
SystemMessageEntity entity = new SystemMessageEntity();
if (query.Any())
{
M_SYSTEM_MESSAGE mess = query.Single();
entity.messageId = mess.MESSAGE_ID;
entity.messageCd = mess.MESSAGE_CD;
entity.languageType = mess.LANGUAGE_TYPE;
entity.message = mess.MESSAGE;
entity.messageContent = mess.MESSAGE_CONTENT;
}
return(entity);
}
