public async Task <IActionResult> UserList([FromBody] dynamic payload)
{
string srchTxt = payload.searchText;
string userId = this.HttpContext.User.GetClaim(OpenIdConnectConstants.Claims.Subject);
var connectedPart = GroupChatHub.getConnectedParticpant(userId).FirstOrDefault();
var userList = (
from u in this._ctx.Users
where u.Id != userId
orderby u.Email
select new
{
DisplayName = u.Email,
UserId = u.Id,
ParticipantType = ChatParticipantTypeEnum.User,
Status = connectedPart == null ? EnumChatParticipantStatus.Offline : EnumChatParticipantStatus.Online,
Email = u.Email
}
);
return(Json(await userList.ToArrayAsync()));
}
public async Task <IActionResult> Participants([FromBody] dynamic payload)
{
string srchTxt = payload.searchText;
string userId = this.HttpContext.User.GetClaim(OpenIdConnectConstants.Claims.Subject);
string userEmail = this._ctx.Users.Find(userId).Email;
var msgListQuery = (from g in this._ctx.ChatGroups.Include(d => d.DateSeen).ThenInclude(d => d.User)
join p in this._ctx.Participants.Include(d => d.User) on g equals p.Group into arrPart
join ms in this._ctx.ChatMessages on g equals ms.ChatGroup into chatMessages
where g.ParticipantType == EnumChatGroupParticipantType.user &&
arrPart.Any(d => d.User.Id == userId)
select new {
Particpants = arrPart,
ChatGroup = g,
UnreadMessageCount = chatMessages
.Where(d => d.DateSent > g.DateSeen
.Where(s => s.User.Id == userId)
.Select(ds => ds.DateSeen)
.Max())
.Count()
}
);
Console.WriteLine(msgListQuery.ToString());
var msgList = await msgListQuery.ToArrayAsync();
var userList = await(
from u in this._ctx.Users
where !msgList.Any(d => d.Particpants.Any(p => p.User == u)) &&
u.Id != userId
select new { Id = u.Id, Email = u.Email, }
).ToArrayAsync();
List <ParticipantResponseViewModel> resp = new List <ParticipantResponseViewModel>();
foreach (var item in msgList)
{
var part = new ParticipantResponseViewModel();
part.Participants = new List <ChatParticipantViewModel>();
foreach (var p in item.Particpants.OrderBy(d => d.User.Id == userId))
{
var connectedPart = GroupChatHub.getConnectedParticpant(p.User.Id).FirstOrDefault();
part.Participants.Add(new ChatParticipantViewModel()
{
DisplayName = p.User.Email,
UserId = p.User.Id,
ParticipantType = ChatParticipantTypeEnum.User,
Status = connectedPart == null ? EnumChatParticipantStatus.Offline : EnumChatParticipantStatus.Online,
Email = p.User.Email
});
}
part.Metadata = new ParticipantMetadataViewModel()
{
TotalUnreadMessages = item.UnreadMessageCount,
Title = item.ChatGroup.Title,
GroupId = item.ChatGroup != null?item.ChatGroup.Id.ToString() : ""
};
resp.Add(part);
}
foreach (var user in userList)
{
var part = new ParticipantResponseViewModel();
part.Participants = new List <ChatParticipantViewModel>();
var connectedPart = GroupChatHub.getConnectedParticpant(user.Id).FirstOrDefault();
part.Participants.Add(new ChatParticipantViewModel()
{
DisplayName = user.Email,
UserId = user.Id,
ParticipantType = ChatParticipantTypeEnum.User,
Status = connectedPart == null ? EnumChatParticipantStatus.Offline : EnumChatParticipantStatus.Online,
Email = user.Email
});
part.Participants.Add(new ChatParticipantViewModel()
{
DisplayName = userEmail,
UserId = userId,
ParticipantType = ChatParticipantTypeEnum.User,
Status = EnumChatParticipantStatus.Online,
Email = userEmail
});
part.Metadata = new ParticipantMetadataViewModel()
{
TotalUnreadMessages = 0,
GroupId = "",
Title = part.Participants.First().DisplayName
};
resp.Add(part);
}
return(Json(resp.OrderBy(d => d.Participants.Any(p => p.Status == EnumChatParticipantStatus.Online)).ThenBy(d => d.Metadata.Title)));
}