public DataTable getRateSchedules(string contractID)
        {
            ContractDAL myContractDAL = new ContractDAL();

            RateSchedule_Collection myRateSchedules = myContractDAL.getRateSchedulesForContract(contractID);

            return myRateSchedules.toDataTable();
        }
        public DataTable getContracts(string statusTypeCode)
        {
            ContractDAL myContractDAL = new ContractDAL();

            Contract_Collection myContract_Collection = myContractDAL.getContractsByStatusType(statusTypeCode);

            return myContract_Collection.ToDataTable();
        }
        private void setBtn_Click(object sender, System.EventArgs e)
        {
            ContractBO newContract = new ContractBO();

            newContract.ContractName = contractNameBx.Text;

            ContractDAL contractData = new ContractDAL();

            int contractID = contractData.insertContract(newContract);

            RateScheduleBO rateSchedule = new RateScheduleBO();

            rateSchedule.ContractID = contractID;
            rateSchedule.RateScheduleName = contractNameBx.Text;
            rateSchedule.Coverage.StartDate = System.DateTime.Today;
            rateSchedule.Coverage.EndDate = System.DateTime.Today;

            // Add by default to Development
            rateSchedule.Status = "3";

            RateScheduleDAL rateScheduleData = new RateScheduleDAL();
            rateScheduleData.insertRateSchedule(rateSchedule);

            ContractAdded(this, EventArgs.Empty);

            this.Close();
        }
        // ********************************* REMOVE CONTRACT
        private void removeContractPicBx_Click(object sender, System.EventArgs e)
        {
            ContractDAL contractData = new ContractDAL();
            ContractBO contract = contractData.getContract(rmsController.ContractID);

            contractData.deleteContract(contract);

            loadContractsTreeView();
        }
        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];
        }