// GET: Conversation
public ActionResult Index(string sortType)
{
if (TempData.ContainsKey("message"))
{
ViewBag.message = TempData["message"].ToString();
}
if (sortType == null)
{
sortType = "Received";
}
var currentUser = User.Identity.GetUserId();
if (currentUser == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
if (sortType == "Received")
{
/*var conversations = from conv in _db.Conversations.Include("Product").Include("Sender")
* where conv.Product.UserId == currentUser
* select conv;
* var conversations = from conv in _db.Conversations.Include("Product").Include("Sender")
* where conv.Product.UserId == currentUser
* select conv;
* ViewBag.conversations = conversations;
*
* var latestMessages = new List<Message>();
* foreach (var conv in conversations)
* {
* var message = (from mess in _db.Messages.Include("Sender").Include("Receiver")
* where mess.ConversationId == conv.ConversationId
* orderby mess.Date descending
* select mess).First();
* latestMessages.Add(message);
* }*/
var conversations = (from c in _db.Conversations.Include("Product").Include("Sender")
join m in _db.Messages.Include("Sender").Include("User")
on c.ConversationId equals m.ConversationId
where c.Product.UserId == currentUser
select new { c, m } into x
group x by new { x.c } into g
select new
{ Conversation = g.Key.c,
Message = g.Select(x => x.m).Where(y => y.ConversationId == g.Key.c.ConversationId).OrderByDescending(m => m.Date),
MessageDate = g.Select(x => x.m).Max(x => x.Date) }).OrderByDescending(y => y.MessageDate);
var conversationsMes = new List <ConversationMessage>();
foreach (var conversation in conversations)
{
var convMes = new ConversationMessage {
Conversation = conversation.Conversation,
LatestMessage = conversation.Message.Where(m => m.ConversationId == conversation.Conversation.ConversationId).First()
};
convMes.LatestMessage.Content = MessageController.Decrypt(convMes.LatestMessage.Content);
conversationsMes.Add(convMes);
}
var model = new ConversationViewModel {
Conversations = conversationsMes
};
return(View(model));
}
else
if (sortType == "Sent")
{
/*var conversations = from conv in _db.Conversations.Include("Product").Include("Sender")
* where conv.SenderId == currentUser
* select conv;
* ViewBag.conversations = conversations;
*
* var latestMessages = new List<Message>();
* foreach (var conv in conversations)
* {
* var message = (from mess in _db.Messages.Include("Sender").Include("Receiver")
* where mess.ConversationId == conv.ConversationId
* orderby mess.Date descending
* select mess).First();
* latestMessages.Add(message);
* }*/
var conversations = (from c in _db.Conversations.Include("Product").Include("Sender")
join m in _db.Messages.Include("Sender").Include("User")
on c.ConversationId equals m.ConversationId
where c.SenderId == currentUser
select new { c, m } into x
group x by new { x.c } into g
select new
{
Conversation = g.Key.c,
Message = g.Select(x => x.m).Where(y => y.ConversationId == g.Key.c.ConversationId).OrderByDescending(m => m.Date),
MessageDate = g.Select(x => x.m).Max(x => x.Date)
}).OrderByDescending(y => y.MessageDate);
var conversationsMes = new List <ConversationMessage>();
foreach (var conversation in conversations)
{
var convMes = new ConversationMessage
{
Conversation = conversation.Conversation,
LatestMessage = conversation.Message.Where(m => m.ConversationId == conversation.Conversation.ConversationId).First()
};
convMes.LatestMessage.Content = MessageController.Decrypt(convMes.LatestMessage.Content);
conversationsMes.Add(convMes);
}
var model = new ConversationViewModel {
Conversations = conversationsMes
};
return(View(model));
}
return(View());
}
}
public ActionResult Show(int id)
{
if (TempData.ContainsKey("message"))
{
ViewBag.message = TempData["message"].ToString();
}
var currentUser = User.Identity.GetUserId();
ViewBag.CurrentUser = currentUser;
Conversation conversation = _db.Conversations.Find(id);
var messages = from msg in _db.Messages.Include("Sender").Include("Receiver")
where msg.ConversationId == id
orderby msg.Date
select msg;
if ((conversation.Product.UserId == currentUser) || (conversation.SenderId == currentUser))
{
var readMessages = messages.Where(m => (m.ReceiverId == currentUser) && (m.Read == false)).ToList();
if (readMessages.Count() > 0)
{
foreach (var messageRead in readMessages)
{
messageRead.Read = true;
}
/*foreach (var message in messages)
* _db.Entry(message).Property(x => x.Content).IsModified = false;*/
_db.SaveChanges();
}
}
foreach (var message in messages)
{
message.Content = MessageController.Decrypt(message.Content);
//_db.Entry(message).Property(x => x.Content).IsModified = false;
}
;
var model = new MessageViewModel
{
ConversationId = conversation.ConversationId,
ProductId = conversation.ProductId,
Product = conversation.Product,
SenderId = conversation.SenderId,
Sender = conversation.Sender,
Messages = messages.ToList()
};
if ((conversation.Product.UserId == currentUser) || (conversation.SenderId == currentUser))
{
return(View(model));
}
else
{
return(RedirectToAction("Index"));
}
}