// get director ID based on director name
public static int GetDID(string directorName)
{
int dID = -1;
MediaDataSet.TabDirectorDataTable tabDirectorDataTable = new MediaDataSet.TabDirectorDataTable();
TabDirectorTableAdapter tabDirectorTableAdapter = new TabDirectorTableAdapter();
try
{
// retrieve data from database
tabDirectorTableAdapter.SelectDirector(tabDirectorDataTable, directorName);
// convert data into int
dID = (int)tabDirectorDataTable.Rows[0]["DID"];
}
catch (IndexOutOfRangeException e)
{
Console.WriteLine(directorName + " cannot be found in the database.");
Console.WriteLine(e.Message);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(dID);
}
public List <PairModel> GetDirectors()
{
List <PairModel> pairList = new List <PairModel>();
MediaDataSet.TabDirectorDataTable directorTable = mediaDAO.GetDirectors();
if (directorTable != null)
{
foreach (MediaDataSet.TabDirectorRow row in directorTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairList.Add(pair);
}
return(pairList);
}
else
{
return(null);
}
}