public User GetUserById(int id)
{
using (var context = new userandtaskDataContext(_connectionString))
{
return(context.Users.FirstOrDefault(u => u.Id == id));
}
}
public User GetByEmail(string email)
{
using (var context = new userandtaskDataContext(_connectionString))
{
return(context.Users.FirstOrDefault(u => u.Email == email));
}
}
public void AddTask(Task task)
{
using (var context = new userandtaskDataContext(_connectionString))
{
context.Tasks.InsertOnSubmit(task);
context.SubmitChanges();
}
}
public void CompleteTask(int id)
{
using (var context = new userandtaskDataContext(_connectionString))
{
var task = context.Tasks.FirstOrDefault(t => t.Id == id);
task.Status = Status.Completed;
context.SubmitChanges();
}
}
public IEnumerable <Task> GetTasks()
{
using (var context = new userandtaskDataContext(_connectionString))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <Task>(t => t.User);
context.LoadOptions = loadOptions;
return(context.Tasks.ToList());
}
}
public void SelectTask(int userId, int taskId)
{
using (var context = new userandtaskDataContext(_connectionString))
{
var task = context.Tasks.FirstOrDefault(t => t.Id == taskId);
task.UserId = userId;
task.Status = Status.Taken;
context.SubmitChanges();
}
}
public void Register(User user, string password)
{
string passwordSalt = PasswordHelper.GenerateSalt();
string passwordHash = PasswordHelper.HashPassword(password, passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
using (var context = new userandtaskDataContext(_connectionString))
{
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
}
}
public User Login(string email, string password)
{
using (var context = new userandtaskDataContext(_connectionString))
{
var user = GetByEmail(email);
if (user == null)
{
return(null);
}
bool isCorrectPassword = PasswordHelper.PasswordMatch(password, user.PasswordSalt, user.PasswordHash);
if (isCorrectPassword)
{
return(user);
}
return(null);
}
}
