public IActionResult Index()
{
var books = _context.Set <Book>().AsEnumerable().ToList();
var viewModel = new BookViewModel
{
Books = books
};
return(View(viewModel));
}
public void TestResetKeysSingleEntityPkAndForeignKey()
{
//SETUP
var options = SqliteInMemory.CreateOptions <BookContext>();
using (var context = new BookContext(options))
{
context.Database.EnsureCreated();
context.SeedDatabaseFourBooks();
var entity = context.Set <Review>().First();
//ATTEMPT
var resetter = new DataResetter(context);
resetter.ResetKeysSingleEntity(entity);
//VERIFY
entity.ReviewId.ShouldEqual(0);
entity.BookId.ShouldEqual(0);
}
}
public RepositoryBase(BookContext context)
{
Context = context;
DbSet = context.Set <T>();
}
public virtual IQueryable <Book> GetAll()
{
IQueryable <Book> query = context.Set <Book>().Where(x => x.State == EntityStatus.Active);
return(query);
}
public async Task <T> SelectByIdAsync(int id)
{
return(await Context.Set <T>().FindAsync(id));
}
public async Task <T> GetByIdAsync(int id)
{
return(await _context.Set <T>().FindAsync(id));
}
public IQueryable <T> Where(Expression <Func <T, bool> > expression)
{
return(_context.Set <T>().Where(expression));
}
public BookRepository(BookContext context)
{
this.context = context;
dbSet = context.Set <Book>();
}
public virtual IEnumerable <T> GetAll()
{
return(_context.Set <T>().AsEnumerable());
}
public IEnumerable <TEntity> GetAll()
{
var entities = _context.Set <TEntity>().ToList();
return(entities);
}
public ActionResult Buy(int id)
{
ViewBag.Book = db.Set <Book>().Find(id);
return(View());
}
public T Add <T>(T t) where T : class
{
mBookContext.Set <T>().Add(t);
mBookContext.SaveChanges();
return(t);
}
static async Task Main(string[] args)
{
//await Test();
using (BookContext bookContext = new BookContext(sqliteString))
{
bookContext.Database.EnsureCreated();
bookContext.Database.OpenConnection();
// test with db
bookContext.Set <ChapterLink>().Load();
bookContext.Set <IssueLink>().Load();
bookContext.Set <BookLink>().Load();
var testBook0 = bookContext.BookLinks.FirstOrDefault();
Console.WriteLine(testBook0?.IndexPage);
string username = File.ReadAllText(@"D:\Test Dir\LoginWebTest\username.txt");
string password = File.ReadAllText(@"D:\Test Dir\LoginWebTest\password.txt");
Wenku8Parser2 parser = new Wenku8Parser2(username, password, Wenku8Parser.LoginDuration.OneDay);
parser.Init();
if (await parser.TryLogin())
{
parser.SaveCookie();
List <BookshelfLink> myBooks = await parser.GetBooksFromBookshelf();
foreach (var bookshelfLink in myBooks)
{
BookLink bookLinkFromWeb = await parser.FindBookIndexPageAsync(bookshelfLink.MainPage, CodePage.Gb2312);
// update book to database (update or add new)
await TryAddNewBook(bookContext, bookLinkFromWeb);
bookContext.SaveChanges();
// download book
parser.OnlyReturnNew = true;
BookLink bookLinkFromDB = await bookContext.BookLinks.FirstOrDefaultAsync(b => b.IndexPage == bookLinkFromWeb.IndexPage);
Book book = await parser.GetBookAsync(bookLinkFromDB, CodePage.Gb2312);
bookContext.SaveChanges();
book.SaveToTxt(Environment.CurrentDirectory);
// test with db
//bookContext = new BookContext();
//bookContext.Database.EnsureCreated();
//bookContext.Database.OpenConnection();
var testBook = await bookContext.BookLinks.FirstOrDefaultAsync();
Console.WriteLine(testBook.IndexPage);
//bookContext.Database.CloseConnection();
//bookContext.Dispose();
return;
// download book
//Book book = await parser.GetBookAsync(bookLink);
// test with db after get book content
bookContext.SaveChanges();
var testBook2 = await bookContext.BookLinks.FirstOrDefaultAsync();
Console.WriteLine(testBook2.IndexPage);
bookContext.Database.CloseConnection();
// save txt to file
//book.SaveToTxt(AppDomain.CurrentDomain.BaseDirectory);
}
}
else
{
Console.WriteLine("Login failed!");
}
}
Console.ReadLine();
}
public GenericRepository(BookContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
