public UserService(
UserManager <ApplicationUser> userManager,
FmsDbContext context,
IHttpContextAccessor httpContextAccessor)
{
_userManager = userManager;
_context = context;
_httpContextAccessor = httpContextAccessor;
}
public DefaultAnswerService(
FmsDbContext context,
IMemoryCache cache,
IConfigurationProvider mappingConfiguration,
UserManager <UserEntity> userManager)
{
_context = context;
_mappingConfiguration = mappingConfiguration;
_userManager = userManager;
_mapper = _mappingConfiguration.CreateMapper();
}
public static async Task <IReadOnlyList <CabinetSummaryDto> > GetCabinetListAsync(
this FmsDbContext context, bool includeInactive = true)
{
var cabinets = await context.Cabinets.AsNoTracking()
.Where(e => e.Active || includeInactive)
.OrderBy(e => e.FirstFileLabel)
.ThenBy(e => e.Name)
.Select(e => new CabinetSummaryDto(e)).ToListAsync();
// loop through all the cabinets except the last one and set last file label
for (var i = 0; i < cabinets.Count - 1; i++)
{
cabinets[i].LastFileLabel = cabinets[i + 1].FirstFileLabel;
}
return(cabinets);
}
public static async Task SeedDataAsync(this FmsDbContext context, CancellationToken token)
{
if (!await context.FacilityStatuses.AnyAsync(token))
{
await context.FacilityStatuses.AddRangeAsync(GetFacilityStatuses(), token);
}
if (!await context.FacilityTypes.AnyAsync(token))
{
await context.FacilityTypes.AddRangeAsync(GetFacilityTypes(), token);
}
if (!await context.OrganizationalUnits.AnyAsync(token))
{
await context.OrganizationalUnits.AddRangeAsync(GetOrganizationalUnits(), token);
}
if (!await context.BudgetCodes.AnyAsync(token))
{
await context.BudgetCodes.AddRangeAsync(GetBudgetCodes(), token);
}
if (!await context.ComplianceOfficers.AnyAsync(token))
{
await context.ComplianceOfficers.AddRangeAsync(GetComplianceOfficers(), token);
}
if (!await context.Cabinets.AnyAsync(token))
{
await context.Cabinets.AddRangeAsync(GetCabinets(), token);
}
if (!await context.Files.AnyAsync(token))
{
await context.Files.AddRangeAsync(GetFiles(), token);
}
if (!await context.Facilities.AnyAsync(token))
{
await context.Facilities.AddRangeAsync(GetFacilities(), token);
}
if (!await context.RetentionRecords.AnyAsync(token))
{
await context.RetentionRecords.AddRangeAsync(GetRetentionRecords(), token);
}
await context.SaveChangesAsync(token);
}
public static Task CreateStoredProceduresAsync(this FmsDbContext context) => context.Database.ExecuteSqlRawAsync(CreateSpGetNearbyFacilities);
public static async Task AddTestData(
FmsDbContext context,
UserManager <UserEntity> userManager)
{
if (context.Questions.Any())
{
// Already has data
return;
}
var adminUser = userManager.Users
.SingleOrDefault(u => u.Email == "*****@*****.**");
context.Questions.Add(new QuestionEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9195976"),
Description = "How do you rate the overall event?",
Answers = new[]
{
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9995971"),
Description = "1",
Icon = "far fa-angry fa-5x text-red",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9195981"),
Description = "2",
Icon = "far fa-frown fa-5x text-yellow-darker",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9195972"),
Description = "3",
Icon = "far fa-meh fa-5x text-warning",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9195961"),
Description = "4",
Icon = "far fa-smile fa-5x text-lime",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9195971"),
Description = "5",
Icon = "far fa-grin-hearts fa-5x text-green",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
}
},
User = adminUser,
Active = true,
AllowMultipleAnswer = false,
FreeTextQuestion = false,
CustomQuestion = true,
FeedbackType = "participated",
CreatedAt = DateTimeOffset.UtcNow
});
context.Questions.Add(new QuestionEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9195974"),
Description = "What did you like about this volunteering activity?",
User = adminUser,
Active = true,
AllowMultipleAnswer = false,
FreeTextQuestion = true,
CustomQuestion = false,
FeedbackType = "participated",
CreatedAt = DateTimeOffset.UtcNow
});
context.Questions.Add(new QuestionEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9195975"),
Description = "What can be improved in this volunteering activity?",
User = adminUser,
Active = true,
AllowMultipleAnswer = false,
FreeTextQuestion = true,
CustomQuestion = false,
FeedbackType = "participated",
CreatedAt = DateTimeOffset.UtcNow
});
context.Questions.Add(new QuestionEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9e9195973"),
Description = "Hey there, You had registered for the event on saturday. We would like to know the reason for not joining the event to understand if the team which created the event has some room for improvement in their process, so that we get 100% participation from the registered attendees.",
Answers = new[]
{
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-25a9e9995971"),
Description = "Unexpected Personal Committment",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-26a9e9995971"),
Description = "Unexpected Official Work",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-27a9e9995971"),
Description = "Even Not What I Expected",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-28a9e9995971"),
Description = "Did Not Receive Further Information About The Event",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-29a9e9995971"),
Description = "Incorrectly Registered",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-24a9e9995971"),
Description = "Do Not Wish to Disclose",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
}
},
User = adminUser,
Active = true,
AllowMultipleAnswer = false,
FreeTextQuestion = false,
CustomQuestion = false,
FeedbackType = "notparticipated",
CreatedAt = DateTimeOffset.UtcNow
});
context.Questions.Add(new QuestionEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-35a9c9195975"),
Description = "Hey there, Please share your feedback for unregistering from the event ?",
Answers = new[]
{
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-45a9e9995971"),
Description = "Unexpected Personal Committment",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-46a9e9995971"),
Description = "Unexpected Official Work",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-47a9e9995971"),
Description = "Even Not What I Expected",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-48a9e9995971"),
Description = "Did Not Receive Further Information About The Event",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-49a9e9995971"),
Description = "Incorrectly Registered",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
},
new AnswerEntity
{
Id = Guid.Parse("ee2b83be-91db-4de5-8122-50a9e9995971"),
Description = "Do Not Wish to Disclose",
Active = true,
CreatedAt = DateTimeOffset.UtcNow
}
},
User = adminUser,
Active = true,
AllowMultipleAnswer = false,
FreeTextQuestion = false,
CustomQuestion = false,
FeedbackType = "unregistered",
CreatedAt = DateTimeOffset.UtcNow
});
await context.SaveChangesAsync();
}
public DefaultParticipantService(FmsDbContext context, IConfigurationProvider mappingConfiguration)
{
_context = context;
_mappingConfiguration = mappingConfiguration;
_mapper = _mappingConfiguration.CreateMapper();
}
protected Query()
{
var db = new FmsDbContext();
_dataAccessor = new DataAccessor(db.Connection);
}
public BudgetCodeRepository(FmsDbContext context) => _context = context;
public FileRepository(FmsDbContext context) => _context = context;
private RepositoryHelper()
{
_context = new FmsDbContext(_options, default);
_context.Database.EnsureCreated();
SeedAllData();
}
public FacilityRepository(FmsDbContext context) => _context = context;
public ComplianceOfficerRepository(FmsDbContext context) => _context = context;
public ItemsListRepository(FmsDbContext context) => _context = context;
public CabinetRepository(FmsDbContext context) => _context = context;
public OrganizationalUnitRepository(FmsDbContext context) => _context = context;
