protected override void OnLoad(EventArgs e)
{
var contentLoader = ServiceLocator.Current.GetInstance <IContentLoader>();
RepeaterItems.DataSource = contentLoader.GetChildren <YouTubePlaylistItem>(CurrentData.ContentLink);
RepeaterItems.DataBind();
}
public void SearchAnnounceByCategoryId(int categoryId)
{
string queryString = announceQuery + "WHERE categories.id = @category_id";
SqlCommand select = new SqlCommand(queryString, connection);
select.CommandType = CommandType.Text;
select.Parameters.Add("@category_id", SqlDbType.Int).Value = categoryId;
using (SqlDataAdapter adapter = new SqlDataAdapter(select))
{
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
announcements = new DataSet();
adapter.Fill(announcements);
RepeaterItems.DataSource = announcements;
RepeaterItems.DataBind();
}
}
protected void BtnCategorias_Click(object sender, EventArgs e)
{
Button boton = (Button)sender;
if (boton != null)
{
foreach (Control bt in PanelCategorias.Controls)
{
if (bt.GetType() == typeof(Button))
{
Button btAux = (Button)bt;
btAux.CssClass = "list-group-item"; //Sacar la selección a todos los botones
}
}
boton.CssClass = "list-group-item active"; //Seleccionar el boton clickeado
RepeaterItems.DataSource = producto.listarProductosPorCategoria(boton.Text);
RepeaterItems.DataBind();
}
}
public void SearchAnnounce()
{
string queryString = announceQuery +
"WHERE categories.name LIKE @search_value OR cities.name LIKE @search_value OR message_text LIKE @search_value OR " +
"title LIKE @search_value OR subcategories.name LIKE @search_value OR regions.name LIKE @search_value";
string searchValue = Search.Text.Trim().ToLowerInvariant();
SqlCommand select = new SqlCommand(queryString, connection);
select.CommandType = CommandType.Text;
select.Parameters.Add("@search_value", SqlDbType.VarChar, 150).Value = $"%{searchValue}%";
using (SqlDataAdapter adapter = new SqlDataAdapter(select))
{
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
announcements = new DataSet();
adapter.Fill(announcements);
RepeaterItems.DataSource = announcements;
RepeaterItems.DataBind();
}
}
public void SearchAnnounce()
{
string queryString = "SELECT announcements.id as id, title, user_id, announcements.subcategory_id as subcategory_id, " +
"subcategories.name as subcategory_name, categories.name as category_name, categories.id as category_id,city_id, announcements.image_name, " +
"cities.name as city_name, regions.name as region_name, announcements.creation_date, message_text, price FROM announcements " +
"INNER JOIN subcategories ON subcategories.id = announcements.subcategory_id " +
"INNER JOIN categories ON subcategories.category_id = categories.id " +
"INNER JOIN users ON users.id = announcements.user_id " +
"INNER JOIN cities ON cities.id = users.city_id " +
"INNER JOIN regions ON regions.id = cities.region_id " +
"WHERE user_id=@user_id";
int userId = 0;
if (Session["id"] != null)
{
userId = int.Parse(Session["id"].ToString());
}
else
{
return;
}
SqlCommand select = new SqlCommand(queryString, connection);
select.CommandType = CommandType.Text;
select.Parameters.Add("@user_id", SqlDbType.Int).Value = userId;
using (SqlDataAdapter adapter = new SqlDataAdapter(select))
{
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
announcements = new DataSet();
adapter.Fill(announcements);
RepeaterItems.DataSource = announcements;
RepeaterItems.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
producto = new Producto();
if (!Page.IsPostBack)
{
RepeaterItems.DataSource = producto.listarProductosEnOferta();
RepeaterItems.DataBind();
}
Categoria categoria = new Categoria();
DataTable dtTable = categoria.listarCategorias();
foreach (DataRow dtRow in dtTable.Rows)
{
string desc = dtRow["Descripcion"].ToString();
Button boton = new Button();
boton.Text = desc;
boton.CssClass = "list-group-item";
boton.Width = 250;
boton.Click += new EventHandler(this.BtnCategorias_Click);
PanelCategorias.Controls.Add(boton);
}
}
