public void Case07() { var simAndDevice = new SimAndDevice() { Sim = _sim2, Device = _device1, IsolatedNw2Ip = "127.0.0.1/18", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-01"), EndDate = DateTime.Parse("2020-02-09") }; _context.Add(simAndDevice); _context.SaveChanges(); var obj = new { IsolatedNw2Ip = "127.0.0.1/18", AuthenticationDuration = 1, StartDate = "2020-02-01", EndDate = "2020-02-09" }; var(response, _, json) = Utils.Put(_client, $"{Url}/{simAndDevice.Id}", Utils.CreateJsonContent(obj), "user1", "user1", 1, "domain01"); // ユーザー管理者 Assert.Equal(HttpStatusCode.Forbidden, response.StatusCode); Assert.NotNull(json["traceId"]); // 存在 Assert.NotNull(json["errors"]["Role"]); }
public void Case13() { SetUpData(); for (int j = 1; j <= 2; j++) { for (int i = 1; i <= 25; i++) { var simDevice = new SimAndDevice() // 正常データ { Sim = _sim1, Device = _device1, IsolatedNw2Ip = $"127.0.0.{i:00}", AuthenticationDuration = i, StartDate = DateTime.Parse($"2020-{j:00}-{i:00}"), EndDate = DateTime.Parse($"2021-{j:00}-{i:00}"), }; _context.AddRange(simDevice); } } _context.SaveChanges(); var(response, _, json) = Utils.Get(_client, $"{Url}/?page=2&Msisdn=msisdn&DeviceName=device&startDateFrom=2019-12-29&startDateTo=2020-02-27&endDateFrom=2020-12-29&endDateTo=2021-02-27&IsAuthenticationDone=False&sortBy=endDate&orderBy=desc", "user1", "user1", 1, "domain01"); // ユーザー管理者 var list = (JArray)json["results"]; Assert.Equal(HttpStatusCode.OK, response.StatusCode); Assert.Equal(20, list.Count); Assert.Equal(50, (int)json["count"]); Assert.Equal("2021-02-05", list[0]["endDate"]); Assert.Equal("2021-02-04", list[1]["endDate"]); // 利用終了日ソート:'降順 }
public void Case16() { SetUpData(); for (int j = 1; j <= 2; j++) { for (int i = 1; i <= 25; i++) { var simDeviceAuthenticationStateDone = new SimAndDeviceAuthenticated() { Expiration = DateTime.Now.AddHours(6.00) }; var simDevice = new SimAndDevice() // 正常データ { Sim = _sim1, Device = _device1, IsolatedNw2Ip = $"127.0.0.{i:00}", AuthenticationDuration = i, StartDate = DateTime.Parse($"2020-{j:00}-{i:00}"), EndDate = DateTime.Parse($"2021-{j:00}-{i:00}"), SimAndDeviceAuthenticated = simDeviceAuthenticationStateDone }; _context.AddRange(simDevice, simDeviceAuthenticationStateDone); } } _context.SaveChanges(); var(response, _, json) = Utils.Get(_client, $"{Url}/?OrganizationCode={_org1.Code}&page=1&pageSize=2&Msisdn=msisdn&DeviceName=device&startDateFrom=2019-12-29&startDateTo=2020-02-27&endDateFrom=2020-12-29&endDateTo=2021-02-27&IsAuthenticationDone=True&sortBy=endDate&orderBy=asc", "user0", "user0"); // スーパー管理者 var list = (JArray)json["results"]; Assert.Equal(HttpStatusCode.OK, response.StatusCode); Assert.Equal(2, list.Count); Assert.Equal(50, (int)json["count"]); Assert.Equal("2021-01-01", list[0]["endDate"]); Assert.Equal("2021-01-02", list[1]["endDate"]);// 利用終了日ソート:'昇順 }
public void Case05() { var simDeviceAuthenticationStateDone = new SimAndDeviceAuthenticated() { Expiration = DateTime.Now.AddHours(1.00) }; var simDevice1 = new SimAndDevice() // 組織 : '自組織 { Sim = _sim1, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), SimAndDeviceAuthenticated = simDeviceAuthenticationStateDone }; _context.Add(simDeviceAuthenticationStateDone); _context.Add(simDevice1); _context.SaveChanges(); var(response, _, json) = Utils.Get(_client, $"{Url}/{simDevice1.Id}", "user1", "user1", 1, "domain01"); // ユーザー管理者 Assert.Equal(HttpStatusCode.OK, response.StatusCode); Assert.Equal(simDevice1.Id.ToString(), json["id"]); Assert.Equal(simDevice1.Sim.Msisdn, json["sim"]["msisdn"]); Assert.Equal(simDevice1.Device.Name, json["device"]["name"]); Assert.Equal(simDevice1.IsolatedNw2Ip, json["isolatedNw2Ip"]); Assert.Equal(simDevice1.AuthenticationDuration, json["authenticationDuration"]); Assert.Equal(simDevice1.StartDate.ToString("yyyy-MM-dd"), json["startDate"]); Assert.Null(json["endDate"].FirstOrDefault()); Assert.Equal(simDeviceAuthenticationStateDone.Id, json["simAndDeviceAuthenticated"]["id"]); }
public ListingMineTests(CustomWebApplicationFactoryWithMariaDb <JinCreek.Server.Admin.Startup> factory) { _client = factory.CreateClient(); _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>(); Utils.RemoveAllEntities(_context); _context.Add(_org1 = Utils.CreateOrganization(code: 1, name: "org1")); _context.Add(_org2 = Utils.CreateOrganization(code: 2, name: "org2")); _context.Add(_domain1 = new Domain { Id = Guid.NewGuid(), Name = "domain1", OrganizationCode = _org1.Code }); _context.Add(_domain2 = new Domain { Id = Guid.NewGuid(), Name = "domain2", OrganizationCode = _org2.Code }); _context.Add(_user0 = new SuperAdmin { AccountName = "user0", Name = "", Password = Utils.HashPassword("user0") }); // スーパー管理者 _context.Add(_user1 = new UserAdmin { AccountName = "user1", Name = "", Password = Utils.HashPassword("user1"), Domain = _domain1 }); // ユーザー管理者 _context.Add(_user2 = new GeneralUser { AccountName = "xuser2a", Name = "", Domain = _domain1 }); _context.Add(_simGroup1 = Utils.CreateSimGroup(organization: _org1, name: "simGroup1", isolatedNw1IpPool: "isolatedNw1IpPool")); _context.Add(_simGroup2 = Utils.CreateSimGroup(organization: _org2, name: "simGroup2", isolatedNw1IpPool: "isolatedNw1IpPool")); _context.Add(_sim1A = new Sim { SimGroup = _simGroup1, Msisdn = "1", Imsi = "1a", IccId = "1a", UserName = "******", Password = "******" }); _context.Add(_sim1B = new Sim { SimGroup = _simGroup1, Msisdn = "0123456789", Imsi = "1b", IccId = "1b", UserName = "******", Password = "******" }); _context.Add(_sim2 = new Sim { SimGroup = _simGroup2, Msisdn = "2", Imsi = "2", IccId = "2", UserName = "******", Password = "******" }); _context.Add(_device1 = Utils.CreateDevice(domain: _domain1, name: "device1")); _context.Add(_device2 = Utils.CreateDevice(domain: _domain1, name: "xdevice2a")); _context.Add(_simDevice1 = new SimAndDevice { Id = Guid.NewGuid(), SimId = _sim1A.Id, Device = _device1, IsolatedNw2Ip = "" }); _context.Add(_simDevice2 = new SimAndDevice { Id = Guid.NewGuid(), SimId = _sim1A.Id, Device = _device2, IsolatedNw2Ip = "" }); _context.Add(_multiFactor1 = new MultiFactor { Id = Guid.NewGuid(), SimAndDevice = _simDevice1, EndUserId = _user1.Id, ClosedNwIp = "" }); _context.Add(_multiFactor2 = new MultiFactor { Id = Guid.NewGuid(), SimAndDevice = _simDevice2, EndUserId = _user2.Id, ClosedNwIp = "" }); //_context.Add(new SimAndDeviceAuthenticationSuccessLog { Id = Guid.NewGuid(), SimAndDevice = _simDevice1 }); //_context.Add(new SimAndDeviceAuthenticationFailureLog { Id = Guid.NewGuid(), Sim = _sim1 }); //_context.Add(new MultiFactorAuthenticationSuccessLog { Id = Guid.NewGuid(), MultiFactor = _factorCombination1 }); //_context.Add(new MultiFactorAuthenticationFailureLog { Id = Guid.NewGuid(), SimAndDevice = _simDevice1 }); //_context.Add(new DeauthenticationLog { Id = Guid.NewGuid(), MultiFactor = _factorCombination1 }); _context.SaveChanges(); }
public void Case04() { var simDevice1 = new SimAndDevice() // 組織 : '自組織 SIM(MSISDN):'フィルターに合致 { Sim = _sim1, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), }; var simDevice4 = new SimAndDevice() // 組織 : '自組織 SIM(MSISDN):'フィルターに合致 { Sim = _sim1a, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), }; var simDevice2 = new SimAndDevice() // 組織 : '自組織 SIM(MSISDN):'フィルターに合致せず { Sim = new Sim() // 組織 : '自組織 { Msisdn = "abcdfe", Imsi = "12", IccId = "11111", UserName = "******", Password = "******", SimGroup = _simGroup1 }, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), }; var simDevice3 = new SimAndDevice() // 組織 : '他組織 SIM(MSISDN):'フィルターに合致 { Sim = _sim2, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), }; _context.AddRange(simDevice3, simDevice1, simDevice2, simDevice4); _context.SaveChanges(); var(response, _, json) = Utils.Get(_client, $"{Url}/?page=1&Msisdn=msisdn&sortBy=Msisdn&orderBy=asc", "user1", "user1", 1, "domain01"); // ユーザー管理者 var list = (JArray)json["results"]; Assert.Equal(HttpStatusCode.OK, response.StatusCode); Assert.NotEmpty(list); Assert.Equal(2, list.Count); Assert.Equal(2, (int)json["count"]); Assert.Equal("msisdn01", list[0]["sim"]["msisdn"]); // SIM(MSISDN)ソート:'昇順 Assert.Equal("msisdn01a", list[1]["sim"]["msisdn"]); }
private void CreateSimAndDeviceAuthenticationSuccessLog(SimAndDevice simAndDevice) { var simAndDeviceAuthenticationSuccessLog = new SimAndDeviceAuthenticationSuccessLog { SimAndDevice = simAndDevice, Time = DateTime.Now, Sim = simAndDevice.Sim }; _authenticationRepository.Create(simAndDeviceAuthenticationSuccessLog); }
public MultiFactor GetFactorCombination(string account, SimAndDevice simAndDevice) { var factorCombination = _mainDbContext.MultiFactor .AsNoTracking() .Include(fc => fc.SimAndDevice) .Include(fc => fc.EndUser) .Include(fc => fc.MultiFactorAuthenticated) .Where(fc => fc.EndUser.AccountName == account && fc.SimAndDevice.Id == simAndDevice.Id) .FirstOrDefault(); return(factorCombination); }
private void CreateSimAndDeviceRecords() { SimAndDevice1 = new SimAndDevice() { Sim = Sim1, Device = Device1, IsolatedNw2Ip = "192.168.10.1", AuthenticationDuration = 2, StartDate = CurrentDateTimeForStart.Item1, EndDate = CurrentDateTimeForStart.Item2, }; MainDbContext.AddRange(SimAndDevice1); }
public void Case01() { var simDevice1 = new SimAndDevice() // 組織 : '自組織 { Sim = _sim1, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Now.AddHours(6.00) }; var simDevice2 = new SimAndDevice() // 組織 : '自組織 { Sim = _sim1a, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), }; var simDevice3 = new SimAndDevice() // 組織 : '自組織 { Sim = _sim1a, Device = _device2, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), }; var simDevice5 = new SimAndDevice() // 組織 : '他組織 { Sim = _sim2, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), }; _context.AddRange(simDevice5, simDevice1, simDevice2, simDevice3); _context.SaveChanges(); var(response, _, json) = Utils.Get(_client, $"{Url}/?", "user1", "user1", 1, "domain01"); // ユーザー管理者 Assert.Equal(HttpStatusCode.OK, response.StatusCode); var list = (JArray)json["results"]; Assert.Equal(3, list.Count); Assert.Equal(3, (int)json["count"]); Assert.Equal("msisdn01", list[0]["sim"]["msisdn"]); Assert.Equal("msisdn01a", list[1]["sim"]["msisdn"]); //SIM(MSISDN)ソート:'昇順 Assert.Equal("device01", list[1]["device"]["name"]); Assert.Equal("device02", list[2]["device"]["name"]); // 端末ソート:'昇順 }
public SimAndDevice SetUpInsertDataForDeauthenticationCase13() { var simDevice = new SimAndDevice { Sim = Sim, Device = Device, IsolatedNw2Ip = "Nw2Address", StartDate = DateTime.Now.AddHours(-6.00), EndDate = DateTime.Now.AddHours(6.00), AuthenticationDuration = 1 }; MainDbContext.AddRange(simDevice); MainDbContext.SaveChanges(); return(simDevice); }
public void Case19() { var sim1 = new Sim() //自組織 { Msisdn = "1001", Imsi = "1001", IccId = "1001", UserName = "******", Password = "******", SimGroup = _simGroup1 }; var sim2 = new Sim() // 自組織 { Msisdn = "1002", Imsi = "1002", IccId = "1002", UserName = "******", Password = "******", SimGroup = _simGroup1 }; var simAndDevice = new SimAndDevice() { Sim = sim2, Device = _device1, IsolatedNw2Ip = "127.0.0.1/18", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-01"), EndDate = DateTime.Parse("2020-02-09") }; _context.AddRange(sim1, sim2, simAndDevice); _context.SaveChanges(); var obj = new StringBuilder(); obj.AppendLine("is Delete,ID,SIM Group ID,SIM Group Name,MSISDN,IMSI,ICC ID,User Name,Password"); obj.AppendLine($"a,{sim1.Id},{_simGroup1.Id},{_simGroup1.Name},{sim1.Msisdn},{sim1.Imsi},{sim1.IccId},sim001,123456"); obj.AppendLine($"D,{sim2.Id},{_simGroup1.Id},{_simGroup1.Name},{sim2.Msisdn},{sim2.Imsi},{sim2.IccId},sim003,123456"); //SimDeviceも存在 var(response, body, _) = Utils.Post(_client, $"{Url}", Utils.CreateFormContent(obj.ToString(), "csv"), "user1", "user1", 1, "domain01"); // ユーザー管理者 Assert.Equal(HttpStatusCode.BadRequest, response.StatusCode); var json = JObject.Parse(body); Assert.NotNull(json["traceId"]); // 存在 Assert.NotNull(json["errors"][nameof(SimAndDevice)]); }
public ActionResult <SimAndDevice> PostSimAndDevice(RegisterParam param) { var sim = _userRepository.GetSim((Guid)param.SimId); var device = _userRepository.GetDevice((Guid)param.DeviceId); if (param.StartDate < device.StartDate || param.StartDate > device.EndDate) { ModelState.AddModelError(nameof(param.StartDate), Messages.OutOfDate); } if (param.EndDate < device.StartDate || param.EndDate > device.EndDate) { ModelState.AddModelError(nameof(param.EndDate), Messages.OutOfDate); } if (!ModelState.IsValid) { return(ValidationProblem(ModelState)); } var simDevice = new SimAndDevice() { Sim = sim, Device = device, StartDate = (DateTime)param.StartDate, EndDate = param.EndDate, AuthenticationDuration = (int)param.AuthenticationDuration, IsolatedNw2Ip = param.IsolatedNw2Ip }; if (_context.SimAndDevice.Any(s => s.Sim.Id == simDevice.Sim.Id && s.Device.Id == simDevice.Device.Id)) { ModelState.AddModelError(nameof(SimAndDevice), Messages.Duplicate); return(ValidationProblem(ModelState)); } try { _userRepository.Create(simDevice); } catch (DbUpdateException) { return(Conflict()); //throw; } return(CreatedAtAction("GetSimAndDevice", new { id = simDevice.Id }, simDevice)); }
public void Case03() { var simDevice1 = new SimAndDevice() // 組織 : '自組織 { Sim = _sim1, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), }; _context.Add(simDevice1); _context.SaveChanges(); var(response, _, json) = Utils.Get(_client, $"{Url}/?page=30", "user1", "user1", 1, "domain01"); // ユーザー管理者 var list = (JArray)json["results"]; Assert.Equal(HttpStatusCode.OK, response.StatusCode); Assert.Empty(list); }
public void Case10() { for (int j = 1; j <= 2; j++) { for (int i = 1; i <= 25; i++) { var simDeviceAuthenticationStateDone = new SimAndDeviceAuthenticated() { Expiration = DateTime.Now.AddHours(6.00) }; var simDevice = new SimAndDevice() // 組織 : '自組織 認証済み:'フィルターに合致 { Sim = _sim1, Device = _device1, IsolatedNw2Ip = $"127.0.0.{i:00}", AuthenticationDuration = i, StartDate = DateTime.Parse($"2020-{j:00}-{i:00}"), SimAndDeviceAuthenticated = simDeviceAuthenticationStateDone }; _context.AddRange(simDevice, simDeviceAuthenticationStateDone); } } _context.Add(new SimAndDevice() // 組織 : '自組織 認証済み:'フィルターに合致せず { Sim = _sim1, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-01") }); _context.SaveChanges(); var(response, _, json) = Utils.Get(_client, $"{Url}/?page=3&IsAuthenticationDone=True&sortBy=startDate&orderBy=asc", "user1", "user1", 1, "domain01"); // ユーザー管理者 var list = (JArray)json["results"]; Assert.Equal(HttpStatusCode.OK, response.StatusCode); Assert.InRange(list.Count, 1, 20); Assert.Equal(50, (int)json["count"]); Assert.Equal("2020-02-16", list[0]["startDate"]); Assert.Equal("2020-02-17", list[1]["startDate"]); // 利用開始日ソート:'昇順 }
private SimAndDeviceAuthenticated CreateSimAndDeviceAuthenticated(SimAndDevice simAndDevice) { string startTime = _configuration.GetSection("Auth:ExpireHour").Value; var simAndDeviceAuthenticated = simAndDevice.SimAndDeviceAuthenticated; if (simAndDeviceAuthenticated == null) { simAndDeviceAuthenticated = new SimAndDeviceAuthenticated { Expiration = DateTime.Now.AddHours(double.Parse(startTime)) }; simAndDevice.SimAndDeviceAuthenticated = simAndDeviceAuthenticated; _authenticationRepository.Create(simAndDeviceAuthenticated); } else { simAndDeviceAuthenticated.Expiration = DateTime.Now.AddHours(double.Parse(startTime)); _authenticationRepository.Update(simAndDeviceAuthenticated); } return(simAndDeviceAuthenticated); }
public void Case03() { var simDeviceAuthenticationStateDone = new SimAndDeviceAuthenticated() { Expiration = DateTime.Now.AddHours(1.00) }; var simDevice1 = new SimAndDevice() // 組織 : '他組織 { Sim = _sim2, Device = _device1, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Now.AddHours(6.00), SimAndDeviceAuthenticated = simDeviceAuthenticationStateDone }; _context.Add(simDeviceAuthenticationStateDone); _context.Add(simDevice1); _context.SaveChanges(); var(response, _, json) = Utils.Get(_client, $"{Url}/{simDevice1.Id}", "user1", "user1", 1, "domain01"); // ユーザー管理者 Assert.Equal(HttpStatusCode.Forbidden, response.StatusCode); Assert.NotNull(json["errors"]["Role"]); }
public InquiryMineTests(CustomWebApplicationFactory <JinCreek.Server.Admin.Startup> factory) { _client = factory.CreateClient(); _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>(); Utils.RemoveAllEntities(_context); _context.Add(_org1 = Utils.CreateOrganization(code: 1, name: "org1")); _context.Add(_org2 = Utils.CreateOrganization(code: 2, name: "org2")); _context.Add(_domain1 = new Domain { Id = Guid.NewGuid(), Name = "domain01", OrganizationCode = _org1.Code }); _context.Add(_domain2 = new Domain { Id = Guid.NewGuid(), Name = "domain02", OrganizationCode = _org2.Code }); _context.Add(_userGroup1 = new UserGroup { Id = Guid.NewGuid(), Name = "userGroup1", DomainId = _domain1.Id }); _context.Add(_userGroup2 = new UserGroup { Id = Guid.NewGuid(), Name = "userGroup2", DomainId = _domain2.Id }); _context.Add(_user0 = new SuperAdmin { AccountName = "user0", Password = Utils.HashPassword("user0") }); // スーパー管理者 _context.Add(_user1 = new UserAdmin { AccountName = "user1", Password = Utils.HashPassword("user1"), DomainId = _domain1.Id }); // ユーザー管理者 _context.Add(_user2 = new GeneralUser() { AccountName = "user2", DomainId = _domain2.Id }); _context.Add(_simGroup1 = new SimGroup { Id = Guid.NewGuid(), Name = "simGroup1", Organization = _org1, Apn = "apn", AuthenticationServerIp = "AuthServerIpAddress", IsolatedNw1IpPool = "Nw1IpAddressPool", IsolatedNw1SecondaryDns = "Nw1SecondaryDns", IsolatedNw1IpRange = "Nw1IpAddressRange", IsolatedNw1PrimaryDns = "Nw1PrimaryDns", NasIp = "NasIpAddress", UserNameSuffix = "UserNameSuffix", PrimaryDns = "PrimaryDns", SecondaryDns = "SecondaryDns" }); _context.Add(_simGroup2 = new SimGroup { Id = Guid.NewGuid(), Name = "simGroup2", OrganizationCode = _org2.Code }); _context.Add(_sim1 = new Sim { SimGroup = _simGroup1, Msisdn = "msisdn01", Imsi = "imsi01", IccId = "iccid01", UserName = "******", Password = "******" }); _context.Add(_sim2 = new Sim { SimGroup = _simGroup1, Msisdn = "msisdn01", Imsi = "imsi01", IccId = "iccid01", UserName = "******", Password = "******" }); //他組織 _context.Add(_deviceGroup1 = new DeviceGroup { Id = Guid.NewGuid(), DomainId = _domain1.Id, Name = "deviceGroup1" }); _context.Add(_device1 = new Device { Id = Guid.NewGuid(), DomainId = _domain1.Id, Name = "device1", ManagedNumber = "2", UseTpm = true, WindowsSignInListCacheDays = 1 }); _context.Add(_device1 = new Device { Id = Guid.NewGuid(), DomainId = _domain2.Id, Name = "device2", ManagedNumber = "2", UseTpm = true, WindowsSignInListCacheDays = 1 }); //他組織 _context.Add(_simDevice1 = new SimAndDevice { SimId = _sim1.Id, DeviceId = _device1.Id }); _context.Add(_simDevice2 = new SimAndDevice { SimId = _sim2.Id, DeviceId = _device1.Id }); // sim 他組織 //_context.Add(_simDevice3 = new SimAndDevice { SimId = _sim1.Id, DeviceId = _device2.Id }); // 端末 他組織 _context.Add(_multiFactor2 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice1.Id, EndUserId = _user2.Id }); //User他組織 _context.SaveChanges(); }
public RegisterTests(CustomWebApplicationFactoryWithMariaDb <Startup> factory) { _client = factory.CreateClient(); _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>(); Utils.RemoveAllEntities(_context); _context.Add(_org1 = Utils.CreateOrganization(code: 1, name: "org1", startDate: DateTime.Parse("2020-01-14"), endDate: DateTime.Parse("2021-01-30"))); _context.Add(_domain1 = new Domain { Id = Guid.NewGuid(), Name = "domain01", Organization = _org1 }); _context.Add(_userGroup1 = new UserGroup { Id = Guid.NewGuid(), Domain = _domain1, Name = "userGroup1" }); _context.Add(_user1 = new SuperAdmin { AccountName = "user0", Name = "user0", Password = Utils.HashPassword("user0") }); // スーパー管理者 _context.Add(_user2 = new UserAdmin { AccountName = "user1", Name = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1 }); // ユーザー管理者 _context.Add(_user3 = new GeneralUser { AccountName = "user2", Name = "user2", DomainId = _domain1.Id }); _context.Add(new UserGroupEndUser() { EndUser = _user2, UserGroup = _userGroup1 }); _context.Add(new AvailablePeriod { EndUser = _user2, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(new AvailablePeriod { EndUser = _user3, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(_deviceGroup1 = new DeviceGroup { Id = Guid.NewGuid(), Name = "_deviceGroup1", Domain = _domain1 }); _context.Add(_lteModule1 = new LteModule { Name = "lte1", UseSoftwareRadioState = true, NwAdapterName = "abc" }); _context.Add(_device1 = new Device() { LteModule = _lteModule1, Domain = _domain1, Name = "device01", UseTpm = true, ManagedNumber = "001", WindowsSignInListCacheDays = 1, }); _context.Add(_simGroup1 = new SimGroup() { Id = Guid.NewGuid(), Name = "simGroup1", Organization = _org1, Apn = "apn", AuthenticationServerIp = "AuthServerIpAddress", IsolatedNw1IpPool = "Nw1IpAddressPool", IsolatedNw1SecondaryDns = "Nw1SecondaryDns", IsolatedNw1IpRange = "Nw1IpAddressRange", IsolatedNw1PrimaryDns = "Nw1PrimaryDns", NasIp = "NasIpAddress", UserNameSuffix = "UserNameSuffix", PrimaryDns = "PrimaryDns", SecondaryDns = "SecondaryDns" }); _context.Add(_sim1 = new Sim() // 組織 : '自組織 { Msisdn = "1001", Imsi = "1001", IccId = "1001", UserName = "******", Password = "******", SimGroup = _simGroup1 }); _context.Add(_sim2 = new Sim() // 組織 : '自組織 { Msisdn = "1002", Imsi = "1002", IccId = "1002", UserName = "******", Password = "******", SimGroup = _simGroup1 }); _context.Add(_simAndDevice1 = new SimAndDevice() { Sim = _sim1, Device = _device1, IsolatedNw2Ip = "127.0.0.1/18", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-01"), EndDate = DateTime.Parse("2021-02-01") }); _context.SaveChanges(); }
private SimDeviceAuthenticationResponse CreateSimDeviceAuthenticationResponse(SimAndDeviceAuthenticated simAndDeviceAuthenticated, SimAndDevice simAndDevice, HashSet <string> canLogonUsers) { var simDeviceAuthenticationResponse = new SimDeviceAuthenticationResponse { AuthId = simAndDeviceAuthenticated.Id, CanLogonUsers = canLogonUsers, AssignDeviceIpAddress = simAndDevice.IsolatedNw2Ip, WindowsSignInListCacheDays = simAndDevice.Device.WindowsSignInListCacheDays, IsSoftwareRadioState = simAndDevice.Device.LteModule?.UseSoftwareRadioState, AuthenticationDuration = simAndDevice.AuthenticationDuration }; if (simAndDevice.Device.OrganizationClientApp != null) { var clientInformation = new SimDeviceAuthenticationResponse.ClientInformation(); clientInformation.Os = simAndDevice.Device.OrganizationClientApp?.ClientApp.ClientOs.Name; try { clientInformation.Version = new Version(simAndDevice.Device.OrganizationClientApp?.ClientApp.Version); } catch (ArgumentException) { _logger.LogWarning($"Invalid Version {simAndDevice.Device.OrganizationClientApp?.ClientApp.Version}"); } simDeviceAuthenticationResponse.Client = clientInformation; } return(simDeviceAuthenticationResponse); }
public InquiryTests(CustomWebApplicationFactoryWithMariaDb <JinCreek.Server.Admin.Startup> factory) { _client = factory.CreateClient(); _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>(); Utils.RemoveAllEntities(_context); _context.Add(_org1 = Utils.CreateOrganization(code: 1, name: "org1")); _context.Add(_org2 = Utils.CreateOrganization(code: 2, name: "org2")); _context.Add(_domain1 = new Domain { Id = Guid.NewGuid(), Name = "domain01", OrganizationCode = _org1.Code }); _context.Add(_domain2 = new Domain { Id = Guid.NewGuid(), Name = "domain02", OrganizationCode = _org2.Code }); _context.Add(_userGroup1 = new UserGroup { Id = Guid.NewGuid(), Name = "userGroup1", DomainId = _domain1.Id }); _context.Add(_userGroup2 = new UserGroup { Id = Guid.NewGuid(), Name = "userGroup2", DomainId = _domain2.Id }); _context.Add(_user0 = new SuperAdmin { Name = "", AccountName = "user0", Password = Utils.HashPassword("user0") }); // スーパー管理者 _context.Add(_user1 = new UserAdmin() { Name = "", AccountName = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1 }); // ユーザー管理者 _context.Add(_user2 = new GeneralUser() { Name = "", AccountName = "user2", DomainId = _domain1.Id }); _context.Add(_user3 = new GeneralUser() { Name = "", AccountName = "user3", DomainId = _domain1.Id }); _context.Add(_user4 = new GeneralUser() { Name = "", AccountName = "user4", DomainId = _domain2.Id }); _context.Add(new AvailablePeriod() { EndUser = _user1, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(new AvailablePeriod() { EndUser = _user2, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(new AvailablePeriod() { EndUser = _user3, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(new AvailablePeriod() { EndUser = _user4, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(_userGroupEndUser = new UserGroupEndUser() { EndUser = _user2, UserGroup = _userGroup1 }); _context.Add(_simGroup1 = new SimGroup { Name = "simGroup1", Organization = _org1, Apn = "apn", AuthenticationServerIp = "AuthServerIpAddress", IsolatedNw1IpPool = "Nw1IpAddressPool", IsolatedNw1SecondaryDns = "Nw1SecondaryDns", IsolatedNw1IpRange = "Nw1IpAddressRange", IsolatedNw1PrimaryDns = "Nw1PrimaryDns", NasIp = "NasIpAddress", UserNameSuffix = "UserNameSuffix", PrimaryDns = "PrimaryDns", SecondaryDns = "SecondaryDns" }); _context.Add(_sim1 = new Sim { SimGroup = _simGroup1, Msisdn = "msisdn01", Imsi = "imsi01", IccId = "iccid01", UserName = "******", Password = "******" }); _context.Add(_sim2 = new Sim { SimGroup = _simGroup1, Msisdn = "msisdn02", Imsi = "imsi02", IccId = "iccid02", UserName = "******", Password = "******" }); _context.Add(_deviceGroup1 = new DeviceGroup { DomainId = _domain1.Id, Name = "deviceGroup1" }); _context.Add(_device1 = new Device { LteModule = _lte1, Domain = _domain1, Name = "device01", UseTpm = true, ManagedNumber = "001", ProductName = "", SerialNumber = "", WindowsSignInListCacheDays = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Parse("2021-02-01") }); _context.Add(_device2 = new Device { LteModule = _lte1, Domain = _domain1, Name = "device02", UseTpm = true, ManagedNumber = "002", ProductName = "", SerialNumber = "", WindowsSignInListCacheDays = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Parse("2021-02-01") }); _context.Add(_device3 = new Device { LteModule = _lte1, Domain = _domain2, Name = "device02", UseTpm = true, ManagedNumber = "002", ProductName = "", SerialNumber = "", WindowsSignInListCacheDays = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Parse("2021-02-01") }); _context.Add(_simDevice1 = new SimAndDevice { SimId = _sim1.Id, DeviceId = _device1.Id, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Parse("2020-03-07"), }); _context.Add(_simDevice2 = new SimAndDevice { SimId = _sim2.Id, DeviceId = _device1.Id, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Parse("2020-03-07"), }); _context.Add(_simDevice3 = new SimAndDevice { SimId = _sim1.Id, DeviceId = _device2.Id, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Parse("2020-03-07"), }); _context.Add(_simDevice4 = new SimAndDevice { SimId = _sim2.Id, DeviceId = _device2.Id, IsolatedNw2Ip = "127.0.0.1", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-07"), EndDate = DateTime.Parse("2020-03-07"), }); _context.Add(_multiFactor1 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice1.Id, EndUserId = _user2.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor2 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice2.Id, EndUserId = _user2.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor3 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice3.Id, EndUserId = _user2.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor4 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice4.Id, EndUserId = _user2.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor5 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice1.Id, EndUserId = _user3.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor6 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice2.Id, EndUserId = _user3.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor7 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice3.Id, EndUserId = _user3.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor8 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice4.Id, EndUserId = _user3.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor9 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice1.Id, EndUserId = _user4.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor10 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice2.Id, EndUserId = _user4.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor11 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice3.Id, EndUserId = _user4.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(_multiFactor12 = new MultiFactor { Id = Guid.NewGuid(), SimAndDeviceId = _simDevice4.Id, EndUserId = _user4.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Parse("2020-02-01"), }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor1 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor2 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor3 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor4 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor5 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor6 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor7 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor8 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor9 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor10 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor11 }); _context.Add(new MultiFactorAuthenticated() { Expiration = DateTime.Now.AddHours(1.00), MultiFactor = _multiFactor12 }); _context.SaveChanges(); }
private void SetDataDeviceGroup06() { //DeviceGroup-6 var deviceGroup = new DeviceGroup() { Domain = Domain, Name = "deviceGroup01", AdObjectId = Guid.Parse("435cd502-5a65-4649-8a39-1e53294304f8") //削除 }; Device1 = new Device() // Devive-7 { Domain = Domain, Name = "device01", UseTpm = true, WindowsSignInListCacheDays = 1, StartDate = DateTime.Parse("2020-03-01"), ManagedNumber = "", SerialNumber = "", ProductName = "", AdObjectId = Guid.NewGuid(), OrganizationClientApp = OrganizationClientApp, LteModule = new LteModule() { Name = "lte01", NwAdapterName = "", UseSoftwareRadioState = true }, DeviceGroupDevices = new HashSet <DeviceGroupDevice>() { new DeviceGroupDevice() { DeviceGroup = deviceGroup } }, EndDate = null // EndDate : 不在 }; SimAndDevice1 = new SimAndDevice() { Device = Device1, Sim = Sim1, IsolatedNw2Ip = "", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-03-01"), EndDate = DateTime.Parse("2021-03-02") // '存在(実行日以外) }; MainDbContext.SimAndDevice.Add(new SimAndDevice() { Device = Device1, Sim = new Sim() { Msisdn = "11111111112", Imsi = "1111111112", IccId = "1111111112", UserName = "******", Password = "******", SimGroup = SimGroup1 }, IsolatedNw2Ip = "", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-03-01") // endDate:不在 }); MainDbContext.AddRange(deviceGroup, Device1, SimAndDevice1); }
public DeleteMineTests(CustomWebApplicationFactoryWithMariaDb <Admin.Startup> factory) { _client = factory.CreateClient(); _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>(); Utils.RemoveAllEntities(_context); _context.Add(_org1 = Utils.CreateOrganization(code: 1, name: "org1")); _context.Add(_org2 = Utils.CreateOrganization(code: 2, name: "org2")); _context.Add(_domain1 = new Domain { Id = Guid.NewGuid(), Name = "domain01", Organization = _org1 }); _context.Add(_domain2 = new Domain { Id = Guid.NewGuid(), Name = "domain02", Organization = _org2 }); _context.Add(_userGroup1 = new UserGroup { Id = Guid.NewGuid(), Name = "userGroup1", Domain = _domain1 }); _context.Add(_userGroup2 = new UserGroup { Id = Guid.NewGuid(), Name = "userGroup2", Domain = _domain2 }); _context.Add(_user1 = new SuperAdmin { AccountName = "user0", Name = "user0", Password = Utils.HashPassword("user0") }); // スーパー管理者 _context.Add(_user2 = new UserAdmin { AccountName = "user1", Name = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1 }); // ユーザー管理者 _context.Add(_user3 = new GeneralUser { AccountName = "user2", Name = "user2", DomainId = _domain1.Id }); _context.Add(_user4 = new GeneralUser { AccountName = "user4", Name = "user4", DomainId = _domain2.Id }); _context.Add(_simGroup1 = Utils.CreateSimGroup(name: "simGroup1", organization: _org1, isolatedNw1IpPool: "IsolatedNw1IpPool")); _context.Add(_simGroup2 = Utils.CreateSimGroup(name: "simGroup2", organization: _org2, isolatedNw1IpPool: "IsolatedNw1IpPool")); _context.Add(_sim1 = new Sim() // 組織 : '自組織 { Msisdn = "msisdn01", Imsi = "imsi01", IccId = "iccid01", UserName = "******", Password = "******", SimGroup = _simGroup1 }); _context.Add(_sim2 = new Sim() // 組織 : '他組織 { Msisdn = "1002", Imsi = "1002", IccId = "1002", UserName = "******", Password = "******", SimGroup = _simGroup2 }); _context.Add(_device1 = new Device() { LteModule = null, Domain = _domain1, Name = "device01", UseTpm = true, ManagedNumber = "001", WindowsSignInListCacheDays = 1, }); _context.Add(_simDevice1 = new SimAndDevice() { Sim = _sim1, Device = _device1, IsolatedNw2Ip = "127.0.0.1/18", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-01"), EndDate = DateTime.Parse("2020-02-09") }); _context.Add(_multiFactor1 = new MultiFactor { SimAndDeviceId = _simDevice1.Id, EndUserId = _user3.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Now, EndDate = DateTime.Now }); _context.Add(_multiFactor2 = new MultiFactor // 他組織 { SimAndDeviceId = _simDevice1.Id, EndUserId = _user4.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Now, EndDate = DateTime.Now }); _context.SaveChanges(); }
/// <summary> /// CSVインポート /// </summary> /// <param name="csv"></param> /// <param name="endUser"></param> /// <returns></returns> private ActionResult <IEnumerable <SimAndDevice> > ImportCsv(TextReader csv, EndUser endUser = null) { // 1. 型変換エラーがあればここで終了する: var records = Utils.ParseCsv <CsvRecord, CsvRecordMap>(csv, ModelState); if (!ModelState.IsValid) { return(ValidationProblem(ModelState)); } // 2. バリデーションエラーがあればここで終了する: Utils.TryValidateCsvRecords(records, ModelState); if (!ModelState.IsValid) { return(ValidationProblem(ModelState)); } var simDevices = new List <SimAndDevice>(); using (var transaction = _context.Database.BeginTransaction()) { foreach (var record in records) { var sim = _userRepository.GetSim((Guid)record.SimId); var device = _userRepository.GetDevice((Guid)record.DeviceId); if (record.StartDate < device.StartDate || record.StartDate > device.EndDate) { ModelState.AddModelError(nameof(record.StartDate), Messages.OutOfDate); } if (record.EndDate < device.StartDate || record.EndDate > device.EndDate) { ModelState.AddModelError(nameof(record.EndDate), Messages.OutOfDate); } if (!ModelState.IsValid) { return(ValidationProblem(ModelState)); } var simDevice = _context.SimAndDevice .Include(s => s.Sim) .Include(s => s.Device) .Include(s => s.Sim.SimGroup) .Include(s => s.Sim.SimGroup.Organization) .SingleOrDefault(s => s.SimId == sim.Id && s.DeviceId == device.Id); if (simDevice == null) // simDeviceはない そしてDeleteはDかdのない 登録 { var simDevice1 = new SimAndDevice() { Sim = sim, Device = device, AuthenticationDuration = (int)record.AuthenticationDuration, IsolatedNw2Ip = record.IsolatedNw2Ip, EndDate = record.EndDate, StartDate = (DateTime)record.StartDate }; _userRepository.Create(simDevice1); simDevices.Add(simDevice1); continue; } if (endUser != null && simDevice.Sim.SimGroup.Organization.Code != endUser.Domain.Organization.Code) { ModelState.AddModelError("Role", Messages.InvalidRole); return(ValidationProblem(modelStateDictionary: ModelState, statusCode: StatusCodes.Status403Forbidden)); } if ("d".Equals(record.Delete) || "D".Equals(record.Delete)) // Dかdか そしてsimDeviceはあり は削除 { if (_context.SimAndDeviceAuthenticated.Any(s => s.SimAndDeviceId == simDevice.Id)) { ModelState.AddModelError(nameof(SimAndDeviceAuthenticated), Messages.ChildEntityExists); return(ValidationProblem(ModelState)); } if (_context.MultiFactor.Any(f => f.SimAndDeviceId == simDevice.Id)) { ModelState.AddModelError("FactorCombination", Messages.ChildEntityExists); return(ValidationProblem(ModelState)); } if (_context.MultiFactorAuthenticationFailureLog.Any(f => f.SimAndDevice.Id == simDevice.Id)) { ModelState.AddModelError("MultiFactorAuthenticationFailure", Messages.ChildEntityExists); return(ValidationProblem(ModelState)); } if (_context.SimAndDeviceAuthenticationSuccessLog.Any(f => f.SimAndDevice.Id == simDevice.Id)) { ModelState.AddModelError("SimAndDeviceAuthenticationSuccess", Messages.ChildEntityExists); return(ValidationProblem(ModelState)); } _userRepository.RemoveSimAndDevice(simDevice.Id); simDevices.Add(simDevice); continue; } simDevice.IsolatedNw2Ip = record.IsolatedNw2Ip; simDevice.StartDate = (DateTime)record.StartDate; simDevice.EndDate = record.EndDate; simDevice.AuthenticationDuration = (int)record.AuthenticationDuration; _userRepository.Update(simDevice); simDevices.Add(simDevice); } transaction.Commit(); } return(Ok(simDevices)); }
public RegisterMineTests(CustomWebApplicationFactoryWithMariaDb <Startup> factory) { _client = factory.CreateClient(); _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>(); Utils.RemoveAllEntities(_context); _context.Add(_org1 = Utils.CreateOrganization(code: 1, name: "org1", startDate: DateTime.Parse("2020-01-14"), endDate: DateTime.Parse("2021-01-30"))); _context.Add(_org2 = Utils.CreateOrganization(code: 2, name: "org2", startDate: DateTime.Parse("2020-01-14"), endDate: DateTime.Parse("2021-01-30"))); _context.Add(_domain1 = new Domain { Id = Guid.NewGuid(), Name = "domain01", Organization = _org1 }); _context.Add(_domain2 = new Domain { Id = Guid.NewGuid(), Name = "domain02", Organization = _org2 }); _context.Add(_userGroup1 = new UserGroup { Id = Guid.NewGuid(), Domain = _domain1, Name = "userGroup1" }); _context.Add(_user1 = new SuperAdmin { AccountName = "user0", Name = "user0", Password = Utils.HashPassword("user0") }); // スーパー管理者 _context.Add(_user2 = new UserAdmin { AccountName = "user1", Name = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1 }); // ユーザー管理者 _context.Add(_user3 = new GeneralUser { AccountName = "user2", Name = "user2", Domain = _domain1 }); _context.Add(new UserGroupEndUser { EndUser = _user2, UserGroup = _userGroup1 }); _context.Add(new AvailablePeriod { EndUser = _user2, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(new AvailablePeriod { EndUser = _user3, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(_user4 = new GeneralUser { AccountName = "user4", Name = "user4", Domain = _domain2 }); _context.Add(_deviceGroup1 = new DeviceGroup { Id = Guid.NewGuid(), Name = "_deviceGroup1", Domain = _domain1 }); _context.Add(_lteModule1 = new LteModule { Name = "lte1", UseSoftwareRadioState = true, NwAdapterName = "abc" }); _context.Add(_device1 = new Device { LteModule = _lteModule1, Domain = _domain1, Name = "device01", UseTpm = true, ManagedNumber = "001", WindowsSignInListCacheDays = 1, }); _context.Add(_device2 = new Device() // 他組織 { LteModule = _lteModule1, Domain = _domain2, Name = "device02", UseTpm = true, ManagedNumber = "001", WindowsSignInListCacheDays = 1, }); _context.Add(_simGroup1 = Utils.CreateSimGroup(organization: _org1, name: "simGroup1", isolatedNw1IpPool: "Nw1IpAddressPool")); _context.Add(_simGroup2 = Utils.CreateSimGroup(organization: _org2, name: "simGroup2", isolatedNw1IpPool: "Nw1IpAddressPool")); _context.Add(_sim1 = new Sim() // 組織 : '自組織 { Msisdn = "1001", Imsi = "1001", IccId = "1001", UserName = "******", Password = "******", SimGroup = _simGroup1 }); _context.Add(_sim2 = new Sim() // 組織 : '他組織 { Msisdn = "1002", Imsi = "1002", IccId = "1002", UserName = "******", Password = "******", SimGroup = _simGroup2 }); _context.Add(_simAndDevice1 = Utils.CreateSimAndDevice(sim: _sim1, device: _device1, startDate: DateTime.Parse("2020-02-01"), endDate: DateTime.Parse("2021-02-01"))); _context.Add(_simAndDevice2 = Utils.CreateSimAndDevice(sim: _sim2, device: _device1)); // sim 他組織 _context.Add(_simAndDevice3 = Utils.CreateSimAndDevice(sim: _sim1, device: _device2)); // 端末 他組織 _context.SaveChanges(); }
public ListingTests(CustomWebApplicationFactory <JinCreek.Server.Admin.Startup> factory) { _client = factory.CreateClient(); _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>(); Utils.RemoveAllEntities(_context); _context.Add(_org1 = Utils.CreateOrganization(code: 1, name: "org1")); _context.Add(_org2 = Utils.CreateOrganization(code: 2, name: "org2")); _context.Add(_domain1 = new Domain { Id = Guid.NewGuid(), Name = "domain01", Organization = _org1 }); _context.Add(_domain2 = new Domain { Id = Guid.NewGuid(), Name = "domain02", Organization = _org2 }); _context.Add(_user1 = new SuperAdmin { AccountName = "user0", Password = Utils.HashPassword("user0") }); // スーパー管理者 _context.Add(_user2 = new UserAdmin() { AccountName = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1 }); // ユーザー管理者 _context.Add(_user3 = new GeneralUser() { AccountName = "user3", DomainId = _domain1.Id }); _context.Add(_user3a = new GeneralUser() { AccountName = "user3a", DomainId = _domain1.Id }); _context.Add(_user4 = new GeneralUser() { AccountName = "user4", DomainId = _domain2.Id }); _context.Add(_deviceGroup1 = new DeviceGroup() { Id = Guid.NewGuid(), Name = "_deviceGroup1", Domain = _domain1 }); _context.Add(_lte1 = new LteModule() { Name = "lte1", UseSoftwareRadioState = true, NwAdapterName = "abc" }); _context.Add(_simGroup1 = new SimGroup() { Id = Guid.NewGuid(), Name = "simGroup1", Organization = _org1, Apn = "apn", AuthenticationServerIp = "AuthServerIpAddress", IsolatedNw1IpPool = "Nw1IpAddressPool", IsolatedNw1SecondaryDns = "Nw1SecondaryDns", IsolatedNw1IpRange = "Nw1IpAddressRange", IsolatedNw1PrimaryDns = "Nw1PrimaryDns", NasIp = "NasIpAddress", UserNameSuffix = "UserNameSuffix", PrimaryDns = "PrimaryDns", SecondaryDns = "SecondaryDns" }); _context.Add(_simGroup2 = new SimGroup { Id = Guid.NewGuid(), Name = "simGroup2", Organization = _org2, IsolatedNw1IpPool = "" }); _context.Add(_sim1 = new Sim() // 組織 : '自組織 { Msisdn = "msisdn01", Imsi = "imsi01", IccId = "iccid01", UserName = "******", Password = "******", SimGroup = _simGroup1 }); _context.Add(_sim1a = new Sim() // 組織 : '自組織 { Msisdn = "msisdn01a", Imsi = "imsi01a", IccId = "iccid01a", UserName = "******", Password = "******", SimGroup = _simGroup1 }); _context.Add(_sim2 = new Sim() // 組織 : '他組織 { Msisdn = "msisdn02", Imsi = "imsi02", IccId = "iccid02", UserName = "******", Password = "******", SimGroup = _simGroup2 }); _context.Add(_device1 = new Device() { LteModule = _lte1, Domain = _domain1, Name = "device01", UseTpm = true, ManagedNumber = "001", WindowsSignInListCacheDays = 1, }); _context.Add(_device1a = new Device() { LteModule = _lte1, Domain = _domain1, Name = "device01a", UseTpm = true, ManagedNumber = "001", WindowsSignInListCacheDays = 1, }); _context.Add(_device2 = new Device()// 端末 他組織 { LteModule = _lte1, Domain = _domain2, Name = "device02", UseTpm = true, ManagedNumber = "001", WindowsSignInListCacheDays = 1, }); _context.Add(_simDevice1 = new SimAndDevice { SimId = _sim1.Id, DeviceId = _device1.Id }); _context.Add(_simDevice1a = new SimAndDevice { SimId = _sim1a.Id, DeviceId = _device1.Id }); _context.Add(_simDevice1b = new SimAndDevice { SimId = _sim1a.Id, DeviceId = _device1a.Id }); _context.Add(_simDevice2 = new SimAndDevice { SimId = _sim2.Id, DeviceId = _device1.Id }); // sim 他組織 _context.Add(_simDevice3 = new SimAndDevice { SimId = _sim1.Id, DeviceId = _device2.Id }); // 端末 他組織 _context.SaveChanges(); }
public UpdateTests(CustomWebApplicationFactory <JinCreek.Server.Admin.Startup> factory) { _client = factory.CreateClient(); _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>(); Utils.RemoveAllEntities(_context); _context.Add(_org1 = Utils.CreateOrganization(code: 1, name: "org1")); _context.Add(_org2 = Utils.CreateOrganization(code: 2, name: "org2")); _context.Add(_domain1 = new Domain { Id = Guid.NewGuid(), Name = "domain01", Organization = _org1 }); _context.Add(_domain2 = new Domain { Id = Guid.NewGuid(), Name = "domain02", Organization = _org2 }); _context.Add(_userGroup1 = new UserGroup { Id = Guid.NewGuid(), Name = "userGroup1", Domain = _domain1 }); _context.Add(_userGroup2 = new UserGroup { Id = Guid.NewGuid(), Name = "userGroup2", Domain = _domain2 }); _context.Add(_user1 = new SuperAdmin { AccountName = "user0", Password = Utils.HashPassword("user0") }); // スーパー管理者 _context.Add(_user2 = new UserAdmin() { AccountName = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1 }); // ユーザー管理者 _context.Add(_user3 = new GeneralUser() { AccountName = "user2", DomainId = _domain1.Id }); _context.Add(_availablePeriod = new AvailablePeriod() { EndUser = _user2, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(_availablePeriod = new AvailablePeriod() { EndUser = _user3, EndDate = DateTime.Parse("2021-03-01"), StartDate = DateTime.Parse("2020-02-10") }); _context.Add(_simGroup1 = new SimGroup() { Id = Guid.NewGuid(), Name = "simGroup1", Organization = _org1, Apn = "apn", AuthenticationServerIp = "AuthenticationServerIp", IsolatedNw1IpPool = "IsolatedNw1IpPool", IsolatedNw1SecondaryDns = "IsolatedNw1SecondaryDns", IsolatedNw1IpRange = "IsolatedNw1IpRange", IsolatedNw1PrimaryDns = "IsolatedNw1PrimaryDns", NasIp = "NasIp", PrimaryDns = "PrimaryDns", SecondaryDns = "SecondaryDns" }); _context.Add(_simGroup2 = new SimGroup { Id = Guid.NewGuid(), Name = "simGroup2", Organization = _org2, IsolatedNw1IpPool = "" }); _context.Add(_sim1 = new Sim() // 組織 : '自組織 { Msisdn = "msisdn01", Imsi = "imsi01", IccId = "iccid01", UserName = "******", Password = "******", SimGroup = _simGroup1 }); _context.Add(_device1 = new Device() { LteModule = null, Domain = _domain1, Name = "device01", UseTpm = true, ManagedNumber = "001", WindowsSignInListCacheDays = 1, }); _context.Add(_simDevice1 = new SimAndDevice() { Sim = _sim1, Device = _device1, IsolatedNw2Ip = "127.0.0.1/18", AuthenticationDuration = 1, StartDate = DateTime.Parse("2020-02-01"), EndDate = DateTime.Parse("2021-02-01") }); _context.Add(_multiFactor1 = new MultiFactor { SimAndDeviceId = _simDevice1.Id, EndUserId = _user3.Id, ClosedNwIp = "127.0.0.1", StartDate = DateTime.Now, EndDate = DateTime.Now }); _context.SaveChanges(); }