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);