public void AddTask(Task task) { using (var context = new userandtaskDataContext(_connectionString)) { context.Tasks.InsertOnSubmit(task); context.SubmitChanges(); } }
public void CompleteTask(int id) { using (var context = new userandtaskDataContext(_connectionString)) { var task = context.Tasks.FirstOrDefault(t => t.Id == id); task.Status = Status.Completed; context.SubmitChanges(); } }
public void SelectTask(int userId, int taskId) { using (var context = new userandtaskDataContext(_connectionString)) { var task = context.Tasks.FirstOrDefault(t => t.Id == taskId); task.UserId = userId; task.Status = Status.Taken; context.SubmitChanges(); } }
public void Register(User user, string password) { string passwordSalt = PasswordHelper.GenerateSalt(); string passwordHash = PasswordHelper.HashPassword(password, passwordSalt); user.PasswordHash = passwordHash; user.PasswordSalt = passwordSalt; using (var context = new userandtaskDataContext(_connectionString)) { context.Users.InsertOnSubmit(user); context.SubmitChanges(); } }