public void LookupBook( int index)
{
BookDetail book;
using (var connection = new DatabaseConnectionProvider().GetConnection())
{
SqlConnection sqlConnection = new SqlConnection("Data Source={0};Initial Catalog={1};User Id={2};Password={3}");
sqlConnection.Open();
var command = new SqlCommand
{
CommandType = CommandType.Text,
Connection = connection,
CommandText = "Select * from Books where bookid = @BookId"
};
command.Parameters.AddWithValue("@BookId", index);
using (var reader = command.ExecuteReader())
{
book = new BookDetail
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Title = reader.GetString(reader.GetOrdinal("Title")),
Author = new AuthorDetail
{
FirstName = reader.GetString(reader.GetOrdinal("FirstName")),
LastName = reader.GetString(reader.GetOrdinal("LastName"))
},
};
}
}
}
/// <summary>
/// Creates the entity.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private static IBookDetail CreateEntity(IDataReader reader)
{
var book = new BookDetail();
if (reader == null)
{
return book;
}
while (reader.Read())
{
book = new BookDetail
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Title = reader.GetString(reader.GetOrdinal("Title")),
Author = new AuthorDetail
{
FirstName = reader.GetString(reader.GetOrdinal("FirstName")),
LastName = reader.GetString(reader.GetOrdinal("LastName"))
},
};
}
return book;
}