public async Task <IActionResult> PostEmissor([FromBody] EmissorModel model)
{
var result = new EmissorEntity
{
Ativo = model.Ativo,
CpfCpnj = model.CpfCpnj,
Identificador = model.Identificador,
NomeFantasia = model.NomeFantasia,
RazaoSocial = model.RazaoSocial,
Url = model.Url
};
return(Ok(result));
}
public void Insert(EmissorEntity emissor)
{
try
{
OpenConnection();
using (cmd = new SqlCommand("", con))
{
cmd.CommandText = "UP_EMISSOR_CADASTRAR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@NOME", SqlDbType.VarChar, 100)).Value = emissor.Nome;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
}
public EmissorEntity GetById(int id)
{
try
{
OpenConnection();
using (cmd = new SqlCommand("", con))
{
cmd.CommandText = "UP_EMISSOR_BUSCAR";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = id;
dr = cmd.ExecuteReader();
EmissorEntity emissor = null;
if (dr.HasRows)
{
while (dr.Read())
{
emissor = new EmissorEntity()
{
Id = Convert.ToInt32(dr["ID"]),
Nome = Convert.ToString(dr["NOME"]),
Ativo = Convert.ToBoolean(dr["ATIVO"])
};
}
}
return(emissor);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
}
public void Update(EmissorEntity emissor) => new EmissorRepository().Update(emissor);
public void Insert(EmissorEntity emissor) => new EmissorRepository().Insert(emissor);
