private string RetornaStrConexao(string NomeBanco, InstanciaExecucao Instancia = InstanciaExecucao.Normal)
{
string functionReturnValue = null;
functionReturnValue = "";
if (mAmbienteExecucao == AmbienteExecucao.Producao)
{
if (Instancia == InstanciaExecucao.Normal)
{
functionReturnValue = "Password=CHk2v3;Persist Security Info=True;User ID=db_prod;Initial Catalog=" + NomeBanco + ";Data Source=" + retorna_ip();
}
else if (Instancia == InstanciaExecucao.Alog)
{
functionReturnValue = "Password=!#m0d&rn0#!;Persist Security Info=True;User ID=backseg_sa;Initial Catalog=" + NomeBanco + ";Data Source=177.126.186.178";
}
}
else if (mAmbienteExecucao == AmbienteExecucao.DW)
{
functionReturnValue = "Password=CHk2v3;Persist Security Info=True;User ID=db_prod;Initial Catalog=" + NomeBanco + ";Data Source=10.0.0.22";
}
else
{
functionReturnValue = "Password=!#m0d&rn0#!;Persist Security Info=True;User ID=backseg_sa;Initial Catalog=" + NomeBanco + ";Data Source=177.126.186.178";
//RetornaStrConexao = "Password=Wr3327;Persist Security Info=True;User ID=db_dev;Initial Catalog=" & NomeBanco & ";Data Source=200.219.199.122"
}
return(functionReturnValue);
}
public DataTable RetornaTabela(string NomeProcedure, string NomeBanco, int ExecutionTimeOut = 0, InstanciaExecucao Instancia = InstanciaExecucao.Normal)
{
DataTable functionReturnValue = default(DataTable);
DataTable obDT = new DataTable();
try
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
Conn.ConnectionString = RetornaStrConexao(NomeBanco, Instancia);
Conn.Open();
Command.Connection = Conn;
Command.CommandText = NomeProcedure;
Command.Parameters.Clear();
Command.CommandType = CommandType.StoredProcedure;
foreach (Object obParam_loopVariable in Parametros)
{
// obParam = obParam_loopVariable;
Command.Parameters.Add(obParam_loopVariable);
}
if (ExecutionTimeOut > 0)
{
Command.CommandTimeout = ExecutionTimeOut;
}
else
{
Command.CommandTimeout = 0;
}
Adapt.SelectCommand = Command;
Adapt.Fill(obDT);
}
catch (Exception ex)
{
}
finally
{
functionReturnValue = obDT;
}
return(functionReturnValue);
}
public void ExecutaProcedure(string NomeProcedure, string NomeBanco, int ExecutionTimeOut = 0, InstanciaExecucao Instancia = InstanciaExecucao.Normal)
{
SqlParameter obParam = default(SqlParameter);
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
Conn.ConnectionString = RetornaStrConexao(NomeBanco, Instancia);
Conn.Open();
Command.Connection = Conn;
Command.CommandText = NomeProcedure;
Command.Parameters.Clear();
Command.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter obParam_loopVariable2 in Parametros)
{
obParam = obParam_loopVariable2;
Command.Parameters.Add(obParam);
}
if (ExecutionTimeOut > 0)
{
Command.CommandTimeout = ExecutionTimeOut;
}
else
{
Command.CommandTimeout = 0;
}
Command.ExecuteNonQuery();
//APOS RETORNAR A CONSULTA ATUALIZAR OS PARAMETROS
Parametros.Clear();
foreach (SqlParameter obParam_loopVariable3 in Command.Parameters)
{
obParam = obParam_loopVariable3;
Parametros.Add(obParam);
}
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
public void ExecutaQuery(string Query, string NomeBanco, int ExecutionTimeOut = 0, InstanciaExecucao Instancia = InstanciaExecucao.Normal)
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
Conn.ConnectionString = RetornaStrConexao(NomeBanco, Instancia);
Conn.Open();
Command.Connection = Conn;
Command.CommandText = Query;
Command.Parameters.Clear();
Command.CommandType = CommandType.Text;
if (ExecutionTimeOut > 0)
{
Command.CommandTimeout = ExecutionTimeOut;
}
else
{
Command.CommandTimeout = 0;
}
Command.ExecuteNonQuery();
//APOS RETORNAR A CONSULTA ATUALIZAR OS PARAMETROS
Parametros.Clear();
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
