/// <see cref="PersonDAL.GetPersonByClinicalAdministratorID(Clinical_Administrator)"/>
public Person GetPersonByClinicalAdministratorID(Clinical_Administrator admin)
{
if (admin == null || admin.ID == null)
{
throw new ArgumentNullException("admin and its id cannot be null");
}
return(PersonDAL.GetPersonByClinicalAdministratorID(admin));
}
/// <summary>
/// Gets the Person of the Clinical_Administor by their adminID.
///
/// Returns password as null.
/// </summary>
/// <param name="admin">Clinical_Administrator whose Person you desire</param>
/// <returns>Person of the Clinical_Administrator</returns>
public static Person GetPersonByClinicalAdministratorID(Clinical_Administrator admin)
{
Person person = null;
String selectStatement = @"SELECT Person.id, username, firstName, lastName, dateOfBirth, ssn, gender, addressID, contactPhone
FROM Person
JOIN Clinical_Administrator on Person.id = Clinical_Administrator.personID
WHERE Clinical_Administrator.id = @adminID";
using (SqlConnection connection = GetSQLConnection.GetConnection())
{
using (SqlCommand command = new SqlCommand(selectStatement, connection))
{
command.Parameters.AddWithValue("@adminID", admin.ID);
connection.Open();
person = GetPerson(command);
}
}
return(person);
}
