public List <Borrow> AllBorrows() { var borrowTable = new UserData.TabBorrowDataTable(); var borrowAdapter = new TabBorrowTableAdapter(); List <Borrow> list = new List <Borrow>(); int rowCount = borrowAdapter.GetBorrows(borrowTable); if (rowCount > 0) { foreach (DataRow r in borrowTable) { Borrow borrow = new Borrow(); borrow.BID = int.Parse(r["BID"].ToString()); borrow.MediaID = int.Parse(r["MediaID"].ToString()); borrow.BorrowDate = r["BorrowDate"].ToString(); borrow.ReturnDate = r["ReturnDate"].ToString(); borrow.ActualReturnDate = r["ActualReturnDate"].ToString(); borrow.BStatus = r["BStatus"].ToString(); borrow.LateFee = decimal.Parse(r["LateFee"].ToString()); list.Add(borrow); } } return(list); }
public void InsertReturn(string actualReturnDate, decimal lateFee, int BID, int MID) { var borrowTable = new UserData.TabBorrowDataTable(); var borrowAdapter = new TabBorrowTableAdapter(); int rowCount = borrowAdapter.ReturnUpdate(actualReturnDate, lateFee, BID); rowCount = mediaAdapter.UpdateReturn(MID); }
public void InsertBorrow(int UID, int MediaID, string borrowDate, string returnDate) { var borrowTable = new UserData.TabBorrowDataTable(); var borrowAdapter = new TabBorrowTableAdapter(); int countRow = borrowAdapter.InsertBorrow(UID, MediaID, borrowDate, returnDate); countRow = mediaAdapter.UpdateBorrow(MediaID); }