public static MessageStatistics GetMessageStats(string userId)
{
var msgStats = new MessageStatistics();
using (var db = new ApplicationDbContext())
{
msgStats.TotalMessages = db.MessagesSent.Count(usr => usr.UserId.Equals(userId));
msgStats.UnreadMessages =
db.MessagesSent.Count(msg => msg.Status.Equals("UNREAD") && msg.UserId.Equals(userId));
msgStats.ReadMessages =
db.MessagesSent.Count(msg => msg.Status.Equals("READ") && msg.UserId.Equals(userId));
msgStats.RemovedMessages =
db.MessagesSent.Count(msg => msg.Status.Equals("REMOVED") && msg.UserId.Equals(userId));
}
return msgStats;
}
public static MessageStatistics GetMessageStats(string userId)
{
var msgStats = new MessageStatistics();
using (var db = new ApplicationDbContext())
{
msgStats.TotalMessages = db.MessagesSent.Count(usr => usr.UserId.Equals(userId));
msgStats.UnreadMessages =
db.MessagesSent.Count(msg => msg.Status.Equals("UNREAD") && msg.UserId.Equals(userId));
msgStats.ReadMessages =
db.MessagesSent.Count(msg => msg.Status.Equals("READ") && msg.UserId.Equals(userId));
msgStats.RemovedMessages =
db.MessagesSent.Count(msg => msg.Status.Equals("REMOVED") && msg.UserId.Equals(userId));
}
return(msgStats);
}
