//List borrowed by borrow Id public BorrowModel ListBorrowedByBID(int borrowId) { //empty list of media models to start us off List <BorrowModel> borrowedMedias = new List <BorrowModel>(); MediaDS.TabBorrowDataTable borrowedTable = mediaDAO.ListBorrowed(); foreach (MediaDS.TabBorrowRow row in borrowedTable.Rows) { if (row.BID == borrowId) { BorrowModel media = BorrowModel.Parse(row); borrowedMedias.Add(media);//add it to our list of media } } BorrowModel borrowed = null; if (borrowedMedias.Count == 0) { borrowedMedias = null; } else { borrowed = borrowedMedias[0]; } return(borrowed); }
//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); }
//List Borrowed by actual return date public BorrowModel GetBorrowed(int mediaId) { List <BorrowModel> borrowedMedias = new List <BorrowModel>(); MediaDS.TabBorrowDataTable borrowedTable = mediaDAO.ListBorrowed(); foreach (MediaDS.TabBorrowRow row in borrowedTable.Rows) { if (row.MediaID == mediaId && row.ActualReturnDate < row.BorrowDate) { BorrowModel borrowedMedia = BorrowModel.Parse(row); borrowedMedias.Add(borrowedMedia); } } BorrowModel borrowed = null; if (borrowedMedias.Count == 0) { borrowedMedias = null; } else { borrowed = borrowedMedias[0]; } return(borrowed); }
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(); }
public List <BorrowModel> ListBorrowedItems() { List <BorrowModel> borrowList = new List <BorrowModel>(); borrowTable = mediaDAO.ListBorrow(); foreach (MediaDS.TabBorrowRow row in borrowTable.Rows) { BorrowModel borrowItem = BorrowModel.Parse(row); borrowList.Add(borrowItem); } return(borrowList); }
public List <BRModel> ListMediaBorrowUser(int UserID) { List <BRModel> medias = new List <BRModel>(); borrowTable = mediaDAO.ListMediaReturn(UserID); foreach (MediaDS.TabBorrowRow row in borrowTable.Rows) { BRModel media = BRModel.Parse(row); medias.Add(media); } return(medias); }
public List <BorrowModel> ListBorrow() { List <BorrowModel> medias = new List <BorrowModel>(); MediaDS.TabBorrowDataTable borrowTable = mediaDAO.ListBorrow(); foreach (MediaDS.TabBorrowRow row in borrowTable.Rows) { BorrowModel media = BorrowModel.Parse(row); medias.Add(media); } return(medias); }
public List <MediaModel3> ListBorrow() { List <MediaModel3> medias = new List <MediaModel3>(); MediaDS.TabBorrowDataTable borrowTable = mediaDAO.ListBorrow(); foreach (MediaDS.TabBorrowRow row in borrowTable.Rows) { MediaModel3 media = MediaModel3.Parse(row); medias.Add(media); } return(medias); }
//Borrowed medias <<<<< //Lista all borrowed medias public List <BorrowModel> ListAllMediasBorrowed() { //empty list of media models to start us off List <BorrowModel> borrowedMedias = new List <BorrowModel>(); MediaDS.TabBorrowDataTable borrowedTable = mediaDAO.ListBorrowed(); foreach (MediaDS.TabBorrowRow row in borrowedTable.Rows) { //create a model representing that row BorrowModel media = BorrowModel.Parse(row); borrowedMedias.Add(media);//add it to our list of media } return(borrowedMedias); }
//List borrowed by media Id public List <BorrowModel> GetBorrowedByMediaId(int mediaId) { List <BorrowModel> borrowedMedias = new List <BorrowModel>(); MediaDS.TabBorrowDataTable borrowedTable = mediaDAO.ListBorrowed(); foreach (MediaDS.TabBorrowRow row in borrowedTable.Rows) { if (row.MediaID == mediaId) { BorrowModel borrowedMedia = BorrowModel.Parse(row); borrowedMedias.Add(borrowedMedia); } } if (borrowedMedias.Count == 0) { borrowedMedias = null; } return(borrowedMedias); }
public BorrowLogic() { mediaDAO = new MediaDAO(); borrowTable = new MediaDS.TabBorrowDataTable(); }