private void SetUp() { var overdue = OverDueBooks(); listview_books.ItemsSource = ConvertBooktoSearchDisplay(overdue); listview_authors.ItemsSource = ConvertAuthorToSearchDisplay(_authorRepository.GetAll()); listview_cardholders.ItemsSource = ConvertCardholderToSearchDisplay(_cardholderRepository.GetAll()); listview_librarians.ItemsSource = ConvertLibrarianToSearchDisplay(_librarianRepository.GetAll()); }
static void Main(string[] args) { var serviceProvider = new ServiceCollection() .AddSingleton <ILibrarianHelper, LibrarianHelper>() .AddSingleton <IBookHelper, BookHelper>() .AddTransient <IGenericSqlRepository <Librarian>, LibrarianRepository>() .AddTransient <IGenericSqlRepository <CheckOutLog>, CheckoutLogRepository>() .BuildServiceProvider(); Database.SetInitializer <LibraryContext>(new LibraryInitializer()); LibrarianRepository librarianRepository = new LibrarianRepository(); var t = librarianRepository.GetAll(); #region Check UserName and Password is true var librarianHelper = serviceProvider.GetService <ILibrarianHelper>(); var isUserLogin = librarianHelper.IsUserLogin("hoyoung", "holim1"); #endregion #region Search Book // initialize BookHelper var bookHelper = serviceProvider.GetService <IBookHelper>(); // find books search var z = bookHelper.FindBooksSearch("Andrew;Programming"); var d = bookHelper.FindBooksSearch("Science Fiction"); #endregion #region Check out book BookRepository bookRepository = new BookRepository(); var book = bookRepository.Find(5); var canUserCheckout = librarianHelper.CanCheckOut(book, 16); CheckOutLog checkOutLog = new CheckOutLog { BookID = 5, CardholderID = 10, CheckOutDate = DateTime.Now }; CheckoutLogRepository checkoutlogRepository = new CheckoutLogRepository(); if (canUserCheckout) { var checkedOut = checkoutlogRepository.Add(checkOutLog); } var found = checkoutlogRepository.GetAll().Where(x => x.BookID == checkOutLog.BookID && x.CardholderID == checkOutLog.CardholderID) .Select(x => x).ToList(); #endregion #region Update Check Out Log checkOutLog.BookID = 7; var checkOut = checkoutlogRepository.Update(checkOutLog); #endregion #region Delete Checkoutlog var foundCol = checkoutlogRepository.Find(8); checkoutlogRepository.Delete(8); foundCol = checkoutlogRepository.Find(8); #endregion }