C / C++ / MFC

void CRunSetView::DeleteFilters(HTREEITEM hselected)<br />
{<br />
	CTreeCtrl& TreeCtrl = GetTreeCtrl();<br />
	HTREEITEM Parent = TreeCtrl.GetParentItem(hselected);<br />
	<br />
	short nRunsetId = GetItemID(Parent);<br />
	HTREEITEM ChildItem = TreeCtrl.GetChildItem(hselected);<br />
	<br />
	do<br />
	{<br />
		short nMapId = GetItemID(ChildItem);<br />
	<br />
	<br />
		CMigratorClient* pManager = GetDocument()->GetManagerPtr();<br />
	<br />
		CMigratorDoc* cmap = GetDocument();<br />
		_RecordsetPtr rsMap;<br />
		rsMap.CreateInstance(__uuidof(Recordset));<br />
<br />
		<br />
		CString strSQL;<br />
		strSQL.Format(_T("SELECT * FROM DQMap WHERE ID = %d"),nMapId);<br />
		rsMap->Open( _variant_t( strSQL ), _variant_t(( IDispatch *) pManager->GetDatabasePtr(), <br />
			true), adOpenStatic, adLockOptimistic, adCmdText);<br />
		<br />
		if ( !rsMap->GetEndOfFile() )<br />
		{<br />
			CString MapNm = VariantToStr( rsMap->Fields->Item["FilterName"]->Value );<br />
			rsMap->Close();<br />
			<br />
			<br />
			_RecordsetPtr rsMapDQ;<br />
			rsMapDQ.CreateInstance(__uuidof(Recordset));<br />
			strSQL.Format(_T("SELECT * FROM DQMap WHERE FilterName = '%s'"),MapNm);<br />
			rsMapDQ->Open( _variant_t( strSQL ), _variant_t(( IDispatch *) pManager->GetDatabasePtr(), <br />
				true), adOpenStatic, adLockOptimistic, adCmdText);<br />
			<br />
			while( !rsMapDQ->GetEndOfFile() )<br />
			{	<br />
				<br />
				nMapId = _ttoi( VariantToStr( rsMapDQ->Fields->Item["ID"]->Value ));<br />
				<br />
			<br />
				short mapid;<br />
				<br />
				<br />
			<br />
				CMigratorClient* pManager = GetDocument()->GetManagerPtr();<br />
				pManager->DeleteRunSetMap(nRunsetId,nMapId);<br />
			<br />
				cmap->deletefilters(nMapId);<br />
			<br />
				rsMapDQ->MoveNext();<br />
				<br />
				<br />
			}<br />
			rsMapDQ->Close();<br />
		}<br />
	<br />
		<br />
	}while((ChildItem = TreeCtrl.GetNextSiblingItem(ChildItem))!=NULL);<br />
<br />
	HTREEITEM item = GetRootItem();<br />
	DeleteItem(item);<br />
	OnInitialUpdate();<br />
<br />
<br />
	return;<br />
}<br />