public void NoKill()
{
_Dtp.Snapshot = new DateTime(2020, 6, 20, 0, 0, 0, DateTimeKind.Utc);
Add(1, 0, null);
_DbContext.SaveChanges();
var result = _Command.Execute();
Assert.Equal(1, result.Before.Count);
Assert.Equal(1, result.Before.Expired);
Assert.Equal(1, result.Before.Unauthorised);
Assert.Equal(0, result.Before.Authorised);
Assert.Equal(0, result.Before.AuthorisedAndFullyPublished);
Assert.Equal(0, result.Before.TekCount);
Assert.Equal(0, result.Before.TekPublished);
Assert.Equal(0, result.Before.TekUnpublished);
Assert.Equal(0, result.GivenMercy);
Assert.Equal(0, result.After.Count);
Assert.Equal(0, result.After.Expired);
Assert.Equal(0, result.After.Unauthorised);
Assert.Equal(0, result.After.Authorised);
Assert.Equal(0, result.After.AuthorisedAndFullyPublished);
Assert.Equal(0, result.After.TekCount);
Assert.Equal(0, result.After.TekPublished);
Assert.Equal(0, result.After.TekUnpublished);
}
public async Task PostSecretTest_5RetriesAndBang()
{
_DbContext.KeyReleaseWorkflowStates.AddRange(Enumerable.Range(1, 5).Select(Create));
_DbContext.SaveChanges();
// Arrange
var client = _Factory.CreateClient();
_FakeNumbers.Value = 1;
// Act
var result = await client.PostAsync("v1/register", null);
Assert.AreEqual(HttpStatusCode.OK, result.StatusCode);
Assert.AreEqual("{\"labConfirmationId\":null,\"bucketId\":null,\"confirmationKey\":null,\"validity\":-1}", await result.Content.ReadAsStringAsync());
}
private void CreateEditions()
{
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition == null)
{
defaultEdition = new Edition {
Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName
};
_context.Editions.Add(defaultEdition);
_context.SaveChanges();
/* Add desired features to the standard edition, if wanted... */
}
}
private void PostTeks()
{
var b = _DbContext.KeyReleaseWorkflowStates.Find(_BucketPk);
b.TeksTouched = true;
_DbContext.SaveChanges();
}
public string DeleteWorkFlow(string fids)
{
try
{
var workflowDefs = context.WF_WORKFLOW_DEF.Where <WF_WORKFLOW_DEF>(m => fids.Contains(m.WD_SHORT_NAME));
foreach (var workflow in workflowDefs)
{
context.WF_WORKFLOW_DEF.Remove(workflow);
}
context.SaveChanges();
return("1");
}
catch
{
return("0");
}
}
public void Create()
{
new DefaultEditionCreator(_context).Create();
new DefaultLanguagesCreator(_context).Create();
new HostRoleAndUserCreator(_context).Create();
new DefaultSettingsCreator(_context).Create();
_context.SaveChanges();
}
private void AddSettingIfNotExists(string name, string value, int?tenantId = null)
{
if (_context.Settings.IgnoreQueryFilters().Any(s => s.Name == name && s.TenantId == tenantId && s.UserId == null))
{
return;
}
_context.Settings.Add(new Setting(tenantId, null, name, value));
_context.SaveChanges();
}
private void AddLanguageIfNotExists(ApplicationLanguage language)
{
if (_context.Languages.IgnoreQueryFilters().Any(l => l.TenantId == language.TenantId && l.Name == language.Name))
{
return;
}
_context.Languages.Add(language);
_context.SaveChanges();
}
public void Execute()
{
var expired = _DateTimeProvider.Now() - TimeSpan.FromMinutes(_KeysLastWorkflowConfig.AuthorisationWindowDurationMinutes);
_DbContextProvider.BeginTransaction();
throw new NotImplementedException();
//var q = _DbContextProvider.KeysLastWorkflows
// .Where(x => x.State == KeysLastWorkflowState.Receiving && x.AuthorisationWindowStart < expired);
//_DbContextProvider.KeysLastWorkflows.RemoveRange(q);
_DbContextProvider.SaveChanges();
_DbContextProvider.SaveAndCommit();
}
public void Execute()
{
var expired = _DateTimeProvider.Now() - TimeSpan.FromDays(_KeysLastWorkflowConfig.SecretLifetimeDays);
_DbContextProvider.BeginTransaction();
throw new NotImplementedException();
//var q = _DbContextProvider.KeysLastWorkflows
// .Where(x => x.State == KeysLastWorkflowState.Unauthorised && x.Created < expired);
//_DbContextProvider.KeysLastWorkflows.RemoveRange(q);
_DbContextProvider.SaveChanges();
_DbContextProvider.SaveAndCommit();
}
public string DeleteWorkFlowInst(string fids)
{
try
{
var workflowInsts = context.WF_WORKFLOW_INST.Where <WF_WORKFLOW_INST>(m => fids.Contains(m.WI_ID));
foreach (var workflowInst in workflowInsts)
{
context.WF_WORKFLOW_INST.Remove(workflowInst);
}
context.SaveChanges();
return("1");
}
catch
{
return("0");
}
}
private void UpdateWorkflow(BaseWorkflow workflow, UserWorkflow existingUserWorkflow)
{
//not updating the primary properties e.g. sourceEmailAddress, expiresIn etc.
existingUserWorkflow.SetPersonal(workflow.WorkflowData.FirstName, workflow.WorkflowData.LastName, workflow.WorkflowData.Email);
existingUserWorkflow.SetWork(workflow.WorkflowData.Work);
existingUserWorkflow.SetAddress(workflow.WorkflowData.Street, workflow.WorkflowData.City, workflow.WorkflowData.Zip, workflow.WorkflowData.State);
existingUserWorkflow.UpdateStatus(workflow.Status);
foreach (var step in existingUserWorkflow.Steps)
{
if (step.TrackingState == TrackingState.Updated)
{
_db.Entry(step).State = EntityState.Modified;
}
}
_db.Entry(existingUserWorkflow).State = EntityState.Modified;
_db.SaveChanges();
}
private void CreateDefaultTenant()
{
// Default tenant
var defaultTenant = _context.Tenants.IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == AbpTenantBase.DefaultTenantName);
if (defaultTenant == null)
{
defaultTenant = new Tenant(AbpTenantBase.DefaultTenantName, AbpTenantBase.DefaultTenantName);
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition != null)
{
defaultTenant.EditionId = defaultEdition.Id;
}
_context.Tenants.Add(defaultTenant);
_context.SaveChanges();
}
}
public WorkflowControllerPostKeysTests()
{
WorkflowDbContext DbcFac() => new WorkflowDbContext(new DbContextOptionsBuilder().UseSqlServer($"Data Source=.;Database={nameof(WorkflowControllerPostKeysTests)};Integrated Security=True").Options);
_DbContext = DbcFac();
_Factory = WithWebHostBuilder(builder =>
{
builder.ConfigureTestServices(services =>
{
services.AddScoped(sp =>
{
var context = DbcFac();
context.BeginTransaction();
return(context);
});
});
builder.ConfigureAppConfiguration((ctx, config) =>
{
config.AddInMemoryCollection(new Dictionary <string, string>
{
["Validation:TemporaryExposureKey:RollingPeriod:Min"] = "1",
["Validation:TemporaryExposureKey:RollingPeriod:Max"] = "256"
});
});
});
_DbContext.Database.EnsureDeleted();
_DbContext.Database.EnsureCreated();
_DbContext.KeyReleaseWorkflowStates.Add(new TekReleaseWorkflowStateEntity
{
BucketId = _BucketId,
ValidUntil = DateTime.UtcNow.AddHours(1),
Created = DateTime.UtcNow,
ConfirmationKey = _Key,
});
_DbContext.SaveChanges();
}
private void CreateRolesAndUsers()
{
// Admin role
var adminRole = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin);
if (adminRole == null)
{
adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin)
{
IsStatic = true
}).Entity;
_context.SaveChanges();
}
// Grant all permissions to admin role
var grantedPermissions = _context.Permissions.IgnoreQueryFilters()
.OfType <RolePermissionSetting>()
.Where(p => p.TenantId == _tenantId && p.RoleId == adminRole.Id)
.Select(p => p.Name)
.ToList();
var permissions = PermissionFinder
.GetAllPermissions(new WorkflowAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant) &&
!grantedPermissions.Contains(p.Name))
.ToList();
if (permissions.Any())
{
_context.Permissions.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = _tenantId,
Name = permission.Name,
IsGranted = true,
RoleId = adminRole.Id
})
);
_context.SaveChanges();
}
// Admin user
var adminUser = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == AbpUserBase.AdminUserName);
if (adminUser == null)
{
adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**");
adminUser.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(adminUser, "123qwe");
adminUser.IsEmailConfirmed = true;
adminUser.IsActive = true;
_context.Users.Add(adminUser);
_context.SaveChanges();
// Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id));
_context.SaveChanges();
}
}
private void CreateHostRoleAndUsers()
{
// Admin role for host
var adminRoleForHost = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin);
if (adminRoleForHost == null)
{
adminRoleForHost = _context.Roles.Add(new Role(null, StaticRoleNames.Host.Admin, StaticRoleNames.Host.Admin)
{
IsStatic = true, IsDefault = true
}).Entity;
_context.SaveChanges();
}
// Grant all permissions to admin role for host
var grantedPermissions = _context.Permissions.IgnoreQueryFilters()
.OfType <RolePermissionSetting>()
.Where(p => p.TenantId == null && p.RoleId == adminRoleForHost.Id)
.Select(p => p.Name)
.ToList();
var permissions = PermissionFinder
.GetAllPermissions(new WorkflowAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host) &&
!grantedPermissions.Contains(p.Name))
.ToList();
if (permissions.Any())
{
_context.Permissions.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = null,
Name = permission.Name,
IsGranted = true,
RoleId = adminRoleForHost.Id
})
);
_context.SaveChanges();
}
// Admin user for host
var adminUserForHost = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == null && u.UserName == AbpUserBase.AdminUserName);
if (adminUserForHost == null)
{
var user = new User
{
TenantId = null,
UserName = AbpUserBase.AdminUserName,
Name = "admin",
Surname = "admin",
EmailAddress = "*****@*****.**",
IsEmailConfirmed = true,
IsActive = true
};
user.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(user, "123qwe");
user.SetNormalizedNames();
adminUserForHost = _context.Users.Add(user).Entity;
_context.SaveChanges();
// Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id));
_context.SaveChanges();
_context.SaveChanges();
}
}