public List <Conversation> GetConversations() { BlueServiceDataContext dc = new Models.BlueServiceDataContext(); var data = dc.Conversations.Where(c => c.User1Id == this.Id || c.User2Id == this.Id).OrderByDescending(c => c.Date).ToList(); foreach (var item in data) { if (item.User2Id == this.Id) { item.User2 = dc.Users.SingleOrDefault(u => u.Id == item.User1Id); } else { item.User2 = dc.Users.SingleOrDefault(u => u.Id == item.User2Id); } } return(data); }
public List <Product> GetFavoriteProducts() { BlueServiceDataContext dc = new Models.BlueServiceDataContext(); return(dc.UserFavoriteProducts.Where(u => u.User.Id == this.Id).Select(u => u.Product).ToList()); }