public void GetAuthorsId(ref List <PrintEdition> printEditions)
{
AuthorDao authorDao = new AuthorDao();
foreach (var item in printEditions)
{
if (item is Book)
{
Book working = (Book)item;
working.AuthorsId = authorDao.GetAuthorsIdsByBookId(item.Id);
}
if (item is Patent)
{
Patent working = (Patent)item;
working.AuthorsId = authorDao.GetAuthorsIdsByPatentId(item.Id);
}
}
}
public Book GetBookById(int id)
{
Book book = null;
var _authorLogic = new AuthorDao();
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand command = GetCommand(connection, "dbo.GetBookById");
AddParameter(GetParameter("@Id", id, System.Data.DbType.Int32), command);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
book = GetBook(reader);
}
}
book.AuthorsId = _authorLogic.GetAuthorsIdsByBookId(book.Id);
return(book);
}
