public void AddCompletedTask(AddCompletedTask task) { var sql = @" insert into TasksCompleted ([Description], DateCreated, Category, UserID) values (@Description, @DateCreated, @Category, @UserId)"; using (var conn = _dbConnectionProvider.GetOpenWsidnConnection()) { conn.Execute(sql, task); } }
public IActionResult Complete(int id) { var taskToComplete = _taskCommands.GetTask(id, _userId); if (taskToComplete == null) { return(new NotFoundResult()); } //Save the completed task to the completed tasks table var completedTask = new AddCompletedTask { Description = taskToComplete.Description, DateCreated = taskToComplete.DateCreated, Category = taskToComplete.Category, UserId = _userId }; _taskCommands.AddCompletedTask(completedTask); //Check if the task is repeating, if not, delete it if (taskToComplete.IntervalByHour == 0) { _taskCommands.DeleteTaskTodo(id, _userId); } //if the task IS repeating, update the DateStart field to the future (vs. right now) else { _taskCommands .UpdateTaskDateStart( id, DateTime.Now.AddHours(taskToComplete.IntervalByHour), _userId ); } return(new LocalRedirectResult(_homeRedirectUrl)); }