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 bool bUserAssociated(string strAdminUser, string strAdminPassword, out string strReturn) { bool bReturn = false; strReturn = ""; mdlDataBaseAccess.clsDataBaseAccess cls_dba_ConnectionDB = new mdlDataBaseAccess.clsDataBaseAccessMySql(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.clsDataBaseAccessMySql(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.clsDataBaseAccessMySql(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.clsDataBaseAccessMySql(ref m_cls_ter_TratadorErro, m_strHost, m_strPort, m_strDataBaseName, m_strUser, m_strPassword); return(cls_dba_ConnectionDB.bSetDefaultData(out strReturn)); }