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);
        }
Beispiel #3
0
        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);
            }
        }