private IDbConnection MySQLConnectin()
{
try
{
if (_mysqlCon == null)
{
IVariableSettingRepo VariableSettingRepo = new VariableSettingRepo();
VariableSetting VariableSetting = VariableSettingRepo.GetBy("Status");
if (VariableSetting != null)
{
if (!string.IsNullOrEmpty(VariableSetting.Value) && VariableSetting.Value.ToUpper() == "PRODUCTION")
{
VariableSetting VariableSettingConStr = VariableSettingRepo.GetBy("MySQLConn");
_mysqlCon = new MySqlConnection(WFUtils.Decrypt(VariableSettingConStr.Value));
}
else
{
_mysqlCon = new MySqlConnection("Server=127.0.0.1;Database=tsspk1511;Uid=root;Pwd=;");
}
}
else
{
_mysqlCon = new MySqlConnection("Server=127.0.0.1;Database=tsspk1511;Uid=root;Pwd=;");
}
}
if (_mysqlCon.State != ConnectionState.Open)
{
_mysqlCon.Open();
}
}
catch (Exception)
{
_mysqlCon = null;
}
return(_mysqlCon);
}
