public static AuthorsAndBooks GetSearchResult(string input) { AuthorsAndBooks authorsandbooks = new AuthorsAndBooks(); authorsandbooks.Authors = AuthorRepository.GetAuthorsBySearch(input); authorsandbooks.Books = BookService.GetBooksBySearch(input); return(authorsandbooks); }
public int Create(AuthorsAndBooks authorAndBook) { try { const string sqlExpression = "INSERT INTO AuthorsAndBooks (AuthorID, BookID) VALUES (@AuthorID, @BookID)"; using (var connection = Dbsql.GetDbConnection()) { connection.Open(); var command = new SqlCommand(sqlExpression, connection); var idAuthorParam = new SqlParameter("@AuthorID", authorAndBook.AuthorID); command.Parameters.Add(idAuthorParam); var idBookParam = new SqlParameter("@BookID", authorAndBook.BookID); command.Parameters.Add(idBookParam); var number = command.ExecuteNonQuery(); return(number); } } catch (SqlException e) { Console.WriteLine(e); return(-1); } }
public string Create(AuthorsAndBooks authorsAndBooks) { int number = _authorsAndBooksDao.Create(authorsAndBooks); return(number > 0 ? $"Добавление успешно" : $"Ошибка при добавлении автора"); }