public static void AddTask(Task task)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
taskManagerDbContext.Tasks.Add(task);
taskManagerDbContext.SaveChanges();
}
public static void AddTasks(List <Task> tasks)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
taskManagerDbContext.Tasks.AddRange(tasks);
taskManagerDbContext.SaveChanges();
}
/* Methods */
public static Task GetTask(int taskId)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
Task task = taskManagerDbContext.Tasks.Find(taskId);
return(task);
}
public async Task <User> GetUserById(int id)
{
using (var taskManagerDbContext = new TaskManagerDbContext())
{
return(await taskManagerDbContext.Users.FindAsync(id));
}
}
public static async Task MigrateDatabasesAsync()
{
using (var dbContext = new TaskManagerDbContext(GetDbContextOptions<TaskManagerDbContext>()))
{
await dbContext.Database.MigrateAsync();
}
}
public async Task <List <User> > GetAllUsers()
{
using (var taskManagerDbContext = new TaskManagerDbContext())
{
return(await taskManagerDbContext.Users.ToListAsync());
}
}
public List <Project> Get()
{
TaskManagerDbContext db = new TaskManagerDbContext();
List <Project> projects = db.Projects.ToList();
return(projects);
}
/* Methods */
public static User GetUser(int userId)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
User user = taskManagerDbContext.Users.Find(userId);
return(user);
}
public async System.Threading.Tasks.Task <List <Task> > GetAllTasks()
{
using (var taskManagerDbContext = new TaskManagerDbContext())
{
return(await taskManagerDbContext.Tasks.ToListAsync());
}
}
public async System.Threading.Tasks.Task <Task> GetTaskByEndDate(DateTime endDate)
{
using (var taskManagerDbContext = new TaskManagerDbContext())
{
return(await taskManagerDbContext.Tasks.FirstOrDefaultAsync(x => x.EndDate == endDate));
}
}
public static void ShowUser(int userId)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
User user = taskManagerDbContext.Users.Find(userId);
Console.WriteLine($"{user.UserId} - {user.Name}");
}
public async System.Threading.Tasks.Task <Task> GetTaskByTitle(string title)
{
using (var taskManagerDbContext = new TaskManagerDbContext())
{
return(await taskManagerDbContext.Tasks.FirstOrDefaultAsync(x => x.Title.ToLower() == title.ToLower()));
}
}
public async System.Threading.Tasks.Task <Task> GetTaskByType(TaskType type)
{
using (var taskManagerDbContext = new TaskManagerDbContext())
{
return(await taskManagerDbContext.Tasks.FindAsync(type));
}
}
public async System.Threading.Tasks.Task <Task> GetTaskById(int id)
{
using (var taskManagerDbContext = new TaskManagerDbContext())
{
return(await taskManagerDbContext.Tasks.FindAsync(id));
}
}
public async Task <User> GetUserByName(string name)
{
using (var taskManagerDbContext = new TaskManagerDbContext())
{
return(await taskManagerDbContext.Users.FirstOrDefaultAsync(x => x.Name.ToLower() == name.ToLower()));
}
}
public static void MigrateDatabases()
{
using (var dbContext = new TaskManagerDbContext(GetDbContextOptions<TaskManagerDbContext>()))
{
dbContext.Database.Migrate();
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, TaskManagerDbContext dbContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseWebpackDevMiddleware(new WebpackDevMiddlewareOptions
{
HotModuleReplacement = true
});
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseAuthentication();
app.UseStaticFiles();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
routes.MapSpaFallbackRoute(
name: "spa-fallback",
defaults: new { controller = "Home", action = "Index" });
});
}
public static void AddUser(User user)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
taskManagerDbContext.Users.Add(user);
taskManagerDbContext.SaveChanges();
}
public static void AddUsers(List <User> users)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
taskManagerDbContext.Users.AddRange(users);
taskManagerDbContext.SaveChanges();
}
public void Configure(IApplicationBuilder app,
IWebHostEnvironment env,
TaskManagerDbContext context,
UserManager <ApplicationUser> userManager,
RoleManager <IdentityRole> roleManager)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
InitializeDb.SeedDatabase(context, userManager, roleManager);
}
app.UseHttpsRedirection();
app.UseRouting();
app.UseStaticFiles(); // wwwroot folder access
app.UseAuthentication();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
app.UseSwagger();
app.UseSwaggerUI(c => { c.SwaggerEndpoint("v1/swagger.json", "TaskManager"); }); // http://localhost/swagger
}
/* Methods */
public static Priority GetPriority(int priorityId)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
Priority priority = taskManagerDbContext.Priorities.Find(priorityId);
return(priority);
}
public static void DeleteTask(int taskId)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
Task task = taskManagerDbContext.Tasks.Find(taskId);
taskManagerDbContext.Tasks.Remove(task);
taskManagerDbContext.SaveChanges();
}
public Project Post([FromBody] Project project)
{
TaskManagerDbContext db = new TaskManagerDbContext();
db.Projects.Add(project);
db.SaveChanges();
return(project);
}
public static void ChangeStatusTask(int taskId)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
Task task = taskManagerDbContext.Tasks.Find(taskId);
task.Status = !task.Status;
taskManagerDbContext.SaveChanges();
}
public static void DeleteUser(int userId)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
User user = taskManagerDbContext.Users.Find(userId);
taskManagerDbContext.Users.Remove(user);
taskManagerDbContext.SaveChanges();
}
public static void ShowTask(int taskId)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
Task task = taskManagerDbContext.Tasks.Include(t => t.User).Include(t => t.Priority).Where(t => t.TaskId == taskId).First();
string status = task.Status ? "Complete" : "Incomplete";
Console.WriteLine($"({task.TaskId}) - [{task.Priority.Title}] - {task.Title} - ({status}) - {task.User.Name} - [{task.DueDate.ToShortDateString()}]");
}
public static void UpdateUser(int userId, string name)
{
TaskManagerDbContext taskManagerDbContext = new TaskManagerDbContext();
User user = taskManagerDbContext.Users.Find(userId);
user.Name = name;
taskManagerDbContext.SaveChanges();
}
public static void Initialize(TaskManagerDbContext dbContext)
{
if (dbContext.Tasks.Any())
{
return;
}
Seed(dbContext);
}
public NotificationService(
TaskManagerDbContext context,
IHubContext <NotificationsHub> notificationsHub,
IAccountService accountService)
{
this.context = context;
this.notificationsHub = notificationsHub;
this.accountService = accountService;
}
private static void Seed(TaskManagerDbContext dbContext)
{
//var parentTask = GetParentTasks()
var tasks = GetTasks();
dbContext.Tasks.AddRange(tasks);
dbContext.SaveChanges();
}
