private ContainerModel GetContainerModel(int userId) { var container = new ContainerModel(); //container.Title = "My Notes"; using (var slideDb = new SlideContext()) { var homeFolder = slideDb.Folders.FirstOrDefault(f => f.UserId == userId && f.ParentId == null); var childFolders = slideDb.Folders.Where(f => f.ParentId == homeFolder.Id).ToList(); var notes = slideDb.Notes.Where(n => n.ParentId == homeFolder.Id).ToList(); container.Folders = MapFolderModel(childFolders); container.Notes = MapNoteModel(notes); } container.BreadCrumb = new List <BreadCrumbModel> { new BreadCrumbModel { Title = "Home", FolderId = 1, IsActive = false }, new BreadCrumbModel { Title = "My Notes", FolderId = 2, IsActive = true } }; return(container); }
int GetChildCount(int folderId) { using (var slideDb = new SlideContext()) { return(slideDb.Notes.Where(n => n.ParentId == folderId).Count()); } }
public EfCoreSlideReader(SlideContext slideContext, ILogger <EfCoreSlideWriter> logger) { _slideContext = slideContext; _logger = logger; }
public EfCoreSlideWriter(SlideContext dbContext, ILogger <EfCoreSlideWriter> logger) { _dbContext = dbContext; _logger = logger; }
public DatabaseInitializationStartupFilter(SlideContext dbContext, ILogger <DatabaseInitializationStartupFilter> logger) { _dbContext = dbContext; _logger = logger; }