public UserForClient GetUser(string Email) { User userFromDB = new User(); userFromDB.Email = Email; string sql = "SELECT * FROM Users WHERE Email=@Email "; DB.PullFromDB(sql, (cmd) => cmd.Parameters.AddWithValueCheckNull("@Email", userFromDB.Email), (dr) => userFromDB = new User(dr)); UserForClient user = new UserForClient(userFromDB); return(user); }
public bool Delete(string Email) { UserForClient user = GetUser(Email); string UserPermission = user.UserPermission; bool delete = DB.ExecuteCommand("DELETE FROM Users WHERE Email = @Email", (cmd) => cmd.Parameters.AddWithValue("@Email", Email)) == 1; if (delete) { UserForClient.DeleteUser(Email, UserPermission); return(true); } return(false); }