public List <UserTask> GetUserTasks()
{
using (var cxt = new UserTaskContext(_connectionString))
{
return(cxt.Tasks.ToList());
}
}
public User GetByEmail(string email)
{
using (var context = new UserTaskContext(_connectionString))
{
return(context.Users.FirstOrDefault(u => u.Email == email));
}
}
public void AddTask(UserTask task)
{
using (var cxt = new UserTaskContext(_connectionString))
{
cxt.Tasks.Add(task);
cxt.SaveChanges();
}
}
public void DeleteTask(int userTaskId)
{
using (var context = new UserTaskContext(_connectionString))
{
context.Database.ExecuteSqlCommand(
"DELETE FROM Tasks WHERE Id = @id",
new SqlParameter("@id", userTaskId));
}
}
public void UpdateTask(UserTask task)
{
using (var context = new UserTaskContext(_connectionString))
{
context.Tasks.Attach(task);
context.Entry(task).State = EntityState.Modified;
context.SaveChanges();
}
}
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();
}
}