/// <summary>
/// Retorna uma entidade de Setor
/// </summary>
/// <autor>Fabio Senziani</autor>
/// <returns><type="EntSetor">EntSetor</list></returns>
public EntSetor ObterPorId(Int32 IdSetor)
{
EntSetor objSetor = new EntSetor();
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
objSetor = dalSetor.ObterPorId(IdSetor, transaction, db);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(objSetor);
}
/// <summary>
/// Popula Setor, conforme DataReader passado
/// </summary>
/// <autor>Fabio Senziani</autor>
/// <param name="dtrDados">DataReader a ser percorrido.</param>
/// <returns><list type="EntSetor">Lista de EntSetor</list></returns>
private List <EntSetor> Popular(DbDataReader dtrDados)
{
List <EntSetor> listEntReturn = new List <EntSetor>();
EntSetor entReturn;
try
{
while (dtrDados.Read())
{
entReturn = new EntSetor();
entReturn.IdSetor = ObjectUtils.ToInt(dtrDados["CDA_SETOR"]);
entReturn.Setor = ObjectUtils.ToString(dtrDados["TX_SETOR"]);
entReturn.Ativo = ObjectUtils.ToBoolean(dtrDados["FL_ATIVO"]);
listEntReturn.Add(entReturn);
}
dtrDados.Close();
}
catch (Exception ex)
{
throw ex;
}
return(listEntReturn);
}
