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); }