// gets the directors name using the directors id
public static string FetchDirector(int id)
{
string sql = SqlProcedures.FetchDirector(id);
DataTable temp = Call(sql);
return(temp.Rows[0][0].ToString());
}