// get all director records
public List <DirectorDTO> GetAllDirector()
{
// list for storing director objects
List <DirectorDTO> directorList = new List <DirectorDTO>();
try
{
// get all rows in the table using query
tabDirectorTableAdapter.Fill(tabDirectorDataTable);
// convert rows into objects
foreach (DataRow directorRow in tabDirectorDataTable.Rows)
{
DirectorDTO director = new DirectorDTO
{
DID = (int)directorRow[0],
DirectorName = (string)directorRow[1]
};
directorList.Add(director);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(directorList);
}
// update a director row
public bool IsDirectorUpdated(DirectorDTO updatedDirector)
{
try
{
// update row using query
tabDirectorTableAdapter.UpdateDirector(updatedDirector.DirectorName, updatedDirector.DID);
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
// add new director row into Director table
public bool IsDirectorInserted(DirectorDTO newDirector)
{
try
{
// insert row using query
tabDirectorTableAdapter.InsertDirector(newDirector.DirectorName);
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}