public static List<MessageWithRecipient> GetMessageByAccountID(Int64 AccountID, Int32 PageNumber, MessageFolders Folder) { var query = (from r in MessageRecipient.All() join m in Messages.All() on r.MessageID equals m.MessageID join a in Account.All() on m.SentByAccountID equals a.AccountID where r.AccountID == AccountID && r.MessageFolderID == (int)Folder orderby m.CreateDate descending select new { Sender = a, Message = m, MessageRecipient = r }).Skip((PageNumber - 1) * 10).Take(10); List<MessageWithRecipient> list = new List<MessageWithRecipient>(); foreach (var item in query) { MessageWithRecipient m = new MessageWithRecipient(); m.Sender = item.Sender; m.Message = item.Message; m.MessageRecipient = item.MessageRecipient; list.Add(m); } return list; }
public static MessageWithRecipient GetMessageByMessageID(Int32 MessageID, Int32 RecipientAccountID) { var message = (from r in MessageRecipient.All() join m in All() on r.MessageID equals m.MessageID join a in Account.All() on m.SentByAccountID equals a.AccountID where r.AccountID == RecipientAccountID && m.MessageID == MessageID where r.AccountID == RecipientAccountID && m.MessageID == MessageID select new { Sender = a, Message = m, MessageRecipient = r }).FirstOrDefault(); MessageWithRecipient mr = new MessageWithRecipient(); mr.Sender = message.Sender; mr.Message = message.Message; mr.MessageRecipient = message.MessageRecipient; return mr; }
public void LoadReply(MessageWithRecipient message) { txtSubject.Text = "RE: " + message.Message.Subject; txtTo.Text = message.Sender.Username; txtMessage.Value = "<BR><BR><HR>Gửi từ ngày: " + message.Message.CreateDate.ToString() + "<BR>Tiêu đề: " + message.Message.Subject + "<BR>Nội dung: " + message.Message.Body; }