public bool Update(VeiculoDTO veiculo)
{
Transaction = null;
DbConnection connection = null;
bool transactionstart = false;
try
{
using (connection = db.CreateConnection())
{
try
{
connection.Open();
if (Transaction == null)
{
Transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
transactionstart = true;
}
dbcommand = db.GetSqlStringCommand(" UPDATE public.veiculo SET" +
" veiculo = @veiculo," +
" tipo = @tipo," +
" id_marca = @id_marca" +
" WHERE" +
" id = @id");
db.AddInParameter(dbcommand, "@veiculo", DbType.String, veiculo.Veiculo);
db.AddInParameter(dbcommand, "@id_marca", DbType.Int16, veiculo.Id_Marca);
db.AddInParameter(dbcommand, "@tipo", DbType.Int16, veiculo.Tipo);
db.AddInParameter(dbcommand, "@id", DbType.Int16, veiculo.Id);
db.ExecuteNonQuery(dbcommand, Transaction);
if (transactionstart)
{
Transaction.Commit();
Transaction = null;
}
connection.Close();
return(true);
}
catch
{
throw;
}
}
}
catch
{
if (transactionstart)
{
if (Transaction.Connection.State == ConnectionState.Open)
{
Transaction.Rollback();
}
Transaction = null;
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
throw;
}
}
public void ExcluirVeiculo(VeiculoDTO dto)
{
dao.Delete("tbl_veiculo", dto, 0);
}
public void InserirVeiculo(VeiculoDTO dto)
{
dao.Insert("tbl_veiculo", dto);
}
public void AlterarVeiculo(VeiculoDTO dto)
{
dao.Update("tbl_veiculo", dto, 0);
}
public VeiculoDTO ObterPorPlaca(string placa)
{
VeiculoDTO retorno = Get <VeiculoDTO>($"{_rotaAutenticacao}/{placa.Trim()}", null, null);
return(retorno);
}
