public async Task ResetProjectDataAsync(string projectId)
{
if (String.IsNullOrEmpty(projectId))
{
return;
}
Project project = _projectRepository.GetById(projectId);
if (project == null)
{
return;
}
try {
await _eventRepository.RemoveAllByProjectIdsAsync(new [] { projectId });
await _stackRepository.RemoveAllByProjectIdsAsync(new [] { projectId });
_projectRepository.Save(project);
} catch (Exception e) {
Log.Error().Project(projectId).Exception(e).Message("Error resetting project data.").Write();
throw;
}
}
private void TryDeleteOrganization(Organization organization)
{
try {
Log.Info().Message("Removing existing empty projects for the organization '{0}' with Id: '{1}'.", organization.Name, organization.Id).Write();
List <Project> projects = _projectRepository.GetByOrganizationId(organization.Id).ToList();
if (projects.Any(project => project.TotalEventCount > 0))
{
Log.Info().Message("Organization '{0}' with Id: '{1}' has a project with existing data. This organization will not be deleted.", organization.Name, organization.Id).Write();
return;
}
Log.Info().Message("Deleting all events for organization '{0}' with Id: '{1}'.", organization.Name, organization.Id).Write();
_eventRepository.RemoveAllByProjectIdsAsync(projects.Select(p => p.Id).ToArray()).Wait();
Log.Info().Message("Deleting all stacks for organization '{0}' with Id: '{1}'.", organization.Name, organization.Id).Write();
_stackRepository.RemoveAllByProjectIdsAsync(projects.Select(p => p.Id).ToArray()).Wait();
Log.Info().Message("Deleting all projects for organization '{0}' with Id: '{1}'.", organization.Name, organization.Id).Write();
_projectRepository.Remove(projects);
Log.Info().Message("Removing users from organization '{0}' with Id: '{1}'.", organization.Name, organization.Id).Write();
List <User> users = _userRepository.GetByOrganizationId(organization.Id).ToList();
foreach (User user in users)
{
if (user.OrganizationIds.All(oid => String.Equals(oid, organization.Id)))
{
Log.Info().Message("Removing user '{0}' as they do not belong to any other organizations.", user.Id, organization.Name, organization.Id).Write();
_userRepository.Remove(user.Id);
}
else
{
Log.Info().Message("Removing user '{0}' from organization '{1}' with Id: '{2}'", user.Id, organization.Name, organization.Id).Write();
user.OrganizationIds.Remove(organization.Id);
_userRepository.Save(user);
}
}
Log.Info().Message("Deleting organization '{0}' with Id: '{1}'.", organization.Name, organization.Id).Write();
_organizationRepository.Remove(organization);
// TODO: Send notifications that the organization and projects have been updated.
} catch (Exception ex) {
ex.ToExceptionless().MarkAsCritical().AddTags("Remove Stale Accounts").AddObject(organization).Submit();
}
}
public override async Task HandleItemAsync(WorkItemContext context)
{
var workItem = context.GetData <RemoveProjectWorkItem>();
Log.Info("Received remove project work item for: {0} Reset Data: {1}", workItem.ProjectId, workItem.Reset);
await context.ReportProgressAsync(0, "Starting deletion...").AnyContext();
var project = await _projectRepository.GetByIdAsync(workItem.ProjectId).AnyContext();
if (project == null)
{
await context.ReportProgressAsync(100, workItem.Reset? "Project data reset" : "Project deleted").AnyContext();
return;
}
if (!workItem.Reset)
{
await context.ReportProgressAsync(20, "Removing tokens").AnyContext();
await _tokenRepository.RemoveAllByOrganizationIdsAsync(new[] { project.Id }).AnyContext();
await context.ReportProgressAsync(40, "Removing web hooks").AnyContext();
await _webHookRepository.RemoveAllByOrganizationIdsAsync(new[] { project.Id }).AnyContext();
}
await context.ReportProgressAsync(60, "Resetting project data").AnyContext();
await _eventRepository.RemoveAllByProjectIdsAsync(new[] { project.Id }).AnyContext();
await _stackRepository.RemoveAllByProjectIdsAsync(new[] { project.Id }).AnyContext();
if (!workItem.Reset)
{
await context.ReportProgressAsync(80, "Removing project").AnyContext();
await _projectRepository.RemoveAsync(project.Id).AnyContext();
}
await context.ReportProgressAsync(100, workItem.Reset? "Project data reset" : "Project deleted").AnyContext();
}
private void TryDeleteOrganization(Organization organization)
{
try {
Log.Info().Message("Removing empty projects: org=\"{0}\" id={1}", organization.Name, organization.Id).Write();
List <Project> projects = _projectRepository.GetByOrganizationId(organization.Id).ToList();
if (projects.Any(project => _eventRepository.GetCountByProjectId(project.Id) > 0))
{
Log.Info().Message("Organization has data: org=\"{0}\" id={1}", organization.Name, organization.Id).Write();
return;
}
Log.Info().Message("Deleting events: org=\"{0}\" id={1}", organization.Name, organization.Id).Write();
_eventRepository.RemoveAllByProjectIdsAsync(projects.Select(p => p.Id).ToArray()).Wait();
Log.Info().Message("Deleting stacks: org=\"{0}\" id={1}", organization.Name, organization.Id).Write();
_stackRepository.RemoveAllByProjectIdsAsync(projects.Select(p => p.Id).ToArray()).Wait();
Log.Info().Message("Deleting projects: org=\"{0}\" id={1}", organization.Name, organization.Id).Write();
_projectRepository.Remove(projects);
Log.Info().Message("Removing users from organization '{0}' with Id: '{1}'.", organization.Name, organization.Id).Write();
List <User> users = _userRepository.GetByOrganizationId(organization.Id).ToList();
foreach (User user in users)
{
if (user.OrganizationIds.All(oid => String.Equals(oid, organization.Id)))
{
Log.Info().Message("Removing user '{0}' as they do not belong to any other organizations.", user.Id, organization.Name, organization.Id).Write();
_userRepository.Remove(user.Id);
}
else
{
Log.Info().Message("Removing user '{0}' from organization '{1}' with id: '{2}'", user.Id, organization.Name, organization.Id).Write();
user.OrganizationIds.Remove(organization.Id);
_userRepository.Save(user);
}
}
Log.Info().Message("Deleting organization '{0}' with Id: '{1}'.", organization.Name, organization.Id).Write();
_organizationRepository.Remove(organization);
} catch (Exception ex) {
Log.Error().Message("Error removing stale org: org={0} id={1} message=\"{2}\"", organization.Name, organization.Id, ex.Message).Exception(ex).Write();
}
}
public override async Task HandleItemAsync(WorkItemContext context)
{
var workItem = context.GetData <RemoveOrganizationWorkItem>();
_logger.Info("Received remove organization work item for: {0}", workItem.OrganizationId);
await context.ReportProgressAsync(0, "Starting deletion...").AnyContext();
var organization = await _organizationRepository.GetByIdAsync(workItem.OrganizationId).AnyContext();
if (organization == null)
{
await context.ReportProgressAsync(100, "Organization deleted").AnyContext();
return;
}
await context.ReportProgressAsync(10, "Removing subscriptions").AnyContext();
if (!String.IsNullOrEmpty(organization.StripeCustomerId))
{
_logger.Info("Canceling stripe subscription for the organization '{0}' with Id: '{1}'.", organization.Name, organization.Id);
var subscriptionService = new StripeSubscriptionService(Settings.Current.StripeApiKey);
var subscriptions = subscriptionService.List(organization.StripeCustomerId).Where(s => !s.CanceledAt.HasValue);
foreach (var subscription in subscriptions)
{
subscriptionService.Cancel(organization.StripeCustomerId, subscription.Id);
}
}
await context.ReportProgressAsync(20, "Removing users").AnyContext();
var users = await _userRepository.GetByOrganizationIdAsync(organization.Id).AnyContext();
foreach (User user in users.Documents)
{
// delete the user if they are not associated to any other organizations and they are not the current user
if (user.OrganizationIds.All(oid => String.Equals(oid, organization.Id)) && !String.Equals(user.Id, workItem.CurrentUserId))
{
_logger.Info("Removing user '{0}' as they do not belong to any other organizations.", user.Id, organization.Name, organization.Id);
await _userRepository.RemoveAsync(user.Id).AnyContext();
}
else
{
_logger.Info("Removing user '{0}' from organization '{1}' with Id: '{2}'", user.Id, organization.Name, organization.Id);
user.OrganizationIds.Remove(organization.Id);
await _userRepository.SaveAsync(user, true).AnyContext();
}
}
await context.ReportProgressAsync(30, "Removing tokens").AnyContext();
await _tokenRepository.RemoveAllByOrganizationIdsAsync(new[] { organization.Id }).AnyContext();
await context.ReportProgressAsync(40, "Removing web hooks").AnyContext();
await _webHookRepository.RemoveAllByOrganizationIdsAsync(new[] { organization.Id }).AnyContext();
await context.ReportProgressAsync(50, "Removing projects").AnyContext();
var projects = await _projectRepository.GetByOrganizationIdAsync(organization.Id).AnyContext();
if (workItem.IsGlobalAdmin && projects.Total > 0)
{
var completed = 1;
foreach (Project project in projects.Documents)
{
_logger.Info("Resetting all project data for project '{0}' with Id: '{1}'.", project.Name, project.Id);
await _eventRepository.RemoveAllByProjectIdsAsync(new[] { project.Id }).AnyContext();
await _stackRepository.RemoveAllByProjectIdsAsync(new[] { project.Id }).AnyContext();
await context.ReportProgressAsync(CalculateProgress(projects.Total, completed++, 51, 89), "Removing projects...").AnyContext();
}
_logger.Info("Deleting all projects for organization '{0}' with Id: '{1}'.", organization.Name, organization.Id);
await _projectRepository.RemoveAsync(projects.Documents).AnyContext();
}
_logger.Info("Deleting organization '{0}' with Id: '{1}'.", organization.Name, organization.Id);
await context.ReportProgressAsync(90, "Removing organization").AnyContext();
await _organizationRepository.RemoveAsync(organization.Id).AnyContext();
await context.ReportProgressAsync(100, "Organization deleted").AnyContext();
}
