/// <summary>
/// Updates a registro
/// </summary>
/// <param name="registroId"></param>
/// <param name="registroEntity"></param>
/// <returns></returns>
public bool UpdateRegistro(int registroId, RegistroEntity registroEntity)
{
var success = false;
if (registroEntity != null)
{
using (var scope = new TransactionScope())
{
var registro = _unitOfWork.RegistroRepository.GetByID(registroId);
if (registro != null)
{
registro.BotonPanico = registroEntity.BotonPanico;
registro.Fecha = registroEntity.Fecha;
registro.Hora = registroEntity.Hora;
registro.IdItem = registroEntity.IdItem;
registro.Nivel = registroEntity.Nivel;
registro.Odometro = registroEntity.Odometro;
registro.Presion = registroEntity.Presion;
registro.Temperatura = registroEntity.Temperatura;
_unitOfWork.RegistroRepository.Update(registro);
_unitOfWork.Save();
scope.Complete();
success = true;
}
}
}
return(success);
}
public RegistroEntity GetById(int id)
{
try
{
OpenConnection();
using (cmd = new SqlCommand("", con))
{
cmd.CommandText = "imp.UP_REGISTRO_BUSCAR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = id;
dr = cmd.ExecuteReader();
RegistroEntity registro = null;
if (dr.HasRows)
{
while (dr.Read())
{
registro = new RegistroEntity()
{
Id = Convert.ToInt32(dr["ID"]),
Bilhete = dr["BILHETE"].ToString(),
Cobertura = dr["COBERTURA"].ToString(),
Companhia = dr[""].ToString(),
CustoOriginal = Convert.ToDecimal(dr["CUSTO_ORIGINAL"]),
DataAtendimento = Convert.ToDateTime(dr["DATA_ATENDIMENTO"]),
DataEmissaoVoucher = Convert.ToDateTime(dr["DATA_EMISSAO_VOUCHER"]),
DataOcorrencia = Convert.ToDateTime(dr["DATA_OCORRENCIA"]),
Dolar = Convert.ToDouble(dr["DOLAR"]),
Fee = Convert.ToDecimal(dr["FEE"]),
ValorReal = Convert.ToDecimal(dr["VALOR_REAL"]),
ValorDolar = Convert.ToDecimal(dr["VALOR_DOLAR"]),
ValorFinal = Convert.ToDecimal(dr["VALOR_FINAL"]),
Nome = dr["NOME"].ToString(),
NumeroDocumento = dr["NUMERO_DOCUMENTO"].ToString(),
NumeroSinistro = dr["NUMERO_SINISTRO"].ToString(),
Processo = dr["PROCESSO"].ToString(),
Referencia = dr["REFERENCIA"].ToString(),
TipoMoeda = dr["TIPO_MOEDA"].ToString(),
TipoMoedaFee = dr["TIPO_MOEDA_FEE"].ToString(),
Voucher = dr["VOUCHER"].ToString(),
SinistroId = Convert.ToInt32(dr["SINISTRO_ID"]),
Importacao = new ImportacaoEntity()
{
Id = Convert.ToInt32(dr["IMPORTACAO_ID"])
}
};
}
}
return(registro);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
}
// PUT api/registro/5
public bool Put(int id, [FromBody] RegistroEntity registroEntity)
{
if (id > 0)
{
return(_registroServices.UpdateRegistro(id, registroEntity));
}
return(false);
}
public void Insert(RegistroEntity registro)
{
try
{
OpenConnection();
using (cmd = new SqlCommand("", con))
{
cmd.CommandText = "imp.UP_REGISTRO_CADASTRAR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IMPORTACAO_ID", SqlDbType.Int)).Value = registro.Importacao.Id;
cmd.Parameters.Add(new SqlParameter("@NUMERO_SINISTRO", SqlDbType.VarChar)).Value = registro.NumeroSinistro;
cmd.Parameters.Add(new SqlParameter("@COMPANHIA", SqlDbType.VarChar)).Value = registro.Companhia;
cmd.Parameters.Add(new SqlParameter("@PROCESSO", SqlDbType.VarChar)).Value = registro.Processo;
cmd.Parameters.Add(new SqlParameter("@BILHETE", SqlDbType.VarChar)).Value = registro.Bilhete;
cmd.Parameters.Add(new SqlParameter("@DATA_EMISSAO_VOUCHER", SqlDbType.SmallDateTime)).Value = registro.DataEmissaoVoucher;
cmd.Parameters.Add(new SqlParameter("@REFERENCIA", SqlDbType.VarChar)).Value = registro.Referencia;
cmd.Parameters.Add(new SqlParameter("@DATA_ATENDIMENTO", SqlDbType.SmallDateTime)).Value = registro.DataAtendimento;
cmd.Parameters.Add(new SqlParameter("@DATA_OCORRENCIA", SqlDbType.SmallDateTime)).Value = registro.DataOcorrencia;
cmd.Parameters.Add(new SqlParameter("@NOME_SEGURADO", SqlDbType.VarChar)).Value = registro.Nome;
cmd.Parameters.Add(new SqlParameter("@DOCUMENTO", SqlDbType.VarChar)).Value = registro.NumeroDocumento;
cmd.Parameters.Add(new SqlParameter("@VOUCHER", SqlDbType.VarChar)).Value = registro.Voucher;
cmd.Parameters.Add(new SqlParameter("@COBERTURA_RECLAMADA", SqlDbType.VarChar)).Value = registro.Cobertura;
cmd.Parameters.Add(new SqlParameter("@CUSTO_ORIGINAL", SqlDbType.Money)).Value = registro.CustoOriginal;
cmd.Parameters.Add(new SqlParameter("@TIPO_MOEDA", SqlDbType.VarChar)).Value = registro.TipoMoeda;
cmd.Parameters.Add(new SqlParameter("@VALOR_FINAL", SqlDbType.Money)).Value = registro.ValorFinal;
cmd.Parameters.Add(new SqlParameter("@FEE", SqlDbType.Money)).Value = registro.Fee;
cmd.Parameters.Add(new SqlParameter("@TIPO_MOEDA_FEE", SqlDbType.VarChar)).Value = registro.TipoMoedaFee;
cmd.Parameters.Add(new SqlParameter("@VALOR_ND_US", SqlDbType.Money)).Value = registro.ValorDolar;
cmd.Parameters.Add(new SqlParameter("@VALOR_ND_RS", SqlDbType.Money)).Value = registro.ValorReal;
cmd.Parameters.Add(new SqlParameter("@TAXA_CAMBIO", SqlDbType.Float)).Value = registro.Dolar;
cmd.Parameters.Add(new SqlParameter("@NOTA_DEBITO", SqlDbType.VarChar, 20)).Value = registro.NotaDebito;
cmd.Parameters.Add(new SqlParameter("@DATA_EMISSAO_ND", SqlDbType.SmallDateTime)).Value = registro.DataEmissaoND;
cmd.Parameters.Add(new SqlParameter("@DATA_ENVIO", SqlDbType.SmallDateTime)).Value = registro.DataEnvio;
cmd.Parameters.Add(new SqlParameter("@STATUS_PAGAMENTO", SqlDbType.VarChar, 20)).Value = registro.StatusPagamento;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
}
/// <summary>
/// Creates a registro
/// </summary>
/// <param name="registroEntity"></param>
/// <returns></returns>
public int CreateRegistro(RegistroEntity registroEntity)
{
using (var scope = new TransactionScope())
{
var registro = new Registro
{
BotonPanico = registroEntity.BotonPanico,
Fecha = registroEntity.Fecha,
Hora = registroEntity.Hora,
IdItem = registroEntity.IdItem,
Nivel = registroEntity.Nivel,
Odometro = registroEntity.Odometro,
Presion = registroEntity.Presion,
Temperatura = registroEntity.Temperatura
};
_unitOfWork.RegistroRepository.Insert(registro);
_unitOfWork.Save();
scope.Complete();
return(registro.IdRegistro);
}
}
public void Update(RegistroEntity registro)
{
try
{
OpenConnection();
using (cmd = new SqlCommand("", con))
{
cmd.CommandText = "imp.UP_REGISTRO_ATUALIZAR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = registro.Id;
cmd.Parameters.Add(new SqlParameter("@IMPORTACAO_ID", SqlDbType.Int)).Value = registro.Importacao.Id;
cmd.Parameters.Add(new SqlParameter("@SINISTRO_ID", SqlDbType.Int)).Value = registro.SinistroId;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
}
// POST api/registro
public int Post([FromBody] RegistroEntity registroEntity)
{
return(_registroServices.CreateRegistro(registroEntity));
}
public void Update(RegistroEntity registro) => new RegistroRepository().Update(registro);
public void Insert(RegistroEntity registro) => new RegistroRepository().Insert(registro);
