public static PairModel Parse(MediaDataSet.TabGenreRow row)
{
PairModel pair = new PairModel();
pair.ID = row.GID;
pair.Name = row.GenreName;
return(pair);
}
public static PairModel Parse(MediaDataSet.TabLanguageRow row)
{
PairModel pair = new PairModel();
pair.ID = row.LID;
pair.Name = row.LanguageName;
return(pair);
}
public static PairModel Parse(MediaDataSet.TabDirectorRow row)
{
PairModel pair = new PairModel();
pair.ID = row.DID;
pair.Name = row.DirectorName;
return(pair);
}
public List <PairModel> ListGenres()
{
List <PairModel> list = new List <PairModel>();
genreTable = mediaDAO.ListGenres();
foreach (MediaDS.TabGenreRow row in genreTable.Rows)
{
PairModel pair = PairModel.Parse(row);
list.Add(pair);
}
return(list);
}
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> 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> 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 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 List <PairModel> ListGenres()
{
//unused code from file in canvas that allows list all genres based on TabGenre
List <PairModel> list = new List <PairModel>();
genreTable = mediaDAO.ListGenres();
foreach (MediaDS.TabGenreRow row in genreTable.Rows)
{
PairModel pair = PairModel.Parse(row);
list.Add(pair);
}
return(list);
}
public static PairModel Parse(MediaDS.TabLanguageRow langRow)
{
if (langRow == null)
{
return(null);
}
PairModel pair = new PairModel();
pair.PairID = langRow.LID;
pair.PairName = langRow.LanguageName;
return(pair);
}
public static PairModel Parse(MediaDS.TabDirectorRow directRow)
{
if (directRow == null)
{
return(null);
}
PairModel pair = new PairModel();
pair.PairID = directRow.DID;
pair.PairName = directRow.DirectorName;
return(pair);
}
public List <PairModel> ListGenre()
{
List <PairModel> medias = new List <PairModel>();
MediaDS.TabGenreDataTable genreTable = mediaDAO.ListGenre();
foreach (MediaDS.TabGenreRow row in genreTable.Rows)
{
PairModel media = PairModel.Parse(row);
medias.Add(media);
}
return(medias);
}
//function overlooding TabAuthor
public static PairModel Parse(DataSet1.TabAuthorRow uglyRow)
{
if (uglyRow == null)
{
return(null);
}
PairModel tempModel = new PairModel();
tempModel.PairID = uglyRow.AID.ToString();
tempModel.PairName = uglyRow.AuthorName;
return(tempModel);
}
public static PairModel Parse(MediaDS.TabGenreRow genreRow)
{
if (genreRow == null)
{
return(null);
}
PairModel pair = new PairModel();
pair.PairID = genreRow.GID;
pair.PairName = genreRow.GenreName;
return(pair);
}
//List all the author in TabAuthor
public List <PairModel> ListAuthor()
{
List <PairModel> _lists = new List <PairModel>();
_authorTable = _bookDao.GetAuthor();
foreach (DataSet1.TabAuthorRow uglyRow in _authorTable.Rows)
{
PairModel tempRow = PairModel.Parse(uglyRow);
_lists.Add(tempRow);
}
return(_lists);
}
/// <summary>
/// List language from TabLanguage
/// </summary>
/// <returns></returns>
public List <PairModel> ListLanguage()
{
List <PairModel> _lists = new List <PairModel>();
_languageTable = _bookDao.ListLanguage();
foreach (DataSet1.TabLanguageRow uglyRow in _languageTable.Rows)
{
PairModel tempRow = PairModel.Parse(uglyRow);
_lists.Add(tempRow);
}
return(_lists);
}
/// <summary>
/// List category from TabCategory
/// </summary>
/// <returns></returns>
public List <PairModel> ListCategory()
{
List <PairModel> _lists = new List <PairModel>();
_categorytable = _bookDao.GetCategory();
foreach (DataSet1.TabCategoryRow uglyRow in _categorytable.Rows)
{
PairModel tempRow = PairModel.Parse(uglyRow);
_lists.Add(tempRow);
}
return(_lists);
}
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);
}
}
public List <PairModel> GetLanguages()
{
List <PairModel> pairList = new List <PairModel>();
MediaDataSet.TabLanguageDataTable languageTable = mediaDAO.GetLanguages();
if (languageTable != null)
{
foreach (MediaDataSet.TabLanguageRow row in languageTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairList.Add(pair);
}
return(pairList);
}
else
{
return(null);
}
}
