Esempio n. 1
0
        public static List <Message> GetOutbox(Guid userId, int?groupID, DateTime?dateSentFrom, DateTime?dateSentTo, bool?flagged, bool?isRead, string generalSearchParam, string toUserName, string subject, string message, int?pageNum, int?pageSize, string sortAttr, string sortDir, out int numberMessages, SiteContext siteContext)
        {
            List <Message> listMsg = new List <Message>();

            int?NumberMessages        = null;
            CSBooster_DataContext wdc = new CSBooster_DataContext(ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString);
            var results = wdc.hisp_UserMessages_GetMessagesUserOutbox(userId, groupID, dateSentFrom, dateSentTo, flagged, isRead, "%" + toUserName + "%", "%" + subject + "%", "%" + message + "%", "%" + generalSearchParam + "%", pageNum ?? 1, pageSize ?? 10, sortAttr, sortDir, ref NumberMessages);

            foreach (MessageResult result in results)
            {
                Message newMessage = new Message(siteContext);
                Message.FillMessage(newMessage, result);
                listMsg.Add(newMessage);
            }

            numberMessages = NumberMessages.Value;

            return(listMsg);
        }