// 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 MediaDAO()
{
mediaDataSet = new MediaDS();
tabMediaAdapter = new TabMediaTableAdapter();
viewMediaTableAdapter = new ViewMediaTableAdapter();
tabGenreTableAdapter = new TabGenreTableAdapter();
tabLanguageTableAdapter = new TabLanguageTableAdapter();
tabDirectorTableAdapter = new TabDirectorTableAdapter();
}
public MediaDAO()
{
viewMediaAdapter = new ViewMediaTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
tabMediaTableAdapter = new TabMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
tabReserveTableAdapter = new TabReservedTableAdapter();
tabBorrowTableAdapter = new TabBorrowTableAdapter();
}
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaTableAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
mediaTableAdapter = new TabMediaTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
reservedTableAdapter = new TabReservedTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
}
public int UpdateDirector(string directorName, int directorID)
{
var directorTable = new UserData.TabDirectorDataTable();
var directorAdapter = new TabDirectorTableAdapter();
int rowCount = 0;
if (directorName != null)
{
rowCount = directorAdapter.UpdateDirector(directorName, directorID);
}
return(rowCount);
}
public int InsertDirector(String directorName)
{
var directorTable = new UserData.TabDirectorDataTable();
var directorAdapter = new TabDirectorTableAdapter();
int rowCount = 0;
if (directorName != null)
{
rowCount = directorAdapter.InsertDirector(directorName);
return(rowCount);
}
return(rowCount);
}
public List <Directors> getDirectors()
{
List <Directors> directors = new List <Directors>();
var directorsTable = new UserData.TabDirectorDataTable();
var directorsAdapater = new TabDirectorTableAdapter();
int rowCount = directorsAdapater.getDirectors(directorsTable);
if (rowCount > 0)
{
foreach (DataRow dr in directorsTable)
{
Directors dir = new Directors();
dir.DID = int.Parse(dr["DID"].ToString());
dir.DirectorName = dr["DirectorName"].ToString();
directors.Add(dir);
}
}
return(directors);
}
public void DeleteDirector(int directorID)
{
var directorTable = new UserData.TabDirectorDataTable();
var directorAdapter = new TabDirectorTableAdapter();
int rowCount = directorAdapter.DeleteDirector(directorID);
}
