public static IEnumerable <BudgetCategory> GetAll()
{
using (var context = new CCDPlannerDBContext())
{
IEnumerable <BudgetCategory> categories = context.BudgetCategories.Where(x => x.ParentCategory == null).ToList();
categories = Traverse(categories);
return(categories);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(
IApplicationBuilder app,
IHostingEnvironment env,
CCDPlannerDBContext dbContext,
DbIdentityInitializer dbIdentityInitializer
)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseCors(b => b.AllowAnyOrigin()
.AllowAnyHeader()
.AllowAnyMethod()
.AllowCredentials()
);
// Set up custom content types -associating file extension to MIME type
var provider = new FileExtensionContentTypeProvider();
// Add new mappings
provider.Mappings[".woff"] = "application/font-woff";
app.UseStaticFiles(new StaticFileOptions()
{
ContentTypeProvider = provider
});
// Identity
app.UseAuthentication();
app.Use(async(context, next) =>
{
await next();
if (context.Response.StatusCode == 404 &&
!Path.HasExtension(context.Request.Path.Value) &&
!context.Request.Path.Value.StartsWith("api"))
{
string actualpath = "/index.html";
context.Request.Path = actualpath;
context.Response.StatusCode = 200;
await next();
}
});
app.UseDefaultFiles();
app.UseStaticFiles();
app.UseMvc();
DbInitializer.Initialize(dbContext);
dbIdentityInitializer.Seed().Wait();
}
private static IEnumerable <BudgetCategory> Traverse(IEnumerable <BudgetCategory> categories)
{
using (var context = new CCDPlannerDBContext())
{
foreach (var category in categories)
{
var subCategories = context.BudgetCategories.Where(x => x.ParentCategoryId == category.BudgetCategoryId).ToList();
category.ChildrenCategories = subCategories;
category.ChildrenCategories = Traverse(category.ChildrenCategories).ToList();
}
return(categories);
}
}
protected override BudgetCategory UpdateEntity(CCDPlannerDBContext entityContext, BudgetCategory entity)
{
throw new NotImplementedException();
}
protected override BudgetCategory GetEntity(CCDPlannerDBContext entityContext, Guid id)
{
return(GetEntities(entityContext).Where(c => c.BudgetCategoryId == id).FirstOrDefault());
}
protected override IEnumerable <BudgetCategory> GetEntities(CCDPlannerDBContext entityContext)
{
IEnumerable <BudgetCategory> categories = entityContext.BudgetCategories;
return(categories.Where(c => c.ParentCategoryId == null));
}
protected override BudgetCategory AddEntity(CCDPlannerDBContext entityContext, BudgetCategory entity)
{
return(entityContext.BudgetCategories.Add(entity).Entity);
}