void
FetchAccounts::RefreshPendingList()
{
String sSQL;
sSQL.Format(_T("select * from hm_fetchaccounts where fanexttry <= %s and falocked = 0 and faactive = 1 order by faid asc"), SQLStatement::GetCurrentTimestamp());
_DBLoad(sSQL);
}
void
RuleCriterias::Refresh()
{
String sSQL;
sSQL.Format(_T("select * from hm_rule_criterias where criteriaruleid = %I64d order by criteriaid asc"), m_iRuleID);
_DBLoad(sSQL);
}
void
Aliases::Refresh()
{
String sSQL;
sSQL.Format(_T("select * from hm_aliases where aliasdomainid = %I64d order by aliasname asc"), m_iDomainID);
_DBLoad(sSQL);
}
void
FetchAccounts::Refresh()
{
String sSQL;
sSQL.Format(_T("select * from hm_fetchaccounts where faaccountid = %I64d")
_T(" order by faid asc"), m_iAccountID);
_DBLoad(sSQL);
}
void
TCPIPPorts::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads all SURBL servers from the database.
//---------------------------------------------------------------------------()
{
String sSQL = "select * from hm_tcpipports order by portaddress1 asc, portaddress2 asc, portnumber asc";
_DBLoad(sSQL);
}
void
Routes::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reloads all routes from the database.
//---------------------------------------------------------------------------()
{
String sSQL = "select * from hm_routes order by routedomainname asc";
_DBLoad(sSQL);
}
void
WhiteListAddresses::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads all SURBL servers from the database.
//---------------------------------------------------------------------------()
{
String sSQL = "select * from hm_whitelist order by whiteloweripaddress1 asc, whiteloweripaddress2 asc";
_DBLoad(sSQL);
}
void
Groups::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads all groups form the database
//---------------------------------------------------------------------------()
{
String sSQL = "select * from hm_groups order by groupname asc";
_DBLoad(sSQL);
}
void
Rules::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Refreshes this collection from the database.
//---------------------------------------------------------------------------()
{
String sSQL;
sSQL.Format(_T("select * from hm_rules where ruleaccountid = %I64d order by rulesortorder asc"), m_iAccountID);
_DBLoad(sSQL);
}
void
GroupMembers::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads all group members from the database
//---------------------------------------------------------------------------()
{
String sSQL;
sSQL.Format(_T("select * from hm_group_members where membergroupid = %I64d order by memberid asc"), m_iGroupID);
_DBLoad(sSQL);
}
void
Accounts::Refresh()
{
SQLCommand command;
String sSQL;
if (m_iDomainID == 0)
{
command.SetQueryString(_T("select * from hm_accounts order by accountaddress asc"));
}
else if (m_iAccountID == 0)
{
command.SetQueryString("select * from hm_accounts where accountdomainid = @DOMAINID order by accountaddress asc");
command.AddParameter("@DOMAINID", m_iDomainID);
}
else
{
command.SetQueryString("select * from hm_accounts where accountdomainid = @DOMAINID and accountid = @ACCOUNTID order by accountaddress asc");
command.AddParameter("@DOMAINID", m_iDomainID);
command.AddParameter("@ACCOUNTID", m_iAccountID);
}
_DBLoad(command);
}