/// <summary> /// Get from database all conversation related of the user /// </summary> private void BindData() { var listMessagesFrom = MessageComponent.GetMessagesFrom(UserInfo.UserID).ToList(); var usersTo = (from s in listMessagesFrom select s.ToUserId).Distinct(); var listMessagesTo = MessageComponent.GetMessagesTo(UserInfo.UserID).ToList(); var usersFrom = (from s in listMessagesTo select s.FromUserId).Distinct(); var ListUsersConversations = usersFrom.Concat(usersTo).Distinct(); List <UserProperty> list = new List <UserProperty>(); foreach (int id in ListUsersConversations) { UserPropertyComponent userProperty = new UserPropertyComponent(id); list.Add(userProperty.UserProperty); } if (list.Count <= 0) { noMessageContainer.Visible = true; } else { noMessageContainer.Visible = false; } rpConversations.DataSource = list; rpConversations.DataBind(); }
public List <MessageModel> GetListTo(int rows = 10, int page = 0) { try { var portal = PortalController.GetCurrentPortalSettings(); var currentUser = DotNetNuke.Entities.Users.UserController.GetCurrentUserInfo(); if (currentUser.IsInRole("Registered Users")) { var result = MessageComponent.GetMessagesTo(currentUser.UserID).OrderByDescending(p => p.DateCreated); var totalCount = result.Count(); var totalPages = (int)Math.Ceiling((double)totalCount / rows); var prevLink = page > 0 ? string.Format("/messages/GetListTo?rows={0}&page={1}", rows, page - 1) : ""; var nextLink = page < totalPages - 1 ? string.Format("/messages/GetListTo?rows={0}&page={1}", rows, page + 1) : ""; List <MessageModel> messagesModel = new List <MessageModel>(); foreach (var resultTmp in result.Skip(rows * page).Take(rows).ToList()) { messagesModel.Add(new MessageModel() { MessageId = resultTmp.MessageId, Message = resultTmp.Message1, FromUserId = Convert.ToInt32(resultTmp.FromUserId), ToUserId = Convert.ToInt32(resultTmp.ToUserId), CreatedDate = Convert.ToDateTime(resultTmp.DateCreated), DateRead = Convert.ToDateTime(resultTmp.DateRead) }); } var paginationHeader = new { TotalCount = totalCount, TotalPages = totalPages, PrevPageLink = prevLink, NextPageLink = nextLink }; System.Web.HttpContext.Current.Response.Headers.Add("X-Pagination", Newtonsoft.Json.JsonConvert.SerializeObject(paginationHeader)); return(messagesModel); } throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Unauthorized)); } catch (HttpResponseException e) { throw e; } catch (Exception ee) { DotNetNuke.Services.Exceptions.Exceptions.LogException(ee); throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError)); } }