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