protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity <Book>().HasKey(b => b.Id);
modelBuilder.Entity <Reader>().HasKey(r => r.Id);
modelBuilder.Entity <IssuedBook>().HasKey(ib => ib.Id);
modelBuilder.Entity <Reader>().HasMany((r) => r.IssuedBooks).WithOne(ib => ib.Reader)
.HasForeignKey(ib => ib.IdReader)
.OnDelete(DeleteBehavior.Cascade);
modelBuilder.Entity <Book>().HasMany((b) => b.IssuedBooks).WithOne(ib => ib.Book)
.HasForeignKey(ib => ib.IdBook)
.OnDelete(DeleteBehavior.Cascade);
modelBuilder.Query <IssuedBookView>().ToQuery(() =>
IssuedBooks.Include(ib => ib.Reader).Include(ib => ib.Book)
.Select(book => new IssuedBookView
{
Id = book.Id,
IdReader = book.IdReader,
IdBook = book.IdBook,
ReaderName = book.Reader.Name,
ReaderSurname = book.Reader.Surname,
ReaderPatronymic = book.Reader.Patronymic,
BookName = book.Book.BookName,
BookAuthorName = book.Book.AuthorName,
DateIssue = book.DateIssue,
DateReturn = book.DateReturn,
})
);
}
public async Task <IActionResult> Edit(string id, [Bind("IssueDate,ReturnDate,ReturnMark,EmpId,ReadId,BookId")] IssuedBooks issuedBooks)
{
if (id != issuedBooks.ReturnMark)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(issuedBooks);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IssuedBooksExists(issuedBooks.ReturnMark))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["BookId"] = new SelectList(_context.Books, "BookId", "Author", issuedBooks.BookId);
ViewData["EmpId"] = new SelectList(_context.Employee, "EmpId", "Address", issuedBooks.EmpId);
ViewData["ReadId"] = new SelectList(_context.Readers, "ReadId", "Address", issuedBooks.ReadId);
return(View(issuedBooks));
}
public async Task <IActionResult> Create([Bind("IssueDate,ReturnDate,ReturnMark,EmpId,ReadId,BookId")] IssuedBooks issuedBooks)
{
if (ModelState.IsValid)
{
_context.Add(issuedBooks);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["BookId"] = new SelectList(_context.Books, "BookId", "Author", issuedBooks.BookId);
ViewData["EmpId"] = new SelectList(_context.Employee, "EmpId", "Address", issuedBooks.EmpId);
ViewData["ReadId"] = new SelectList(_context.Readers, "ReadId", "Address", issuedBooks.ReadId);
return(View(issuedBooks));
}
public ActionResult Edit(IssuedBookViewModel issuedBookViewModel)
{
if (ModelState.IsValid)
{
IssuedBooks issuedBooks = db.issuedBook.Find(issuedBookViewModel.issuedId);
var fromDate = issuedBookViewModel.displayFromDate;
var toDate = issuedBookViewModel.displayToDate;
issuedBooks.fromDate = Convert.ToDateTime(fromDate);
issuedBooks.toDate = Convert.ToDateTime(toDate);
db.Entry(issuedBooks).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(issuedBooks));
}
public JsonResult BookIssue(IssuedBooks issuedBooks)
{
var Book = db.book.FirstOrDefault(b => b.bookId == issuedBooks.bookId);
if (issuedBooks != null && Book != null)
{
db.issuedBook.Add(issuedBooks);
db.SaveChanges();
Book.isAvailable = false;
db.Entry(Book).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { result = "success" }));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}