public Book GetMostRecentBook() { using (var context = new BookDb()) { return context.Books.OrderByDescending(b => b.DateCompleted).First(); } }
public List<Book> GetLastReadBooks() { using (var context = new BookDb()) { return context.Books.OrderByDescending(b => b.DateCompleted).Take(5).ToList(); } }
// Execution starts here. private static void Main() { var bookDb = new BookDb(); // Initialize the database with some books: AddBooks(bookDb); // Print all the titles of paperbacks: Console.WriteLine("Paperback Book Titles:"); // Create a new delegate object associated with the static // method Test.PrintTitle: bookDb.ProcessPaperbackBooks(new ProcessBookDelegate(PrintTitle)); //bookDb.ProcessPaperbackBooks(PrintTitle); // Get the average price of a paperback by using // a PriceTotaller object: PriceTotaller totaller = new PriceTotaller(); // Create a new delegate object associated with the nonstatic // method AddBookToTotal on the object totaller: bookDb.ProcessPaperbackBooks(new ProcessBookDelegate(totaller.AddBookToTotal)); //bookDb.ProcessPaperbackBooks(totaller.AddBookToTotal); Console.WriteLine("Average Paperback Book Price: ${0:#.##}", totaller.AveragePrice()); Console.ReadLine(); }
// Initialize the book database with some test books: private static void AddBooks(BookDb bookDb) { bookDb.AddBook("The C Programming Language", "Brian W. Kernighan and Dennis M. Ritchie", 19.95m, true); bookDb.AddBook("The Unicode Standard 2.0", "The Unicode Consortium", 39.95m, true); bookDb.AddBook("The MS-DOS Encyclopedia", "Ray Duncan", 129.95m, false); bookDb.AddBook("Dogbert's Clues for the Clueless", "Scott Adams", 12.00m, true); }
public Book GetFastestBook() { using (var context = new BookDb()) { return context.Books.OrderByDescending(b => b.Minutes / (DbFunctions.DiffDays(b.DateCompleted, b.DateStarted == b.DateCompleted ? DbFunctions.AddDays(b.DateStarted, 1) : b.DateStarted))).First(); } }
public List<Book> GetBooks() { using (var context = new BookDb()) { return (from book in context.Books select book).ToList(); } }
public void ToDataModel() { // Arrange var authorsDb = _fixture.CreateMany <AuthorDb>().ToList(); var book = _fixture.Create <Book>(); _authorMapper.Setup(p => p.ToDataModel(book.Authors, book.Id)) .Returns(authorsDb); var expected = new BookDb { Id = book.Id, Title = book.Title, PageCount = book.PageCount, Publisher = book.Publisher, Year = book.Year, Isbn = book.Isbn, Image = book.Image, Token = book.Token, CreateDate = book.CreateDate, EditDate = book.EditDate, Authors = authorsDb }; // Act var result = _target.ToDataModel(book); // Assert result.Should().BeEquivalentTo(expected); _authorMapper.Verify(p => p.ToDataModel(book.Authors, book.Id), Times.Once); }
public ActionResult AddToOrder(int UserId, int BookId) { Orders ordersContext = new Orders(); BookData bookDataContext = new BookData(); List <Order> orders = ordersContext.OrderData.ToList(); BookDb bookDb = bookDataContext.BookDbs.SingleOrDefault(entity => entity.id == BookId); foreach (var item in orders) { if (item.bookid == BookId && item.customerid == UserId) { Order neworder1 = new Order { bookid = BookId, customerid = UserId }; ordersContext.OrderData.Add(neworder1); ordersContext.SaveChanges(); return(RedirectToAction("ReturnPDF", new { fileurl = bookDb.BookLink })); } } Order neworder = new Order { bookid = BookId, customerid = UserId }; ordersContext.OrderData.Add(neworder); ordersContext.SaveChanges(); return(RedirectToAction("ReturnPDF", new { fileurl = bookDb.BookLink })); }
public Book GetLongestBook() { using (var context = new BookDb()) { return context.Books.OrderByDescending(b => b.Minutes).First(); } }
public void FillDataGridView() { ArrayList books = BookDb.GetAllBooks(); foreach (Book book in books) { dataGridView1.Rows.Add(book.Name, book.Author, book.Genre.Name, book.Price + " " + "AZN", book.PublishDate, book.PageCount); } }
public DashboardDto GetDashboardDto() { using (var context = new BookDb()) { return new DashboardDto { TotalMinutes = context.Books.Sum(b => b.Minutes), TotalNumberOfBooks = context.Books.Count(), TotalPages = context.Books.Sum(b => b.Pages) }; } }
public static Book ToClient(this BookDb @this) { return(new Book( id: @this.Id, name: @this.Name, author: @this.Author, blurb: @this.Blurb, year: @this.Year, datePublished: @this.DatePublished, reviews: @this.Reviews.ToClient().ToList() )); }
protected void Page_Load(object sender, EventArgs e) { UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;//necessary for asp validators... or else BookDb objBookData = new BookDb(); gvBooks.Visible = true; if (IsPostBack == false) { BookDb bDB = new BookDb(); gvBooks.DataSource = bDB.getBookData(); gvBooks.DataBind(); } //bind the arrayList to the 2nd GridView }//page load class
public Book ToDomainModel(BookDb book) { return(new Book { Id = book.Id, Title = book.Title, PageCount = book.PageCount, Publisher = book.Publisher, Year = book.Year, Isbn = book.Isbn, Image = book.Image, Token = book.Token, CreateDate = book.CreateDate, EditDate = book.EditDate, Authors = _authorMapper .ToDomainModel(book.Authors) ?.ToList() }); }
public async Task <int> Update(BookDb bookDb) { var result = await Connection.ExecuteAsync( "[dbo].[Book_Update]", new { bookDb.Id, bookDb.Title, bookDb.PageCount, bookDb.Publisher, bookDb.Year, bookDb.Isbn, bookDb.Image, bookDb.Token }, commandType : CommandType.StoredProcedure, transaction : Transaction); return(result); }
protected void btnBackToOrder_Click(object sender, EventArgs e) { txtStudentId.Visible = true; txtName.Visible = true; txtAddress.Visible = true; txtPhoneNumber.Visible = true; lblCustomerInfo.Visible = true; ddlCampus.Visible = true; gvBooks.Visible = true; gvDisplayOrder.Visible = false; gvManager.Visible = false; totalOrderSale = 0; BookDb bDB = new BookDb(); gvBooks.DataSource = bDB.getBookData(); gvBooks.DataBind(); }
}//end btnSubmitOrder_Click protected void btnViewreport_Click(object sender, EventArgs e) { txtStudentId.Visible = false; txtName.Visible = false; txtAddress.Visible = false; txtPhoneNumber.Visible = false; lblCustomerInfo.Visible = false; ddlCampus.Visible = false; gvBooks.Visible = false; gvDisplayOrder.Visible = false; gvManager.Visible = true; BookDb bDB = new BookDb(); gvManager.DataSource = bDB.getBookData(); gvManager.DataBind(); SortDirection direction = SortDirection.Descending; }
public ActionResult ViewWishList(int UserId) { WishListContext wishListContext = new WishListContext(); BookData bookDataContext = new BookData(); List <WishList> wishLists = wishListContext.WishLists.Where(entity => entity.CustomerId == UserId).ToList(); List <BookDb> bookDbs = new List <BookDb>(); if (wishLists != null) { foreach (var item in wishLists) { BookDb bookDb = bookDataContext.BookDbs.SingleOrDefault(entity => entity.id == item.Bookid); bookDbs.Add(bookDb); } } else { return(Content("WishList is Empty")); } ViewBag.userid = UserId; return(View(bookDbs)); }
public MainForm() { genres = new ArrayList() { new Genre() { Id = 1, Name = "Detective" }, new Genre() { Id = 2, Name = "Romantic" }, new Genre() { Id = 3, Name = "Tragedy" } }; Book book = new Book() { Id = 1, Name = "Tehlike Oyunlar", Author = "Oguz Atay", Price = 35, PageCount = 724, PublishDate = DateTime.Now, Genre = (Genre)genres[0] }; BookDb.Add(book); InitializeComponent(); FillSelect(); FillDataGridView(); }
public ActionResult ViewOrders(int UserId) { Orders ordersContext = new Orders(); BookData bookDataContext = new BookData(); List <Order> orders = ordersContext.OrderData.Where(entity => entity.customerid == UserId).ToList(); List <BookDb> bookDbs = new List <BookDb>(); if (orders != null) { foreach (var item in orders) { BookDb bookDb = bookDataContext.BookDbs.SingleOrDefault(entity => entity.id == item.bookid); bookDbs.Add(bookDb); } } else { return(Content("WishList is Empty")); } DateTime now = DateTime.Now; ViewBag.datetime = now; return(View(bookDbs)); }
public void ToDataModel_WithoutIdAndWithoutAuthors() { // Arrange var book = _fixture.Build <Book>() .With(p => p.Id, Guid.Empty) .Without(p => p.Authors) .Create(); _authorMapper.Setup(p => p.ToDataModel(book.Authors, It.Is <Guid>(g => g != Guid.Empty))) .Returns((IEnumerable <AuthorDb>)null); var expected = new BookDb { Title = book.Title, PageCount = book.PageCount, Publisher = book.Publisher, Year = book.Year, Isbn = book.Isbn, Image = book.Image, Token = book.Token, CreateDate = book.CreateDate, EditDate = book.EditDate, Authors = null }; // Act var result = _target.ToDataModel(book); // Assert Assert.AreNotEqual(Guid.Empty, result.Id); expected.Id = result.Id; result.Should().BeEquivalentTo(expected); _authorMapper.Verify(p => p.ToDataModel(book.Authors, It.Is <Guid>(g => g != Guid.Empty)), Times.Once); }
public SaveHistoryDAO() { db = new BookDb(); }
public BooksController() { this.db = new BookDb(); this.db.Configuration.ProxyCreationEnabled = false; }
public NXBDAO() { db = new BookDb(); }
public GioHangDAO() { db = new BookDb(); }
public KhachHangDAO() { db = new BookDb(); }
public TacGiaDAO() { db = new BookDb(); }
public TaiKhoanDAO() { db = new BookDb(); }
public SachDAO() { db = new BookDb(); }
public ChiTietGioHangDAO() { db = new BookDb(); }
public TheLoaiDAO() { db = new BookDb(); }
public DanhMucDAO() { db = new BookDb(); }