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"))
},
};
}
}
}
public IBookDetail FetchByIndex(int index)
{
DatabaseConnectionProvider connProvider = new DatabaseConnectionProvider();
FetchBookProvider bookProvider = new FetchBookProvider(new SqlResourceLoader());
BookDataManager bookDataManager = new BookDataManager(connProvider, bookProvider);
return bookDataManager.FetchBookByIndex(index);
}
/// <summary>
/// Executes the command.
/// </summary>
/// <param name="arg">The arg.</param>
protected static void ExecuteCommand(string arg)
{
var connectionProvider = new DatabaseConnectionProvider();
using (var command = connectionProvider.GetConnection().CreateCommand())
{
command.CommandText = new SqlResourceLoader().LoadSqlStatement(arg);
command.ExecuteNonQuery();
}
}
