//Fill ---------- public List <Borrow> getAllReserved() { List <Borrow> myList = new List <Borrow>(); BorrowDS.TabBorrowDataTable myData = borrowDAO.getAllBorrowTab(); //parse data from datatable rows to list elements myList = parseBorrowDataTolistAll(myData); return(myList); }
public List <Borrow> getByUserForUserActivity(int userId) { List <Borrow> myList = new List <Borrow>(); BorrowDS.TabBorrowDataTable myData = borrowDAO.getByUserIdForActiveBookings(userId); //parse data from datatable rows to list elements myList = parseBorrowDataTolistAll(myData); return(myList); }
public bool getMediaExists(int mediaId) { List <Borrow> myList = new List <Borrow>(); BorrowDS.TabBorrowDataTable myData = borrowDAO.getMediaExists(mediaId); //parse data from datatable rows to list elements myList = parseBorrowDataTolistAll(myData); // results list count == 0 if (myList.Count > 0) { return(true); } else { return(false); } }
//functions --------- public List <Borrow> parseBorrowDataTolistAll(BorrowDS.TabBorrowDataTable myDataTable) { //create list List <Borrow> myList = new List <Borrow>(); // sort through data by rows foreach (BorrowDS.TabBorrowRow row in myDataTable.Rows) { if (row == null) { return(null); } else { Borrow borrowItem = new Borrow(row.BID, row.UID, row.MediaID, row.BorrowDate.ToString(), row.ReturnDate.ToString(), row.ActualReturnDate.ToString(), (int)row.LateFee); myList.Add(borrowItem); } } return(myList); }