public User GetByEmail(string email)
{
using (var context = new RealTimeTasksDataContext(_connectionString))
{
return(context.Users.FirstOrDefault(u => u.EmailAddress == email));
}
}
public void SetCompleted(int taskId)
{
using (var context = new RealTimeTasksDataContext(_connectionString))
{
context.ExecuteCommand("UPDATE TaskItems SET IsCompleted = 1 WHERE Id = {0}",
taskId);
}
}
public void SetDoing(int taskId, int userId)
{
using (var context = new RealTimeTasksDataContext(_connectionString))
{
context.ExecuteCommand("UPDATE TaskItems SET HandledBy = {0} WHERE Id = {1}",
userId, taskId);
}
}
public void AddTask(TaskItem task)
{
using (var context = new RealTimeTasksDataContext(_connectionString))
{
context.TaskItems.InsertOnSubmit(task);
context.SubmitChanges();
}
}
public IEnumerable <TaskItem> GetActiveTasks()
{
using (var context = new RealTimeTasksDataContext(_connectionString))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <TaskItem>(t => t.User);
context.LoadOptions = loadOptions;
return(context.TaskItems.Where(t => !t.IsCompleted).ToList());
}
}
public void AddUser(User user, string password)
{
string salt = PasswordHelper.GenerateSalt();
string passwordHash = PasswordHelper.HashPassword(password, salt);
user.PasswordSalt = salt;
user.PasswordHash = passwordHash;
using (var context = new RealTimeTasksDataContext(_connectionString))
{
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
}
}