/// <summary>
/// Retorna uma lista de entidade de TurmaQuestionario
/// </summary>
/// <autor>Fabio Senziani</autor>
/// <param name="transaction">Transaction</param>
/// <param name="db">DataBase</param>
/// <returns><list type="EntTurmaQuestionario">Lista de EntTurmaQuestionario</list></returns>
public List <EntTurmaQuestionario> ObterTodosPorTurma(Int32 nTurma, DbTransaction transaction, Database db)
{
List <EntTurmaQuestionario> listEntReturn = new List <EntTurmaQuestionario>();
DbCommand dbCommand = db.GetStoredProcCommand("STP_SelecionaTurmaQuestionarioPorTurma");
db.AddInParameter(dbCommand, "@nCEA_TURMA", DbType.Int32, nTurma);
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
using (DbDataReader dtrDados = (System.Data.Common.DbDataReader)db.ExecuteReader(dbCommand, transaction))
{
if (dtrDados != null && dtrDados.HasRows)
{
foreach (DbDataRecord DataRecord in dtrDados)
{
EntTurmaQuestionario entReturn = new EntTurmaQuestionario();
entReturn.Ordem = ObjectUtils.ToInt(dtrDados["NU_ORDEM"]);
entReturn.Obrigatorio = ObjectUtils.ToBoolean(dtrDados["FL_OBRIGATORIO"]);
entReturn.Turma.IdTurma = ObjectUtils.ToInt(dtrDados["CEA_TURMA"]);
entReturn.Questionario.IdQuestionario = ObjectUtils.ToInt(dtrDados["CEA_QUESTIONARIO"]);
entReturn.Questionario.Questionario = ObjectUtils.ToString(dtrDados["TX_QUESTIONARIO"]);
listEntReturn.Add(entReturn);
}
return(listEntReturn);
}
else
{
return(listEntReturn);
}
}
}
/// <summary>
/// Excluir um Questionario da Turma
/// </summary>
/// <autor>Diogo T. Machado</autor>
/// <param name="objTurmaQuestionario">Entidade que representa a tabela Turma Questionario</param>
/// <param name="transaction">Transaction</param>
/// <param name="db">DataBase</param>
public void ExcluirTurmaQuestionario(EntTurmaQuestionario objTurmaQuestionario, DbTransaction transaction, Database db)
{
DbCommand dbCommand = db.GetStoredProcCommand("STP_DeletaTurmaQuestionario");
db.AddInParameter(dbCommand, "@CEA_QUESTIONARIO", DbType.Int32, objTurmaQuestionario.Questionario.IdQuestionario);
db.AddInParameter(dbCommand, "@CEA_TURMA", DbType.Int32, objTurmaQuestionario.Turma.IdTurma);
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.ExecuteNonQuery(dbCommand, transaction);
}
/// <summary>
/// Inclui um registro na tabela Turma_Questionario
/// </summary>
/// <autor>Diogo T. Machado</autor>
/// <param name="objTurmaQuestionario">Entidade que representa a tabela Turma_Questionario</param>
/// <param name="transaction">Transaction</param>
/// <param name="db">DataBase</param>
/// <returns>Entidade de TurmaQuestionario</returns>
public EntTurmaQuestionario Inserir(EntTurmaQuestionario objTurmaQuestionario, DbTransaction transaction, Database db)
{
EntTurmaQuestionario objRetorno = null;
DbCommand dbCommand = db.GetStoredProcCommand("STP_InsereTurmaQuestionario");
dbCommand.CommandTimeout = BdConfig.CommmandTimeout;
db.AddInParameter(dbCommand, "@CEA_QUESTIONARIO", DbType.Int32, objTurmaQuestionario.Questionario.IdQuestionario);
db.AddInParameter(dbCommand, "@CEA_TURMA", DbType.Int32, objTurmaQuestionario.Turma.IdTurma);
db.AddInParameter(dbCommand, "@FL_OBRIGATORIO", DbType.Boolean, objTurmaQuestionario.Obrigatorio);
db.AddInParameter(dbCommand, "@NU_ORDEM", DbType.Int32, objTurmaQuestionario.Ordem);
db.ExecuteNonQuery(dbCommand, transaction);
return(objRetorno);
}
/// <summary>
/// Excluir TurmaQuestionario
/// </summary>
/// <autor>Diogo T. Machado</autor>
/// <param name="objTurmaEmpresa">Id de Grupo</param>
public void Excluir(EntTurmaQuestionario objTurmaEmpresa)
{
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
dalTurmaQuestionario.ExcluirTurmaQuestionario(objTurmaEmpresa, transaction, db);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
}
private List <EntTurmaQuestionario> obterQuestionariosSelecionados(List <EntTurmaQuestionario> lstQuestionariosAssociados)
{
int Ordem = lstQuestionariosAssociados.Count;
foreach (GridViewRow item in this.grdQuestionarioIncluir.Rows)
{
if (item.RowType == DataControlRowType.DataRow)
{
if (((CheckBox)item.Cells[3].Controls[1]).Checked)
{
EntTurmaQuestionario objQuestionario = new EntTurmaQuestionario();
Ordem++;
objQuestionario.Questionario.IdQuestionario = StringUtils.ToInt(((Label)this.grdQuestionarioIncluir.Rows[item.DataItemIndex].Cells[0].FindControl("lblIdQuestionario")).Text);
objQuestionario.Questionario.Questionario = ((DataBoundLiteralControl)item.Cells[1].Controls[0]).Text;
objQuestionario.Ordem = Ordem;
lstQuestionariosAssociados.Add(objQuestionario);
}
}
}
return(lstQuestionariosAssociados);
}
/// <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);
}
