public void RemoveAllEntities(MainDbContext context, RadiusDbContext radiusDbContext) { context.RemoveRange(context.AuthenticationLog); // 認証操作 context.RemoveRange(context.AuthenticationState); // 認証状態 context.RemoveRange(context.MultiFactor); // 多要素組合せ context.RemoveRange(context.SimAndDevice); // SIM & 端末組合せ context.RemoveRange(context.Sim); // SIM context.RemoveRange(context.SimGroup); // SIMグループ context.RemoveRange(context.Device); // 端末 context.RemoveRange(context.LteModule); // LTEモジュール context.RemoveRange(context.DeviceGroup); // 端末グループ context.RemoveRange(context.DeviceGroupDevice); // 端末グループ - 端末 context.RemoveRange(context.OrganizationClientApp); // 組織端末アプリ context.RemoveRange(context.ClientApp); // JinCreek端末アプリ context.RemoveRange(context.ClientOs); // JinCreekサポート端末OS context.RemoveRange(context.AvailablePeriod); // 利用期間 context.RemoveRange(context.User); // ユーザー context.RemoveRange(context.UserGroup); // ユーザーグループ context.RemoveRange(context.UserGroupEndUser); // ユーザーグループ - ユーザー context.RemoveRange(context.Domain); // ドメイン context.RemoveRange(context.Organization); // 組織 radiusDbContext.RemoveRange(radiusDbContext.Radusergroup); radiusDbContext.RemoveRange(radiusDbContext.Radcheck); radiusDbContext.RemoveRange(radiusDbContext.Radgroupcheck); radiusDbContext.RemoveRange(radiusDbContext.Radgroupreply); radiusDbContext.RemoveRange(radiusDbContext.Radippool); context.SaveChanges(); radiusDbContext.SaveChanges(); }
public void CreateDataCase17() { CreateBaseData(); var simAndDeviceAuthenticated = new SimAndDeviceAuthenticated() { SimAndDevice = SimAndDevice1, Expiration = CurrentDateTimeForLessThanStart.Item2 }; MainDbContext.AddRange(simAndDeviceAuthenticated); SimAndDevice1.SimAndDeviceAuthenticated = simAndDeviceAuthenticated; var multiFactorAuthenticated = new MultiFactorAuthenticated() { MultiFactor = MultiFactor1, Expiration = CurrentDateTimeForLessThanStart.Item2 }; MainDbContext.AddRange(multiFactorAuthenticated); MultiFactor1.MultiFactorAuthenticated = multiFactorAuthenticated; MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void SetUpInsertDataForCase02() { SetUpInsertBaseDataForDeauthenticationRadiusDb(); MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase04() { CreateBaseData(); Organization.StartDate = CurrentDateTimeForStart.Item2; // '実行日より未来 MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase08() { CreateBaseData(); Organization.StartDate = CurrentDateTimeForEnd.Item1; // '実行日より過去 Organization.EndDate = CurrentDateTimeForEnd.Item1; // '実行日より過去 MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase06() { CreateBaseData(); Organization.StartDate = CurrentDateTimeForStart.Item1; // '実行日と同日 Organization.EndDate = CurrentDateTimeForStart.Item2; // '実行日より未来 SimGroup1.IsolatedNw1IpRange = "192.168.1.128/32"; // '有効ホストIP数=1個 サブネット=32bit MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); // radiusのデータなし }
//public void SetUpInsertDataForCase03() //{ // SetUpInsertBaseDataForDeauthenticationRadiusDb(); // MainDbContext.SaveChanges(); // RadiusDbContext.SaveChanges(); //} //public void SetUpInsertDataForCase04() //{ // SetUpInsertBaseDataForDeauthenticationRadiusDb(); // MainDbContext.SaveChanges(); // RadiusDbContext.SaveChanges(); //} //public void SetUpInsertDataForCase05() //{ // var (simAndDevice, _, _) = InsertSimDevice(CurrentDateTimeForEnd, true); // simAndDevice.SimAndDeviceAuthenticated.Id = Guid.NewGuid(); // SetUpInsertBaseDataForDeauthenticationRadiusDb(); // MainDbContext.SaveChanges(); // RadiusDbContext.SaveChanges(); //} public void SetUpInsertDataForCase06() { var(simDevice, _, _) = InsertSimDevice(CurrentDateTimeForEnd, true); simDevice.SimAndDeviceAuthenticated.Id = Guid.Parse("0e4e88ae-c880-11e2-8598-5855cafa776a"); SetUpInsertBaseDataForDeauthenticationRadiusDb(); MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void SetUpInsertBaseDataForDeauthenticationRadiusDb() { //base.SetUpInsertBaseDataForRadiusDb(); RadiusDbContext.SaveChanges(); var radreply = RadiusDbContext.Radreply.Where(r => r.Username == "user1@jincreek2" && r.Attribute == "Framed-IP-Address").Single(); RadiusDbContext.SaveChanges(); radreply.Value = "NwAddress"; }
public void CreateDataCase05() { CreateBaseData(); Organization.StartDate = CurrentDateTimeForStart.Item1; // '実行日と同日 Organization.EndDate = CurrentDateTimeForStart.Item1; // '実行日と同日 MainDbContext.SaveChanges(); MainDbContext.RemoveRange(MainDbContext.Sim); MainDbContext.RemoveRange(MainDbContext.SimGroup); // sim と SimGroupない MainDbContext.SaveChanges(); SetDataForNotSim(); SetDataForNotSimGroup(); RadiusDbContext.SaveChanges(); }
public void SetUpInsertDataForCase08() { var(simDevice, _, _) = InsertSimDevice(CurrentDateTimeForEnd, true); simDevice.SimAndDeviceAuthenticated.Id = Guid.Parse("0e4e88ae-c880-11e2-8598-5855cafa776a"); SetUpInsertFactorCombinationAndEndUser(simDevice, "AdminAccount", "AccountUser1", CurrentDateTimeForEnd, CurrentDateTimeForEnd); SetUpInsertBaseDataForDeauthenticationRadiusDb(); MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase07() { CreateBaseData(); Organization.Code = 5; Organization.StartDate = CurrentDateTimeForStart.Item1; // '実行日と同日 Organization.EndDate = null; // 不在 //Ad-Domain-2-3-5 //JinCreek-Domain-3-5-6 SetDataDeviceGroup06(); SetDataUserGroup06(); MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
private void SetUpInsertBaseDataForRadiusDb() { var radreply = new Radreply { Username = "******", Op = "=", Attribute = "RadreplyAttribute1", Value = "Nw1Address" }; _radiusDbContext.Radreply.Add(radreply); _radiusDbContext.SaveChanges(); }
public void CreateDataCase10() { CreateBaseData(); var simAndDeviceAuthenticated = new SimAndDeviceAuthenticated() { SimAndDevice = SimAndDevice1, Expiration = CurrentDateTimeForEnd.Item2 }; MainDbContext.AddRange(simAndDeviceAuthenticated); SimAndDevice1.SimAndDeviceAuthenticated = simAndDeviceAuthenticated; MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase04() { CreateBaseData(); var multiFactorAuthenticated = new MultiFactorAuthenticated() { MultiFactor = MultiFactor1, Expiration = CurrentDateTimeForEnd.Item2 }; MainDbContext.AddRange(multiFactorAuthenticated); MultiFactor1.MultiFactorAuthenticated = multiFactorAuthenticated; MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase02() { MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase03() { CreateBaseData(); MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase09() { CreateBaseData(); Organization.StartDate = CurrentDateTimeForEnd.Item1; // '実行日より過去 Organization.EndDate = CurrentDateTimeForStart.Item1; // '実行日と同日 SimGroup1.IsolatedNw1IpRange = "192.168.1.0/30"; // '有効ホストIP数=2個(サブネット = 30bit)※NIP最小アドレス var radgroupcheck1 = new Radgroupcheck() // SimGroupいるの Radgroupcheck Radgroupreply { Attribute = "Pool-Name", Groupname = SimGroup1.Id.ToString(), Op = ":=", Value = SimGroup1.IsolatedNw1IpPool }; var radgroupcheck2 = new Radgroupcheck() { Attribute = "Called-Station-Id", Groupname = SimGroup1.Id.ToString(), Op = "==", Value = SimGroup1.Apn }; var radgroupcheck3 = new Radgroupcheck() { Attribute = "NAS-IP-Address", Groupname = SimGroup1.Id.ToString(), Op = "==", Value = SimGroup1.NasIp }; var radgroupreply1 = new Radgroupreply() { Attribute = "MS-Primary-DNS-Server", Groupname = SimGroup1.Id.ToString(), Op = ":=", Value = SimGroup1.PrimaryDns }; var radgroupreply2 = new Radgroupreply() { Attribute = "MS-Secondary-DNS-Server", Groupname = SimGroup1.Id.ToString(), Op = ":=", Value = SimGroup1.SecondaryDns }; var radcheck1 = new Radcheck() // SimいるのRadcheckとRadusergroup { Username = Sim1.UserName + "@" + Sim1.SimGroup.UserNameSuffix, Attribute = "Cleartext-Password", Op = ":=", Value = Sim1.Password }; var radcheck2 = new Radcheck() { Username = Sim1.UserName + "@" + Sim1.SimGroup.UserNameSuffix, Attribute = "Calling-Station-Id", Op = "==", Value = Sim1.Msisdn }; var radusergroup = new Radusergroup() { Username = Sim1.UserName + "@" + Sim1.SimGroup.UserNameSuffix, Groupname = Sim1.SimGroup.Id.ToString() }; var radippool = new Radippool() { Framedipaddress = "192.168.1.1", //'Simgroup1のCIDR別有効ホストIP範囲に含まれる Nasipaddress = "", Calledstationid = "", Callingstationid = "", Username = "", Poolkey = "", PoolName = SimGroup1.IsolatedNw1IpPool }; var radippool2 = new Radippool() { Framedipaddress = "192.168.1.100", //'Simgroup1のCIDR別有効ホストIP範囲に含まれない Nasipaddress = "", Calledstationid = "", Callingstationid = "", Username = "", Poolkey = "", PoolName = SimGroup1.IsolatedNw1IpPool }; SetDataForNotSim(); RadiusDbContext.AddRange(radgroupcheck1, radgroupcheck2, radgroupcheck3, radgroupreply1, radgroupreply2, radcheck1, radcheck2, radusergroup, radippool, radippool2); MainDbContext.Sim.Add(new Sim() { Msisdn = "111111111", Imsi = "11111111111", IccId = "1111111111", UserName = "******", Password = "******", SimGroup = SimGroup1 }); MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }
public void CreateDataCase07() { CreateBaseData(); Organization.StartDate = CurrentDateTimeForStart.Item1; // '実行日と同日 Organization.EndDate = null; // 不在 SimGroup1.IsolatedNw1IpRange = "192.168.1.128/32"; // '有効ホストIP数=1個 サブネット=32bit var simGroup2 = new SimGroup() { Organization = Organization, Name = "SimGroup2", Apn = "apn.example.com", NasIp = "192.168.0.2", IsolatedNw1IpPool = "ip_pool_2", IsolatedNw1IpRange = "192.168.1.255/30", // '有効ホストIP数=2個 サブネット=30bit)※NIP最大(要補正)アドレス AuthenticationServerIp = "172.16.0.1", PrimaryDns = "192.168.0.2", SecondaryDns = "192.168.0.3", UserNameSuffix = "jincreek2" }; var simGroup3 = new SimGroup() { Organization = Organization, Name = "SimGroup3", Apn = "apn.example.com", NasIp = "192.168.0.2", IsolatedNw1IpPool = "ip_pool_3", IsolatedNw1IpRange = "192.168.1.64/31", // '有効ホストIP数=0個(サブネット = 31bit) AuthenticationServerIp = "172.16.0.1", PrimaryDns = "192.168.0.2", SecondaryDns = "192.168.0.3", UserNameSuffix = "jincreek3" }; MainDbContext.Sim.Add(new Sim() // sim_1 { Msisdn = "111111112", Imsi = "11111111112", IccId = "1111111112", UserName = "******", Password = "******", SimGroup = SimGroup1 }); var sim2 = new Sim() // sim_2 { Msisdn = "111111113", Imsi = "11111111113", IccId = "1111111113", UserName = "******", Password = "******", SimGroup = simGroup2 }; RadiusDbContext.Radcheck.Add(new Radcheck() // SimいるのRadcheckとRadusergroup { Username = sim2.UserName + "@" + sim2.SimGroup.UserNameSuffix, Attribute = "Cleartext-Password", Op = ":=", Value = sim2.Password }); RadiusDbContext.Radcheck.Add(new Radcheck() { Username = sim2.UserName + "@" + sim2.SimGroup.UserNameSuffix, Attribute = "Calling-Station-Id", Op = "==", Value = Sim1.Msisdn }); RadiusDbContext.Radusergroup.Add(new Radusergroup() { Username = sim2.UserName + "@" + sim2.SimGroup.UserNameSuffix, Groupname = sim2.SimGroup.Id.ToString(), }); RadiusDbContext.Radippool.Add(new Radippool() { Framedipaddress = "192.168.1.100", //'simGroup3のCIDR別有効ホストIP範囲に含まれない Nasipaddress = "", Calledstationid = "", Callingstationid = "", Username = "", Poolkey = "", PoolName = simGroup3.IsolatedNw1IpPool }); SetDataForNotSimGroup(); MainDbContext.SaveChanges(); RadiusDbContext.SaveChanges(); }