public List <MarcaDomain> ListarTodos() { string QuerySelect = "SELECT * FROM MARCA"; List <MarcaDomain> ListaMarca = new List <MarcaDomain>(); using (SqlConnection con = new SqlConnection(StringConexao)) { con.Open(); using (SqlCommand cmd = new SqlCommand(QuerySelect, con)) { SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { MarcaDomain marca = new MarcaDomain { MarcaId = Convert.ToInt32(sdr["MARCAID"]), Nome = sdr["NOME"].ToString() }; ListaMarca.Add(marca); } return(ListaMarca); } } }
public IActionResult Post(MarcaDomain marca) { try { MarcaRepository.Cadastrar(marca); return(Ok()); } catch (Exception ex) { return(BadRequest()); } }
//private string StringConexao = "Data Source=36864133885; initial catalog= PARTNER_GROUP; integrated security=true"; public void Cadastrar(MarcaDomain marca) { using (SqlConnection con = new SqlConnection(StringConexao)) { string QueryInsert = "INSERT INTO MARCA(NOME) VALUES(@NOME)"; using (SqlCommand cmd = new SqlCommand(QueryInsert, con)) { cmd.Parameters.AddWithValue("@NOME", marca.Nome); con.Open(); cmd.ExecuteNonQuery(); } } }