public static List <MessageThreads> GetAllMsgThreads() { List <MessageThreads> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.MessageThreads_SelectAll" , inputParamMapper : null , map : delegate(IDataReader reader, short set) //function from BaseService { MessageThreads p = new MessageThreads(); int startingIndex = 0; //startingOrdinal p.Id = reader.GetSafeInt32(startingIndex++); p.ThreadTitle = reader.GetSafeString(startingIndex++); p.UserId = reader.GetSafeString(startingIndex++); p.CreatedDate = reader.GetSafeDateTime(startingIndex++); p.LastMessageDate = reader.GetSafeDateTime(startingIndex++); p.CommentCount = reader.GetSafeInt32(startingIndex++); p.ViewCount = reader.GetSafeInt32(startingIndex++); if (list == null) { list = new List <MessageThreads>(); } list.Add(p); } ); return(list); }
public HttpResponseMessage GetThreadById(int threadId) { //string senderId = UserService.GetCurrentUserId(); MessageThreads ThreadInfo = MessageThreadsService.getThreadById(threadId); ItemResponse <MessageThreads> response = new ItemResponse <MessageThreads>(); response.Item = ThreadInfo; return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public static List <MessageThreads> GetThreadsByGroupId(int GroupId, int pageNumber, int pageSize) { List <MessageThreads> list = null; //get message threads by groupId DataProvider.ExecuteCmd(GetConnection, "MessageThreads_JoinSearchByGroupId" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@GroupId", GroupId); paramCollection.AddWithValue("@CurrentPage", pageNumber); paramCollection.AddWithValue("@ItemsPerPage", pageSize); } , map : delegate(IDataReader reader, short set) { MessageThreads m = new MessageThreads(); int startingIndex = 0; //startingOrdinal m.Id = reader.GetSafeInt32(startingIndex++); m.ThreadTitle = reader.GetSafeString(startingIndex++); m.UserId = reader.GetSafeString(startingIndex++); m.CreatedDate = reader.GetSafeDateTime(startingIndex++); m.LastMessageDate = reader.GetSafeDateTime(startingIndex++); m.CommentCount = reader.GetSafeInt32(startingIndex++); m.ViewCount = reader.GetSafeInt32(startingIndex++); UserMini u = new UserMini(); u.profileName = reader.GetSafeString(startingIndex++); u.profileLastName = reader.GetSafeString(startingIndex++); u.UserId = reader.GetSafeString(startingIndex++); m.UserInfo = u; if (list == null) { list = new List <MessageThreads>(); } list.Add(m); } ); return(list); }
public static MessageThreads getThreadById(int ThreadId) { MessageThreads m = null; DataProvider.ExecuteCmd(GetConnection, "MessageThreads_JoinSelectThreadInfoById" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@ThreadId", ThreadId); } , map : delegate(IDataReader reader, short set) { m = new MessageThreads(); int startingIndex = 0; //startingOrdinal m.Id = reader.GetSafeInt32(startingIndex++); m.ThreadTitle = reader.GetSafeString(startingIndex++); m.UserId = reader.GetSafeString(startingIndex++); m.CreatedDate = reader.GetSafeDateTime(startingIndex++); m.LastMessageDate = reader.GetSafeDateTime(startingIndex++); m.CommentCount = reader.GetSafeInt32(startingIndex++); m.ViewCount = reader.GetSafeInt32(startingIndex++); UserMini u = new UserMini(); u.profileName = reader.GetSafeString(startingIndex++); u.profileLastName = reader.GetSafeString(startingIndex++); u.UserId = reader.GetSafeString(startingIndex++); m.UserInfo = u; Groups g = new Groups(); g.Id = reader.GetSafeInt32(startingIndex++); m.GroupInfo = g; } ); return(m); }
public IntercomClient(string appid, string apikey, Users users, Impressions impressions, MessageThreads messageThreads, Notes notes, Tags tags) { this.ApiKey = apikey; this.AppId = appid; this.Users = users; this.Impressions = impressions; this.MessageThreads = messageThreads; this.Notes = notes; this.Tags = tags; }