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