/// <summary>
/// Obter Logs
/// </summary>
/// <returns></returns>
public static List <Pagina> Listar(int pintIdCategoria = 0, int pintStatus = -1)
{
string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString;
SqlConnection objConexao = new SqlConnection(strConectionString);
SqlCommand objComando = new SqlCommand("SPE_L_PAGINAS");
objComando.Connection = objConexao;
objComando.CommandType = CommandType.StoredProcedure;
if (pintIdCategoria > 0)
{
objComando.Parameters.Add("@categoriaId", SqlDbType.Int).Value = pintIdCategoria;
}
if (pintStatus > -1)
{
objComando.Parameters.Add("@status", SqlDbType.Int).Value = pintStatus;
}
try
{
//Abre Conexao
objConexao.Open();
//Declara variavel de retorno
List <Pagina> objList = new List <Pagina>();
Pagina obj = default(Pagina);
IDataReader idrReader = default(IDataReader);
idrReader = objComando.ExecuteReader();
while ((idrReader.Read()))
{
obj = new Pagina();
obj.FromIDataReader(idrReader);
objList.Add(obj);
}
return(objList);
}
catch (Exception ex)
{
throw ex;
}
finally
{
//Fecha a conexao se aberta
if (objConexao.State != ConnectionState.Closed)
{
objConexao.Close();
}
}
}
/// <summary>
/// Obter perfil pelo id
/// </summary>
/// <returns></returns>
public static Pagina Obter(int pintIdPagina)
{
string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString;
SqlConnection objConexao = new SqlConnection(strConectionString);
SqlCommand objComando = new SqlCommand("SPE_L_PAGINAS");
objComando.Connection = objConexao;
objComando.CommandType = CommandType.StoredProcedure;
objComando.Parameters.Add("@PAGINAID", SqlDbType.Int).Value = pintIdPagina;
try
{
objConexao.Open();
Pagina objPagina = new Pagina();
IDataReader idrReader = default(IDataReader);
idrReader = objComando.ExecuteReader();
while ((idrReader.Read()))
{
objPagina.FromIDataReader(idrReader);
}
return(objPagina);
}
catch (Exception ex)
{
throw ex;
}
finally
{
//Fecha a conexao se aberta
if (objConexao.State != ConnectionState.Closed)
{
objConexao.Close();
}
}
}