public IEnumerable<Member> GetAlltimeChatMembers(Chat chat)
{
IEnumerable<string> participants = new List<string>();
participants = participants.Union(chat.Participants.Split(' '));
participants = participants.Union(chat.ActiveMembers.Split(' '));
participants = participants.Union(chat.Posters.Split(' '));
var members = LoadMembers(participants);
return members;
}
public IEnumerable <Member> GetAlltimeChatMembers(Chat chat)
{
IEnumerable <string> participants = new List <string>();
participants = participants.Union(chat.Participants.Split(' '));
participants = participants.Union(chat.ActiveMembers.Split(' '));
participants = participants.Union(chat.Posters.Split(' '));
var members = LoadMembers(participants);
return(members);
}
public IEnumerable<Member> GetCurrentChatMembers(Chat chat)
{
var members = ExecuteReaderItems<Member>("SELECT * FROM ChatMembers Where chatname = @name",
(reader, member) =>
{
member.Name = reader.GetObject<string>("identity");
},
new[] {CreateParameter("@name", chat.Name)});
members = LoadMembers(members.Select(m => m.Name));
return members;
}
public IEnumerable <Member> GetCurrentChatMembers(Chat chat)
{
var members = ExecuteReaderItems <Member>("SELECT * FROM ChatMembers Where chatname = @name",
(reader, member) =>
{
member.Name = reader.GetObject <string>("identity");
},
new[] { CreateParameter("@name", chat.Name) });
members = LoadMembers(members.Select(m => m.Name));
return(members);
}
private void Fill(DbDataReader reader, Chat chat)
{
chat.Name = reader.GetObject<string>("name") ?? "";
chat.Id = reader.GetValueObject<long>("id");
chat.Topic =
reader.GetObject<string>("topic") ?? "";
chat.FriendlyName =
reader.GetObject<string>("friendlyname") ?? "";
chat.Posters =
reader.GetObject<string>("posters") ?? "";
chat.Participants =
reader.GetObject<string>("participants") ?? "";
chat.Adder = reader.GetObject<string>("adder");
chat.Picture = reader.GetObject<byte[]>("picture");
chat.ActiveMembers =
reader.GetObject<string>(
"activemembers") ?? "";
var timestamp =
reader.GetValueObject<long>(
"last_change");
chat.LastChange = DateUtils.ConvertFromLinuxStamp(timestamp);
}
private void Fill(DbDataReader reader, Chat chat)
{
chat.Name = reader.GetObject <string>("name") ?? "";
chat.Id = reader.GetValueObject <long>("id");
chat.Topic =
reader.GetObject <string>("topic") ?? "";
chat.FriendlyName =
reader.GetObject <string>("friendlyname") ?? "";
chat.Posters =
reader.GetObject <string>("posters") ?? "";
chat.Participants =
reader.GetObject <string>("participants") ?? "";
chat.Adder = reader.GetObject <string>("adder");
chat.Picture = reader.GetObject <byte[]>("picture");
chat.ActiveMembers =
reader.GetObject <string>(
"activemembers") ?? "";
var timestamp =
reader.GetValueObject <long>(
"last_change");
chat.LastChange = DateUtils.ConvertFromLinuxStamp(timestamp);
}
public IEnumerable <Message> GetMessages(Chat chat)
{
var query = string.Format("SELECT * FROM Messages WHERE chatname = '{0}'", chat.Name);
return(ExecuteReaderItems <Message>(query, Fill));
}
public IEnumerable<Message> GetMessages(Chat chat)
{
var query = string.Format("SELECT * FROM Messages WHERE chatname = '{0}'", chat.Name);
return ExecuteReaderItems<Message>(query, Fill);
}
