public MediaLogic()
{
mediaDAO = new MediaDAO();
mediaTable = new MediaDS.ViewMediaDataTable();
languageTable = new MediaDS.TabLanguageDataTable();
genreTable = new MediaDS.TabGenreDataTable();
directorTable = new MediaDS.TabDirectorDataTable();
borrowTable = new MediaDS.TabBorrowDataTable();
mediaAvailableTable = new MediaDS.ViewMediaAvailableDataTable();
mediaBorrowedTable = new MediaDS.ViewMediaBorrowedDataTable();
}
//Director tabel
public List <IdAndValue> getAllDirectorTable()
{
List <IdAndValue> myList = new List <IdAndValue>();
MediaDS.TabDirectorDataTable myData = mediaDAO.getAllDirectors();
//parse data from datatable rows to list elements
myList = parseDirectorDataTolist(myData);
return(myList);
}
public List <PairModel> ListDirector()
{
List <PairModel> list = new List <PairModel>();
directorTable = mediaDAO.ListDirector();
foreach (MediaDS.TabDirectorRow row in directorTable.Rows)
{
PairModel pair = PairModel.Parse(row);
list.Add(pair);
}
return(list);
}
public List <PairModel> ListDirector()
{
List <PairModel> pairs = new List <PairModel>();
MediaDS.TabDirectorDataTable directorTable = mediaDAO.ListDirector();
foreach (MediaDS.TabDirectorRow row in directorTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairs.Add(pair);
}
return(pairs);
}
public List <PairModel> ListDirector()
{
List <PairModel> medias = new List <PairModel>();
MediaDS.TabDirectorDataTable directorTable = mediaDAO.ListDirector();
foreach (MediaDS.TabDirectorRow row in directorTable.Rows)
{
PairModel media = PairModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public int getDirectorIdByName(string directorName)
{
//get data from DAO
MediaDS.TabDirectorDataTable myData = mediaDAO.getDirectorByName(directorName);
int recievedId = -1;
foreach (MediaDS.TabDirectorRow row in myData.Rows) //should only result to one row
{
if (row != null)
{
recievedId = row.DID;
}
}
return(recievedId); //if is -1 their is an error
}
//Parse genre director and language tables usign IdAndValueClass
//tableDirector
public List <IdAndValue> parseDirectorDataTolist(MediaDS.TabDirectorDataTable myDataTable)
{
List <IdAndValue> idVal = new List <IdAndValue>();
foreach (MediaDS.TabDirectorRow row in myDataTable.Rows)
//foreach (UserDS.TabUserRow row in myDataTable.Rows)
{
if (row == null)
{
return(null);
}
else
{
IdAndValue item = new IdAndValue(row.DID, row.DirectorName);
idVal.Add(item);
}
}
return(idVal);
}