public IActionResult PersonDetail(int id)
{
Person person = _bookcontext.People.Include(q => q.BookPeople).ThenInclude(BookPeople => BookPeople.Book).ThenInclude(BookPeople => BookPeople.BookPersons).Include(q => q.PersonDuties).FirstOrDefault(q => q.ID == id);
PersonVM model = new PersonVM();
model.Name = person.Name;
model.SurName = person.SurName;
model.BirthDate = person.BirthDate;
model.Biography = person.Biography;
model.Duties = person.PersonDuties.Where(q => q.IsDeleted == false).Select(q => q.DutyID == Convert.ToInt32(EnumDuty.Writer) ? EnumDuty.Writer.ToString() : EnumDuty.Interpreter.ToString()).ToList();
model.Imagepath = person.Imagepath;
model.BookPeople = person.BookPeople;
List <Category> modelcategory = _bookcontext.Categories.Where(q => q.IsDeleted == false).OrderBy(q => q.CategoryName).ToList();
List <Person> modelpeople = _bookcontext.People.Include(q => q.BookPeople.Where(q => q.DutyID == 0)).Where(q => q.IsDeleted == false).OrderBy(q => q.Name).ToList();
SiteBookVM sitebook = new SiteBookVM();
sitebook.Categories = modelcategory;
sitebook.people = modelpeople;
sitebook.PersonDetail = model;
return(View(sitebook));
}
public IActionResult Index(int?page)
{
var pagenumber = page ?? 1;
List <PersonVM> people = _bookcontext.People.Include(q => q.BookPeople).ThenInclude(BookPeople => BookPeople.Book).Where(q => q.IsDeleted == false).OrderBy(q => q.Name).Select(q => new PersonVM()
{
PersonID = q.ID,
Name = q.Name,
SurName = q.SurName,
Biography = q.Biography,
BirthDate = q.BirthDate,
Imagepath = q.Imagepath,
BookPeople = q.BookPeople.Where(q => q.IsDeleted == false).ToList(),
Duties = q.PersonDuties.Where(q => q.IsDeleted == false).Select(q => q.DutyID == Convert.ToInt32(EnumDuty.Writer) ? EnumDuty.Writer.ToString() : EnumDuty.Interpreter.ToString()).ToList(),
}).ToList();
List <Category> modelcategory = _bookcontext.Categories.Where(q => q.IsDeleted == false).OrderBy(q => q.CategoryName).ToList();
List <Person> modelpeople = _bookcontext.People.Include(q => q.BookPeople.Where(q => q.DutyID == 0)).Where(q => q.IsDeleted == false).OrderBy(q => q.Name).ToList();
SiteBookVM sitebook = new SiteBookVM();
sitebook.Categories = modelcategory;
sitebook.people = modelpeople;
sitebook.PeopleVM = people.ToPagedList(pagenumber, 9);
return(View(sitebook));
}
public IActionResult EditComment(SiteBookVM model)
{
Comment comment = _bookcontext.Comments.FirstOrDefault(q => q.ID == model.Comment.ID);
comment.Header = model.Comment.Header;
comment.Content = model.Comment.Content;
comment.UpdateDate = DateTime.Now;
_bookcontext.SaveChanges();
return(RedirectToAction("BookDetail", "SiteBook", new { id = comment.BookID }));
}
public IActionResult Search(string keywords, int?catalog, int?category, int?scategory, int?page)
{
var pagenumber = page ?? 1;
List <Category> modelcategory = _bookcontext.Categories.Where(q => q.IsDeleted == false).OrderBy(q => q.CategoryName).ToList();
List <Person> modelpeople = _bookcontext.People.Include(q => q.BookPeople.Where(q => q.DutyID == 0)).Where(q => q.IsDeleted == false).OrderBy(q => q.Name).ToList();
var data = _bookcontext.Books.Include(x => x.BookCategories).ThenInclude(BookCategory => BookCategory.Category).Include(x => x.BookPersons).ThenInclude(BookPerson => BookPerson.Person).OrderBy(q => q.Name).Where(x => x.IsDeleted == false).ToList();
if (!String.IsNullOrEmpty(keywords))
{
data = data.Where(x => x.Name.ToLower().Contains(keywords.ToLower()) || x.BookPersons.Where(x => x.Person.Name.ToLower().Contains(keywords.ToLower())).Any() || x.BookPersons.Where(x => x.Person.SurName.ToLower().Contains(keywords.ToLower())).Any() && x.IsDeleted == false).Where(Book => Book.IsDeleted == false).ToList();
}
if (catalog != null)
{
data = data.Where(x => x.BookCategories.Where(x => x.Category.TopCategory == catalog || x.CategoryID == catalog).Any())
.Where(Book => Book.IsDeleted == false).ToList();
}
if (category != null)
{
data = data.Where(x => x.BookCategories.Where(x => x.CategoryID == category || x.Category.TopCategory == category).Any())
.Where(Book => Book.IsDeleted == false).ToList();
}
if (scategory != null)
{
data = data.Where(x => x.BookCategories.Where(x => x.CategoryID == scategory).Any())
.Where(Book => Book.IsDeleted == false).ToList();
}
SiteBookVM sitebook = new SiteBookVM();
sitebook.books = data.ToPagedList(pagenumber, 9);
sitebook.Categories = modelcategory;
sitebook.people = modelpeople;
return(View("Index", new SiteBookVM {
books = data.ToPagedList(pagenumber, 9), Categories = modelcategory, people = modelpeople
}));
}
public IActionResult AddComment(SiteBookVM model)
{
Comment comment = new Comment();
comment.UserID = Convert.ToInt32(TempData["UserID"]);
comment.Header = model.Comment.Header;
comment.Content = model.Comment.Content;
comment.BookID = model.Bookdetail.ID;
_bookcontext.Comments.Add(comment);
_bookcontext.SaveChanges();
return(RedirectToAction("BookDetail", "SiteBook", new { id = model.Bookdetail.ID }));
}
public IActionResult BookDetail(int id)
{
List <Category> modelcategory = _bookcontext.Categories.Where(q => q.IsDeleted == false).OrderBy(q => q.CategoryName).ToList();
Book modelbook = _bookcontext.Books.Include(q => q.BookCategories).ThenInclude(BookCategories => BookCategories.Category).Include(q => q.BookPersons.Where(q => q.IsDeleted == false)).ThenInclude(BookPersons => BookPersons.Person).Include(q => q.Comments.Where(q => q.IsDeleted == false && q.BookID == id)).ThenInclude(Comments => Comments.User).Include(q => q.UserPoints.Where(q => q.IsDeleted == false)).ThenInclude(UserPoints => UserPoints.USer).FirstOrDefault(q => q.ID == id);
List <Person> modelpeople = _bookcontext.People.Include(q => q.BookPeople.Where(q => q.DutyID == 0)).Where(q => q.IsDeleted == false).OrderBy(q => q.Name).ToList();
SiteBookVM sitebook = new SiteBookVM();
sitebook.Bookdetail = modelbook;
sitebook.Categories = modelcategory;
sitebook.people = modelpeople;
return(View(sitebook));
}
public IActionResult Index(int?page)
{
var pagenumber = page ?? 1;
List <Book> modelbook = _bookcontext.Books.Include(q => q.BookCategories).ThenInclude(BookCategories => BookCategories.Category).Include(q => q.BookPersons).ThenInclude(BookPerson => BookPerson.Person).Where(q => q.IsDeleted == false).OrderBy(q => q.Name).ToList();
List <Category> modelcategory = _bookcontext.Categories.Where(q => q.IsDeleted == false).OrderBy(q => q.CategoryName).ToList();
List <Person> modelpeople = _bookcontext.People.Include(q => q.BookPeople.Where(q => q.DutyID == 0)).Where(q => q.IsDeleted == false).OrderBy(q => q.Name).ToList();
//var pagedsitebook = modelbook.ToPagedList(pagenumber, 10);
SiteBookVM sitebook = new SiteBookVM();
//sitebook.books = pagedsitebook.ToList();
sitebook.Categories = modelcategory;
sitebook.people = modelpeople;
sitebook.books = modelbook.ToPagedList(pagenumber, 9);
return(View(sitebook));
}
public IActionResult WriterListclick(int id, int?page)
{
var pagenumber = page ?? 1;
List <Category> modelcategory = _bookcontext.Categories.Where(q => q.IsDeleted == false).OrderBy(q => q.CategoryName).ToList();
List <Person> modelpeople = _bookcontext.People.Include(q => q.BookPeople.Where(q => q.DutyID == 0)).Where(q => q.IsDeleted == false).OrderBy(q => q.Name).ToList();
List <Book> data = _bookcontext.Books.Include(x => x.BookCategories).ThenInclude(BookCategory => BookCategory.Category).Include(x => x.BookPersons).ThenInclude(BookPerson => BookPerson.Person).OrderBy(q => q.Name).Where(x => x.IsDeleted == false).ToList();
data = data.Where(x => x.BookPersons.Where(x => x.PersonID == id).Any())
.Where(Book => Book.IsDeleted == false).ToList();
SiteBookVM sitebook = new SiteBookVM();
sitebook.books = data.ToPagedList(pagenumber, 9);
sitebook.Categories = modelcategory;
sitebook.people = modelpeople;
return(View("Index", new SiteBookVM {
books = data.ToPagedList(pagenumber, 9), Categories = modelcategory, people = modelpeople
}));
}