public async Task AddProductPackDates() { var product = new SimsProduct { Name = "Product PackDates no sizes with dates", BatchCodes = "BC1234 BC59867", Brand = "New Brand", HostId = 21, CountryOfOriginId = 103, Amount = "7", ProductTypeId = 2, AmountUnitTypeId = 1, AdditionalInfo = "More Data needed", PackDescription = "This is description", ProductDates = new List <SimsProductDate>() { new SimsProductDate { Date = DateTime.Now, DateTypeId = 2 }, new SimsProductDate { Date = DateTime.Now, DateTypeId = 3 } } }; using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var updatedProduct = await simsHost.Signals.Products.Add(product.HostId, product); Assert.True(updatedProduct.ProductDates.Count() > 0); } }
public async Task AddSignalNoSPT() { var Signal = new SimsSignal { Title = "Cheesecake ALERT! No Cheese too much cake. 1 Man Swooned", SignalStatusId = 0, Priority = "HIGH", LeadOfficer = "", CountryOfOrigin = "GB", NotifyingCountry = "UK", IsEu = false, BaseProduct = "Cheese", Manufacturer = "Mister cake", FoodOrFeed = "food", Hazard = "involutnary Swooning", HazardGroup = "Panic", DataSource = "Food_Poisoning_Bulletin", SourceType = "Others", PublishedDate = DateTime.Parse("2020-08-19"), InsertedDate = DateTime.Parse("2020-08-20"), SourceLink = "https://foodpoisoningbulletin.com/2020/maison-terre-goldenseal-root-powder-recalled-one-infant-has-died/" }; using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var savedSignal = await simsHost.Signals.Add(Signal); //Assert.True(savedSignal.MostUniqueId != Guid.Empty); } }
private async Task CreateIncidents(ISimsDbHost sims, SimsDbContext ctx, SeedingConfigData seeder) { var iManager = sims.Incidents; List <Task <BaseIncident> > TaskList = new List <Task <BaseIncident> >(); await iManager.Add(seeder.GetNewIncidents()); var coreIncident = seeder.GetNewIncidents().ElementAt(0); var newBatch = new List <BaseIncident>(); for (var x = 0; x < 9000 / 20; ++x) { foreach (var title in this.titleList) { var newIncident = coreIncident.WithTitle($"{title}-{x}") .WithStatus((int)SimsIncidentStatusTypes.Unassigned) .WithLeadOfficer(""); newBatch.Add(newIncident); } } var numbersTest = coreIncident.WithTitle("Number Searching Test Incident 1234 1234.5678 RIM2021.123 RIM2021-123 (1234)") .WithStatus((int)SimsIncidentStatusTypes.Unassigned) .WithLeadOfficer(""); newBatch.Add(numbersTest); await iManager.Add(newBatch); }
public async Task AddProductNoCollections() { var newName = "Product no collections"; var product = new SimsProduct { Name = newName, BatchCodes = "BC1234 BC59867", Brand = "New Brand", HostId = 21, CountryOfOriginId = 103, Amount = "7", ProductTypeId = 2, AmountUnitTypeId = 1, AdditionalInfo = "Signal Data", PackDescription = "This is descirption", }; using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var updatedProduct = await simsHost.Signals.Products.Add(product.HostId, product); Assert.True(updatedProduct.Name == newName); } }
public async Task AddProductPackSizesDefaultAmount() { var product = new SimsProduct { Name = "Product Pack Sizes no dates with sizes", BatchCodes = "BC New packers BNA2324", Brand = "A Brand", HostId = 17, CountryOfOriginId = 47, ProductTypeId = 2, Amount = "0.0", AmountUnitTypeId = 3, AdditionalInfo = "More Data needed", PackDescription = "This is description", PackSizes = new List <SimsProductPackSize> { new SimsProductPackSize { Size = "7", UnitId = 2 }, new SimsProductPackSize { Size = "18.8", UnitId = 2 }, } }; using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var updatedProduct = await simsHost.Signals.Products.Add(product.HostId, product); Assert.True(updatedProduct.PackSizes.Count() == 2 && updatedProduct.Amount == "0.0"); } }
public async Task AddStakeholderOnlineForm() { var factCheck = "New stakeholder"; var updatedIncidentType = 71; var newOnlineForm = this.BasicForm(); newOnlineForm.Title = factCheck; using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var savedForm = await simsHost.OnlineForms.Add(newOnlineForm); var stakeHolders = await simsHost.OnlineForms.Stakeholders.Add(savedForm.CommonId, new SimsStakeholder { AddressId = 42, AddressTitle = "This sims stakeholders address", DiscriminatorId = 1, Email = "*****@*****.**", GovDept = "Gov Dept", Name = "Sims Stakholeer", Phone = "01234 Phonme" }); Assert.True(stakeHolders.Id > 0); } }
public async Task AddAddress() { var testTitle = "Test - New orgnaisations"; var org = new SimsAddress { Title = testTitle, //MainContact = "New-Org Smity", AddressLine1 = "Address line 1", AddressLine2 = "Address line 2", PostCode = "Test post", TownCity = "Test Town City", CountryId = 201, County = "Country", TelephoneNumber = "01234567890", Contacts = new List <SimsAddressContact> { new SimsAddressContact { EmailAddress = "email@address", TelephoneNumber = "01234567890", Name = "New-Org Smity", IsMain = true } } }; using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var savedAddress = await simsHost.Addresses.Add(org); Assert.True(savedAddress.Title == testTitle); } }
public async Task GetProductAddresses() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var addresses = await simsHost.Signals.Products.Fbos.GetAddresses(1); } }
public async Task GetNote() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); await simsHost.Incidents.Notes.GetAll(17); } }
public async Task AddSignalUser() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); await simsHost.Audit.LogEntry("Signal", "TestPageOverview", 500); } }
public async Task AddIncidentUser() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); await simsHost.Audit.LogEntry("Incident", "TestPageAlpha", 44); } }
public async Task RemoveIncidentLink() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var removedLink = await simsHost.Incidents.Links.Remove(1, 6); Assert.True(removedLink.From == 1 && removedLink.To == 6); } }
public async Task GetDisplayProduct() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var prodDisplay = await simsHost.Signals.Products.Get(1); Assert.True(!String.IsNullOrEmpty(prodDisplay.Amount) && !String.IsNullOrEmpty(prodDisplay.Name)); } }
public async Task GetDashboardNoSearchOnlineForm() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var dashboardSearch = await simsHost.OnlineForms.DashboardSearch(); Assert.True(dashboardSearch.Count() > 0); } }
public async Task DashboardSearchPeanut() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var results = await simsHost.Incidents.DashboardSearch("peanuts"); Assert.True(results.TotalResults > 0); } }
public async Task AddLink() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var allAddedLinks = (await simsHost.Signals.Links.Add(1, new int[] { 40, 34, 85 }, "Terry can")).ToList(); var alLinks = (await simsHost.Signals.Links.GetForHost(1)).ToList(); Assert.True(alLinks.Count == 3); } }
public async Task NotClosed() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var signalNotClosed = await simsHost.Signals.Exists(19); Assert.True(signalNotClosed); } }
public async Task FindAddress() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var results = await simsHost.Addresses.FindAddress("black"); Assert.True(results.ToList().Count > 0); } }
public async Task Get() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var signal = await simsHost.Signals.Get(42); Assert.True(signal != null && signal.Title.Length > 0); } }
public async Task DoesNotExist() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var signalExists = await simsHost.Signals.Exists(99999); Assert.False(signalExists); } }
public SignalNotesTesting() { var seedInfo = new SeedingConfigData(); this.mapper = seedInfo.GetDbAutoMapper(); var config = seedInfo.GetConfigData(); this.conn = ((JsonElement)config["ConnectionStrings:FSADbConn"]).ToString(); this.userId = seedInfo.userIds[0]; }
public async Task GetNote() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var notes = await simsHost.Signals.Notes.GetAll(1); Assert.True(notes.ToList().Count > 0); } }
public async Task UpdateClosedIncident() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var data = await simsHost.Incidents.Get(59); var updated = data.WithTitle("New Title after closing"); //await Assert.ThrowsAsync<IncidentClosedException>(async () => await simsHost.Incidents.Update(updated)); } }
public async Task UpdatePublished() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var signal = await simsHost.Signals.Get(13); signal.Title = "Cheesecake ALERT!"; signal.PublishedDate = DateTime.Parse("01/01/2020"); await Assert.ThrowsAsync <ArgumentOutOfRangeException>(async() => await simsHost.Signals.Update(signal)); } }
private async Task CreateSignalStakeholders(ISimsDbHost sims, SeedingConfigData seeder) { var stakeholders = seeder.GetSignalStakeholder.ToList(); await sims.Signals.Stakeholders.Add(stakeholders[0].HostId, stakeholders[0]); await sims.Signals.Stakeholders.Add(stakeholders[1].HostId, stakeholders[1]); await sims.Signals.Stakeholders.Add(stakeholders[2].HostId, stakeholders[2]); await sims.Signals.Stakeholders.Add(stakeholders[3].HostId, stakeholders[3]); }
public async Task UpdateSignal() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var signal = await simsHost.Signals.Get(23); signal.Title = "Cheesecake ALERT!"; var savedSignal = await simsHost.Signals.Update(signal); //Assert.True(savedSignal.MostUniqueId != Guid.Empty); } }
public async Task CloseIncident() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var data = await simsHost.Incidents.Get(59); var updated = data.WithStatus((int)SimsIncidentStatusTypes.Closed); var item = await simsHost.Incidents.Update(updated); Assert.True(item.IncidentClosed != null && item.StatusId == (int)SimsIncidentStatusTypes.Closed); } }
public SignalsStakeholdersTesting() { var seedInfo = new SeedingConfigData(); this.mapper = seedInfo.GetDbAutoMapper(); this.userId = seedInfo.userIds[0]; this.anotherId = seedInfo.userIds[1]; this.userId3 = seedInfo.userIds[2]; this.miller = seedInfo.userIds[3]; var config = seedInfo.GetConfigData(); this.conn = ((JsonElement)config["ConnectionStrings:FSADbConn"]).ToString(); }
public async Task NullToNullLeadLocalAuthroity() { using (var ctx = SeedingConfigData.GetDbContext(this.conn)) { var simsHost = SimsDbHost.CreateHost(ctx, this.mapper, this.userId); var data = await simsHost.Incidents.Get(3); var updated = data.WithLocalAuthority(null); var item = await simsHost.Incidents.Update(updated); Assert.True(item.LeadLocalAuthorityId == null); } }
public DbSimsContextFixture() { var seedInfo = new SeedingConfigData(); this.Config = seedInfo.GetConfigData(); var conn = ((JsonElement)Config["ConnectionStrings:FSADbConn"]).ToString(); this.titleList = File.ReadAllLines("./Setup/ListOfTitles.txt"); this.dbConn = new SqlConnection(); this.services = new ServiceCollection(); this.UserId = ((JsonElement)Config["username"]).ToString(); SetUpDbContext(conn); Seed(); }