public IActionResult AllTheBooks()
{
var bookList = new BookListModel
{
BookList = new List <BookModel>
{
new BookModel {
BookTitle = "Book1",
BookAuthor = "Christian",
BookYear = 2010
},
new BookModel {
BookTitle = "Book2",
BookAuthor = "Hina",
BookYear = 2014
},
new BookModel {
BookTitle = "Book3",
BookAuthor = "Mariam",
BookYear = 1998
}
}
};
return(View(bookList));
}
public async Task <bool> Delete(int bookListId)
{
BookListModel item = await GetRaw(bookListId);
if (item == null)
{
return(true);
}
if (!item.Removable)
{
return(false);
}
try
{
_context.Remove(item);
await _context.SaveChangesAsync();
return(true);
}
catch (DbUpdateConcurrencyException)
{
item = await GetRaw(bookListId);
return(item == null);
}
}
private async Task <IList <BookModel> > prepareSearchResults(IList <BookModel> results)
{
if (results.Count == 0)
{
return(results);
}
List <BookModel> finalResults = new List <BookModel>();
foreach (BookModel book in results)
{
BookModel finalBook = await Get("", book.IdGoogleService, false);
if (finalBook == null)
{
finalBook = book;
}
else
{
BookListModel bl = (await UserBookList(book.Id));
book.UserBookListId = (bl == null) ? 0 : bl.Id;
}
finalResults.Add(finalBook);
}
return(finalResults);
}
public ActionResult DonateBook(BookListModel donatedBook)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var Username = Session["UserName"].ToString();
var dbUser = db.Users.SingleOrDefault(x => x.Username == Username);
var Reques = new RequestFor();
Reques.Genres = new List <Genre>();
Reques.User = new User();
Reques.User.Id = dbUser.Id;
Random rastgele = new Random();
int sayi = rastgele.Next(500);
Reques.Id = sayi;
Reques.Message = donatedBook.Message;
foreach (var item in donatedBook.genres.ToList())
{
if (item.Checked)
{
var genre = new Genre();
genre.Name = item.Name;
genre.Checked = item.Checked;
genre.RequestFors = new RequestFor();
//---------------------------requestera tür isimlerini mesaj olarak ekle
genre.RequestFors.Id = Reques.Id;
genre.GenreBookCount = 1;
db.Genres.Add(genre);
}
}
// db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public async Task <bool> Reorder(IList <int> orderedIds)
{
List <BookListModel> userLists = await GetAllRaw();
List <int> userListIds = userLists.Select(bl => bl.Id).ToList();
if (userListIds.Count != orderedIds.Count)
{
return(false);
}
int position = 0;
foreach (int id in orderedIds)
{
if (!userListIds.Contains(id))
{
return(false);
}
BookListModel bookList = userLists[userListIds.IndexOf(id)];
bookList.Order = position;
_context.Update(bookList);
position++;
}
await _context.SaveChangesAsync();
return(true);
}
public async Task <ResponseViewModel> Edit([FromForm, Bind("Id, Name,Color")] BookListModel bookList)
{
bookList.Removable = true;
bookList.User = null;
BookListModel result = await _bookList.Edit(bookList);
if (result == null)
{
return new ResponseViewModel()
{
Message = _localizer["EdicionKO"],
Code = (int)HttpStatusCode.BadRequest,
VerificationToken = _antiforgery.GetAndStoreTokens(HttpContext).RequestToken
}
}
;
return(new ResponseViewModel()
{
Message = _localizer["EdicionOK"],
Result = result.getViewModel(),
VerificationToken = _antiforgery.GetAndStoreTokens(HttpContext).RequestToken
});
}
public async Task <ResponseViewModel> Create([FromForm, Bind("Name,Color")] BookListModel bookList, [FromForm] string BookId)
{
bookList.Removable = true;
bookList.User = AppEnvironment.CurrentUser;
BookListModel result = await _bookList.Add(bookList);
if (!string.IsNullOrEmpty(BookId))
{
result = await _bookList.AddBookToList(BookId, result.Id);
}
if (result == null)
{
return new ResponseViewModel()
{
Message = _localizer["CreacionKO"],
Code = (int)HttpStatusCode.BadRequest,
VerificationToken = _antiforgery.GetAndStoreTokens(HttpContext).RequestToken
}
}
;
return(new ResponseViewModel()
{
Message = _localizer["CreacionOK"],
Result = result.getViewModel(),
VerificationToken = _antiforgery.GetAndStoreTokens(HttpContext).RequestToken
});
}
public async Task <BookListModel> DeleteBookToList(string bookId, int bookListId)
{
BookListModel bookList = await GetRaw(bookListId, true);
if (bookList == null)
{
return(null);
}
BookModel book = await _book.Get(bookId);
if (book == null || book.Id <= 0)
{
return(bookList);
}
List <Book_BookListModel> book_bookList_list = bookList.Book_BookLists.Where(b => b.BookId == book.Id).ToList();
if (book_bookList_list.Count == 0)
{
return(bookList);
}
_context.Remove(book_bookList_list.First());
_context.Update(bookList);
await _context.SaveChangesAsync();
return(bookList);
}
public async Task <BookListModel> Edit(BookListModel bookList)
{
BookListModel item = await GetRaw(bookList.Id);
if (item == null)
{
return(null);
}
if (!item.Removable)
{
return(item);
}
item.Color = bookList.Color;
item.Name = bookList.Name;
_context.Entry(item).State = EntityState.Modified;
try
{
_context.Update(item);
await _context.SaveChangesAsync();
return(bookList);
}
catch (DbUpdateConcurrencyException)
{
return(item);
}
}
/// <summary>
/// 首页
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
var model = new BookListModel();
model.Company = GetCompany();
return(View(GetViewPath("~/Views/Book/index.cshtml"), model));
}
public BookListModel QueryBooks(RequestBookModel searchMessage)
{
var cs = "Server=localhost\\SQLEXPRESS;Database=LibraryDB;Trusted_Connection=True;";
using var con = new SqlConnection(cs); //Using Class SqlConnection for COnnent to database
con.Open();
string sql = string.Format(@"SELECT Id, Name, Auther, Category, BookmarkBtn, DetailBtn FROM BookTable
WHERE(Name LIKE '%{0}%' OR Auther LIKE '%{0}%' OR Category LIKE '%{0}%')",
searchMessage.text);
using var cmd = new SqlCommand(sql, con);
using SqlDataReader rdr = cmd.ExecuteReader();
BookListModel output = new BookListModel();
output.books = new List <BookModel>();
while (rdr.Read())
{
output.books.Add(
new BookModel()
{
bookId = rdr.GetInt32(0),
name = rdr.GetString(1),
author = rdr.GetString(2),
category = rdr.GetString(3),
bookmark = rdr.GetBoolean(4),
detail = rdr.GetBoolean(5),
}
);
}
return(output);
}
public BookListModel AllBooks()
{
var cs = "Server=localhost\\SQLEXPRESS;Database=LibraryDB;Trusted_Connection=True;";
using var con = new SqlConnection(cs); //Using Class SqlConnection for COnnent to database
con.Open();
string sql = "SELECT Id, Name, Auther, Category, Bookmark, Detail FROM BookTable";
using var cmd = new SqlCommand(sql, con);
using SqlDataReader rdr = cmd.ExecuteReader();
BookListModel output = new BookListModel();
output.books = new List <BookModel>();
while (rdr.Read())
{
output.books.Add(
new BookModel()
{
bookId = rdr.GetInt32(0),
name = rdr.GetString(1),
author = rdr.GetString(2),
category = rdr.GetString(3),
bookmark = rdr.GetBoolean(4),
detail = rdr.GetBoolean(5),
}
);
}
return(output);
}
public ActionResult SaveBookData(BookListModel obj)
{
var _service = new BookService();
try
{
if (obj != null)
{
if (obj.BookPicImage != null)
{
string ImageName = obj.BookName + "_" + DateTime.Now.Ticks.ToString() + "_" + obj.BookPicImage.FileName.ToString();
_service.UploadImage(obj.BookPicImage, Server.MapPath(ConfigurationManager.AppSettings["BookImage"]), ImageName);
obj.BookPic = ImageName;
}
var save = _service.SaveBookData(obj);
if (save)
{
return(View("GetBookList"));
}
else
{
return(RedirectToAction("AddBook"));
}
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
}
return(View("GetBookList"));
}
public ActionResult BookList()
{
BookListModel model = new BookListModel();
model.Books = db.Tbl_Book;
return(View(model));
}
/// <summary>
/// 得到类目
/// </summary>
/// <returns></returns>
protected virtual IList <BookEntity> GetBooks(BookListModel model)
{
var query = new QueryInfo();
query.Query <BookEntity>().Where(it => it.Site.Id == SiteId && it.IsUsed)
.OrderBy(it => it.Id).Select(it => new object[] { it.Id, it.FileName });
return(this.GetEntities <BookEntity>(query));
}
public async Task <IActionResult> Filter(string searchTerm)
{
IEnumerable <BookResponse> books = await _bookService.SearchBooksAsync(searchTerm);
List <BookListModel.BookListDetailModel> bookModels = new BookListModel().TransformToModel(books);
return(Ok(bookModels));
}
public static BookListModel GetBookListModel()
{
if (BookListModel == null)
{
BookListModel = new BookListModel();
}
return BookListModel;
}
public IActionResult Index()
{
var model = new BookListModel
{
BookList = db.Books.ToArray(),
};
return(View(model));
}
public IActionResult Post([FromForm] string key_word)
{
var model = new BookListModel
{
BookList = db.Books.FromSql("select * from Books where title like '%" + key_word + "%';").ToArray(),
};
return(View("Index", model));
}
public IActionResult Post([FromForm] string key_word)
{
var model = new BookListModel
{
BookList = db.Books.Where(b => b.Title.Contains(key_word)).ToArray(),
};
return(View("Index", model));
}
/// <summary>
/// 首页
/// </summary>
/// <returns></returns>
public ActionResult List()
{
var model = new BookListModel();
model.Books = GetBooks(model);
model.Company = GetCompany();
model.SetSize();
if (model.Books == null || model.Books.Count == 0)
{
return(Content(""));
}
return(View(GetViewPath("~/Views/Book/_Book.cshtml"), model));
}
public async Task <BookListModel> Add(BookListModel bookList)
{
if (bookList.User == null)
{
bookList.User = AppEnvironment.CurrentUser;
}
bookList.Order = (await GetAllRaw()).Count;
_context.Add(bookList);
await _context.SaveChangesAsync();
return(bookList);
}
private async Task <BookListModel> GetRaw(int bookListId, bool includeBooks = false)
{
IQueryable <BookListModel> query = _context.BookList
.Where(bl => bl.Id == bookListId && bl.User.Id == AppEnvironment.CurrentUser.Id);
if (includeBooks)
{
query = query.Include(bl => bl.Book_BookLists).ThenInclude(bbl => bbl.Book);
}
BookListModel bl = await query.FirstOrDefaultAsync();
return(bl);
}
private BookListModel ConvertToListModel(Book book)
{
var result = new BookListModel
{
BookID = book.BookID,
Author = book.Author,
Title = book.Title,
Comments = book.Comments,
Email = book.Email,
Price = book.Price,
Year = book.Year
};
return(result);
}
public IActionResult AllTheBooks()
{
var bookList = new BookListModel {
};
// bookList.BookList= new List<BookModel>();
var context = new BookishContext();
var shelves = context.BookModel;
foreach (var book in shelves)
{
bookList.BookList.Add(book);
}
return(View(bookList));
}
public async Task <BookListModel> Get(int bookListId, bool includeBooks = false)
{
BookListModel bl = await GetRaw(bookListId, includeBooks);
if (bl == null)
{
return(null);
}
if (AppEnvironment.DefaultBookLists.ContainsKey(bl.Name))
{
bl.Name = _localizer[bl.Name];
}
_context.Entry(bl).State = EntityState.Detached;
return(bl);
}
public ActionResult DonateBook()
{
using (BodonateDbContext db = new BodonateDbContext())
{
if (Session["UserName"] != null)
{
var Username = Session["UserName"].ToString();
var dbUser = db.Users.SingleOrDefault(x => x.Username == Username);
var model = new List <BookModel>();
var Model = new BookListModel();
var genre1 = new BookModel();
genre1.Name = "hikaye";
ModelState.Clear();
Model.genres.Add(genre1);
var genre2 = new BookModel();
genre2.Name = "deneme";
ModelState.Clear();
Model.genres.Add(genre2);
/*
* var genreList = GenreRepo.GetAllGenres();
*
*
* foreach (var item in genreList)
* {
* var add = new BookModel();
* add.Name = item.Name;
* add.Checked = item.Checked;
* Model.genres.Add(add);
*
* }
*
*/
return(View(Model));
}
}
return(RedirectToAction("UserLogin"));
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created For : To save and update book data by using book id
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool SaveBookData(BookListModel obj)
{
bool isSave = false;
try
{
if (obj.BookId == 0)
{
var tableData = new Tbl_BookStore();
tableData.BookName = obj.BookName;
tableData.BookPic = obj.BookPic;
tableData.BookPrice = obj.BookPrice;
tableData.BookISBN = obj.BookISBN;
tableData.BookPublication = obj.BookPublication;
tableData.BookDate = obj.BookDate;
tableData.AuthorName = obj.AuthorName;
tableData.BookDescription = obj.BookDescription;
tableData.IsDelete = false;
_db.Tbl_BookStore.Add(tableData);
_db.SaveChanges();
isSave = true;
}
else
{
var getData = _db.Tbl_BookStore.Where(x => x.BookId == obj.BookId).FirstOrDefault();
getData.BookName = obj.BookName;
getData.BookPic = obj.BookPic;
getData.BookPrice = obj.BookPrice;
getData.BookISBN = obj.BookISBN;
getData.BookPublication = obj.BookPublication;
getData.BookDate = obj.BookDate;
getData.AuthorName = obj.AuthorName;
getData.BookDescription = obj.BookDescription;
getData.IsDelete = false;
_db.Entry(getData).State = EntityState.Modified;
_db.SaveChanges();
isSave = true;
}
}
catch (Exception ex)
{
isSave = false;
throw;
}
return(isSave);
}
public BookListModel PrepareBookListModel(BookSearchModel searchModel)
{
var books = _bookervice.GetAllBooks(searchModel.SearchBookName);
var model = new BookListModel
{
Data = books.Select(book =>
{
//fill in model values from the entity
var bookModel = book.ToModel <BookModel>();
return(bookModel);
}),
Total = books.TotalCount
};
return(model);
}
public async Task <ResponseViewModel> DeleteBookToList([FromForm] string BookId, [FromForm] int BookListId)
{
BookListModel bookList = await _bookList.DeleteBookToList(BookId, BookListId);
if (bookList == null)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
await Response.WriteAsync(_localizer["LibroBorradoKO"]);
return(null);
}
return(new ResponseViewModel()
{
Message = _localizer["LibroBorradoOK"],
Result = bookList.getViewModel()
});
}
public IActionResult SearchOneBook(string search)
{
var context = new BookishContext();
List <BookModel> books;
if (!String.IsNullOrEmpty(search))
{
books = context.BookModel.Where(x => x.BookTitle == search).ToList();
}
else
{
books = context.BookModel.ToList();
}
var booklist = new BookListModel {
BookList = books
};
return(View(booklist));
}
