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