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