static void Main(string[] args) { BookUnitOfWork uow = new BookUnitOfWork(new BookModel()); AddBooks(uow); GetBooks(uow); }
private static void GetBooks(BookUnitOfWork uow) { var books = uow.ExecuteSelectProcedure <BookSummary>("spGetBooks", new object[] { "" }); foreach (var book in books) { Console.WriteLine("Name {0}, Author {1}, Publisher {2}", book.BookName, book.Author, book.Publisher); } Console.ReadLine(); }
private static void AddBooks(BookUnitOfWork uow) { //var book = uow.tblBooks.Insert(new tblBook() { Name = "A" }); //uow.tblBookDetails.Insert(new tblBookDetail() { Author = "Author1", BookID = book.BookID, Publisher = "P1", tblBook = book }); //book = uow.tblBooks.Insert(new tblBook() { Name = "B" }); //uow.tblBookDetails.Insert(new tblBookDetail() { Author = "Author2", BookID = book.BookID, Publisher = "P1", tblBook = book }); //book = uow.tblBooks.Insert(new tblBook() { Name = "C" }); //uow.tblBookDetails.Insert(new tblBookDetail() { Author = "Author3", BookID = book.BookID, Publisher = "P1", tblBook = book }); uow.ExecuteCommandProcedure("spInsertBook", new object[] { "A", "Author1", "P1" }); uow.ExecuteCommandProcedure("spInsertBook", new object[] { "B", "Author1", "P2" }); uow.ExecuteCommandProcedure("spInsertBook", new object[] { "C", "Author2", "P2" }); uow.ExecuteCommandProcedure("spInsertBook", new object[] { "D", "Author2", "P1" }); uow.ExecuteCommandProcedure("spInsertBook", new object[] { "E", "Author3", "P1" }); uow.Save(); }
public void Book_Save_Testing() { var context = new Mock <IBookDbContext>(); var bookUnitOfWork = new BookUnitOfWork(context.Object); var bookRepository = new Mock <IBookRepository>(); var categoryRepository = new Mock <ICategoryRepository>(); var facade = new BookFacade(bookRepository.Object, categoryRepository.Object, bookUnitOfWork); //var createRequest = new Mock<CreateBookRequest>(); //createRequest.Object.Create.Id = 0; //createRequest.Object.Create.IsActive = 1; //createRequest.Object.Create.IsbnNumber = "12345"; //createRequest.Object.Create.Price = 566; //createRequest.Object.Create.PublishedDate = DateTime.Now; //createRequest.Object.Create.Remarks = "Remarks"; //createRequest.Object.Create.TitleB = "Book Bengali"; //createRequest.Object.Create.TitleE = "Book English"; //createRequest.Object.Create.TotalPage = 150; //createRequest.Object.Create.BookCategoryId = 1; //createRequest.Object.Create.Description = "desc"; var createRequest = new CreateBookRequest { Create = { Id = 0, IsActive = 1, IsbnNumber = "12345", Price = 566, PublishedDate = DateTime.Now, Remarks = "Remarks", TitleB = "Book Bengali", TitleE = "Book English", TotalPage = 150, BookCategoryId = 1, Description = "desc" } }; facade.SaveBook(createRequest); }
public Bookshelf(ApiContext context) { _unitOfWork = new BookUnitOfWork(context); }
public BookController(ApiContext context) { _unitOfWork = new BookUnitOfWork(context); }
public BooksController(BookUnitOfWork b, IMapper mapper) { bookUnitOfWork = b; Mapper = mapper; }