public void addUser(User user) { string queryString = "addUser"; SqlCommand command = new SqlCommand(queryString, conn); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@userName", user.getUsername())); command.Parameters.Add(new SqlParameter("@password", user.getPassword())); command.Parameters.Add(new SqlParameter("@userType", user.isAdmin())); command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); reader.Close(); }
public bool validateLogin(User user) { string procedureName = "validateLogin"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@userName", user.getUsername())); parameters.Add(new SqlParameter("@givenPW", user.getPassword())); SqlDataReader reader = executeStoredProcedure(procedureName, parameters); reader.Read(); bool isValid = reader.GetBoolean(0); closeReader(ref reader); return(isValid); }