public MediaLogic()
{
mediaDAO = new MediaDAO();
mediaTable = new MediaDS.ViewMediaDataTable();
languageTable = new MediaDS.TabLanguageDataTable();
genreTable = new MediaDS.TabGenreDataTable();
tabMediaTable = new MediaDS.TabMediaDataTable();
}
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();
}
//Language tabel
public List <IdAndValue> getAllLanguageTable()
{
List <IdAndValue> myList = new List <IdAndValue>();
MediaDS.TabLanguageDataTable myData = mediaDAO.getAllLanguages();
//parse data from datatable rows to list elements
myList = parseLanguageDataTolist(myData);
return(myList);
}
public List <PairModel> ListLanguages()
{
List <PairModel> list = new List <PairModel>();
languageTable = mediaDAO.ListLanguages();
foreach (MediaDS.TabLanguageRow row in languageTable.Rows)
{
PairModel pair = PairModel.Parse(row);
list.Add(pair);
}
return(list);
}
public List <PairModel> ListLanguages()
{
//unused code from file in canvas that allows list all languages based on TabLanguage
List <PairModel> list = new List <PairModel>();
languageTable = mediaDAO.ListLanguages();
foreach (MediaDS.TabLanguageRow row in languageTable.Rows)
{
PairModel pair = PairModel.Parse(row);
list.Add(pair);
}
return(list);
}
public List <PairModel> ListLanguage()
{
List <PairModel> pairs = new List <PairModel>();
MediaDS.TabLanguageDataTable languageTable = mediaDAO.ListLanguage();
foreach (MediaDS.TabLanguageRow row in languageTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairs.Add(pair);
}
return(pairs);
}
public List <PairModel> ListLanguage()
{
List <PairModel> medias = new List <PairModel>();
MediaDS.TabLanguageDataTable languageTable = mediaDAO.ListLanguage();
foreach (MediaDS.TabLanguageRow row in languageTable.Rows)
{
PairModel media = PairModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public int getLanguageIdByName(string languageName)
{
//get data from DAO
MediaDS.TabLanguageDataTable myData = mediaDAO.getLanguageByName(languageName);
int recievedId = -1;
foreach (MediaDS.TabLanguageRow row in myData.Rows) //should only result to one row
{
if (row != null)
{
recievedId = row.LID;
}
}
return(recievedId); //if is -1 their is an error
}
//tableLanguage
public List <IdAndValue> parseLanguageDataTolist(MediaDS.TabLanguageDataTable myDataTable)
{
List <IdAndValue> idVal = new List <IdAndValue>();
foreach (MediaDS.TabLanguageRow row in myDataTable.Rows)
//foreach (UserDS.TabUserRow row in myDataTable.Rows)
{
if (row == null)
{
return(null);
}
else
{
IdAndValue item = new IdAndValue(row.LID, row.LanguageName);
idVal.Add(item);
}
}
return(idVal);
}
