//public decimal CalculateAccountBalance(int accountNo)
//{
// string sql = string.Format(@"
// select
// Accounts.BalanceBroughtForwardAmount +
// (
// select isnull(SUM(Amount), 0)
// from
// AccountTransactions
// where AccountNo = {0}
// ) as BalanceAmount
// from Accounts
// where No = {0}", accountNo);
// return decimal.Parse(Connection.GetScalar(sql).ToString());
//}
public CategoryCollection GetSubCategories()
{
string sql = @"
select *
from Categories c1
where
IsArchived <> 1 and
(
select count(*)
from Categories c2
where c2.ParentCategoryNo = c1.No
) = 0
order by
Type desc,
Name asc";
CategoryTable categoryTable = new CategoryTable();
Connection.GetTable(categoryTable, sql);
return(CategoryCollection.CreateCategoryCollection(categoryTable));
}