public void AtualizarRangeIPS(ControleAcessoConta controle)
{
using (OracleConnection con = new OracleConnection(Config.StringConexao()))
{
var parametros = new DynamicParameters();
parametros.Add(name: "Descricao", value: controle.Descricao, direction: ParameterDirection.Input);
parametros.Add(name: "IPInicial", value: controle.IPInicial, direction: ParameterDirection.Input);
parametros.Add(name: "IPFinal", value: controle.IPFinal, direction: ParameterDirection.Input);
parametros.Add(name: "Id", value: controle.Id, direction: ParameterDirection.Input);
con.Execute(@"UPDATE CRM.TB_CRM_CONTAS_IPS SET Descricao = :Descricao, IPInicial = :IPInicial, IPFinal = :IPFinal WHERE Id = :Id", parametros);
}
}
public void CadastrarRangeIPS(ControleAcessoConta controle)
{
using (OracleConnection con = new OracleConnection(Config.StringConexao()))
{
var parametros = new DynamicParameters();
parametros.Add(name: "Descricao", value: controle.Descricao, direction: ParameterDirection.Input);
parametros.Add(name: "ContaId", value: controle.ContaId, direction: ParameterDirection.Input);
parametros.Add(name: "IPInicial", value: controle.IPInicial, direction: ParameterDirection.Input);
parametros.Add(name: "IPFinal", value: controle.IPFinal, direction: ParameterDirection.Input);
con.Execute(@"INSERT INTO CRM.TB_CRM_CONTAS_IPS (Id, Descricao, ContaId, IPInicial, IPFinal) VALUES (CRM.SEQ_CRM_CONTAS_IPS.NEXTVAL, :Descricao, :ContaId, :IPInicial, :IPFinal)", parametros);
}
}
