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 ? $"Добавление успешно" : $"Ошибка при добавлении автора");
}
