private static void SyncSitesToIDE_and_Portal(CimscoNZEntities _masterDataContext)
{
using (CimscoIDE_dbEntities _ideDataContext = new CimscoIDE_dbEntities())
using (CimscoPortalEntities _portalDataContext = new CimscoPortalEntities())
{
//var _sourceSiteIdList = _sourceSites.Select(s => s.SiteId).ToList();
using (var _transaction1 = _ideDataContext.Database.BeginTransaction())
using (var _transaction2 = _portalDataContext.Database.BeginTransaction())
{
var _alreadyInTarget1 = (from _targetIds in _ideDataContext.sSites
select _targetIds.SiteId).ToList();
var _alreadyInTarget2 = (from _targetIds in _portalDataContext.Sites
select _targetIds.SiteId).ToList();
var _sourceMasterData = (from _sourceRecords in _masterDataContext.Sites
select _sourceRecords.SiteId).ToList();
_ideDataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sites] ON");
_portalDataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sites] ON");
foreach (int _id in _sourceMasterData)
{
sSite _newRecord1 = _masterDataContext.Sites.Where(s => s.SiteId == _id).ProjectTo<sSite>().FirstOrDefault();
if (_alreadyInTarget1.Contains(_id))
{
var _targetRecord = _ideDataContext.sSites.Where(s => s.SiteId == _id).FirstOrDefault();
_ideDataContext.Entry(_targetRecord).CurrentValues.SetValues(_newRecord1);
_ideDataContext.SaveChanges();
}
else
{
_ideDataContext.sSites.Add(_newRecord1);
_ideDataContext.SaveChanges();
}
InvoiceDataUpload.DataTarget.Site _newRecord2 = _masterDataContext.Sites.Where(s => s.SiteId == _id).ProjectTo<InvoiceDataUpload.DataTarget.Site>().FirstOrDefault();
if (_alreadyInTarget2.Contains(_id))
{
var _targetRecord = _portalDataContext.Sites.Where(s => s.SiteId == _id).FirstOrDefault();
_portalDataContext.Entry(_targetRecord).CurrentValues.SetValues(_newRecord2);
_portalDataContext.SaveChanges();
}
else
{
_portalDataContext.Sites.Add(_newRecord2);
_portalDataContext.SaveChanges();
}
}
_ideDataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sites] OFF");
_portalDataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sites] OFF");
_transaction1.Commit();
_transaction2.Commit();
}
}
}
private static void SyncMasterData(TextWriter log)
{
using (CimscoNZEntities _masterDataContext = new CimscoNZEntities())
{
SyncSitesToIDE_and_Portal(_masterDataContext);
SyncGroupsToIDE_and_Portal(_masterDataContext);
SyncCustomersToIDE_and_Portal(_masterDataContext);
SyncEnergyPointsToIDE_and_Portal(_masterDataContext);
log.Write(SyncEnergySuppliersToIDE_and_Portal(_masterDataContext));
//List<CustomerGroupSiteModel> _siteCustomerGroupHierachy = new List<CustomerGroupSiteModel>();
//_siteCustomerGroupHierachy = _masterDataContext.Sites.ProjectTo<CustomerGroupSiteModel>().ToList();
}
}
private static void RemoveDeletedSitesFromIDE_and_Portal(CimscoNZEntities _masterDataContext)
{
using (CimscoIDE_dbEntities _ideDataContext = new CimscoIDE_dbEntities())
using (CimscoPortalEntities _portalDataContext = new CimscoPortalEntities())
{
using (var transaction1 = _portalDataContext.Database.BeginTransaction())
using (var transaction2 = _ideDataContext.Database.BeginTransaction())
{
var _recordsInSource = (from _targetIds in _masterDataContext.Sites
select _targetIds.SiteId).ToList();
var _deleteFromTarget1 = (from _sourceRecords in _portalDataContext.Sites
where !_recordsInSource.Contains(_sourceRecords.SiteId)
select _sourceRecords.SiteId).ToList();
var _deleteFromTarget2 = (from _sourceRecords in _ideDataContext.sSites
where !_recordsInSource.Contains(_sourceRecords.SiteId)
select _sourceRecords.SiteId).ToList();
if (_deleteFromTarget1.Count != _deleteFromTarget2.Count)
{
// Log event, as these should match
}
if (_deleteFromTarget1.Count > 0)
{
foreach (int _id in _deleteFromTarget1)
{
var _removeRecord = new InvoiceDataUpload.DataTarget.Site { SiteId = _id };
_portalDataContext.Sites.Attach(_removeRecord);
_portalDataContext.Sites.Remove(_removeRecord);
}
_portalDataContext.SaveChanges();
}
if (_deleteFromTarget2.Count > 0)
{
foreach (int _id in _deleteFromTarget2)
{
var _removeRecord = new sSite { SiteId = _id };
_ideDataContext.sSites.Attach(_removeRecord);
_ideDataContext.sSites.Remove(_removeRecord);
}
_ideDataContext.SaveChanges();
}
transaction1.Commit();
transaction2.Commit();
}
}
}
private static string SyncEnergySuppliersToIDE_and_Portal(CimscoNZEntities _masterDataContext)
{
int _updates = 0;
int _adds = 0;
string _dataType = "Energy Suppliers";
using (CimscoIDE_dbEntities _ideDataContext = new CimscoIDE_dbEntities())
using (CimscoPortalEntities _portalDataContext = new CimscoPortalEntities())
{
//var _sourceSiteIdList = _sourceSites.Select(s => s.SiteId).ToList();
using (var _transaction1 = _ideDataContext.Database.BeginTransaction())
using (var _transaction2 = _portalDataContext.Database.BeginTransaction())
{
var _alreadyInTarget1 = (from _targetIds in _ideDataContext.sEnergySuppliers
select _targetIds.SupplierId).ToList();
var _alreadyInTarget2 = (from _targetIds in _portalDataContext.EnergySuppliers
select _targetIds.SupplierId).ToList();
var _sourceMasterData = (from _sourceRecords in _masterDataContext.EnergySuppliers
select _sourceRecords.SupplierId).ToList();
_ideDataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[EnergySuppliers] ON");
_portalDataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[EnergySuppliers] ON");
foreach (int _id in _sourceMasterData)
{
sEnergySupplier _newRecord1 = _masterDataContext.EnergySuppliers.Where(s => s.SupplierId == _id).ProjectTo<sEnergySupplier>().FirstOrDefault();
if (_alreadyInTarget1.Contains(_id))
{
var _targetRecord = _ideDataContext.sEnergySuppliers.Where(s => s.SupplierId == _id).FirstOrDefault();
_ideDataContext.Entry(_targetRecord).CurrentValues.SetValues(_newRecord1);
_ideDataContext.SaveChanges();
_updates++;
}
else
{
_ideDataContext.sEnergySuppliers.Add(_newRecord1);
_ideDataContext.SaveChanges();
_adds++;
}
InvoiceDataUpload.DataTarget.EnergySupplier _newRecord2 = _masterDataContext.EnergySuppliers.Where(s => s.SupplierId == _id).ProjectTo<InvoiceDataUpload.DataTarget.EnergySupplier>().FirstOrDefault();
if (_alreadyInTarget2.Contains(_id))
{
var _targetRecord = _portalDataContext.EnergySuppliers.Where(s => s.SupplierId == _id).FirstOrDefault();
_portalDataContext.Entry(_targetRecord).CurrentValues.SetValues(_newRecord2);
_portalDataContext.SaveChanges();
_updates++;
}
else
{
_portalDataContext.EnergySuppliers.Add(_newRecord2);
_portalDataContext.SaveChanges();
_adds++;
}
}
_ideDataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[EnergySuppliers] OFF");
_portalDataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[EnergySuppliers] OFF");
_transaction1.Commit();
_transaction2.Commit();
}
}
return String.Format("{2}: Additions : {0}, Updates : {1}", _adds.ToString(), _updates.ToString(), _dataType);
}
private static void RemoveDeletedMasterData(TextWriter log)
{
using (CimscoNZEntities _masterDataContext = new CimscoNZEntities())
{
RemoveDeletedSitesFromIDE_and_Portal(_masterDataContext);
RemoveDeletedGroupsFromIDE_and_Portal(_masterDataContext);
RemoveDeletedCustomersFromIDE_and_Portal(_masterDataContext);
RemoveDeletedEnergyPointsFromIDE_and_Portal(_masterDataContext);
RemoveDeletedEnergySuppliersFromIDE_and_Portal(_masterDataContext);
}
}
