public async Task AddHost(
Guid siteId,
string hostName,
CancellationToken cancellationToken = default(CancellationToken))
{
if (siteId == Guid.Empty) throw new ArgumentException("siteId must not be empty guid");
var host = new SiteHost();
host.SiteId = siteId;
host.HostName = hostName;
dbContext.SiteHosts.Add(host);
int rowsAffected = await dbContext.SaveChangesAsync(cancellationToken)
.ConfigureAwait(false);
}
public async Task<List<ISiteHost>> GetSiteHosts(int siteId)
{
List<ISiteHost> hosts = new List<ISiteHost>();
using (DbDataReader reader = await dbSiteSettings.GetHostList(siteId))
{
while (reader.Read())
{
SiteHost host = new SiteHost();
host.LoadFromReader(reader);
hosts.Add(host);
}
}
return hosts;
}
public async Task<ISiteHost> GetSiteHost(string hostName)
{
using (DbDataReader reader = await dbSiteSettings.GetHost(hostName))
{
while (reader.Read())
{
SiteHost host = new SiteHost();
host.LoadFromReader(reader);
return host;
}
}
return null;
}
public List<ISiteHost> GetAllHostsNonAsync()
{
List<ISiteHost> hosts = new List<ISiteHost>();
using (DbDataReader reader = dbSiteSettings.GetAllHostsNonAsync())
{
while (reader.Read())
{
SiteHost host = new SiteHost();
host.LoadFromReader(reader);
hosts.Add(host);
}
}
return hosts;
}
public async Task<List<ISiteHost>> GetPageHosts(
int pageNumber,
int pageSize)
{
List<ISiteHost> hosts = new List<ISiteHost>();
using (DbDataReader reader = await dbSiteSettings.GetPageHosts(pageNumber, pageSize))
{
while (reader.Read())
{
SiteHost host = new SiteHost();
host.LoadFromReader(reader);
hosts.Add(host);
}
}
return hosts;
}
public async Task<ISiteHost> GetSiteHost(string hostName, CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
using (DbDataReader reader = dbSiteSettings.GetHost(hostName))
{
while (reader.Read())
{
SiteHost host = new SiteHost();
host.LoadFromReader(reader);
return host;
}
}
return null;
}
public async Task<List<ISiteHost>> GetSiteHosts(int siteId, CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
List<ISiteHost> hosts = new List<ISiteHost>();
using (DbDataReader reader = dbSiteSettings.GetHostList(siteId))
{
while (reader.Read())
{
SiteHost host = new SiteHost();
host.LoadFromReader(reader);
hosts.Add(host);
}
}
return hosts;
}
public async Task<List<ISiteHost>> GetPageHosts(
int pageNumber,
int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
List<ISiteHost> hosts = new List<ISiteHost>();
using (DbDataReader reader = await dbSiteSettings.GetPageHosts(
pageNumber,
pageSize,
cancellationToken))
{
while (reader.Read())
{
SiteHost host = new SiteHost();
host.LoadFromReader(reader);
hosts.Add(host);
}
}
return hosts;
}
public async Task AddHost(
Guid siteId,
string hostName,
CancellationToken cancellationToken = default(CancellationToken))
{
if (siteId == Guid.Empty) throw new ArgumentException("siteId must not be empty guid");
if (string.IsNullOrEmpty(hostName)) throw new ArgumentException("hostName must be provided");
ThrowIfDisposed();
cancellationToken.ThrowIfCancellationRequested();
//await EnsureProjectId().ConfigureAwait(false);
var projectId = siteId.ToString();
var host = new SiteHost();
host.SiteId = siteId;
host.HostName = hostName;
await hostCommands.CreateAsync(
projectId,
host.Id.ToString(),
host,
cancellationToken).ConfigureAwait(false);
}
public async Task<bool> AddHost(
Guid siteGuid,
int siteId,
string hostName,
CancellationToken cancellationToken = default(CancellationToken))
{
SiteHost host = new SiteHost();
host.SiteGuid = siteGuid;
host.SiteId = siteId;
host.HostName = hostName;
dbContext.SiteHosts.Add(host);
int rowsAffected = await dbContext.SaveChangesAsync(cancellationToken);
return rowsAffected > 0;
}
