public async Task <IHttpActionResult> vGroupUser() { object db_Result = null; using (var db = new ModelAC()) { db_Result = db.Im_UserGroup .OrderBy(p => p.IM_Group_Id) .ThenByDescending(p => p.CreateTime) .Take(100) .Select(p => new { Id = p.Id, IM_Group_Id = p.IM_Group_Id, GroupId = p.IM_Group.GroupId, GroupName = p.IM_Group.GroupName, IM_User_Id = p.IM_User_Id, UserId = p.IM_User.UserId, Name = p.IM_User.Name, GroupPosition = p.GroupPosition, CreateTime = p.CreateTime, }).ToList(); } return(Ok(db_Result)); }
public async Task <IHttpActionResult> vChatterActorBySingle() { object db_Result = null; using (var db = new ModelAC()) { db_Result = db.IM_ChatterActor .Where(p => p.IM_Chatter.ChatType == IM_ChatType.Single) .OrderBy(p => p.ChatterId) .Take(10) .Select(p => new { Id = p.Id, App_Id = p.App_Id, Single_A_IM_User = p.IM_Chatter.Single_A_IM_User.UserId, Single_B_IM_User = p.IM_Chatter.Single_B_IM_User.UserId, UserId = p.IM_User.UserId, Name = p.IM_User.Name, Last_MsgId = p.Last_MsgId, UnreadMsgCount = p.UnreadMsgCount, ChatterTime = p.ChatterTime, IsCleared = p.IsCleared, }).ToList(); } return(Ok(db_Result)); }
public async Task <IHttpActionResult> vMsgSingle() { object db_Result = null; using (var db = new ModelAC()) { db_Result = db.IM_MsgSingle .OrderByDescending(p => p.MsgTime) .Take(10) .Select(p => new { Id = p.Id, App_Id = p.App_Id, MsgClientId = p.MsgClientId, MsgTime = p.MsgTime, MsgType = p.MsgType, MsgBody = p.MsgBody, From_UserId = p.From_IM_User.UserId, From_Name = p.From_IM_User.Name, To_UserId = p.To_IM_User.UserId, To_Name = p.To_IM_User.Name }).ToList(); } return(Ok(db_Result)); }
/// <summary> /// 获取-单聊记录(分页) /// </summary> public object His_SingleHistory(IHis_SingleHistory model) { var user = LOGIN_USER; List <OSingle_SendText> db_Result = new List <OSingle_SendText>(); using (var db = new ModelAC()) { var userB = db.IM_User.SingleOrDefault(p => p.App_Id == APP_GUID && p.UserId == model.ChatId); #region 数据查询 if (model.MsgId == null) {//获取最新5条消息 db_Result = db.IM_MsgSingle .Where(p => (p.From_UserId == user.Id && p.To_UserId == userB.Id) || (p.From_UserId == userB.Id && p.To_UserId == user.Id)) .OrderByDescending(p => p.SortId) .Take(5) .Select(p => new OSingle_SendText { #region 输出 Id = p.Id.ToString(), MsgClientId = p.MsgClientId, From_UserId = p.From_UserId == user.Id ? user.UserId : userB.UserId, To_UserId = p.From_UserId == user.Id ? user.UserId : userB.UserId, MsgTime = p.MsgTime, IsRead = p.IsRead, MsgType = p.MsgType, MsgBody = p.MsgBody, #endregion }) .ToList(); } else {//获取MsgId之前5条消息 var msg = db.IM_MsgSingle.SingleOrDefault(p => p.App_Id == APP_GUID && p.Id == model.MsgId); db_Result = db.IM_MsgSingle .Where(p => p.SortId < msg.SortId) .Where(p => (p.From_UserId == user.Id && p.To_UserId == userB.Id) || (p.From_UserId == userB.Id && p.To_UserId == user.Id)) .OrderByDescending(p => p.SortId) .Take(5) .Select(p => new OSingle_SendText { #region 输出 Id = p.Id.ToString(), MsgClientId = p.MsgClientId, From_UserId = p.From_UserId == user.Id ? user.UserId : userB.UserId, To_UserId = p.From_UserId == user.Id ? user.UserId : userB.UserId, MsgTime = p.MsgTime, IsRead = p.IsRead, MsgType = p.MsgType, MsgBody = p.MsgBody, #endregion }) .ToList(); } #endregion } var jsonResult = CommonJson.camelObject(db_Result); return(jsonResult); }
public async Task <IHttpActionResult> Login(string appKey, string account) { var user = new IM_User(); using (var db = new ModelAC()) { user = db.IM_User.SingleOrDefault(p => p.App_Id == new Guid(appKey) && p.UserId == account); } if (user != null) { var userInfo = new { Account = user.UserId, Name = user.Name, Img = getSITE_URL() + "/content/useravatar/mine_001.png" }; var loginResult = new LoginResult { Status = true, Msg = "验证通过.", User = userInfo }; return(Ok(loginResult)); } else { var loginResult = new LoginResult { Status = false, Msg = "没有账户信息." }; return(Ok(loginResult)); } }
/// <summary> /// 发送-图片消息 /// </summary> /// <returns></returns> public object Group_SendPicture(IGroup_SendText model) { var user = LOGIN_USER; var msg = new IM_MsgGroup(); var db_result = 0; using (var db = new ModelAC()) { #region db msg.App_Id = APP_GUID; msg.MsgClientId = model.MsgClientId; msg.From_UserId = user.Id; msg.To_GroupId = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == model.To_GroupId).Id; msg.MsgTime = DateTime.Now; msg.IsFullRead = false; msg.MsgType = model.MsgType; msg.MsgBody = model.MsgBody; db.IM_MsgGroup.Add(msg); db_result = db.SaveChanges(); #endregion } var session_result = Group_updateSession(msg); if (db_result == 1) { var mOGroup_SendText = new OGroup_SendText() { #region 输出 Id = msg.Id.ToString(), MsgClientId = msg.MsgClientId, From_UserId = model.From_UserId, //From_UserImg = SITE_URL + user.PortraitUri, To_GroupId = model.To_GroupId, MsgTime = msg.MsgTime, IsFullRead = msg.IsFullRead, MsgType = msg.MsgType, MsgBody = msg.MsgBody, #endregion }; var jsonResult = CommonJson.camelObject(mOGroup_SendText); #region 消息分发 Clients.OthersInGroup(msg.To_GroupId.ToString()).Group_SendPicture(jsonResult); #endregion return(jsonResult); } else { return(null); } }
/// <summary> /// 群主-加人 /// </summary> /// <param name="model"></param> /// <returns></returns> public object GM_AddUsers(IGM_AddUsers model) { var mOGM_AddUsers = new OGM_AddUsers(); var group = new IM_Group(); var users_add = new List <IM_User>(); var db_result = 0; using (var db = new ModelAC()) { #region db group = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == model.GroupId); users_add = db.IM_User.Where(p => p.App_Id == APP_GUID && model.Accounts.Contains(p.UserId)).ToList(); foreach (var user in users_add) { var mIm_UserGroup = new Im_UserGroup(); mIm_UserGroup.IM_User_Id = user.Id; mIm_UserGroup.IM_Group_Id = group.Id; mIm_UserGroup.GroupPosition = IM_GroupPosition.Memeber; db.Im_UserGroup.Add(mIm_UserGroup); } db_result = db.SaveChanges(); #endregion } if (db_result > 0) { mOGM_AddUsers.Success = true; mOGM_AddUsers.Msg = "添加群成员成功!"; #region 连接组维护 var app_accounts = users_add.Select(p => HubKey.App__Account(app: APP, account: p.UserId)).ToList(); var connectionIDs = Base_GetConnectionIds(app_accounts); foreach (var connectionId in connectionIDs) { //将连接添加到指定的组 Groups.Add(connectionId, group.Id.ToString()); } #endregion #region 更新相关群组聊表信息-发送系统通知 Update_GM_AddUsers(group); #endregion return(CommonJson.camelObject(mOGM_AddUsers)); } else { mOGM_AddUsers.Success = false; mOGM_AddUsers.Msg = "添加群成员失败!"; return(CommonJson.camelObject(mOGM_AddUsers)); } }
/// <summary> /// 是否存在群聊 /// </summary> /// <param name="groupId">群聊编号</param> /// <returns></returns> private bool ImGroupExists(string groupId) { var db_result = 0; using (var db = new ModelAC()) { db_result = db.IM_Group.Count(e => e.App_Id == APP_GUID && e.GroupId == groupId); } return(db_result > 0); }
/// <summary> /// 群主-创建群 /// </summary> public object GM_Create(IGM_Create model) { var mOGM_Create = new OGM_Create(); if (ImGroupExists(model.GroupId)) { mOGM_Create.Success = false; mOGM_Create.Msg = "已存在该群组编号"; return(CommonJson.camelObject(mOGM_Create)); } var user = LOGIN_USER; var group = new IM_Group(); var mIm_UserGroup = new Im_UserGroup(); var db_result = 0; using (var db = new ModelAC()) { #region db group.App_Id = APP_GUID; group.GroupId = model.GroupId; group.GroupName = model.GroupName; mIm_UserGroup.IM_User_Id = user.Id; mIm_UserGroup.IM_Group_Id = group.Id; mIm_UserGroup.GroupPosition = IM_GroupPosition.Founder; db.IM_Group.Add(group); db.Im_UserGroup.Add(mIm_UserGroup); db_result = db.SaveChanges(); #endregion } if (db_result > 0) { mOGM_Create.Success = true; mOGM_Create.Msg = "群聊创建成功!"; //将连接添加到指定的组 Groups.Add(Context.ConnectionId, group.Id.ToString()); return(CommonJson.camelObject(mOGM_Create)); } else { mOGM_Create.Success = false; mOGM_Create.Msg = "服务器错误!"; return(CommonJson.camelObject(mOGM_Create)); } }
/// <summary> /// 获取-好友 /// </summary> /// <returns></returns> public object FG_GetFriends() { List <OFG_GetFriends> resFriends = null; using (var db = new ModelAC()) { var friends = db.IM_User.Where(p => p.App_Id == APP_GUID && p.UserId != ACCOUNT).OrderBy(p => p.Name); resFriends = friends.Select(p => new OFG_GetFriends { Account = p.UserId, Name = p.Name, Img = SITE_URL + p.PortraitUri }).ToList(); } return(CommonJson.camelObject(resFriends)); }
/// <summary> /// 会话-重置未读消息数 /// </summary> /// <returns></returns> public object Chatter_ResetUnreadMsg(IChatter_ResetUnreadMsg model) { var user = LOGIN_USER; IM_ChatterActor chatterActor = null; var db_result = 0; using (var db = new ModelAC()) { if (model.SessionType == IM_ChatType.Single) { var userB = db.IM_User.SingleOrDefault(p => p.App_Id == APP_GUID && p.UserId == model.ChatId); chatterActor = db.IM_ChatterActor .SingleOrDefault(p => p.App_Id == APP_GUID && p.IM_Chatter.ChatType == IM_ChatType.Single && p.UserId == user.Id && ((p.IM_Chatter.Single_A_UserId == user.Id && p.IM_Chatter.Single_B_UserId == userB.Id) || (p.IM_Chatter.Single_A_UserId == userB.Id && p.IM_Chatter.Single_B_UserId == user.Id))); chatterActor.UnreadMsgCount = 0; db_result = db.SaveChanges(); } else if (model.SessionType == IM_ChatType.Group) { var group = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == model.ChatId); chatterActor = db.IM_ChatterActor .SingleOrDefault(p => p.App_Id == APP_GUID && p.IM_Chatter.ChatType == IM_ChatType.Group && p.UserId == user.Id && p.IM_Chatter.Group_GroupId == group.Id); chatterActor.UnreadMsgCount = 0; db_result = db.SaveChanges(); } } if (db_result == 1) { var jsonResult = CommonJson.camelObject(new OChatter_ResetUnreadMsg { ChatId = model.ChatId, SessionId = chatterActor.ChatterId.ToString(), SessionType = model.SessionType, UnreadMsgCount = chatterActor.UnreadMsgCount }); return(jsonResult); } else { return(null); } }
/// <summary> /// 获取群组成员列表 /// </summary> /// <param name="groupId"></param> private List <OGM_GroupInfo> Get_GroupMembers(string groupId) { var resMembers = new List <OGM_GroupInfo>(); using (var db = new ModelAC()) { var group = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == groupId); resMembers = db.Im_UserGroup .Where(p => p.IM_Group_Id == group.Id) .Select(p => new OGM_GroupInfo { GroupPosition = p.GroupPosition, Account = p.IM_User.UserId, Name = p.IM_User.Name, Img = SITE_URL + p.IM_User.PortraitUri, }).ToList(); } return(resMembers); }
/// <summary> /// 获取群组集合 /// </summary> private IList <OFG_GetGroups> Base_GetGroups() { var user = LOGIN_USER; List <OFG_GetGroups> resGroups = null; using (var db = new ModelAC()) { resGroups = db.Im_UserGroup .Where(p => p.IM_User_Id == user.Id) .Select(p => new OFG_GetGroups { Id = p.IM_Group_Id.ToString(), GroupId = p.IM_Group.GroupId, GroupName = p.IM_Group.GroupName, GroupPosition = p.GroupPosition }).ToList(); } return(resGroups); }
/// <summary> /// 发送-图片消息 /// </summary> /// <returns></returns> public object Single_SendPicture(ISingle_SendText model) { var msg = new IM_MsgSingle(); var db_result = 0; using (var db = new ModelAC()) { #region db msg.App_Id = APP_GUID; msg.MsgClientId = model.MsgClientId; msg.From_UserId = db.IM_User.SingleOrDefault(p => p.App_Id == APP_GUID && p.UserId == model.From_UserId).Id; msg.To_UserId = db.IM_User.SingleOrDefault(p => p.App_Id == APP_GUID && p.UserId == model.To_UserId).Id; msg.MsgTime = DateTime.Now; msg.IsRead = false; msg.MsgType = model.MsgType; msg.MsgBody = model.MsgBody; db.IM_MsgSingle.Add(msg); db_result = db.SaveChanges(); #endregion } var session_result = Single_updateSession(msg); if (db_result == 1) { var mOSingle_SendText = new OSingle_SendText() { #region 输出 Id = msg.Id.ToString(), MsgClientId = msg.MsgClientId, From_UserId = model.From_UserId, To_UserId = model.To_UserId, MsgTime = msg.MsgTime, IsRead = msg.IsRead, MsgType = msg.MsgType, MsgBody = msg.MsgBody, #endregion }; var jsonResult = CommonJson.camelObject(mOSingle_SendText); #region 消息分发 string to__Account = HubKey.App__Account(app: APP, account: model.To_UserId); using (var db = new SignalR_MapUsersModel()) { var connections = db.Connections.Where(p => p.User_UserName == to__Account && p.Connected == true).ToList(); for (int i = 0; i < connections.Count(); i++) { Clients.Client(connections[i].ConnectionID).Single_SendPicture(jsonResult); } } #endregion return(jsonResult); } else { return(null); } }
/// <summary> /// 更新会话 /// 单聊 /// </summary> /// <param name="model"></param> /// <returns></returns> private bool Single_updateSession(IM_MsgSingle msg) { var user = LOGIN_USER; var db_result = 0; using (var db = new ModelAC()) { var session = db.IM_Chatter.SingleOrDefault(p => p.App_Id == APP_GUID && p.ChatType == IM_ChatType.Single && ((p.Single_A_UserId == msg.From_UserId && p.Single_B_UserId == msg.To_UserId) || (p.Single_A_UserId == msg.To_UserId && p.Single_B_UserId == msg.From_UserId)) ); if (session == null) { #region 新增会话 var newSession = new IM_Chatter() { App_Id = APP_GUID, ChatType = IM_ChatType.Single, Single_A_UserId = msg.From_UserId, Single_B_UserId = msg.To_UserId, Group_GroupId = null, }; newSession.IM_ChatterActors.Add(new IM_ChatterActor() {//消息发送者 App_Id = APP_GUID, ChatterId = newSession.Id, UserId = msg.From_UserId, Last_MsgId = msg.Id, UnreadMsgCount = 0, ChatterTime = DateTime.Now, IsCleared = false, }); newSession.IM_ChatterActors.Add(new IM_ChatterActor() {//消息接收者 App_Id = APP_GUID, ChatterId = newSession.Id, UserId = msg.To_UserId, Last_MsgId = msg.Id, UnreadMsgCount = 1, ChatterTime = DateTime.Now, IsCleared = false, }); db.IM_Chatter.Add(newSession); db_result = db.SaveChanges(); #endregion } else { #region 更新会话 foreach (var toActor in session.IM_ChatterActors) { toActor.Last_MsgId = msg.Id; if (toActor.UserId != user.Id) {//消息接收者 toActor.UnreadMsgCount += 1; } toActor.ChatterTime = DateTime.Now; } db_result = db.SaveChanges(); #endregion } } return(db_result > 0); }
/// <summary> /// 获取-群聊记录(分页) /// </summary> public object His_GroupHistory(IHis_GroupHistory model) { var user = LOGIN_USER; List <OGroup_SendText> db_Result = new List <OGroup_SendText>(); using (var db = new ModelAC()) { var group = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == model.ChatId); #region 数据查询 if (model.MsgId == null) {//获取最新5条消息 db_Result = db.IM_MsgGroup .Where(p => p.To_GroupId == group.Id) .OrderByDescending(p => p.SortId) .Take(5) .Select(p => new OGroup_SendText { #region 输出 Id = p.Id.ToString(), MsgClientId = p.MsgClientId, From_UserId = p.From_IM_User.UserId, //From_UserImg = SITE_URL + p.From_IM_User.PortraitUri, To_GroupId = group.GroupId, MsgTime = p.MsgTime, IsFullRead = p.IsFullRead, MsgType = p.MsgType, MsgBody = p.MsgBody, #endregion }) .ToList(); } else {//获取MsgId之前5条消息 var msg = db.IM_MsgGroup.SingleOrDefault(p => p.App_Id == APP_GUID && p.Id == model.MsgId); db_Result = db.IM_MsgGroup .Where(p => p.SortId < msg.SortId) .Where(p => p.To_GroupId == group.Id) .OrderByDescending(p => p.SortId) .Take(5) .Select(p => new OGroup_SendText { #region 输出 Id = p.Id.ToString(), MsgClientId = p.MsgClientId, From_UserId = p.From_IM_User.UserId, //From_UserImg = SITE_URL + p.From_IM_User.PortraitUri, To_GroupId = group.GroupId, MsgTime = p.MsgTime, IsFullRead = p.IsFullRead, MsgType = p.MsgType, MsgBody = p.MsgBody, #endregion }) .ToList(); } #endregion } var jsonResult = CommonJson.camelObject(db_Result); return(jsonResult); }
/// <summary> /// 更新会话 /// 群聊 /// </summary> /// <param name="model"></param> /// <returns></returns> private bool Group_updateSession(IM_MsgGroup msg) { var user = LOGIN_USER; //所有群聊成员 var allMembers = new List <Guid>(); var db_result = 0; using (var db = new ModelAC()) { allMembers = db.Im_UserGroup.Where(p => p.IM_Group_Id == msg.To_GroupId).Select(p => p.IM_User_Id).ToList(); var session = db.IM_Chatter.SingleOrDefault(p => p.App_Id == APP_GUID && p.ChatType == IM_ChatType.Group && p.Group_GroupId == msg.To_GroupId); if (session == null) { #region 新增会话 var newSession = new IM_Chatter() { App_Id = APP_GUID, ChatType = IM_ChatType.Group, Single_A_UserId = null, Single_B_UserId = null, Group_GroupId = msg.To_GroupId, }; newSession.IM_ChatterActors.Add(new IM_ChatterActor() {//消息发送者 App_Id = APP_GUID, ChatterId = newSession.Id, UserId = msg.From_UserId, Last_MsgId = msg.Id, UnreadMsgCount = 0, ChatterTime = DateTime.Now, IsCleared = false, }); allMembers.Remove(msg.From_UserId); foreach (var memeberId in allMembers) {//消息接收者 newSession.IM_ChatterActors.Add(new IM_ChatterActor() { App_Id = APP_GUID, ChatterId = newSession.Id, UserId = memeberId, Last_MsgId = msg.Id, UnreadMsgCount = 1, ChatterTime = DateTime.Now, IsCleared = false, }); } db.IM_Chatter.Add(newSession); db_result = db.SaveChanges(); #endregion } else { #region 更新会话 List <Guid> oldIM_ChatterActors = session.IM_ChatterActors.Select(p => p.UserId).ToList(); List <Guid> expectedList = allMembers.Except(oldIM_ChatterActors).ToList(); foreach (var toActor in session.IM_ChatterActors) {//更新会话参与者 toActor.Last_MsgId = msg.Id; if (toActor.UserId != user.Id) {//消息接收者 toActor.UnreadMsgCount += 1; } toActor.ChatterTime = DateTime.Now; } if (expectedList.Exists(p => p == msg.From_UserId)) {//新增会话参与者-消息发送者 expectedList.Remove(msg.From_UserId); session.IM_ChatterActors.Add(new IM_ChatterActor() { App_Id = APP_GUID, ChatterId = session.Id, UserId = msg.From_UserId, Last_MsgId = msg.Id, UnreadMsgCount = 0, ChatterTime = DateTime.Now, IsCleared = false, }); } foreach (var memeberId in expectedList) {//新增会话参与者-消息接收者 session.IM_ChatterActors.Add(new IM_ChatterActor() { App_Id = APP_GUID, ChatterId = session.Id, UserId = memeberId, Last_MsgId = msg.Id, UnreadMsgCount = 1, ChatterTime = DateTime.Now, IsCleared = false, }); } db_result = db.SaveChanges(); #endregion } } return(db_result > 0); }
public async Task <IHttpActionResult> vSessionByUser(Guid APP_GUID, Guid userId) { List <OChatter_ChatterInfo> db_Result = new List <OChatter_ChatterInfo>(); using (var db = new ModelAC()) { List <OChatter_ChatterInfo> sessions = new List <OChatter_ChatterInfo>(); #region 单聊会话 var single = db.IM_ChatterActor .Where(p => p.App_Id == APP_GUID && p.IM_Chatter.ChatType == IM_ChatType.Single && p.UserId == userId) .Select(p => new OChatter_ChatterInfo { ChatId = p.IM_Chatter.Single_A_UserId == userId ? p.IM_Chatter.Single_B_IM_User.UserId : p.IM_Chatter.Single_A_IM_User.UserId, ChatName = p.IM_Chatter.Single_A_UserId == userId ? p.IM_Chatter.Single_B_IM_User.Name : p.IM_Chatter.Single_A_IM_User.Name, ChatImg = string.Empty + p.IM_User.PortraitUri, SessionId = p.ChatterId.ToString(), SessionType = p.IM_Chatter.ChatType, UnreadMsgCount = p.UnreadMsgCount, ChatterTime = p.ChatterTime, Messages = new HashSet <object>() { db.IM_MsgSingle.Where(s => s.Id == p.Last_MsgId) .Select(m => new OSingle_SendText { Id = m.Id.ToString(), MsgClientId = m.MsgClientId, From_UserId = m.From_IM_User.UserId, To_UserId = m.To_IM_User.UserId, MsgTime = m.MsgTime, IsRead = m.IsRead, MsgType = m.MsgType, MsgBody = m.MsgBody, }).FirstOrDefault() }, }); #endregion #region 群聊会话 var group = db.IM_ChatterActor .Where(p => p.App_Id == APP_GUID && p.IM_Chatter.ChatType == IM_ChatType.Group && p.UserId == userId) .Select(p => new OChatter_ChatterInfo { ChatId = p.IM_Chatter.Group_IM_Group.GroupId, ChatName = p.IM_Chatter.Group_IM_Group.GroupName, ChatImg = null, SessionId = p.ChatterId.ToString(), SessionType = p.IM_Chatter.ChatType, UnreadMsgCount = p.UnreadMsgCount, ChatterTime = p.ChatterTime, Messages = new HashSet <object>() { db.IM_MsgSingle.Where(s => s.Id == p.Last_MsgId) .Select(m => new OSingle_SendText { Id = m.Id.ToString(), MsgClientId = m.MsgClientId, From_UserId = m.From_IM_User.UserId, To_UserId = m.To_IM_User.UserId, MsgTime = m.MsgTime, IsRead = m.IsRead, MsgType = m.MsgType, MsgBody = m.MsgBody, }).FirstOrDefault() }, }); #endregion sessions.AddRange(single); sessions.AddRange(group); db_Result = sessions.OrderByDescending(p => p.ChatterTime).ToList(); } var jsonResult = CommonJson.camelObject(db_Result); return(Ok(jsonResult)); }