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;
}
