Beispiel #1
0
        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();
                }
            }
        }
Beispiel #2
0
        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);
        }