public void Delete(int id)
{
var task = TaskListContext.Tasks.First(t => t.Id == id);
TaskListContext.Tasks.Remove(task);
TaskListContext.SaveChanges();
}
public Task Create(Task task)
{
var createdTask = TaskListContext.Tasks.Add(task).Entity;
TaskListContext.SaveChanges();
return(createdTask);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, TaskListContext dbContext)
{
using (var serviceScope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope())
{
var context = serviceScope.ServiceProvider.GetRequiredService <TaskListContext>();
context.Database.EnsureCreated();
}
app.UseMvc();
app.UseDefaultFiles();
app.UseStaticFiles();
}
public void Delete(int id)
{
var taskList = TaskListContext.TaskLists.Where(t => t.Id == id).Include(t => t.Tasks).First();
if (taskList.Tasks != null)
{
foreach (var task in taskList.Tasks)
{
TaskListContext.Tasks.Remove(task);
}
}
TaskListContext.Remove(taskList);
TaskListContext.SaveChanges();
}
public TaskList Create(TaskList taskList)
{
var createdTasks = new List <Task>();
foreach (var task in taskList.Tasks)
{
var createdTask = TaskListContext.Tasks.Add(task).Entity;
createdTasks.Add(createdTask);
}
taskList.Tasks = createdTasks;
var createdTaskList = TaskListContext.TaskLists.Add(taskList).Entity;
TaskListContext.SaveChanges();
return(createdTaskList);
}
public TaskList Update(TaskList taskList)
{
var tasksFromDb = TaskListContext.Tasks.Where(t => t.TaskListId == taskList.Id);
//are there tasks which were previously in tasklist but no longer?
var tasksToRemove = new List <Task>();
foreach (var taskFromDb in tasksFromDb)
{
if (!taskList.Tasks.Any(t => t.Id == taskFromDb.Id))
{
tasksToRemove.Add(taskFromDb);
}
}
TaskListContext.Tasks.RemoveRange(tasksToRemove);
var tasks = taskList.Tasks;
taskList.Tasks = new List <Task>();
foreach (var task in tasks)
{
if (TaskListContext.Tasks.Any(t => t.Id == task.Id))
{
taskList.Tasks.Add(TaskListContext.Tasks.First(t => t.Id == task.Id));
}
else
{
taskList.Tasks.Add(TaskListContext.Tasks.Add(task).Entity);
}
}
TaskListContext.Update(taskList);
TaskListContext.SaveChanges();
return(taskList);
}
public EfGenericRepository(TaskListContext context)
{
_context = context;
_dbSet = context.Set <TEntity>();
}
public TaskListRepository(TaskListContext taskListContext) : base(taskListContext)
{
}
//Constructor, which will build an instance of TaskListContext when called
public HomeController(TaskListContext con)
{
context = con;
}
public UserController(TaskListContext context)
{
_context = context;
}
public TeamInfoRepository(TaskListContext taskListContext)
{
db = taskListContext;
}
public ValuesController(TaskListContext context)
{
_context = context;
}
public TodoController(TaskListContext context)
{
_todoService = new TodoService();
}
public ProjectsRepository(TaskListContext taskListContext)
{
_context = taskListContext;
}
public EfUnitOfWork(string connectionString)
{
_databaseContext = new TaskListContext(connectionString);
}
public UnitOfWork(TaskListContext context)
{
_context = context;
}
public TaskRepository(TaskListContext context)
{
this.db = context;
}
public AttachmentTypeRepository(TaskListContext taskListContext)
{
db = taskListContext;
}
public UsersRepository(TaskListContext taskListContext)
{
db = taskListContext;
}
public RolesRepository(TaskListContext taskListContext)
{
db = taskListContext;
}
public EFUnitOfWork(DbContextOptions options)
{
db = new TaskListContext(options);
}
public HomeController(ILogger <HomeController> logger, TaskListContext con)
{
_logger = logger;
context = con;
}
/// <summary>
/// Contrutor da classe com os parametros que serão injetados automaticamente.
/// </summary>
/// <param name="db">Contexto do banco de dados</param>
public RepositoryBase(TaskListContext db)
{
this._db = db;
}
public TaskController(TaskListContext db)
{
_db = db;
}
public EFUnitOfWork(string connectionString)
{
db = new TaskListContext(connectionString);
}
public ProjectRepository(TaskListContext context)
{
this.db = context;
}
public TasksController(TaskListContext context)
{
_context = context;
}
public HomeController(TaskListContext taskListContext)
{
_taskListContext = taskListContext;
}
public TodoAndUsersRepository(TaskListContext taskListContext)
{
_context = taskListContext;
}
public TodoAndAttachesRepository(TaskListContext taskListContext)
{
db = taskListContext;
}
