// ou integrated security - em caso de não ter autenticação.. //visualização public List <GenerosDomain> ListarGeneros() { List <GenerosDomain> Generos = new List <GenerosDomain>(); using (SqlConnection connect = new SqlConnection(bd)) { string query = "SELECT IdGenero, Nome FROM Generos"; connect.Open(); SqlDataReader reader; using (SqlCommand command = new SqlCommand(query, connect)) { reader = command.ExecuteReader(); while (reader.Read()) { GenerosDomain generos = new GenerosDomain { IdGenero = Convert.ToInt32(reader[0]), Nome = reader["Nome"].ToString() }; Generos.Add(generos); } } } return(Generos); }
public List <GenerosDomain> ListarTodos() { List <GenerosDomain> generosLs = new List <GenerosDomain>(); SqlConnection con = new SqlConnection(StringConexao); con.Open(); string Query = "SELECT * FROM Generos ORDER BY IdGenero ASC"; SqlCommand cmd = new SqlCommand(Query, con); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.HasRows) { while (sdr.Read()) { GenerosDomain genero = new GenerosDomain { IdGenero = Convert.ToInt32(sdr["IdGenero"]), Nome = sdr["Nome"].ToString() }; generosLs.Add(genero); } } return(generosLs); }
//Inicio Listar---------------------------------------- public List <GenerosDomain> Listar() { List <GenerosDomain> generos = new List <GenerosDomain>(); string Query = "select * from Generos"; using (SqlConnection con = new SqlConnection(StringConexao)) { con.Open(); SqlDataReader sdr; using (SqlCommand cmd = new SqlCommand(Query, con)) { sdr = cmd.ExecuteReader(); while (sdr.Read()) { GenerosDomain genero = new GenerosDomain { IdGenero = Convert.ToInt32(sdr["IdAutor"]), Nome = sdr["Nome"].ToString(), }; generos.Add(genero); } } } return(generos); }
public GenerosDomain BuscarPorId(int id) { string Query = "SELECT IdGenero, Nome FROM Generos WHERE IdGenero = @IdGenero"; using (SqlConnection con = new SqlConnection(StringConexao)) { con.Open(); SqlDataReader sdr; using (SqlCommand cmd = new SqlCommand(Query, con)) { cmd.Parameters.AddWithValue("@IdGenero", id); sdr = cmd.ExecuteReader(); if (sdr.HasRows) { while (sdr.Read()) { GenerosDomain genero = new GenerosDomain { IdGenero = Convert.ToInt32(sdr["IdGenero"]), Nome = sdr["Nome"].ToString() }; return(genero); } } return(null); } } }
public List <GenerosDomain> Listar() { List <GenerosDomain> generos = new List <GenerosDomain>(); using (SqlConnection con = new SqlConnection(StringConexao)) { string Query = "SELECT IdGenero, Nome FROM Generos"; con.Open(); SqlDataReader rdr; using (SqlCommand cmd = new SqlCommand(Query, con)) { rdr = cmd.ExecuteReader(); while (rdr.Read()) { GenerosDomain genero = new GenerosDomain { IdGenero = Convert.ToInt32(rdr["IdGenero"]), Nome = rdr["Nome"].ToString() }; generos.Add(genero); } } } return(generos); }
public List <GenerosDomain> Listar() { List <GenerosDomain> Generos = new List <GenerosDomain>(); using (SqlConnection con = new SqlConnection(StringConexao)) { string Query = "SELECT IdGenero, Descricao FROM Generos"; con.Open(); SqlDataReader sdr; using (SqlCommand cmd = new SqlCommand(Query, con)) { sdr = cmd.ExecuteReader(); while (sdr.Read()) { GenerosDomain generos = new GenerosDomain { IdGenero = Convert.ToInt32(sdr["IdGenero"]), Descricao = sdr["Descricao"].ToString() }; Generos.Add(generos); } } } return(Generos); }
public GenerosDomain BuscarPorId(int id) { using (SqlConnection connection = new SqlConnection(bd)) { string queryBuscar = "Select IdGenero, Nome from generos where IdGenero=@Id"; using (SqlCommand command = new SqlCommand(queryBuscar, connection)) { command.Parameters.AddWithValue("@Id", id); connection.Open(); SqlDataReader reader; reader = command.ExecuteReader(); if (reader.Read()) { GenerosDomain generosDomain = new GenerosDomain { IdGenero = Convert.ToInt32(reader["IdGenero"]), Nome = reader["Nome"].ToString() }; return(generosDomain); } return(null); } } }
public List <GenerosDomain> Listar() { using (SqlConnection con = new SqlConnection(StringConexao)) { con.Open(); string Query = "Select * from Generos"; using (SqlCommand cmd = new SqlCommand(Query, con)) { SqlDataReader sdr; sdr = cmd.ExecuteReader(); while (sdr.Read()) { GenerosDomain genero = new GenerosDomain() { IdGenero = Convert.ToInt32(sdr["IdGenero"]), Descricao = sdr["Descricao"].ToString() }; Generos.Add(genero); } } return(Generos); } }
public IActionResult BuscarPorId(int id) { GenerosDomain generosDomain = GeneroRepository.BuscarPorId(id); if (generosDomain == null) { return(NotFound()); } return(Ok(generosDomain)); }
public IActionResult GetById(int id) { GenerosDomain generoBuscado = dominio.BuscarPorId(id); if (generoBuscado == null) { string erro = "O valor inserido é nulo"; return(NotFound(erro)); } return(StatusCode(200, generoBuscado)); }
public IActionResult BuscarId(int Id) { GenerosDomain generosDomain = GeneroRepository.Buscarid(Id); //GenerosDomain generosDomain = new GeneroRepository.BuscarId(Id); if (generosDomain == null) { return(NotFound()); } return(Ok(generosDomain)); }
public IActionResult Cadastrar(GenerosDomain generos) { try { generosRepository.Cadastrar(generos); return(Ok()); } catch (Exception ex) { return(BadRequest(new { mensagem = "Ocorreu um erro" + ex.Message })); } }
public void Cadastrar(GenerosDomain generosDomain) { string Query = "INSERT INTO Generos (Descricao) VALUES (@Descricao)"; using (SqlConnection con = new SqlConnection(StringConexao)) { SqlCommand cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("Descricao", generosDomain.Descricao); con.Open(); cmd.ExecuteNonQuery(); } }
public void Cadastrar(GenerosDomain generosDomain) { string Query = "Insert into Generos (Nome) values(@Nome)"; using (SqlConnection con = new SqlConnection(StringConexao)) { SqlCommand cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("@Nome", generosDomain.Nome); con.Open(); cmd.ExecuteNonQuery(); } }
public void Inserir(GenerosDomain generosDomain) { string Query = "INSERT INTO Generos(Nome) VALUES (@Nome);"; using (SqlConnection con = new SqlConnection(StringConexao)) { SqlCommand cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("@Nome", generosDomain.Nome); con.Open(); cmd.ExecuteNonQuery(); } }
public void Alterar(GenerosDomain generosDomain) { string Query = "UPDATE Generos SET Nome = @Nome WHERE IdGenero = @IdGenero;"; using (SqlConnection con = new SqlConnection(StringConexao)) { SqlCommand cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("@IdGenero", generosDomain.IdGenero); cmd.Parameters.AddWithValue("@Nome", generosDomain.Nome); con.Open(); cmd.ExecuteNonQuery(); } }
//Cadastro public void Post(GenerosDomain generosDomain) { //string queryinsert = "Insert into generos(Nome) Values('"+generosDomain.Nome+"');" string comando = "insert into Generos(Nome)values(@Nome)"; using (SqlConnection con = new SqlConnection(bd)) { SqlCommand command = new SqlCommand(comando, con); command.Parameters.AddWithValue("@Nome", generosDomain.Nome); con.Open(); command.ExecuteNonQuery(); } }
public void AtualizarIdUrl(int id, GenerosDomain generosDomain) { using (SqlConnection connection = new SqlConnection(bd)) { string queryAtualizar = "update generos set Nome = @Nome where IDGenero = @Id"; using (SqlCommand command = new SqlCommand(queryAtualizar, connection)) { command.Parameters.AddWithValue("@Id", id); command.Parameters.AddWithValue("@Nome", generosDomain.Nome); connection.Open(); command.ExecuteNonQuery(); } } }
public void Cadastrar(GenerosDomain genero) { SqlConnection con = new SqlConnection(StringConexao); con.Open(); string Query = "INSERT INTO Generos (Nome) VALUES (@Nome)"; SqlDataReader sdr; SqlCommand cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("@Nome", genero.Nome); sdr = cmd.ExecuteReader(); }
public void Cadastrar(GenerosDomain Generos) { using (SqlConnection con = new SqlConnection(StringConexao)) { con.Open(); string Query = "Insert into Generos (Descricao) values (@Descricao)"; using (SqlCommand cmd = new SqlCommand(Query, con)) { cmd.Parameters.AddWithValue("@Descricao", Generos.Descricao); cmd.ExecuteNonQuery(); } } }
public void AtualizarCorpo(GenerosDomain generosDomain) { using (SqlConnection connection = new SqlConnection(bd)) { string queryUpdate = "update generos set Nome = @Nome where IdGenero = @Id"; using (SqlCommand command = new SqlCommand(queryUpdate, connection)) { command.Parameters.AddWithValue("@Id", generosDomain.IdGenero); command.Parameters.AddWithValue("@Nome", generosDomain.Nome); connection.Open(); command.ExecuteNonQuery(); } } }
public IActionResult PutIdCorpo(GenerosDomain generosDomain) { GenerosDomain generoBuscado = dominio.BuscarPorId(generosDomain.IdGenero); if (generoBuscado != null) { try { dominio.AtualizarCorpo(generosDomain); } catch (Exception ex) { return(BadRequest(ex)); } } return(Ok(generosDomain)); }
public void Atualizar(GenerosDomain genero) { using (SqlConnection con = new SqlConnection(StringConexao)) { // string Query = "UPDATE Funcionarios SET Nome = @Nome, Sobrenome = @Sobrenome WHERE IdFuncionario = @IdFuncionario"; string QueryUp = "UPDATE Generos SET Nome = @Nome WHERE IdGenero = @IdGenero"; using (SqlCommand cmd = new SqlCommand(QueryUp, con)) { cmd.Parameters.AddWithValue("@IdGenero", genero.IdGenero); cmd.Parameters.AddWithValue("@Nome", genero.Nome); con.Open(); cmd.ExecuteNonQuery(); } } }
public IActionResult Post(GenerosDomain generosDomain) { if (generosDomain.Nome.Length == 0) { string mensagem = "Erro, não foi possível inserir (Valor não nulo requerido)."; return(BadRequest(mensagem)); } try { dominio.Post(generosDomain); } catch (Exception ex) { string.Format($"O erro {ex.Message.ToString()} foi identificado"); } return(Ok(dominio.ListarGeneros())); }
public IActionResult PutUrl(int id, GenerosDomain generosDomain) { GenerosDomain generoBuscado = dominio.BuscarPorId(id); if (generoBuscado == null) { return(NotFound( new { mensagem = "Genero não encontrado", erro = true })); } try { dominio.AtualizarIdUrl(id, generosDomain); return(Ok(dominio.ListarGeneros())); } catch (Exception ex) { return(BadRequest(ex.Message.ToString())); } }
public IActionResult Atualizar(int id, GenerosDomain genero) { genero.IdGenero = id; GeneroRepository.Atualizar(genero); return(Ok()); }
public IActionResult Alterar(int id, GenerosDomain generoDomain) { generoDomain.IdGenero = id; generosRepository.Alterar(generoDomain); return(Ok()); }
public IActionResult CadastrarAutor(GenerosDomain GeneroDomain) { GeneroRepository.Cadastrar(GeneroDomain); return(Ok()); }
public IActionResult Cadastrar(GenerosDomain generosDomain) { generoRepository.Cadastrar(generosDomain); return(Ok()); }
public IActionResult Atualizar(GenerosDomain generos) { GeneroRepository.Atualizar(generos); return(Ok()); }