/// <summary> /// Altera uma Turma /// </summary> /// <autor>Diogo T. Machado</autor> /// <param name="objTurma">Entidade de Turma</param> public void Alterar(EntTurma objTurma) { using (DbConnection connection = db.CreateConnection()) { connection.Open(); DbTransaction transaction = connection.BeginTransaction(); int count = 0; try { dalTurma.Alterar(objTurma, transaction, db); new DalTurmaQuestionario().ExcluirTodosPorTurma(objTurma.IdTurma, transaction, db); foreach (EntTurmaQuestionario item in objTurma.Questionarios) { count++; item.Ordem = count; item.Turma.IdTurma = objTurma.IdTurma; EntTurmaQuestionario objTurmaQuestionario = new DalTurmaQuestionario().Inserir(item, transaction, db); //objRetorno.Questionarios.Add(objTurmaQuestionario); } transaction.Commit(); } catch { transaction.Rollback(); throw; } finally { connection.Close(); } } }
/// <summary> /// Inclui uma Turma /// </summary> /// <autor>Diogo T. Machado</autor> /// <param name="objTurma">Entidade de Turma</param> /// <returns>Entidade de Turma</returns> public EntTurma Inserir(EntTurma objTurma) { EntTurma objRetorno = null; EntTurmaQuestionario objTurmaQuestionario = null; using (DbConnection connection = db.CreateConnection()) { connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { objRetorno = dalTurma.Inserir(objTurma, transaction, db); transaction.Commit(); } catch { transaction.Rollback(); throw; } finally { connection.Close(); } } using (DbConnection connection = db.CreateConnection()) { connection.Open(); DbTransaction transaction = connection.BeginTransaction(); int count = 0; try { if (objRetorno.IdTurma > 0) { //Gera Etapas da Turma objRetorno.Etapas = new BllEtapa().GerarEtapasTurma(objTurma); //Insere os questionarios da turma new DalTurmaQuestionario().ExcluirTodosPorTurma(objTurma.IdTurma, transaction, db); foreach (EntTurmaQuestionario item in objTurma.Questionarios) { count++; item.Ordem = count; item.Turma.IdTurma = objTurma.IdTurma; objTurmaQuestionario = new DalTurmaQuestionario().Inserir(item, transaction, db); } } transaction.Commit(); } catch { transaction.Rollback(); throw; } finally { connection.Close(); } } return(objRetorno); }