public List <User> GetUserListByFilter(Expression <Func <User, bool> > filter = null)
{
using (var context = new ToDoListDbContext())
{
return(context.Users.Where(filter).ToList());
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ToDoListDbContext context)
{
context.Database.Migrate();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
}
public List <ToDoList> GetToDoListByFilter(Expression <Func <ToDoList, bool> > filter = null)
{
using (var context = new ToDoListDbContext())
{
return(context.ToDoLists.Where(filter).ToList());
}
}
public ActionResult Index()
{
using (ToDoListDbContext db = new ToDoListDbContext())
{
List <Task> tasks = db.Tasks.ToList();
return(View(tasks));
}
}
public Startup(IConfiguration configuration)
{
Configuration = configuration;
//add this: simply creates db if it doesn't exist, no migrations
using (var context = new ToDoListDbContext())
{
context.Database.EnsureCreated();
}
}
public TasksController()
{
var toDoListDbContext = new ToDoListDbContext();
ToDoListDbContext = toDoListDbContext;
TaskManager = new TaskManager <Task>(new TaskStore <Task>(toDoListDbContext));
CategoryManager = new CategoryManager <Category>(new CategoryStore <Category>(toDoListDbContext));
}
public ActionResult Delete(Task task)
{
using (ToDoListDbContext db = new ToDoListDbContext())
{
db.Tasks.Attach(task);
db.Entry(task).State = EntityState.Deleted;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
protected override void OnStartup(StartupEventArgs e)
{
base.OnStartup(e);
var database = new ToDoListDbContext();
database.Database.EnsureCreated();
DatabaseLocator.Database = database;
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
ToDoListDbContext.Dispose();
}
base.Dispose(disposing);
return;
}
public static void SeedHostDb(ToDoListDbContext context)
{
context.SuppressAutoSetTenantId = true;
// Host seed
new InitialHostDbBuilder(context).Create();
// Default tenant seed (in host database).
new DefaultTenantBuilder(context).Create();
new TenantRoleAndUserBuilder(context, 1).Create();
}
public ActionResult Create(Task task)
{
if (!ModelState.IsValid)
{
return(View(task));
}
using (ToDoListDbContext db = new ToDoListDbContext())
{
db.Entry(task).State = EntityState.Added;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (ToDoListDbContext db = new ToDoListDbContext())
{
Task task = db.Tasks.Where(t => t.Id == id).First();
if (task == null)
{
return(HttpNotFound());
}
return(View(task));
}
}
public static async Task AddTestData(ToDoListDbContext context)
{
try
{
if (context.ToDos.Any())
{
return;
}
context.ToDos.AddRange(GetTasks());
await context.SaveChangesAsync();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ToDoListDbContext context)
{
context.Database.Migrate();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=ToDoItems}/{action=Index}/{id?}");
});
}
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ToDoListDbContext db)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
db.Database.EnsureCreated();
app.UseRouting();
app.UseOpenApi();
app.UseSwaggerUi3();
app.UseHangfireDashboard();
app.UseHangfireServer();
RecurringJobs.SendAllTasksDaily();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
public ToDoItemsController(ToDoListDbContext context, IToDoListService <Guid, string> toDo)
{
_context = context;
_toDo = toDo;
}
public DefaultEditionCreator(ToDoListDbContext context)
{
_context = context;
}
public NotesRepository(ToDoListDbContext dbContext)
{
_dbContext = dbContext;
}
public InitialHostDbBuilder(ToDoListDbContext context)
{
_context = context;
}
public ToDoOperationService(ToDoListDbContext context)
{
_context = context;
}
public ToDoListService(ToDoListDbContext context)
{
_context = context;
}
public AssignmentRepository(ToDoListDbContext dbContext) : base(dbContext)
{
}
public ToDoListController(ToDoListDbContext todoContext)
{
_todoContext = todoContext;
}
public HostRoleAndUserCreator(ToDoListDbContext context)
{
_context = context;
}
public PersonService(ILogger <PersonService> logger, ToDoListDbContext context)
{
_logger = logger;
_context = context;
}
public AccountController(UserManager <User> userManager, ToDoListDbContext dbContext)
{
_userManager = userManager;
_dbContext = dbContext;
}
public Repository(ToDoListDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public AccountService(ToDoListDbContext context) => _dbContext = context;
public TaskService(ILogger <TaskService> logger, ToDoListDbContext context)
{
_logger = logger;
_context = context;
}
public TodoController(ToDoListDbContext ToDoListDb)
{
_ToDoListDb = ToDoListDb;
}
