public static List <Accordions> Listar(int conteudoId)
{
var strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString;
var objConexao = new SqlConnection(strConectionString);
try
{
using (var objComando = new SqlCommand("SPE_L_MODULO_ACCORDION"))
{
objComando.Connection = objConexao;
objComando.CommandType = CommandType.StoredProcedure;
objComando.Parameters.Add("@CONTEUDOID", SqlDbType.Int).Value = conteudoId;
//Abre Conexao
objConexao.Open();
//Declara variavel de retorno
var objList = new List <Accordions>();
var obj = default(Accordions);
var idrReader = default(IDataReader);
idrReader = objComando.ExecuteReader();
while ((idrReader.Read()))
{
obj = new Accordions();
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();
}
}
}
protected void rptAccordian_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Accordions objDados = (Accordions)e.Item.DataItem;
List <ConteudoPagina> lstConteudoPagina = DOConteudoPagina.ListarAccordion(objDados.AccordionId);
string urlPagina = Request.RawUrl.Split('?')[0];
PlaceHolder placeHolderControl = (PlaceHolder)e.Item.FindControl("PlaceHolder");
if (lstConteudoPagina.Count > 0)
{
foreach (ConteudoPagina objConteudoPagina in lstConteudoPagina)
{
Control objContainer = LoadControl("~/Modulos/CMS/Paginas/Container.ascx");
if (urlPagina.Contains("Preview.aspx"))
{
//Limpa os controles para exibição
objContainer.Controls.Clear();
}
else
{
foreach (Control objControl in objContainer.Controls)
{
if (objControl.ID == "divSubir" || objControl.ID == "divDescer")
{
objControl.Visible = false;
}
}
}
objContainer.ID = string.Concat("CTT_", objConteudoPagina.ConteudoId);
objContainer.Controls.AddAt(0, LoadControl(String.Concat("~/Modulos/CMS/Modulos", objConteudoPagina.Arquivo)));
placeHolderControl.Controls.Add(objContainer);
}
}
}
}
