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);
}
}
