public TrlApplicationAltService(ICommonDataService commonDataService, ITrlLicenseService trlLicenseService, IObjectMapper objectMapper, MigrationDbContext context) { _commonDataService = commonDataService; _trlLicenseService = trlLicenseService; _objectMapper = objectMapper; _context = context; }
public ImlApplicationAltService(ICommonDataService commonDataService, IImlLicenseService imlLicenseService, IObjectMapper objectMapper, MigrationDbContext context, ImlMedicineService imlMedicineService) { _commonDataService = commonDataService; _imlLicenseService = imlLicenseService; _objectMapper = objectMapper; _context = context; _imlMedicineService = imlMedicineService; }
public TrlApplicationProcessService(ICommonDataService dataService, LimsExchangeService limsExchangeService, IObjectMapper objectMapper, IEntityStateHelper entityStateHelper, MigrationDbContext context) { _dataService = dataService; _limsExchangeService = limsExchangeService; _objectMapper = objectMapper; _entityStateHelper = entityStateHelper; _context = context; }
public TokenService(IConfiguration configuration, MigrationDbContext context, LimsExchangeService limsService) { config = configuration; _context = context; _limsService = limsService; }
public ImlMedicineService(ICommonDataService dataService, IConfiguration configuration, MigrationDbContext context, IUserInfoService userInfoService) { DataService = dataService; _configuration = configuration; _context = context; _userInfo = userInfoService.GetCurrentUserInfo(); }
public void fix() { using (ApplicationDbContext newthreadcontext = new ApplicationDbContext()) { using (MigrationDbContext migrateDB = new MigrationDbContext()) { // ad info if (!newthreadcontext.TemplateDB.Any()) { var adinfo = migrateDB.TemplatesDB.Include("RecommendedInfo"); foreach (var i in adinfo) { var t = newthreadcontext.TemplateDB.Add(new AdInfoTemplate() { TemplateName = i.TemplateName, RecommendedInfo = new List <AdInfoString>() }); foreach (var x in i.RecommendedInfo) { t.RecommendedInfo.Add(new AdInfoString() { Name = x.Name }); } } newthreadcontext.SaveChanges(); } } } using (ApplicationDbContext newthreadcontext = new ApplicationDbContext()) { using (MigrationDbContext migrateDB = new MigrationDbContext()) { if (!newthreadcontext.MiscInfoDB.Any()) { var make = migrateDB.MakeDB.ToList(); foreach (var i in make) { newthreadcontext.MiscInfoDB.Add(new MiscInfo() { Value = i.Name, Descriptor = "VehicleMake" }); } var adtype = migrateDB.TypesDB.ToList(); foreach (var i in adtype) { newthreadcontext.MiscInfoDB.Add(new MiscInfo() { Value = i.Value, Name = i.Name, Descriptor = "AdType" }); } var bodytype = migrateDB.BodyTypeDB.ToList(); foreach (var i in bodytype) { newthreadcontext.MiscInfoDB.Add(new MiscInfo() { Value = i.Type, Descriptor = "VehicleBodyType" }); } var transmission = migrateDB.TransmissionDB.ToList(); foreach (var i in transmission) { newthreadcontext.MiscInfoDB.Add(new MiscInfo() { Value = i.Name, Descriptor = "VehicleTransmission" }); } var drivetrain = migrateDB.DrivetrainDB.ToList(); foreach (var i in drivetrain) { newthreadcontext.MiscInfoDB.Add(new MiscInfo() { Value = i.Name, Descriptor = "VehicleDrivetrain" }); } var condition = migrateDB.ConditionDB.ToList(); foreach (var i in condition) { newthreadcontext.MiscInfoDB.Add(new MiscInfo() { Value = i.Name, Descriptor = "VehicleCondition" }); } var fueltype = migrateDB.FuelDB.ToList(); foreach (var i in fueltype) { newthreadcontext.MiscInfoDB.Add(new MiscInfo() { Value = i.Name, Descriptor = "VehicleFuelType" }); } var priceinfo = migrateDB.PriceInfoDB.ToList(); foreach (var i in priceinfo) { newthreadcontext.MiscInfoDB.Add(new MiscInfo() { Value = i.Name, Descriptor = "PriceInfo" }); } newthreadcontext.SaveChanges(); } } } using (ApplicationDbContext newthreadcontext = new ApplicationDbContext()) { using (MigrationDbContext migrateDB = new MigrationDbContext()) { if (!newthreadcontext.CategoryDB.Any()) { var cat = migrateDB.CategoryDB.Include("SubCategories.AdInfoTemplate").ToList(); foreach (var i in cat) { var currentcat = newthreadcontext.CategoryDB.Add(new Category() { Name = i.Name, TotalClassifiedAdsCount = i.TotalClassifiedAdsCount }); List <SubCategory> scl = new List <SubCategory>(); foreach (var j in i.SubCategories) { if (j.AdInfoTemplate != null) { var template = newthreadcontext.TemplateDB.SingleOrDefault(x => x.TemplateName.Equals(j.AdInfoTemplate.TemplateName)); scl.Add(new SubCategory() { Category = currentcat, Name = j.Name, stringId = j.stringId, AdInfoTemplate = template }); } else { scl.Add(new SubCategory() { Category = currentcat, Name = j.Name, stringId = j.stringId }); } } newthreadcontext.SubCategoryDB.AddRange(scl); } newthreadcontext.SaveChanges(); } } } if (!RoleManager.RoleExists("Admin")) { RoleManager.Create(new IdentityRole() { Name = "Admin" }); } if (!RoleManager.RoleExists("Banned")) { RoleManager.Create(new IdentityRole() { Name = "Banned" }); } if (!RoleManager.RoleExists("Moderator")) { RoleManager.Create(new IdentityRole() { Name = "Moderator" }); } if (!RoleManager.RoleExists("Premium")) { RoleManager.Create(new IdentityRole() { Name = "Premium" }); } if (!RoleManager.RoleExists("User")) { RoleManager.Create(new IdentityRole() { Name = "User" }); } using (ApplicationDbContext newthreadcontext = new ApplicationDbContext()) { using (MigrationDbContext migrateDB = new MigrationDbContext()) { if (!newthreadcontext.CountryDB.Any()) { var trinidad = newthreadcontext.CountryDB.Add(new Country() { Name = "Trinidad" }); var tobago = newthreadcontext.CountryDB.Add(new Country() { Name = "Tobago" }); newthreadcontext.SaveChanges(); } if (!newthreadcontext.RegionDB.Any()) { var trinidad = newthreadcontext.CountryDB.SingleOrDefault(x => x.Name.Equals("Trinidad")); List <Region> trinR = new List <Region>() { new Region() { Country = trinidad, Name = "Port of Spain" }, new Region() { Country = trinidad, Name = "San Fernando" }, new Region() { Country = trinidad, Name = "Marabella" }, new Region() { Country = trinidad, Name = "Chaguanas" }, new Region() { Country = trinidad, Name = "Cunupia" }, new Region() { Country = trinidad, Name = "Endeavour" }, new Region() { Country = trinidad, Name = "Felicity" }, new Region() { Country = trinidad, Name = "Montrose" }, new Region() { Country = trinidad, Name = "Arima" }, new Region() { Country = trinidad, Name = "Point Fortin" }, new Region() { Country = trinidad, Name = "Guapo" }, new Region() { Country = trinidad, Name = "Techier" }, new Region() { Country = trinidad, Name = "Claxton Bay" }, new Region() { Country = trinidad, Name = "Diego Martin" }, new Region() { Country = trinidad, Name = "Maraval" }, new Region() { Country = trinidad, Name = "Westmoorings" }, new Region() { Country = trinidad, Name = "Penal" }, new Region() { Country = trinidad, Name = "Debe" }, new Region() { Country = trinidad, Name = "Moruga" }, new Region() { Country = trinidad, Name = "Princes Town" }, new Region() { Country = trinidad, Name = "Mayaro" }, new Region() { Country = trinidad, Name = "Rio Claro" }, new Region() { Country = trinidad, Name = "Guayaguayare" }, new Region() { Country = trinidad, Name = "Barataria" }, new Region() { Country = trinidad, Name = "Laventille" }, new Region() { Country = trinidad, Name = "Morvant" }, new Region() { Country = trinidad, Name = "St. Joseph" }, new Region() { Country = trinidad, Name = "San Juan" }, new Region() { Country = trinidad, Name = "Guaico" }, new Region() { Country = trinidad, Name = "Sangre Grande" }, new Region() { Country = trinidad, Name = "Toco" }, new Region() { Country = trinidad, Name = "Valencia" }, new Region() { Country = trinidad, Name = "Cedros" }, new Region() { Country = trinidad, Name = "Fyzabad" }, new Region() { Country = trinidad, Name = "La Brea" }, new Region() { Country = trinidad, Name = "Santa Flora" }, new Region() { Country = trinidad, Name = "Siparia" }, new Region() { Country = trinidad, Name = "Arouca" }, new Region() { Country = trinidad, Name = "Curepe" }, new Region() { Country = trinidad, Name = "Piarco" }, new Region() { Country = trinidad, Name = "St Augustine" }, new Region() { Country = trinidad, Name = "Trincity" }, new Region() { Country = trinidad, Name = "Tunapuna" }, new Region() { Country = trinidad, Name = "Couva" }, new Region() { Country = trinidad, Name = "Talparo" }, new Region() { Country = trinidad, Name = "Tabaquite" }, new Region() { Country = trinidad, Name = "Point Lisas" }, new Region() { Country = trinidad, Name = "Caroni" }, new Region() { Country = trinidad, Name = "Santa Cruz" }, new Region() { Country = trinidad, Name = "Freeport" } }; trinidad.Regions = trinR; trinidad.RegionCount = trinR.Count; newthreadcontext.SaveChanges(); var tobago = newthreadcontext.CountryDB.SingleOrDefault(x => x.Name.Equals("Tobago")); List <Region> tobaR = new List <Region>() { new Region() { Country = tobago, Name = "Charlotteville" }, new Region() { Country = tobago, Name = "Roxborough" }, new Region() { Country = tobago, Name = "Scarborough" }, new Region() { Country = tobago, Name = "Canaan" }, new Region() { Country = tobago, Name = "Plymouth" }, new Region() { Country = tobago, Name = "Moriah" } }; tobago.Regions = tobaR; tobago.RegionCount = tobaR.Count; newthreadcontext.SaveChanges(); } } } using (MigrationDbContext migrateDB = new MigrationDbContext()) { if (!UserManager.Users.Any()) { var userwithad = migrateDB.UserProfiles.ToList(); foreach (var user in userwithad) { ApplicationUser newuser = new ApplicationUser() { Email = user.Email, UserName = !String.IsNullOrEmpty(user.UserName) ? user.Email.Split('@').First() : user.UserName, StringId = user.StringId, PhoneNumber = user.ContactNumber }; var result = UserManager.Create(newuser); if (result.Succeeded) { string query = "SELECT green_kappakappa.webpages_Roles.RoleName FROM(green_kappakappa.webpages_Roles INNER JOIN green_kappakappa.webpages_UsersInRoles ON green_kappakappa.webpages_Roles.RoleId = green_kappakappa.webpages_UsersInRoles.RoleId) INNER JOIN UserProfile ON green_kappakappa.webpages_UsersInRoles.UserId = " + user.UserId; var role = migrateDB.Database.SqlQuery <string>(query).ToList(); UserManager.AddToRole(newuser.Id, role.First()); } } } } using (ApplicationDbContext newthreadcontext = new ApplicationDbContext()) { ICollection <ClassifiedAdOld> ads = new List <ClassifiedAdOld>(); using (MigrationDbContext migrateDB = new MigrationDbContext()) { ads = migrateDB.ClassifiedDB.Include("UserCreator").Include("Country").Include("Region").Include("AdInfo").Include("AdPhotos").Include("Category").Include("SubCategory").Include("Reports").ToList(); } if (!newthreadcontext.ClassifiedDB.Any()) { var config = new MapperConfiguration(r => { r.CreateMap <CategoryOld, Category>(); r.CreateMap <SubCategoryOld, SubCategory>() .ForMember(dest => dest.ClassifiedAds, opt => opt.Ignore()); r.CreateMap <InfoOld, Info>(); r.CreateMap <PhotoOld, Photo>(); r.CreateMap <AdPromotionOld, AdPromotion>(); }); IMapper mapper = config.CreateMapper(); foreach (var ad in ads) { var i = newthreadcontext.ClassifiedDB.Add(new ClassifiedAd()); i.AdType = ad.AdType; i.StringId = ad.StringId; i.ContactPrivacy = ad.ContactPrivacy; i.Description = ad.Description; i.EditCount = ad.EditCount; i.EditTimeStamp = ad.EditTimeStamp; i.FeaturedAdStatus = ad.FeaturedAdStatus; i.HtmlFreeDescription = ad.HtmlFreeDescription; i.MyProperty = ad.MyProperty; i.Price = ad.Price; i.PriceInfo = ad.PriceInfo; i.TimeStamp = ad.TimeStamp; i.Title = ad.Title; i.UrgentAdStatus = ad.UrgentAdStatus; i.UserContactEmail = ad.UserContactEmail; i.UserContactName = ad.UserContactName; i.UserContactPhone = ad.UserContactPhone; i.UserContactPhone2 = ad.UserContactPhone2; i.UserContactPhone3 = ad.UserContactPhone3; i.Views = ad.Views; var sc = newthreadcontext.SubCategoryDB.Include("Category").FirstOrDefault(x => x.stringId.Equals(ad.SubCategory.stringId)); i.SubCategory = sc; i.Category = sc.Category; var user = newthreadcontext.Users.FirstOrDefault(x => x.Email.Equals(ad.UserCreator.Email)); i.UserCreator = user; var region = newthreadcontext.RegionDB.Include("Country").FirstOrDefault(x => ad.Region.Name.Contains(x.Name)); i.Region = region; i.Country = region.Country; foreach (var ap in ad.AdPhotos) { var pho = new Photo() { AdListThumbnail = ap.AdListThumbnail, ClassifiedAd = i, ContentType = ap.ContentType, CountNum = ap.CountNum, FileName = ap.FileName, SetThumbnail = ap.SetThumbnail, StringId = ap.StringId }; pho.ClassifiedAd.AdPhotos.Add(pho); } foreach (var ai in ad.AdInfo) { var inf = new Info() { ClassifiedAd = i, Description = ai.Description, Name = ai.Name, IntDescription = ai.IntDescription }; inf.ClassifiedAd.AdInfo.Add(inf); } foreach (var rep in ad.Reports) { var crep = new ClassifiedAdReport() { ClassifiedAd = i, CreatedDate = rep.CreatedDate, OpenRequest = rep.OpenRequest, ReasonDescription = rep.ReasonDescription, ReasonTitle = rep.ReasonTitle, ReportingUser = rep.ReportingUser, Status = rep.Status }; crep.ClassifiedAd.Reports.Add(crep); } if (ad.Status == 0) { i.SubCategory.ClassifiedAdsCount++; i.Category.TotalClassifiedAdsCount++; } newthreadcontext.SaveChanges(); } } } using (MigrationDbContext migrateDB = new MigrationDbContext()) { var query = "SELECT green_kappakappa.webpages_OAuthMembership.Provider, green_kappakappa.webpages_OAuthMembership.ProviderUserId, UserProfile.Email FROM UserProfile INNER JOIN green_kappakappa.webpages_OAuthMembership ON UserProfile.UserId = green_kappakappa.webpages_OAuthMembership.UserId"; var logins = migrateDB.Database.SqlQuery <login>(query).ToList(); foreach (var login in logins) { var user = UserManager.FindByEmail(login.Email); UserManager.AddLogin(user.Id, new UserLoginInfo(login.Provider, login.ProviderUserId)); } } }