public bool UserExists(string email)
{
using (var context = new SharedTasksDBDataContext(_connectionString))
{
return(context.Users.Any(u => u.Email == email));
}
}
public void SetTaskAsCompleted(int taskId)
{
using (var context = new SharedTasksDBDataContext(_connectionString))
{
context.ExecuteCommand("UPDATE Tasks SET IsCompleted = 1 WHERE Id = {0}", taskId);
}
}
public void SetUserForTask(int taskId, int userId)
{
using (var context = new SharedTasksDBDataContext(_connectionString))
{
context.ExecuteCommand("UPDATE Tasks SET UserId = {0} WHERE Id = {1}", userId, taskId);
}
}
public User GetUser(int id)
{
using (var context = new SharedTasksDBDataContext(_connectionString))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <User>(u => u.Tasks);
context.LoadOptions = loadOptions;
return(context.Users.FirstOrDefault(u => u.Id == id));
}
}
private User GetUser(string email)
{
using (var context = new SharedTasksDBDataContext(_connectionString))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <User>(u => u.Tasks);
context.LoadOptions = loadOptions;
return(context.Users.FirstOrDefault(u => u.Email == email));
}
}
public IEnumerable <Task> GetUnresolvedTasks()
{
using (var context = new SharedTasksDBDataContext(_connectionString))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <Task>(t => t.User);
context.LoadOptions = loadOptions;
return(context.Tasks.Where(t => !t.IsCompleted).ToList());
}
}
public void AddTask(Task t)
{
t.Date = DateTime.Now.Date;
t.IsCompleted = false;
using (var context = new SharedTasksDBDataContext(_connectionString))
{
context.Tasks.InsertOnSubmit(t);
context.SubmitChanges();
}
}
public int AddUser(string firstName, string lastName, string email, string password)
{
string salt = GenerateSalt();
string hash = HashPassword(password, salt);
using (var context = new SharedTasksDBDataContext(_connectionString))
{
User user = new User
{
Email = email,
FirstName = firstName,
LastName = lastName,
PasswordHash = hash,
PasswordSalt = salt
};
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
return(user.Id);
}
}
