private void ReturnDataBaseAccess(bool bLoadConfiguration, out mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionDB)
{
mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionReturn = null;
if (bLoadConfiguration)
{
vCarregaDadosConfiguracao();
}
switch (m_enumDataBaseType)
{
case TiposBancoDados.Jet40:
cls_dba_ConnectionReturn = new mdlDataBaseAccess.clsDataBaseAccessOleDbJet40(ref m_cls_ter_TratadorErro, m_strDataBaseAccessJet40Path, m_strDataBaseAccessJet40User, m_strDataBaseAccessJet40Password);
break;
case TiposBancoDados.SqlServer:
cls_dba_ConnectionReturn = new mdlDataBaseAccess.clsDataBaseAccessSqlServer(ref m_cls_ter_TratadorErro, m_strDataBaseAccessSqlServerHost, m_strDataBaseAccessSqlServerPort, m_strDataBaseAccessSqlServerDataBaseName, m_strDataBaseAccessSqlServerUser, m_strDataBaseAccessSqlServerPassword);
break;
case TiposBancoDados.MySql:
cls_dba_ConnectionReturn = new mdlDataBaseAccess.clsDataBaseAccessMySql(ref m_cls_ter_TratadorErro, m_strDataBaseAccessMySqlHost, m_strDataBaseAccessMySqlPort, m_strDataBaseAccessMySqlUser, m_strDataBaseAccessMySqlPassword, m_strDataBaseAccessMySqlDataBaseName);
break;
}
if (m_bDevelopMode)
{
cls_dba_ConnectionReturn.SystemMode = mdlDataBaseAccess.Mode.Developer;
}
else
{
cls_dba_ConnectionReturn.SystemMode = mdlDataBaseAccess.Mode.User;
}
cls_dba_ConnectionDB = cls_dba_ConnectionReturn;
}
private bool bDataBaseConfiguratedRight(bool bLoadConfiguration)
{
bool bRetorno = false;
if (bLoadConfiguration)
{
vCarregaDadosConfiguracao();
}
mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionDB = null;
switch (m_enumDataBaseType)
{
case TiposBancoDados.Jet40:
cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessOleDbJet40(ref m_cls_ter_TratadorErro, m_strDataBaseAccessJet40Path, m_strDataBaseAccessJet40User, m_strDataBaseAccessJet40Password);
bRetorno = bDataAccessRight(ref cls_dba_ConnectionDB);
break;
case TiposBancoDados.SqlServer:
cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessSqlServer(ref m_cls_ter_TratadorErro, m_strDataBaseAccessSqlServerHost, m_strDataBaseAccessSqlServerPort, m_strDataBaseAccessSqlServerDataBaseName, m_strDataBaseAccessSqlServerUser, m_strDataBaseAccessSqlServerPassword);
bRetorno = bDataAccessRight(ref cls_dba_ConnectionDB);
break;
case TiposBancoDados.MySql:
cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessMySql(ref m_cls_ter_TratadorErro, m_strDataBaseAccessMySqlHost, m_strDataBaseAccessMySqlPort, m_strDataBaseAccessMySqlUser, m_strDataBaseAccessMySqlPassword, m_strDataBaseAccessMySqlDataBaseName);
bRetorno = bDataAccessRight(ref cls_dba_ConnectionDB);
break;
}
return(bRetorno);
}
private void vRefreshServidores()
{
System.Windows.Forms.ListViewItem lviHost;
m_lvServidores.Items.Clear();
mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessSqlServer(ref m_cls_ter_TratadorErro, m_strHost, m_strPort, m_strDataBaseName, m_strUser, m_strPassword);
cls_dba_ConnectionDB.DBPort = m_strPort;
cls_dba_ConnectionDB.DBDataBaseName = m_strDataBaseName;
cls_dba_ConnectionDB.DBUser = m_strUser;
cls_dba_ConnectionDB.DBPassword = m_strPassword;
string[] astrComputers = cls_dba_ConnectionDB.astrComputersAvailables();
string[] astrServers = cls_dba_ConnectionDB.astrServersAvailables(astrComputers);
string[] astrDataBases = cls_dba_ConnectionDB.astrDataBaseAvailables(astrServers);
// Computers
foreach (string strComputer in astrComputers)
{
lviHost = m_lvServidores.Items.Add(strComputer);
lviHost.ForeColor = m_clrComputer;
// DataBases
foreach (string strDataBase in astrDataBases)
{
if (strDataBase == strComputer)
{
lviHost.ForeColor = m_clrDataBase;
break;
}
}
// Servers
if (lviHost.ForeColor == m_clrComputer)
{
foreach (string strServer in astrServers)
{
if (strServer == strComputer)
{
lviHost.ForeColor = m_clrServer;
break;
}
}
}
}
if (m_formFAguarde != null)
{
m_formFAguarde.Close();
m_formFAguarde = null;
}
}
private bool bUserAssociated(string strAdminUser, string strAdminPassword, out string strReturn)
{
bool bReturn = false;
strReturn = "";
mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessSqlServer(ref m_cls_ter_TratadorErro, m_strHost, m_strPort, m_strDataBaseName, m_strUser, m_strPassword);
cls_dba_ConnectionDB.DBHost = m_strHost;
cls_dba_ConnectionDB.DBPort = m_strPort;
cls_dba_ConnectionDB.DBDataBaseName = m_strDataBaseName;
cls_dba_ConnectionDB.DBUser = m_strUser;
cls_dba_ConnectionDB.DBPassword = m_strPassword;
cls_dba_ConnectionDB.DBAdminUser = strAdminUser;
cls_dba_ConnectionDB.DBAdminPassword = strAdminPassword;
if (!(bReturn = cls_dba_ConnectionDB.bUserAssociate()))
{
strReturn = "Não foi possível associar o usuário ao bando de dados. Verifique se o usuário e senha de administrador estão corretos.";
}
return(bReturn);
}
private bool bDataBaseUpdated(string strAdminUser, string strAdminPassword, out string strReturn)
{
bool bReturn = false;
strReturn = "";
mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessSqlServer(ref m_cls_ter_TratadorErro, m_strHost, m_strPort, m_strDataBaseName, m_strUser, m_strPassword);
cls_dba_ConnectionDB.DBHost = m_strHost;
cls_dba_ConnectionDB.DBPort = m_strPort;
cls_dba_ConnectionDB.DBDataBaseName = m_strDataBaseName;
cls_dba_ConnectionDB.DBUser = m_strUser;
cls_dba_ConnectionDB.DBPassword = m_strPassword;
cls_dba_ConnectionDB.DBAdminUser = strAdminUser;
cls_dba_ConnectionDB.DBAdminPassword = strAdminPassword;
cls_dba_ConnectionDB.ShowDialogsErrors = false;
if (!(bReturn = (cls_dba_ConnectionDB.nUpdateDataBase() >= 0)))
{
strReturn = "Não foi possível atualizar a estrutura do banco de dados.";
}
return(bReturn);
}
private void vCarregaDadosAdmin(string strAdminUser, string strAdminPassword, out bool bServer, out bool bSqlServer, out bool bDataBase, out bool bUser, out bool bUserAssociated, out bool bDataBaseUpdated, out bool bDefaultData)
{
bServer = false;
bSqlServer = false;
bDataBase = false;
bUser = false;
bUserAssociated = false;
bDataBaseUpdated = false;
bDefaultData = false;
mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessSqlServer(ref m_cls_ter_TratadorErro, m_strHost, m_strPort, m_strDataBaseName, m_strUser, m_strPassword);
cls_dba_ConnectionDB.DBHost = m_strHost;
cls_dba_ConnectionDB.DBPort = m_strPort;
cls_dba_ConnectionDB.DBDataBaseName = m_strDataBaseName;
cls_dba_ConnectionDB.DBUser = m_strUser;
cls_dba_ConnectionDB.DBPassword = m_strPassword;
cls_dba_ConnectionDB.DBAdminUser = strAdminUser;
cls_dba_ConnectionDB.DBAdminPassword = strAdminPassword;
if (bServer = cls_dba_ConnectionDB.bComputerAvailable(m_strHost))
{
if (bSqlServer = cls_dba_ConnectionDB.bServerAvailable())
{
if (bDataBase = cls_dba_ConnectionDB.bDataBaseAvailable())
{
if (bUser = cls_dba_ConnectionDB.bUserAvailable())
{
if (bUserAssociated = cls_dba_ConnectionDB.bUserAssociated())
{
cls_dba_ConnectionDB.ShowDialogsErrors = false;
if (bDataBaseUpdated = (cls_dba_ConnectionDB.nUpdateDataBase() >= 0))
{
string strTemp;
bDefaultData = bDBDefaultData(out strTemp);
}
}
}
}
}
}
}
private bool bDBDefaultData(out string strReturn)
{
mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessSqlServer(ref m_cls_ter_TratadorErro, m_strHost, m_strPort, m_strDataBaseName, m_strUser, m_strPassword);
return(cls_dba_ConnectionDB.bSetDefaultData(out strReturn));
}
