public User GetById(int id)
{
using (var context = new UsersTasksDataContext(_connectionString))
{
return(context.Users.Where(u => u.Id == id).FirstOrDefault());
}
}
public void CompleteTask(int taskId)
{
using (var context = new UsersTasksDataContext(_connectionString))
{
context.ExecuteCommand("Update tasks set completed=1 where Id={0}", taskId);
}
}
public void UpdateTaskWithUser(int taskId, int userId)
{
using (var context = new UsersTasksDataContext(_connectionString))
{
context.ExecuteCommand("Update tasks set userId={0} where Id={1}", userId, taskId);
}
}
public int getIdByEmail(string email)
{
using (var context = new UsersTasksDataContext(_connectionString))
{
User user = context.Users.Where(u => u.EmailAddress == email).FirstOrDefault();
return(user.Id);
}
}
public IEnumerable <Task> GetUncompletedTasks()
{
using (var context = new UsersTasksDataContext(_connectionString))
{
DataLoadOptions loadOptions = new DataLoadOptions();
loadOptions.LoadWith <Task>(t => t.User);
context.LoadOptions = loadOptions;
return(context.Tasks.Where(t => t.Completed == false).ToList());
}
}
public void AddTask(String taskTitle)
{
using (var context = new UsersTasksDataContext(_connectionString))
{
Task task = new Task();
task.Title = taskTitle;
context.Tasks.InsertOnSubmit(task);
context.SubmitChanges();
}
}
public User signedInUser(string EmailAddress, string Password)
{
using (var context = new UsersTasksDataContext(_connectionString))
{
User user = context.Users.Where(u => u.EmailAddress == EmailAddress).FirstOrDefault();
if (PasswordHelper.PasswordMatch(Password, user.PassSalt, user.PassHash))
{
return(user);
}
else
{
return(null);
}
}
}
public void signUp(string FirstName, string LastName, string EmailAddress, string Password)
{
string passSalt = PasswordHelper.GenerateSalt();
string passHash = PasswordHelper.HashPassword(Password, passSalt);
User user = new User();
user.FirstName = FirstName;
user.LastName = LastName;
user.EmailAddress = EmailAddress;
user.PassSalt = passSalt;
user.PassHash = passHash;
using (var context = new UsersTasksDataContext(_connectionString))
{
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
}
}
