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();
}
