public IHttpActionResult GetSingleMessage([FromBody] MessageSearchViewModel model)
{
var result = _DirectMessageService.GetSingleMessage(model.messageID, model.roomID);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
public IActionResult Search(MessageSearchViewModel model)
{
long userId = Utility.GetUserContext().UserId;
MessageSearchRequest request = new MessageSearchRequest
{
PageIndex = model.PageIndex,
PageSize = model.PageSize,
IsReaded = model.IsReaded,
ReceiverId = userId
};
var data = service.Search(request);
return(Ok(data));
}
//
// GET: /Msg/
public ActionResult Index(string sortOrder, string CurrentSort, int?page)
{
//var trn_msg = db.TRN_MSG;
//return View(trn_msg.ToList());
int pageSize = 10;
int pageIndex = 1;
pageIndex = page.HasValue ? Convert.ToInt32(page) : 1;
IPagedList <TRN_MSG> msg = null;
MessageSearchViewModel messageModel = null;
var messages = db.TRN_MSG.AsQueryable();
if (Request.QueryString.HasKeys() && !page.HasValue)
{
messageModel = new MessageSearchViewModel();
if (!string.IsNullOrEmpty(Request.QueryString["Search_From_User"]))
{
messageModel.Search_From_User = decimal.Parse(Request.QueryString["Search_From_User"]);
messages = messages.Where(u => u.FROM_USER_NO == messageModel.Search_From_User);
}
/*
* if (!string.IsNullOrEmpty(Request.QueryString["Search_To_User"]))
* {
* messageModel.Search_To_User = decimal.Parse(Request.QueryString["Search_To_User"]);
* messages = messages.Where(u => u.FROM_USER_NO == messageModel.Search_To_User);
* }
*/
if (!string.IsNullOrEmpty(Request.QueryString["Search_Subject"]))
{
messageModel.Search_Subject = Request.QueryString["Search_Subject"];
messages = messages.Where(u => u.MSG_SUBJECT.ToLower()
.Contains(messageModel.Search_Subject.ToLower()));
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Date_From"]))
{
messageModel.Search_Date_From = DateTime.Parse(Request.QueryString["Search_Date_From"]);
messages = messages.Where(u => u.INSERT_TIME >= messageModel.Search_Date_From);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Date_To"]))
{
messageModel.Search_Date_To = DateTime.Parse(Request.QueryString["Search_Date_To"]);
messages = messages.Where(u => u.INSERT_TIME <= messageModel.Search_Date_To);
}
Session["Message_Search_Model"] = messageModel;
}
if (!Request.QueryString.HasKeys() && !page.HasValue)
{
Session["Message_Search_Model"] = null;
}
if (Session["Message_Search_Model"] != null)
{
messageModel = (MessageSearchViewModel)Session["Message_Search_Model"];
if (messageModel.Search_From_User.HasValue)
{
messages = messages.Where(u => u.FROM_USER_NO == messageModel.Search_From_User);
}
/*
* if (messageModel.Search_To_User.HasValue)
* {
* messages = messages.Where(u => u.FROM_USER_NO == messageModel.Search_To_User);
* }
*/
if (!string.IsNullOrEmpty(messageModel.Search_Subject))
{
messages = messages.Where(u => u.MSG_SUBJECT.ToLower()
.Contains(messageModel.Search_Subject.ToLower()));
}
if (messageModel.Search_Date_From.HasValue)
{
messages = messages.Where(u => u.INSERT_TIME >= messageModel.Search_Date_From);
}
if (messageModel.Search_Date_To.HasValue)
{
messages = messages.Where(u => u.INSERT_TIME <= messageModel.Search_Date_To);
}
}
msg = messages.OrderBy(m => m.INSERT_TIME)
.ToPagedList(pageIndex, pageSize);
ViewBag.Search_Message_Model = (MessageSearchViewModel)Session["Message_Search_Model"];
return(View(msg));
}
