public Booking SelectStandardBookingById(int id)
{
const string sqlText = @"SELECT Id, [Name], debit_account_id, credit_account_id
FROM StandardBookings
WHERE Id = @Id";
Booking standardBooking = new Booking();
using (SqlConnection conn = GetConnection())
{
using (OpenCbsCommand select = new OpenCbsCommand(sqlText, conn))
{
select.AddParam("@Id", id);
using (OpenCbsReader reader = select.ExecuteReader())
{
while (reader.Read())
{
standardBooking.Id = reader.GetInt("Id");
standardBooking.Name = reader.GetString("Name");
Account account =
_chartOfAccounts.GetAccountById(reader.GetInt("debit_account_id"));
standardBooking.DebitAccount = account;
account =
_chartOfAccounts.GetAccountById(reader.GetInt("credit_account_id"));
standardBooking.CreditAccount = account;
}
}
}
}
return standardBooking;
}
