public DataTable getContracts(string statusTypeCode)
        {
            ContractDAL myContractDAL = new ContractDAL();

            Contract_Collection myContract_Collection = myContractDAL.getContractsByStatusType(statusTypeCode);

            return myContract_Collection.ToDataTable();
        }
        private void loadContractsTreeView()
        {
            contractsTree.Nodes.Clear();

            ContractDAL contractData = new ContractDAL();

            Contract_Collection contracts = contractData.getContractsByStatusType(statusTypeComboBx.SelectedValue.ToString());

            ContractBO contract;
            TreeNode contractNode, rateScheduleNode;

            for(int c=0; c<contracts.Count(); c++)
            {
                contract = contracts.getContractAt(c);

                contractNode = new TreeNode(contract.ToString());

                for(int r=0; r<contract.rateScheduleCount(); r++)
                {
                    rateScheduleNode = new TreeNode(contract.getRateScheduleStringAt(r));

                    contractNode.Nodes.Add(rateScheduleNode);
                }

                contractsTree.Nodes.Add(contractNode);
            }

            contractsTree.SelectedNode = contractsTree.Nodes[0];
        }