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