private MessageListModel GetUnreachedMessage(ReachedMessageList reachedMessageList) { MessageListModel messageList = new MessageListModel(); using (Controller.Message controllerMessage = new Controller.Message()) { List <MessageModel> recordList = controllerMessage.GetUserMessage(aid, Controller.Message.MESSAGE_STATUS.UNREACH); if (recordList != null) { foreach (MessageModel message in recordList) { if (reachedMessageList != null) { if (reachedMessageList.Contains((uint)message.mid)) { continue; } } messageList.Add(message); } } } return(messageList); }
private MessageListModel GetChatMessageHistory(uint UserID, uint TalkerID) { MessageListModel chatHistoryList = new MessageListModel(); List <MessageModel> messageList = new Controller.Message().GetMessageWithUser(UserID, TalkerID); if (messageList != null) { foreach (MessageModel message in messageList) { chatHistoryList.Add(message); } } return(chatHistoryList); }
public MessageListModel GetPosts(string username) { var posts = new MessageListModel(); try { using (var db = new OurDbContext()) { //int användarID = db.userAccount.Single(x => x.Username == username).ID; //var meddelanden = from m in db.Message // where m.ReceiverID == användarID // select m; //foreach(var m in meddelanden) //{ // var sender = m.Sender; // var text = m.Content; // posts.Add //} int userID = db.userAccount.FirstOrDefault(x => x.Username == username).ID; var result = from m in db.Message where m.ReceiverID == userID select m; foreach (var item in result) { var message = new MessageModel(); message.Content = item.Content; message.Sender = db.userAccount.FirstOrDefault(x => x.ID == item.SenderID).Username; posts.Add(message); } } return(posts); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }