public List <Chat> GetChatBySql(string sql)
{
using (SqlDataReader sdr = DBHelper.GetReader(sql))
{
List <Chat> list = new List <Chat>();
while (sdr.Read())
{
Chat chat = new Chat(sdr);
SqlVisitSessionProvider vs = new SqlVisitSessionProvider();
chat.Vs = vs.GetSessionById(chat.ChatId);
list.Add(chat);
}
return(list);
}
}
public List<Chat> GetChatBySql(string sql)
{
using (SqlDataReader sdr = DBHelper.GetReader(sql))
{
List<Chat> list = new List<Chat>();
while (sdr.Read())
{
Chat chat = new Chat(sdr);
SqlVisitSessionProvider vs = new SqlVisitSessionProvider();
chat.Vs = vs.GetSessionById(chat.ChatId);
list.Add(chat);
}
return list;
}
}