public List <UserTask> GetUserTasks() { using (var cxt = new UserTaskContext(_connectionString)) { return(cxt.Tasks.ToList()); } }
public User GetByEmail(string email) { using (var context = new UserTaskContext(_connectionString)) { return(context.Users.FirstOrDefault(u => u.Email == email)); } }
public void AddTask(UserTask task) { using (var cxt = new UserTaskContext(_connectionString)) { cxt.Tasks.Add(task); cxt.SaveChanges(); } }
public void DeleteTask(int userTaskId) { using (var context = new UserTaskContext(_connectionString)) { context.Database.ExecuteSqlCommand( "DELETE FROM Tasks WHERE Id = @id", new SqlParameter("@id", userTaskId)); } }
public void UpdateTask(UserTask task) { using (var context = new UserTaskContext(_connectionString)) { context.Tasks.Attach(task); context.Entry(task).State = EntityState.Modified; context.SaveChanges(); } }
public void AddUser(User user, string password) { user.PasswordHash = BCrypt.Net.BCrypt.HashPassword(password); using (var context = new UserTaskContext(_connectionString)) { context.Users.Add(user); context.SaveChanges(); } }