/// <summary>
/// Get UnRead Messages
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static List <Message> GetUnReadMessages(string userId)
{
var messageReadStates = MessageReadStateService
.Query(x => x.UserID == userId && !x.ReadDate.HasValue)
.Include(x => x.Message)
.Include(x => x.Message.AspNetUser)
.Select();
var messages = messageReadStates
.OrderByDescending(x => x.Created)
.Select(x => x.Message)
.ToList();
return(messages);
}
/// <summary>
/// Send Message
/// </summary>
/// <param name="userFrom"></param>
/// <param name="userTo"></param>
/// <param name="subject"></param>
/// <param name="body"></param>
/// <returns></returns>
public static async Task SendMessage(MessageSendModel messageModel)
{
var unitOfWork = ContainerManager.GetConfiguredContainer().Resolve <IUnitOfWorkAsync>();
MessageThread messageThread;
// Use message subject to find the message thread if no listing id is provided
if (!messageModel.ListingID.HasValue)
{
var messageThreadQuery = await MessageThreadService
.Query(x =>
x.Subject.Equals(messageModel.Subject, StringComparison.InvariantCultureIgnoreCase) &&
x.MessageParticipants.Any(y => y.UserID == messageModel.UserFrom) &&
x.MessageParticipants.Any(y => y.UserID == messageModel.UserTo))
.SelectAsync();
messageThread = messageThreadQuery.FirstOrDefault();
}
else
{
// Otherwise, use listing ID
var messageThreadQuery = await MessageThreadService
.Query(x => x.ListingID == messageModel.ListingID)
.SelectAsync();
messageThread = messageThreadQuery.FirstOrDefault();
}
// Create message thread if there is not one yet.
if (messageThread == null)
{
messageThread = new MessageThread()
{
Subject = messageModel.Subject,
ListingID = messageModel.ListingID,
Created = DateTime.Now,
LastUpdated = DateTime.Now,
ObjectState = Repository.Pattern.Infrastructure.ObjectState.Added
};
MessageThreadService.Insert(messageThread);
await UnitOfWorkAsync.SaveChangesAsync();
// Add message participants
MessageParticipantService.Insert(new MessageParticipant()
{
UserID = messageModel.UserFrom,
MessageThreadID = messageThread.ID,
ObjectState = Repository.Pattern.Infrastructure.ObjectState.Added
});
MessageParticipantService.Insert(new MessageParticipant()
{
UserID = messageModel.UserTo,
MessageThreadID = messageThread.ID,
ObjectState = Repository.Pattern.Infrastructure.ObjectState.Added
});
}
// Insert mail message to db
var message = new Message()
{
UserFrom = messageModel.UserFrom,
Body = messageModel.Body,
MessageThreadID = messageThread.ID,
Created = DateTime.Now,
LastUpdated = DateTime.Now,
ObjectState = Repository.Pattern.Infrastructure.ObjectState.Added
};
MessageService.Insert(message);
await UnitOfWorkAsync.SaveChangesAsync();
// Add read state of messages
MessageReadStateService.Insert(new MessageReadState()
{
MessageID = message.ID,
UserID = messageModel.UserFrom,
ReadDate = DateTime.Now,
ObjectState = Repository.Pattern.Infrastructure.ObjectState.Added
});
MessageReadStateService.Insert(new MessageReadState()
{
MessageID = message.ID,
UserID = messageModel.UserTo,
ReadDate = null,
ObjectState = Repository.Pattern.Infrastructure.ObjectState.Added
});
await UnitOfWorkAsync.SaveChangesAsync();
}