public void Delete(Modelo.Materia obj)
{
// Cria Conexão com banco de dados
SqlConnection conn = new SqlConnection(connectionString);
// Abre conexão com o banco de dados
conn.Open();
// Cria comando SQL
SqlCommand com = conn.CreateCommand();
// Define comando de exclusão
List <Modelo.Exercicio> exercicio = new List <Modelo.Exercicio>();
DAL.DALExercicio dalexer = new DAL.DALExercicio();
exercicio = dalexer.SelectAllIdMateria(obj.idMateria);
for (int i = 0; i < exercicio.Count; i++)
{
SqlCommand cmd2 = new SqlCommand("DELETE FROM alternativaExercicio WHERE idExercicio = @idExercicio", conn);
cmd2.Parameters.AddWithValue("@idExercicio", exercicio[i].idExercicio);
cmd2.ExecuteNonQuery();
}
SqlCommand cmd1 = new SqlCommand("DELETE FROM Exercicio WHERE idMateria = @idMateria", conn);
cmd1.Parameters.AddWithValue("@idMateria", obj.idMateria);
SqlCommand cmd = new SqlCommand("DELETE FROM Materia WHERE idMateria = @idMateria", conn);
cmd.Parameters.AddWithValue("@idMateria", obj.idMateria);
// Executa Comando
cmd1.ExecuteNonQuery();
cmd.ExecuteNonQuery();
}
public alternativaExercicio(string texto, bool correta, int idExercicio)
{
this.texto = texto;
this.correta = correta;
exercicio = new Exercicio();
DAL.DALExercicio daldexercicio = new DAL.DALExercicio();
exercicio = daldexercicio.Select(idExercicio)[0];
}
public void Delete(Modelo.Modulo obj)
{
// Cria Conexão com banco de dados
SqlConnection conn = new SqlConnection(connectionString);
// Abre conexão com o banco de dados
conn.Open();
// Cria comando SQL
SqlCommand com = conn.CreateCommand();
List <Modelo.Materia> materia = new List <Modelo.Materia>();
DAL.DALMateria dalmateria = new DAL.DALMateria();
materia = dalmateria.SelectAllIdModulo(Convert.ToInt32(obj.idModulo));
List <Modelo.Exercicio> exercicio = new List <Modelo.Exercicio>();
DAL.DALExercicio dalexer = new DAL.DALExercicio();
for (int i = 0; i < materia.Count; i++)
{
exercicio = dalexer.SelectAllIdMateria(materia[i].idMateria);
for (int j = 0; j < exercicio.Count; j++)
{
SqlCommand cmd3 = new SqlCommand("DELETE FROM alternativaExercicio WHERE idExercicio = @idExercicio", conn);
cmd3.Parameters.AddWithValue("@idExercicio", exercicio[j].idExercicio);
cmd3.ExecuteNonQuery();
}
}
for (int i = 0; i < materia.Count; i++)
{
SqlCommand cmd2 = new SqlCommand("DELETE FROM Exercicio WHERE idMateria = @idMateria", conn);
cmd2.Parameters.AddWithValue("@idMateria", materia[i].idMateria);
cmd2.ExecuteNonQuery();
}
SqlCommand cmd1 = new SqlCommand("Delete FROM Materia WHERE idModulo = @idModulo", conn);
cmd1.Parameters.AddWithValue("idModulo", obj.idModulo);
cmd1.ExecuteNonQuery();
// Define comando de exclusão
SqlCommand cmd = new SqlCommand("DELETE FROM Modulo WHERE idModulo = @idModulo", conn);
cmd.Parameters.AddWithValue("@idModulo", obj.idModulo);
// Executa Comando
cmd.ExecuteNonQuery();
}
