//// GET: Delete Book Details
//[HttpPost]
public ActionResult DeleteBooks(int id)
{
try
{
var profileData = Session["UserProfile"] as UserSession;
if (profileData == null)
{
return(RedirectToAction("Index", "Home"));
}
BookRepository bookRepository = new BookRepository();
BookAuthorRepository bookAuthorRepository = new BookAuthorRepository();
bookAuthorRepository.DeleteBookAuthorByBookId(id);
bookRepository.DeleteBooks(id);
var logModel = new LogModel
{
UserId = profileData.UserID,
TableName = "Book",
Activity = "Deleted Book",
LogDate = DateTime.Now
};
var logRepository = new logRepository();
logRepository.AddLog(logModel);
return(RedirectToAction("Dashboard", "Home"));
}
catch
{
return(RedirectToAction("Dashboard", "Home"));
}
}
public BookService()
{
_bookRepository = new BookRepository();
_publisherRepository = new PublisherRepository();
_bookPublisherRepository = new BookPublisherRepository();
_authorRepository = new AuthorRepository();
_bookAuthorRepository = new BookAuthorRepository();
}
public BookService(LibraryContext db)
{
_bookAuthorRepository = new BookAuthorRepository(db);
_bookPublishingHouseRepository = new BookPublishingHouseRepository(db);
_authorRepository = new AuthorRepository(db);
_publishingHouseRepository = new PublishingHouseRepository(db);
_bookRepository = new BookRepository(db);
}
public static void DBInsert()
{
var BookAuthor = BookAuthorRepository.BookAuthors();
var _dbContaxt = new UserDBContext();
foreach (var item in BookAuthor)
{
_dbContaxt.BookAuthors.Add(item);
}
_dbContaxt.SaveChanges();
Console.WriteLine("Данные добавлены в базу");
}
public PublishingHouseUnitOfWork(PublishingHouseContext context)
{
_context = context;
Authors = new AuthorRepository(_context);
BookAuthors = new BookAuthorRepository(_context);
BookCategories = new BookCategoryRepository(_context);
BookOrders = new BookOrderRepository(_context);
Books = new BookRepository(_context);
Carts = new CartRepository(_context);
Categories = new CategoryRepository(_context);
Comments = new CommentRepository(_context);
Notifications = new NotificationRepository(_context);
Orders = new OrderRepository(_context);
}
public ActionResult GetBook(int id)
{
var profileData = Session["UserProfile"] as UserSession;
if (profileData == null)
{
return(RedirectToAction("Index", "Home"));
}
BookRepository bookRepository = new BookRepository();
BookAuthorRepository bookAuthorRepository = new BookAuthorRepository();
AuthorRepository authorRepository = new AuthorRepository();
PublicationRepository publicationRepository = new PublicationRepository();
ContentRatingRepository contentRatingRepository = new ContentRatingRepository();
List <BookAuthorModel> bookAuthorList = new List <BookAuthorModel>();
BookDetails bookDetail = new BookDetails();
BookModel book = new BookModel();
book = bookRepository.SearchBookById(id);
bookDetail.BookModel = book;
bookAuthorList = bookAuthorRepository.GetByBookId(book.BookId);
if (bookAuthorList.Count == 1)
{
bookDetail.AuthorInfo1 = authorRepository.GetByAuthorId(bookAuthorList[0].AuthorId);
}
else if (bookAuthorList.Count == 2)
{
bookDetail.AuthorInfo1 = authorRepository.GetByAuthorId(bookAuthorList[0].AuthorId);
bookDetail.AuthorInfo2 = authorRepository.GetByAuthorId(bookAuthorList[1].AuthorId);
}
else
{
bookDetail.AuthorInfo1 = authorRepository.GetByAuthorId(bookAuthorList[0].AuthorId);
bookDetail.AuthorInfo2 = authorRepository.GetByAuthorId(bookAuthorList[1].AuthorId);
bookDetail.AuthorInfo3 = authorRepository.GetByAuthorId(bookAuthorList[2].AuthorId);
}
bookDetail.PublicationModel = publicationRepository.GetByPublicationId(book.PublicationId);
bookDetail.ContentRatingModel = contentRatingRepository.GetByContentId(book.ContentRatingId);
return(View(bookDetail));
}
private void addBookButton_Click(object sender, EventArgs e)
{
var addBookForm = new AddBookForm();
DialogResult dialogResult = addBookForm.ShowDialog(this);
if (dialogResult == DialogResult.Cancel)
{
return;
}
string name = addBookForm.nameTextBox.Text;
string editor = addBookForm.editorTextBox.Text;
string type = addBookForm.typeTextBox.Text;
string genre = addBookForm.genreTextBox.Text;
string language = addBookForm.languageTextBox.Text;
var editionYear = new DateTime((int)addBookForm.editionNumericUpDown.Value, 1, 1);
BookRepository bookRepository = new BookRepository();
var book = new Book
{
Name = name,
EditorsName = editor,
EditionYear = editionYear,
Type = type,
Genre = genre,
Language = language
};
bookRepository.Create(book);
int id = 0;
var bookAuthorRepository = new BookAuthorRepository();
BookAuthor bookAuthor;
foreach (object ch in addBookForm.authorsCheckedListBox.CheckedItems)
{
id = int.Parse(ch.ToString().Split(' ')[0]);
bookAuthor = new BookAuthor
{
BookId = book.Id,
AuthorId = id
};
bookAuthorRepository.Create(bookAuthor);
}
int booksCount = (int)addBookForm.countNumericUpDown.Value;
var bookCopyRepository = new BookCopyRepository();
BookCopy bookCopy;
for (int i = 0; i < booksCount; i++)
{
bookCopy = new BookCopy
{
BookId = book.Id,
CopyNumber = i + 1
};
bookCopyRepository.Create(bookCopy);
}
SetDataGridView();
_db.SaveChanges();
}
public BookService(BookRepository bookRepository, BookAuthorRepository bookAuthorRepository)
{
_bookRepository = bookRepository;
_bookAuthorRepository = bookAuthorRepository;
}
public BookService(ApplicationContext context)
{
_bookAuthorRepository = new BookAuthorRepository <BookInAuthor>(context);
_bookRepository = new BookRepository <Book>(context);
_publicationHouseBookRepository = new PublicationHouseBookRepository <PublicationHouseInBook>(context);
}
public static void StoreBookAuthor(bookAuthor ba)
{
BookAuthorRepository.StoreBookAuthor(ba);
}
public static void RemoveBookAuthor(int Aid, string ISBN)
{
BookAuthorRepository.RemoveBookAuthor(Aid, ISBN);
}
public static void RemoveBookAuthorByISBN(string ISBN)
{
BookAuthorRepository.RemoveBookAuthorByISBN(ISBN);
}
public static bool BookAuthorExists(int Aid, string ISBN)
{
return(BookAuthorRepository.GetBookAuthor(Aid, ISBN) != null ? true : false);
}
public ActionResult Post(BookAuthor ba)
{
BookAuthorRepository.AddBookAuthorLink(ba);
return(Ok());
}
public AuthorService(AuthorRepository repository, BookAuthorRepository bookAuthorRepository)
{
_repository = repository;
_bookAuthorRepository = bookAuthorRepository;
}
