public Professorturma Excluir(Professorturma a, int id)
{
conexao.Conectar();
cmd.CommandText = "DELETE Professorturma " +
"WHERE IdProfessorTurma = @id";
cmd.Parameters.AddWithValue("@id", id);
conexao.Desconectar();
return(a);
}
public Professorturma Cadastrar(Professorturma a)
{
conexao.Conectar();
cmd.CommandText =
"INSERT INTO Professorturma (Descricao)" +
"VALUES" +
"(@Descricao)";
cmd.Parameters.AddWithValue("@Descricao", a.Descricao);
cmd.ExecuteNonQuery();
conexao.Desconectar();
return(a);
}
public Professorturma Alterar(Professorturma a, int id)
{
conexao.Conectar();
cmd.CommandText = "UPDATE Professorturma " +
"SET Descricao = @Descricao, " +
"WHERE IdProfessorTurma = @id";
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@Descricao", a.Descricao);
cmd.ExecuteNonQuery();
conexao.Desconectar();
return(a);
}
public Professorturma BuscarPorID(int Id)
{
conexao.Conectar();
cmd.CommandText = "SELECT * FROM Professorturma WHERE" +
" IdProfessorTurma = @id";
cmd.Parameters.AddWithValue("@id", Id);
SqlDataReader dados = cmd.ExecuteReader();
Professorturma professorturma = new Professorturma();
while (dados.Read())
{
professorturma.IdProfessorTurma = Convert.ToInt32(dados.GetValue(0));
professorturma.Descricao = dados.GetValue(1).ToString();
}
conexao.Desconectar();
return(professorturma);
}
public Professorturma Delete(int id, [FromBody] Professorturma a)
{
return(repo.Excluir(a, id));
}
public Professorturma Put(int id, [FromBody] Professorturma a)
{
return(repo.Alterar(a, id));
}
public Professorturma Post([FromBody] Professorturma a)
{
return(repo.Cadastrar(a));
}
