// 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());
}
