Ejemplo n.º 1
0
        public void Migrate()
        {
            try
            {
                _logger.LogInformation("################# Migration of Consumers");
                _sugarDataContext.Database.SetCommandTimeout(600);

                var idsOld             = _repository.Query <MfeUserIds>().Select(x => x.Id).ToList();
                var consumersFromSugar = _sugarDataContext.Query <CConsumers>().OrderByDescending(x => x.DateModified)
                                         .Where(x => idsOld.Contains(x.Id)).AsNoTracking().ToList();
                var sugarGolferProfileAll = _sugarDataContext.Query <CConsumersCstm>()
                                            .Where(x => idsOld.Contains(x.IdC)).AsNoTracking().ToList();
                var countFromSugar = consumersFromSugar.Count();

                var loopCount = countFromSugar / _splitCount;

                _logger.LogInformation("#################Starting Migration of Consumers");
                _logger.LogInformation($"Found {countFromSugar} to migrate");
                var systemId = getSystemId();
                var regionId = _repository.Query <Region>().FirstOrDefault(y => y.Code == "USA").Id.Value;
                for (var x = 0; x < loopCount; x++)
                {
                    var skip = _startCount + (x * _splitCount);
                    if (skip > countFromSugar)
                    {
                        break;
                    }
                    _logger.LogInformation($"Starting segment starting at {skip}");

                    _repository.ReloadContext();
                    _repository.GetDatabase().ChangeTracker.AutoDetectChangesEnabled = false;
                    var sugarItems = consumersFromSugar.Skip(skip).Take(_splitCount).ToList();

                    foreach (var sItem in sugarItems)
                    {
                        if (string.IsNullOrWhiteSpace(sItem.Email))
                        {
                            continue;
                        }


                        var exists = _repository.Query <ConsumerData.Models.Consumer>().Any(y => y.PrimaryEmail.ToLower().Trim() == sItem.Email.ToLower().Trim());

                        if (exists)
                        {
                            continue;
                        }

                        emailsSaved.Add(sItem.Email);

                        var cdmItem = new ConsumerData.Models.Consumer();
                        cdmItem.FirstName    = sItem.Fname;
                        cdmItem.LastName     = sItem.Lname;
                        cdmItem.PrimaryEmail = sItem.Email;
                        cdmItem.Created      = sItem.DateEntered ?? DateTime.UtcNow;
                        cdmItem.Modified     = sItem.DateModified ?? DateTime.UtcNow;
                        cdmItem.Dob          = sItem.Dob;
                        cdmItem.Gender       = sItem.Gender;
                        try
                        {
                            var consumerProfile = new ConsumerProfile
                            {
                                RegionId  = regionId,
                                PhoneHome = sItem.Phonehm,
                                PhoneCell = sItem.Phonemb,
                                Notes     = sItem.Description,
                                Created   = sItem.DateEntered ?? DateTime.UtcNow
                            };

                            if (sItem.AddressPostalcode != null)
                            {
                                consumerProfile.Address = new Address
                                {
                                    Created      = sItem.DateEntered ?? DateTime.UtcNow,
                                    AddressLine1 = sItem.AddressStreet,
                                    City         = sItem.AddressCity,
                                    State        = sItem.AddressState,
                                    Country      = sItem.AddressCountry ?? "USA",
                                    ZipCode      = sItem.AddressPostalcode,
                                    SystemId     = systemId
                                };
                            }
                            if (consumerProfile.SystemToConsumerProfiles == null)
                            {
                                consumerProfile.SystemToConsumerProfiles = new List <SystemToConsumerProfile>();
                            }

                            if (consumerProfile.SystemToConsumerProfiles.All(y => y.SystemId != systemId))
                            {
                                consumerProfile.SystemToConsumerProfiles.Add(new SystemToConsumerProfile()
                                {
                                    SystemId = systemId, Created = DateTime.UtcNow
                                });
                            }

                            consumerProfile.ConsumerExperiences = new List <ConsumerExperience>();

                            cdmItem.ConsumerProfiles = new List <ConsumerProfile>()
                            {
                                consumerProfile
                            };
                        }
                        catch (Exception e)
                        {
                            _logger.LogError($"broke in comsumer profile create ");

                            if (e.Message != null)
                            {
                                _logger.LogError(e.Message);
                            }
                            _logger.LogError(e.StackTrace);
                            if (e.InnerException != null && e.InnerException.Message != null)
                            {
                                _logger.LogError(e.InnerException.Message);
                            }
                        }
                        try
                        {
                            var sugarGolferProfile = sugarGolferProfileAll.FirstOrDefault(y => y.IdC == sItem.Id);

                            if (sugarGolferProfile != null)
                            {
                                var golferProfile = new GolferProfile();
                                if (!string.IsNullOrEmpty(sugarGolferProfile.HandicapC))
                                {
                                    int handicap = 0;

                                    var wasNumber = int.TryParse(sugarGolferProfile.HandicapC, out handicap);

                                    if (wasNumber)
                                    {
                                        golferProfile.Handicap = handicap;
                                    }
                                }
                                if (!string.IsNullOrEmpty(sugarGolferProfile.DriverLoftC))
                                {
                                    golferProfile.DriverLoftId = _staticTableHelper.GetLoftId(sugarGolferProfile.DriverLoftC);
                                }
                                if (!string.IsNullOrEmpty(sugarGolferProfile.DriverShaftFlexC))
                                {
                                    golferProfile.CurrentDriverFlexId = _staticTableHelper.GetFlexId(sugarGolferProfile.DriverShaftFlexC);
                                }
                                golferProfile.CurrentDriverBallFlight = sugarGolferProfile.CurrentDriverBallFlightC;
                                golferProfile.DesiredDriverBallFlight = sugarGolferProfile.DesiredDriverBallFlightC;
                                golferProfile.TypicalDriverDistance   = sugarGolferProfile.TypicalDriverDistanceC;
                                if (!string.IsNullOrEmpty(sugarGolferProfile.IronLengthC))
                                {
                                    golferProfile.CurrentIronLengthId = _staticTableHelper.GetChaftLengthId(sugarGolferProfile.IronLengthC);
                                }
                                golferProfile.Current7IronBallFlight = sugarGolferProfile.CurrentIronBallFlightC;
                                if (!string.IsNullOrEmpty(sugarGolferProfile.IronLieC))
                                {
                                    golferProfile.CurrentIronLieId = _staticTableHelper.GetLieId(sugarGolferProfile.IronLieC);
                                }
                                golferProfile.Desired7IronBallFlight = sugarGolferProfile.DesiredIronBallFlightC;
                                golferProfile.Typical7IronDistance   = sugarGolferProfile.TypicalIronDistanceC;
                                golferProfile.Created = DateTime.UtcNow;
                                int rpms = 0;
                                int.TryParse(sItem.Rpm, out rpms);
                                golferProfile.RoundsPerMonth = rpms;


                                if (!string.IsNullOrEmpty(sItem.Dexterity))
                                {
                                    golferProfile.ClubHandId = _staticTableHelper.GetClubHandId(sItem.Dexterity);
                                }
                                cdmItem.GolferProfile = golferProfile;
                            }
                        }
                        catch (Exception e)
                        {
                            _logger.LogError($"broke on golfer profile create ");

                            if (e.Message != null)
                            {
                                _logger.LogError(e.Message);
                            }
                            _logger.LogError(e.StackTrace);
                            if (e.InnerException != null && e.InnerException.Message != null)
                            {
                                _logger.LogError(e.InnerException.Message);
                            }
                        }

                        try
                        {
                            _repository.SaveQueue(cdmItem);
                        }
                        catch (Exception e)
                        {
                            _logger.LogError($"failed to save ");
                            if (e.Message != null)
                            {
                                _logger.LogError(e.Message);
                            }
                            _logger.LogError(e.StackTrace);
                            if (e.InnerException != null && e.InnerException.Message != null)
                            {
                                _logger.LogError(e.InnerException.Message);
                            }
                        }
                    }


                    _logger.LogError($"Saving Consumers ");
                    try
                    {
                        _repository.Save();
                    }
                    catch (Exception e)
                    {
                        _logger.LogError($"failed to save ");
                        if (e.Message != null)
                        {
                            _logger.LogError(e.Message);
                        }
                        _logger.LogError(e.StackTrace);
                        if (e.InnerException != null && e.InnerException.Message != null)
                        {
                            _logger.LogError(e.InnerException.Message);
                        }
                    }
                    _logger.LogError($"Saving Consumer");
                }
            }
            catch (Exception e)
            {
                _logger.LogError("failed", e);

                if (e.Message != null)
                {
                    _logger.LogError(e.Message);
                }
                _logger.LogError(e.StackTrace);
                if (e.InnerException != null && e.InnerException.Message != null)
                {
                    _logger.LogError(e.StackTrace);
                }
            }
        }
Ejemplo n.º 2
0
        public void Migrate()
        {
            try
            {
                var consumersFromSugar     = _sugarDataContext.Query <WWhatsInTheBag>().OrderByDescending(x => x.DateModified).ToList();
                var whatsInTheBagSugar     = _sugarDataContext.Query <WWhatsInTheBagCstm>().ToList();
                var whatsInToConsumerSugar = _sugarDataContext.Query <WWhatsInTheBagCConsumersC>();
                var countFromSugar         = consumersFromSugar.Count;

                var loopCount = countFromSugar / _splitCount;

                if (loopCount > 0)
                {
                    loopCount = countFromSugar;
                }

                _logger.LogInformation("#################Starting Migration of Whats in the bag");
                _logger.LogInformation($"Found {countFromSugar} to migrate");

                for (var x = 0; x < loopCount; x++)
                {
                    var skip = x * _splitCount;
                    if (skip > countFromSugar)
                    {
                        break;
                    }
                    _logger.LogInformation($"Starting segment starting at {skip}");

                    _repository.ReloadContext();
                    _repository.GetDatabase().ChangeTracker.AutoDetectChangesEnabled = false;
                    var sugarItems = consumersFromSugar.Skip(x * _splitCount).Take(_splitCount).ToList();

                    foreach (var sItem in sugarItems)
                    {
                        var bagItem        = whatsInTheBagSugar.FirstOrDefault(y => y.IdC == sItem.Id);
                        var itemToConsumer = whatsInToConsumerSugar.FirstOrDefault(y => y.WWhatsInTheBagCConsumerswWhatsInTheBagIdb == sItem.Id);
                        var consumerOld    = _sugarDataContext.Query <CConsumers>().FirstOrDefault(y => y.Id == itemToConsumer.WWhatsInTheBagCConsumerscConsumersIda);

                        if (consumerOld == null)
                        {
                            continue;
                        }

                        var consumer = _repository.Query <ConsumerData.Models.Consumer>()
                                       .Include(y => y.GolferProfile)
                                       .FirstOrDefault(y => y.PrimaryEmail.ToLower() == consumerOld.Email.ToLower());
                        if (consumer == null)
                        {
                            continue;
                        }
                        if (consumer.GolferProfile == null)
                        {
                            consumer.GolferProfile = new ConsumerData.Models.GolferProfile
                            {
                                Created    = DateTime.UtcNow,
                                ConsumerId = consumer.Id.Value
                            };
                            _repository.SaveQueue(consumer);
                        }

                        var cdmItem = new ConsumerData.Models.WhatsInTheBag
                        {
                            ClubShaftFlexId      = _staticTableHelper.GetFlexId(bagItem.FlexC),
                            ClubLoftId           = _staticTableHelper.GetLoftId(bagItem.LoftC),
                            FaceLieAdjustmentId  = _staticTableHelper.GetLieId(bagItem.FaceLieAdjustmentC),
                            FaceLoftAdjustmentId = _staticTableHelper.GetLoftId(bagItem.FaceLoftAdjustmentC),
                            Created            = DateTime.UtcNow,
                            ClubCategoryId     = _staticTableHelper.GetCategoryId(sItem.Category),
                            BrandId            = _staticTableHelper.GetBrandId(sItem.Vendor),
                            ClubCategoryTypeId = _staticTableHelper.GetClubCategoryTypeId(bagItem.HeadLoftC),
                            ModelId            = _staticTableHelper.GetModelId(sItem.Model),
                            PlanToPurchase     = !string.IsNullOrWhiteSpace(sItem.PlanningToPurchase),
                            ClubShaftLengthId  = _staticTableHelper.GetChaftLengthId(bagItem.ShaftLengthC),
                            Sku             = bagItem.SkuC,
                            GolferProfileId = consumer.GolferProfile.Id
                        };

                        try
                        {
                            _repository.SaveQueue(cdmItem);
                        }
                        catch (Exception e)
                        {
                            _logger.LogError(e.Message);
                        }
                    }

                    _logger.LogInformation($"Saving Whats in the bag " + DateTime.UtcNow.ToLongDateString());
                    try
                    {
                        _repository.Save();
                    }
                    catch (Exception e)
                    {
                        _logger.LogError(e.Message);
                    }
                    _logger.LogInformation($"Saving Whats in the bag" + DateTime.UtcNow.ToLongDateString());
                }
            }
            catch (Exception e)
            {
                _logger.LogError("Migrate [WhatsInTheBag] failed", e);
            }
        }