//List all borrowed medias by current user
public List <PairModel> ListBorrowedByUid(int uid)
{
List <PairModel> pairs = new List <PairModel>();
MediaDS.TabBorrowDataTable borrowTable = mediaDAO.ListBorrowed();
MediaDS.ViewMediaDataTable mediaTable = mediaDAO.ListMedia();
foreach (MediaDS.TabBorrowRow row in borrowTable.Rows)
{
foreach (MediaDS.ViewMediaRow row2 in mediaTable.Rows)
{
//Filter borrowed medias by user and actualReturnDate
if (row.MediaID == row2.MediaID && row.ActualReturnDate < row.BorrowDate && uid == row.UID)
{
PairModel pair = PairModel.Parse(row.BID, row2.Title);
pairs.Add(pair);
}
}
}
if (pairs.Count == 0)
{
pairs = null;
}
return(pairs);
}
public List <PairModel> ListGenre()
{
List <PairModel> pairs = new List <PairModel>();
MediaDS.TabGenreDataTable genreTable = mediaDAO.ListGenre();
foreach (MediaDS.TabGenreRow row in genreTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairs.Add(pair);
}
return(pairs);
}
public List <PairModel> ListReturn(int UID)
{
List <PairModel> pairs = new List <PairModel>();
MediaDS.TabReturnDataTable returnTable = mediaDAO.ListMediaByUID(UID);
foreach (MediaDS.TabReturnRow row in returnTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairs.Add(pair);
}
return(pairs);
}
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> 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);
}