public void CanAddBook()
{
var helper = Substitute.For <IBookHelper>();
var bookDao = new BookDao(helper);
var author = "author";
var title = "title";
var callNo = "callNo";
// Uses Helper to create a new book with a unique book ID.
// Adds the book to a collection of books and returns new book.
Assert.Equal(0, bookDao.BookList.Count);
// Tell the mock what to return when it is called.
helper.MakeBook(author, title, callNo, Arg.Any <int>()).Returns(new Book(author, title, callNo, 1));
var result = bookDao.AddBook(author, title, callNo);
// Assert that the mock's MakeBook method was called.
helper.Received().MakeBook(author, title, callNo, Arg.Any <int>());
Assert.NotNull(result);
Assert.Equal(author, result.Author);
Assert.Equal(title, result.Title);
Assert.Equal(callNo, result.CallNumber);
Assert.Equal(1, bookDao.BookList.Count);
var book = bookDao.BookList[0];
Assert.Equal(book, result);
}
// GET: Admin/Book
public ActionResult Index()
{
//get list books which are active and order by descending modified date
List <Book> list = BookDao.GetListBooks().OrderByDescending(m => m.ModifiedDate).ToList();
return(PartialView("_IndexBook", list));
}
public void CanCommitLoan()
{
ILoanHelper loanHelper = new LoanHelper();
ILoanDAO loanDao = new LoanDao(loanHelper);
IMemberHelper memberHelper = new MemberHelper();
IMemberDAO memberDao = new MemberDao(memberHelper);
IBookHelper bookHelper = new BookHelper();
IBookDAO bookDao = new BookDao(bookHelper);
var borrowDate = DateTime.Today;
var dueDate = DateTime.Today.AddDays(7);
var member = memberDao.AddMember("Jim", "Tulip", "csu phone", "*****@*****.**");
var book = bookDao.AddBook("Jim Tulip", "Adventures in Programming", "call number");
var loan = loanDao.CreateLoan(member, book, borrowDate, dueDate);
loanDao.CommitLoan(loan);
Assert.NotNull(loan);
Assert.Equal(1, loanDao.LoanList.Count);
Assert.Equal(loan, loanDao.LoanList[0]);
Assert.NotEqual(0, loan.ID);
}
public static void Update(BookViewModel book)
{
BookDao dao = new BookDao();
dao.Update(book.ToEntity());
s_logger.Debug($"UPDATE Book:{book}");
}
public void CanUpdateOverdueStatus()
{
ILoanHelper loanHelper = new LoanHelper();
ILoanDAO loanDao = new LoanDao(loanHelper);
IMemberHelper memberHelper = new MemberHelper();
IMemberDAO memberDao = new MemberDao(memberHelper);
IBookHelper bookHelper = new BookHelper();
IBookDAO bookDao = new BookDao(bookHelper);
var borrowDate = DateTime.Today;
var dueDate = DateTime.Today.AddDays(7);
var member = memberDao.AddMember("Jim", "Tulip", "csu phone", "*****@*****.**");
var book = bookDao.AddBook("Jim Tulip", "Adventures in Programming", "call number");
var loan = loanDao.CreateLoan(member, book, borrowDate, dueDate);
loanDao.CommitLoan(loan);
Assert.Equal(LoanState.CURRENT, loan.State);
loanDao.UpdateOverDueStatus(DateTime.Today.AddMonths(1));
Assert.Equal(LoanState.OVERDUE, loan.State);
}
public ActionResult Edit(long id)
{
var book = new BookDao().ViewDetail(id);
setViewbag();
return(View(book));
}
public void TestUpdateBook()
{
//Arrange
BookDao bookDao = new BookDao();
eBook.Model.Book book = new Book()
{
BOOK_ID = 2326,
BOOK_NAME = "666666",
BOOK_AUTHOR = "66666",
BOOK_NOTE = "66666",
BOOK_BOUGHT_DATE = "2018/03/17",
BOOK_CLASS_ID = "DB",
BOOK_STATUS = "A",
BOOK_KEEPER = "",
BOOK_PUBLISHER = "test1"
};
//Act
bookDao.UpdateBook(book);
eBook.Model.Book check = bookDao.GetUpdateBook(book.BOOK_ID.ToString());
//Assert
Assert.AreEqual(book.BOOK_AUTHOR, check.BOOK_AUTHOR);
}
protected void Page_Load(object sender, EventArgs e)
{
// 传参异常捕获
try
{
// 获取get的传参
BookId = Convert.ToInt32(Request.QueryString["id"]);
}
catch (Exception)
{
Response.Redirect("./Main.aspx");
}
// id值不可为负数
if (BookId <= 0)
{
Response.Redirect("./Main.aspx");
}
BookDao bookDao = new BookDao();
// 获取图书详情
BookInfo bookInfo = bookDao.GetBookDetailById(BookId);
// 展示到页面
BookAuthor = bookInfo.Author;
BookDescription = bookInfo.Description;
BookImage = bookInfo.Image;
BookPrice = bookInfo.Price;
BookTitle = bookInfo.Name;
BookType = bookInfo.TypeName;
}
public static void DeleteWhereIDIs(Guid id, DataOperationUnit dataOpUnit = null)
{
BookDao dao = new BookDao();
dao.DeleteWhereIDIs(id, dataOpUnit?.CurrentConnection);
s_logger.Debug($"DELETE Book:{id}");
}
public static void Insert(BookViewModel target, DataOperationUnit dataOpUnit = null)
{
BookDao dao = new BookDao();
dao.Insert(target.ToEntity(), dataOpUnit?.CurrentConnection);
s_logger.Debug($"INSERT Book:{target}");
}
public ActionResult EditPrispevek(int id, string text, string sumText)
{
BookDao d = new BookDao();
Book b = d.GetbyId(id);
b.Description = text;
b.Version += 0.1;
d.Update(b);
// Zaneseme verzování
KnihovnaUser usr = new KnihovnaUserDao().GetByLogin(User.Identity.Name);
BookVersion ver = new BookVersion();
ver.Id = Books.Counter();
ver.SumText = sumText;
ver.Version = b.Version;
ver.ChangedBy = usr.Id;
ver.Date = DateTime.Now;
ver.IsApproved = false;
ver.IsSuggestion = false;
ver.Text = b.Description;
ver.PostId = b.Id;
BookVersionDao vd = new BookVersionDao();
vd.Create(ver);
return(Redirect(this.Request.UrlReferrer.AbsolutePath));
}
private IEnumerable <Task> GenerateTasksToImportBooks(ILibrary libManager)
{
List <Task> ret = new List <Task>();
IDConversionDao idcDao = new IDConversionDao();
BookDao bookDao = new BookDao();
var anotherDbBooks = bookDao.FindAll(_dataOpUnit.CurrentConnection, s_ANOTHER_DATABASE_ALIAS_NAME).ToList().ToViewModel();
var books = bookDao.FindAll(_dataOpUnit.CurrentConnection).ToList().ToViewModel();
//同ID：対象ライブラリのエンティティを新規IDでインポートする。取込側ライブラリに新規IDと旧IDを記録する。
var alpha = from b in anotherDbBooks
join ob in books on b.ID equals ob.ID
select b;
foreach (var addBook in alpha)
{
var newGuid = Guid.NewGuid();
idcDao.Insert(new Data.Entity.Migration.IDConversion("Book", newGuid, addBook.ID), _dataOpUnit.CurrentConnection);
addBook.ID = newGuid;
ret.AddRange(GenerateTasksToImportBook(libManager, addBook));
}
//異ID：対象ライブラリのエンティティを変更せずそのままインポートする。
var beta = from b in anotherDbBooks.Except(alpha)
select b;
foreach (var addBook in beta)
{
ret.AddRange(GenerateTasksToImportBook(libManager, addBook));
}
return(ret);
}
//书籍详情页面
public ActionResult Detail(int id)
{
Book b;
using (BookDao dao = new BookDao())
b = dao.detail(id);
return View(b);
}
public ActionResult Index(int?page, int?cat)
{
string pozdrav = "Lof lof";
int cislo = 12;
int itemsOnPage = 2;
int pg = page.HasValue ? page.Value : 1;
int totalBooks;
// Potřebuju uložit do kontaineru abych to dostal do view
ViewBag.Pozdrav = pozdrav;
ViewBag.Cislo = cislo;
BookDao bookDao = new BookDao();
IList <Book> books = bookDao.GetBooksPaged(itemsOnPage, pg, out totalBooks, cat);
KnihovnaUser user = new KnihovnaUserDao().GetByLogin(User.Identity.Name);
ViewBag.Pages = (int)Math.Ceiling((double)totalBooks / (double)itemsOnPage);
ViewBag.CurrentPage = pg;
ViewBag.PerPage = itemsOnPage;
ViewBag.Categories = new BookCategoryDao().GetAll();
if (Request.IsAjaxRequest())
{
return(PartialView(books));
}
return(View(books));
}
public ActionResult UploadFileImage(string id, HttpPostedFileBase[] fileImages)
{
var message = 0;
string path = Server.MapPath("~/UploadFile/");
string path2 = "C:\\xampp\\htdocs\\apiFahasa\\image\\";
var delete = new BookDao().DeleteImage(id);
if (fileImages != null)
{
foreach (var file in fileImages)
{
if (file != null)
{
var images = new HINHANH();
var imageDao = new UploadHinhAnhSanPhamDao();
string extensionName = System.IO.Path.GetExtension(file.FileName);
var fileInfo = new FileInfo(file.FileName);
string finalFileName = DateTime.Now.Ticks.ToString() + extensionName;
file.SaveAs(path + finalFileName);
file.SaveAs(path2 + finalFileName);
//Insert database
images.LINKHINHANH = finalFileName;
images.MASANPHAM = id;
images.TENHINHANH = file.FileName;
message = imageDao.Insert(images);
}
}
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
// 更新按钮点击事件
protected void BtnUpdate_Click(object sender, EventArgs e)
{
//获取现在所编辑的书的ID
int id = Convert.ToInt32(Request.QueryString["bookId"]);
//实例化一个数据库操作
BookDao bookDao = new BookDao();
//实例化一个模型
BookInfo book = new BookInfo();
book.Description = this.TextDescription.Text;
book.Author = this.TextAuthor.Text;
book.Image = this.TextImage.Text;
book.Name = this.TextName.Text;
book.Price = Convert.ToDouble(this.TextPrice.Text);
book.TypeId = Convert.ToInt32(DropDownList.SelectedValue);
book.Id = id;
if (bookDao.UpdateBookInfo(book))
{
//设置样式
ResultInfo.CssClass = "text-success";
ResultInfo.Text = "更新成功！";
}
else
{
ResultInfo.CssClass = "text-danger";
ResultInfo.Text = "更新失败！";
}
}
public static bool Update(Dictionary <String, Object> map)
{
if (map == null)
{
return(false);
}
try
{
BookDto dto = (BookDto)map.GetValue("OBJECT");
dto.CategoryId = DefinitionBUS.GetListCategoryId(map.GetValue("CATEGORY").ToString());
dto.AuthorId = AuthorBUS.GetListAuthorId(map.GetValue("AUTHOR").ToString());
dto.PublisherId = PublisherBUS.GetPublisherId(map.GetValue("PUBLISHER").ToString());
dto.ProviderId = ProviderBUS.GetPublisherId(map.GetValue("PROVIDER").ToString());
BookDto oldDto = allNotDeletedBooks.FirstOrDefault(n => n.BookId == dto.BookId);
bool result = BookDao.Update(dto);
if (result)
{
if (oldDto != null)
{
allNotDeletedBooks.Remove(oldDto);
}
allNotDeletedBooks.Add(dto);
allNotDeletedBooks.OrderBy(n => n.BookId);
}
return(result);
}
catch (Exception ex)
{
return(false);
}
}
void Load_cmbAcctType()
{
List <BookDto> bookList = new List <BookDto>();
bookList = BookDao.GetAll();
List <ComboItems> _ItemList = new List <ComboItems>();
ComboItems Item;
Item = new ComboItems();
Item.DisplayMember = "Select";
Item.ValueMember = "-1";
_ItemList.Add(Item);
foreach (BookDto book in bookList)
{
Item = new ComboItems();
Item.DisplayMember = book.BookName;
Item.ValueMember = book.BookID.ToString();
_ItemList.Add(Item);
}
cmbBooks.DataSource = _ItemList;
cmbBooks.DisplayMember = "DisplayMember";
cmbBooks.ValueMember = "ValueMember";
cmbBooks.SelectedValue = "-1";
}
private void ImportBooks(ILibrary libManager)
{
IDConversionDao idcDao = new IDConversionDao();
BookDao bookDao = new BookDao();
var anotherDbBooks = bookDao.FindAll(_dataOpUnit.CurrentConnection, s_ANOTHER_DATABASE_ALIAS_NAME).ToList().ToViewModel();
var books = bookDao.FindAll(_dataOpUnit.CurrentConnection).ToList().ToViewModel();
//同ID：対象ライブラリのエンティティを新規IDでインポートする。取込側ライブラリに新規IDと旧IDを記録する。
var alpha = from b in anotherDbBooks
join ob in books on b.ID equals ob.ID
select b;
foreach (var add in alpha)
{
var newGuid = Guid.NewGuid();
idcDao.Insert(new Data.Entity.Migration.IDConversion("Book", newGuid, add.ID), _dataOpUnit.CurrentConnection);
add.ID = newGuid;
ImportBookWithContents(libManager, add);
}
//異ID：対象ライブラリのエンティティを変更せずそのままインポートする。
var beta = from b in anotherDbBooks.Except(alpha)
select b;
foreach (var add in beta)
{
ImportBookWithContents(libManager, add);
}
}
public ActionResult PartialIndex(int?page, int authorID = 0, int categoryID = 0)
{
ViewBag.AuthorID = authorID;
ViewBag.CategoryID = categoryID;
int pageNumber = page ?? 1;
var listBooks = BookDao.GetListBooks().ToList();
if (authorID > 0)
{
listBooks = listBooks.Where(m => m.AuthorID == authorID && m.IsActive).ToList();
categoryID = 0;
}
if (categoryID > 0)
{
listBooks = listBooks.Where(m => m.CategoryID == categoryID && m.IsActive).ToList();
authorID = 0;
}
ViewBag.CurrentAuthorID = authorID;
ViewBag.CurrentCategoryID = categoryID;
Cart cart = (Cart)Session[SessionBox.CART_SESSION];
if (cart == null)
{
cart = new Cart();
}
ViewBag.Cart = cart;
return(PartialView("_Index", listBooks.ToPagedList(pageNumber, 8)));
}
public JsonResult Delete(int id)
{
//result equals true if delete book successfully, else equals false
bool result = BookDao.DeleteBook(id);
return(Json(result));
}
public void CanGetBookByAuthorAndTitle()
{
var helper = Substitute.For <IBookHelper>();
var bookDao = new BookDao(helper);
var author = "author";
var title = "title";
var callNo = "callNo";
bookDao.BookList = new List <IBook>
{
Substitute.For <Book>("one", "two", "three", 1),
Substitute.For <Book>(author, title, callNo, 2),
Substitute.For <Book>("one", "two", "three", 3),
Substitute.For <Book>(author, "two", callNo, 4),
};
var book = bookDao.FindBooksByAuthorTitle(author, title).Single();
Assert.NotNull(book);
Assert.Equal(2, book.ID);
Assert.Equal(author, book.Author);
Assert.Equal(title, book.Title);
Assert.Equal(callNo, book.CallNumber);
}
public override void DropTable(IConnection connection)
{
BookDao dao = new BookDao(typeof(Version_1));
dao.CurrentConnection = connection;
dao.DropTable();
++ModifiedCount;
}
public void CanCreateBookDao()
{
var helper = Substitute.For <IBookHelper>();
var bookDao = new BookDao(helper);
Assert.NotNull(bookDao);
}
public ActionResult Category(int id)
{
IList <Book> books = new BookDao().GetBooksInCategoryId(id);
ViewBag.Categories = new BookCategoryDao().GetAll();
return(View("Index", books));
}
public static List <BookDto> GetAllNotDeletedBooks()
{
if (allNotDeletedBooks == null || allNotDeletedBooks.Count == 0)
{
allNotDeletedBooks = BookDao.Where(n => n.IsDeleted == false).ToList();
}
return(allNotDeletedBooks);
}
//
// GET: /Admin/Book/
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var dao = new BookDao();
var model = dao.ListAllpaging(searchString, page, pageSize);
ViewBag.searchString = searchString;
return(View(model));
}
public ActionResult Index()
{
var dao = new BookDao();
//var model = dao.Search(search);
//ViewBag.search = search;
return(View());
}
public ActionResult Producer(long Pro_id)
{
var pro = new ProducerDao().ViewDetail(Pro_id);
ViewBag.Producer = pro;
var model = new BookDao().ListByProducer(Pro_id);
return(View(model));
}
public static void WrtieAllBook(int index = 1)
{
for (int i = 0; i < COUNT; i++)
{
Book b = GetBook(i);
using (BookDao dao = new BookDao())
dao.add(b);
}
}
public ActionResult Category(long Ca_id)
{
var category = new BookCategoryDao().ViewDetail(Ca_id);
ViewBag.Category = category;
var model = new BookDao().ListByCategoryID(Ca_id);
return(View(model));
}
public ActionResult Author(long Au_id)
{
var author = new AuthorDao().ViewDetail(Au_id);
ViewBag.Author = author;
var model = new BookDao().ListByAuthor(Au_id);
return(View(model));
}
public ActionResult BookNew()
{
int itemOnPage = 3;
int pg = 1;
int totalBook;
IList<Book> book = new BookDao().GetBookPage(itemOnPage, pg, out totalBook);
return View(book);
}
//用户主页
public ActionResult Index()
{
//热门书籍
PagingArgument p = new PagingArgument();
p.index = 0;
p.size = 10;
List<Book> hotBooks;
using (BookDao dao = new BookDao())
hotBooks = dao.Find(null, p);
ViewBag.hotBooks = hotBooks;
return View();
}
public ActionResult Addbook(Book book, HttpPostedFileBase picture, int categoryId)
{
if ( ModelState.IsValid )
{
if ( picture != null )
{
if ( picture.ContentType == "image/jpeg" || picture.ContentType == "image/png" )
{
Image image = Image.FromStream(picture.InputStream);
if ( image.Height > 200 || image.Width > 200 )
{
Image small = Helper.ImageHelper.ScaleImage(image, 200, 200);
Bitmap b = new Bitmap(small);
Guid guid = Guid.NewGuid();
string imageName = guid.ToString() + ".jpg";
b.Save(Server.MapPath("~/uploads/aticleImage/" + imageName), ImageFormat.Jpeg);
b.Save(Server.MapPath("~/uploads/articleImage/" + imageName), ImageFormat.Jpeg);
small.Dispose();
b.Dispose();
book.ImageName = imageName;
}
else
{
picture.SaveAs(Server.MapPath("~/uploads/Article/" + picture.FileName));
}
}
}
BookCategoryDao bookCategoryDao = new BookCategoryDao();
BookCategory bookCategory = bookCategoryDao.GetById(categoryId);
book.Category = bookCategory;
book.PosteDate = DateTime.Now;
BookDao bookDao = new BookDao();
bookDao.Create(book);
TempData["message-success"] = "Článek byl přidán";
}
else
{
return View("Create", book);
}
return RedirectToAction("Index");
}
//书籍列表
public ActionResult JBookList(int draw, int start, int length, BookCondition c)
{
PagingArgument page = new PagingArgument();
page.start = start;
page.size = length;
List<Book> data = null;
using (BookDao dao = new BookDao())
data = dao.Find(c, page);
DataResponse r = new DataResponse();
r.draw = draw;
r.data = data;
r.recordsFiltered = page.count;
return Json(r, JsonRequestBehavior.AllowGet);
}
// GET: Book
/// <summary>
/// Seznam všech knih
/// </summary>
/// <param name="page"></param>
/// <returns>knihy</returns>
public ActionResult Index(int? page)
{
int itemOnPage = 5;
int pg = page ?? 1;
int totalBook;
IList<Book> book = new BookDao().GetBookPage(itemOnPage, pg, out totalBook);
// Stránkování
ViewBag.Pages = (int)Math.Ceiling((double)totalBook / (double)itemOnPage);
ViewBag.CurrentPage = pg;
ViewBag.Category = new BookCategoryDao().GetAll();
return View(book);
}
public ActionResult EditBook(int id)
{
Book book = new BookDao().GetById(id);
ViewBag.Categories = new BookCategoryDao().GetAll();
return View(book);
}
public ActionResult UpdateBook(Book book, HttpPostedFileBase picture, int categoryId)
{
try
{
BookDao bookDao = new BookDao();
BookCategoryDao bookCategoryDao = new BookCategoryDao();
BookCategory bookCategory = bookCategoryDao.GetById(categoryId);
User user = new UserDao().GetByLogin(User.Identity.Name);
book.Category = bookCategory;
if ( picture != null )
{
if ( picture.ContentType == "image/jpeg" || picture.ContentType == "image/png" )
{
Image image = Image.FromStream(picture.InputStream);
Guid guid = Guid.NewGuid();
string imageName = guid.ToString() + ".jpg";
if ( image.Height > 200 || image.Width > 200 )
{
Image small = Helper.ImageHelper.ScaleImage(image, 200, 200);
Bitmap b = new Bitmap(small);
b.Save(Server.MapPath("~/uploads/articleImage/" + imageName), ImageFormat.Jpeg);
small.Dispose();
b.Dispose();
}
else
{
picture.SaveAs(Server.MapPath("~/uploads/articleImage/" + picture.FileName));
}
System.IO.File.Delete(Server.MapPath("~/uploads/articleImage/" + book.ImageName));
book.ImageName = imageName;
};
}
bookDao.Update(book);
TempData["message-success"] = "Článek " + book.Title + " byl upravena.";
}
catch ( Exception )
{
throw;
}
return RedirectToAction("Index");
}
public BookService()
{
bookDao = new BookDao(new BookRepository()); // :(
}
public ActionResult DeleteBook(int id)
{
try
{
BookDao bookDao = new BookDao();
Book book = bookDao.GetById(id);
if ( book.ImageName != null )
System.IO.File.Delete(Server.MapPath("~/image/articleImage/" + book.ImageName));
bookDao.Delete(book);
TempData["message-success"] = "Článek" + book.Title + "byla smazan.";
}
catch ( Exception exception )
{
throw;
}
return RedirectToAction("Index");
}
public static void WrtieBook(int index)
{
Book b = GetBook(index);
using (BookDao dao = new BookDao())
dao.add(b);
}
/// <summary>
/// Detail knihy
/// </summary>
/// <param name="id">Identifikační číslo knihy</param>
/// <returns>¨detail knihy</returns>
public ActionResult BookDetail(int id)
{
Book book = new BookDao().GetById(id);
return View(book);
}
