public void Insert(NotaDebitoEntity notaDebito)
{
try
{
OpenConnection();
using (cmd = new SqlCommand("", con))
{
cmd.CommandText = "UP_NOTA_DEBITO_CADASTRAR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@NOME", SqlDbType.VarChar, 20)).Value = notaDebito.Nome;
cmd.Parameters.Add(new SqlParameter("@DATA_EMISSAO", SqlDbType.SmallDateTime)).Value = notaDebito.DataEmissao;
cmd.Parameters.Add(new SqlParameter("@DATA_ENVIO", SqlDbType.SmallDateTime)).Value = notaDebito.DataEnvio;
cmd.Parameters.Add(new SqlParameter("@PREVISAO_PAGAMENTO", SqlDbType.SmallDateTime)).Value = notaDebito.PrevisaoPagamento;
cmd.Parameters.Add(new SqlParameter("@DATA_PAGAMENTO", SqlDbType.SmallDateTime)).Value = notaDebito.DataPagamento;
cmd.Parameters.Add(new SqlParameter("@DATA_EMAIL", SqlDbType.SmallDateTime)).Value = notaDebito.DataEmail;
cmd.Parameters.Add(new SqlParameter("@DATA_REPASSE_REMESSA", SqlDbType.SmallDateTime)).Value = notaDebito.DataRepasseRemessa;
cmd.Parameters.Add(new SqlParameter("@DOLAR_BANCO_CENTRAL", SqlDbType.Money)).Value = notaDebito.DolarBancoCentral;
cmd.Parameters.Add(new SqlParameter("@OBSERVACAO", SqlDbType.VarChar)).Value = notaDebito.Observacao;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
}
public NotaDebitoEntity GetById(int id)
{
try
{
OpenConnection();
using (cmd = new SqlCommand("", con))
{
cmd.CommandText = "UP_NOTA_DEBITO_BUSCAR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = id;
dr = cmd.ExecuteReader();
NotaDebitoEntity notaDebito = null;
if (dr.HasRows)
{
while (dr.Read())
{
notaDebito = new NotaDebitoEntity()
{
Id = Convert.ToInt32(dr["ID"]),
Nome = dr["NOME"].ToString(),
Ativo = Convert.ToBoolean(dr["ATIVO"]),
DataEmissao = Convert.ToDateTime(dr["DATA_EMISSAO"]),
DataEnvio = Convert.ToDateTime(dr["DATA_ENVIO"]),
PrevisaoPagamento = Convert.ToDateTime(dr["PREVISAO_PAGAMENTO"]),
DataPagamento = Convert.ToDateTime(dr["DATA_PAGAMENTO"]),
DataRepasseRemessa = Convert.ToDateTime(dr["DATA_REPASSE_REMESSA"]),
DataEmail = Convert.ToDateTime(dr["DATA_EMAIL"]),
DolarBancoCentral = Convert.ToDecimal(dr["DOLAR_BANCO_CENTRAL"]),
Observacao = dr["OBSERVACAO"].ToString()
};
}
}
return(notaDebito);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
}
public void Update(NotaDebitoEntity notaDebito) => new NotaDebitoRepository().Update(notaDebito);
public void Insert(NotaDebitoEntity notaDebito) => new NotaDebitoRepository().Insert(notaDebito);