// Get all directors that currently exist. This is used when a form is opened to populate the dropdown boxes.
public static List <string> RetrieveDirectors()
{
DataTable temp = Call(SqlProcedures.RetrieveDirectors());
List <string> directors = new List <string>();
for (int i = 0; i < temp.Rows.Count; i++)
{
if (temp.Rows[i][1].ToString()[0] != '?')
{
directors.Add(temp.Rows[i][1].ToString());
}
}
return(directors);
}