private void InitialiseSites()
{
_logger.Information("Initialising Sites");
IEnumerable <SitePOCO> sites = new List <SitePOCO>();
try
{
sites = new DatabaseHelper(_remoteAutoTaskDatabaseConnection).GetAllSites(_accountTypeId);
}
catch (Exception ex)
{
_logger.Error(ex, "Failed intialising Sites");
}
if (sites.Count() > 0)
{
_logger.Information($"{sites.Count()} Sites Found");
try
{
_logger.Information($"Uploading Sites");
IEnumerable <SiteModel> siteModels = from site in sites
select new SiteModel()
{
AccountName = site.account_name,
Address1 = site.address_1,
Address2 = site.address_2,
City = site.city,
Country = site.country,
DateCreated = site.create_time,
Id = site.account_id,
ParentAccountId = site.parent_account_id,
State = site.state,
ZipCode = site.zip_code
};
SiteDal dal = new SiteDal(_configuration, _logger);
dal.Truncate();
dal.BulkUpload(siteModels);
_logger.Information($"Completed Sites Bulk insert");
}
catch (Exception ex)
{
_logger.Error(ex, "Failed Bulk upload of sites");
}
}
}
