//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); }