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