private List<ThreadEntryIPAddress> GetThreadEntryIPAddresses()
{
var listThreadEntryIPAddresses = new List<ThreadEntryIPAddress>();
using (IDnaDataReader reader = StoredProcedureReader.Create("", ConnectionString))
{
reader.ExecuteWithinATransaction(@"select * from ThreadEntriesIPAddress order by entryid");
while (reader.Read())
{
var ipInfo = new ThreadEntryIPAddress();
ipInfo.entryId = reader.GetInt32("EntryId");
ipInfo.ipAddress = reader.GetString("ipAddress");
ipInfo.bbcuid = reader.GetGuidAsStringOrEmpty("BBCUID");
listThreadEntryIPAddresses.Add(ipInfo);
}
return listThreadEntryIPAddresses;
}
}
private ThreadEntryIPAddress GetThreadEntryIPAddressInfo(int entryId)
{
using (IDnaDataReader reader = StoredProcedureReader.Create("", ConnectionString))
{
reader.ExecuteWithinATransaction(@"select * from ThreadEntriesIPAddress where entryid=" + entryId);
reader.Read();
var ipInfo = new ThreadEntryIPAddress();
ipInfo.entryId = reader.GetInt32("EntryId");
ipInfo.ipAddress = reader.GetString("ipAddress");
ipInfo.bbcuid = reader.GetGuidAsStringOrEmpty("BBCUID");
return ipInfo;
}
}
