public User GetById(int id) { using (var context = new UserTaskContext(_connectionString)) { return(context.Users.FirstOrDefault(u => u.Id == id)); } }
public User GetByEmail(string email) { using (var context = new UserTaskContext(_connectionString)) { return(context.Users.FirstOrDefault(u => u.Email == email)); } }
public IEnumerable <UserTask> GetUncompletedTasks() { using (var context = new UserTaskContext(connectionString)) { return(context.Tasks.Include(t => t.User).Where(t => !t.Completed).ToList()); } }
public UserTask GetById(int taskId) { using (var context = new UserTaskContext(connectionString)) { return(context.Tasks.Include(t => t.User).FirstOrDefault(i => i.Id == taskId)); } }
public bool EmailAvailable(string email) { using (var context = new UserTaskContext(_connectionString)) { bool isUsed = context.Users.Any(u => u.Email == email); return(isUsed); } }
public void AddTask(UserTask task) { using (var context = new UserTaskContext(connectionString)) { context.Tasks.Add(task); context.SaveChanges(); } }
public void MarkComplete(int taskId) { using (var context = new UserTaskContext(connectionString)) { var task = context.Tasks.FirstOrDefault(t => t.Id == taskId); task.Completed = true; context.SaveChanges(); } }
public void MarkTaken(int taskId, int userId) { using (var context = new UserTaskContext(connectionString)) { context.Database.ExecuteSqlCommand( "UPDATE Tasks SET UndertakenBy = @userId WHERE Id = @taskId", new SqlParameter("@userId", userId), new SqlParameter("@taskId", taskId)); } }
public void AddUser(User user, string password) { user.PasswordHash = BCrypt.Net.BCrypt.HashPassword(password); using (var context = new UserTaskContext(connectionString)) { context.Users.Add(user); context.SaveChanges(); } }
public void ChangeStatus(int TaskId, TaskStatus status, User user) { var task = GetTaskById(TaskId); task.Status = status; task.TakenUserId = user.Id; using (var context = new UserTaskContext(_connectionString)) { context.UserTasks.Attach(task); context.Entry(task).State = EntityState.Modified; context.SaveChanges(); } }
public void AddTask(string task) { UserTask userTask = new UserTask { Task = task, Status = TaskStatus.NotTaken, Id = 0 }; using (var context = new UserTaskContext(_connectionString)) { context.UserTasks.Add(userTask); context.SaveChanges(); } }
public List <UserTask> GetTasks(User u) { using (var context = new UserTaskContext(_connectionString)) { var userTasks = context.UserTasks.Where(ut => ut.Status != TaskStatus.Completed).ToList(); foreach (UserTask ut in userTasks) { if (ut.Status == TaskStatus.Taken && ut.TakenUserId == u.Id) { ut.Status = TaskStatus.TakenByThisUser; } } return(userTasks); } }