public static void ExecutaSQL(string sql, SqlParameter[] parametros)
{
using (SqlConnection conexao = ConexaoBD.GetConexao())
{
using (SqlCommand comando = new SqlCommand(sql, conexao))
{
if (parametros != null)
{
comando.Parameters.AddRange(parametros);
}
comando.ExecuteNonQuery();
}
conexao.Close();
}
}
public static void ExecutaProc(string nomeProc, SqlParameter[] parametros)
{
using (SqlConnection conexao = ConexaoBD.GetConexao())
{
using (SqlCommand comando = new SqlCommand(nomeProc, conexao))
{
comando.CommandType = CommandType.StoredProcedure;
if (parametros != null)
{
comando.Parameters.AddRange(parametros);
}
comando.ExecuteNonQuery();
}
conexao.Close();
}
}
public static DataTable ExecutaSelect(string sql, SqlParameter[] parametros)
{
using (SqlConnection conexao = ConexaoBD.GetConexao())
{
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conexao))
{
if (parametros != null)
{
adapter.SelectCommand.Parameters.AddRange(parametros);
}
DataTable tabela = new DataTable();
adapter.Fill(tabela);
conexao.Close();
return(tabela);
}
}
}
public static DataTable ExecutaProcSelect(string nomeProc, SqlParameter[] parametros)
{
using (SqlConnection conexao = ConexaoBD.GetConexao())
{
using (SqlDataAdapter adapter = new SqlDataAdapter(nomeProc, conexao))
{
if (parametros != null)
{
adapter.SelectCommand.Parameters.AddRange(parametros);
}
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable tabela = new DataTable();
adapter.Fill(tabela);
conexao.Close();
return(tabela);
}
}
}