Filtering the EVENTS Module

We just bought this CMS software. I am pretty new to the API. I have gone thru some documentation on the wesbite searching for my answers. Well i am still searching!!!. My question is regarding filtering by Category, Tags, start Date and End Date in the Events Module.

I am using Sitefinity 5.1

For example I have created  Three Events. (Event1, Event2, Event3)
Event1 has a Category as CityA and Tags as Kids, Teens.
Event2 has a Category as CityB  and Tags as Kids, Adults.
Event3 has a Category as CityC, and Tags as Teens, Adults.

I want filter the results based upon categories, tags and dates selected.
So i created 2 RadListBox with check boxes of Tags and Categories, and two RadDatePicker for the dates.

 So how do i show all the Events based upon different Categories and Tags with start date and End Date ?  The user can select Multiple Categories and multiple Tags.  I want the result set to bind to a RadListView

I have made the ASCX page with the controls.  I also tried to use the IMetaSearchInfo which is not working. I don't know what namespaces i need.

I also hard coded the Tags and Categories in the RadListBox with check boxes.
 IS there any other way that i can automatically populate the RadListBox using the API without hard coding the tags and categories?

Here is MY ASCX Code

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Events.ascx.cs" Inherits="SitefinityWebApp.UserControls.Events" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
<telerik:RadSkinManager ID="QsfSkinManager" runat="server" ShowChooser="true" />
<telerik:RadFormDecorator ID="QsfFromDecorator" runat="server" DecoratedControls="All"
    EnableRoundedCorners="false" />
<label for="NamesDDL">
    Select contact name to view its product orders:</label>
<div style="margin-top: 15px;">
    <table>
        <tr>
            <td>
                Categories
            </td>
            <td>
                Location
            </td>
            <td>
                Start Date
            </td>
            <td>
                End Date
            </td>
        </tr>
        <tr>
            <td>


 
    <telerik:RadListBox ID="RadListBox1" runat="server" CheckBoxes="true" Width="120px"
                Height="100px">
                <Items>
                    <telerik:RadListBoxItem Text="Kids"></telerik:RadListBoxItem>
                    <telerik:RadListBoxItem Text="Adult"></telerik:RadListBoxItem>
                    <telerik:RadListBoxItem Text="Teens"></telerik:RadListBoxItem>
                </Items>
            </telerik:RadListBox>


          
               
            </td>
            <td>

            <telerik:RadListBox ID="RadListBox2" runat="server" CheckBoxes="true" Height="100"  Width="120px">
                <Items>
                    <telerik:RadListBoxItem Text="CityA"></telerik:RadListBoxItem>
                    <telerik:RadListBoxItem Text="CityB"></telerik:RadListBoxItem>
                    <telerik:RadListBoxItem Text="CittyC"></telerik:RadListBoxItem>
                </Items>
            </telerik:RadListBox>
              
            </td>
            <td>
                <telerik:RadDatePicker ID="RadDatePicker1" runat="server">
                    <Calendar ID="Calendar1" runat="server" EnableKeyboardNavigation="true">
                    </Calendar>
                    <DateInput ID="DateInput2" ToolTip="Date input" runat="server">
                    </DateInput>
                </telerik:RadDatePicker>
            </td>
            <td>
                <telerik:RadDatePicker ID="RadDatePicker2" runat="server">
                    <Calendar ID="Calendar2" runat="server" EnableKeyboardNavigation="true">
                    </Calendar>
                    <DateInput ID="DateInput1" ToolTip="Date input" runat="server">
                    </DateInput>
                </telerik:RadDatePicker>
                <telerik:RadButton ID="Submit" runat="server" Text="Search" OnClick="Submit_Click">
                </telerik:RadButton>
            </td>
        </tr>
    </table>
</div>
<div style="margin: 15px 0 20px;">
   <telerik:RadListView ID="RadListView1" DataSourceID="SqlDataSource1" runat="server"
        ItemPlaceholderID="EmployeesContainer" AllowPaging="True" PageSize=3>
        <LayoutTemplate>
            <fieldset style="width: 900px">
                <legend>Events</legend>
                <asp:PlaceHolder ID="EmployeesContainer" runat="server"></asp:PlaceHolder>
            </fieldset>
        </LayoutTemplate>
        <ItemTemplate>
            <fieldset style="float: left; width: 420px;">
                <legend>Company:
                            <%#Eval("Title")%>
                </legend>
                <table cellpadding="0" cellspacing="0">
                    <tr>
                        <td>
                            <table cellpadding="0" cellspacing="0">
                                <tr>
                                    <td style="width: 25%">Location:
                                    </td>
                                    <td style="width: 50%">
                                        <%#Eval("Location")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Address:
                                    </td>
                                    <td>
                                        <%#Eval("Address")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Contact:
                                    </td>
                                    <td>
                                        <%# Eval("Contact")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Email:
                                    </td>
                                    <td>
                                        <%# Eval("Email")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Website:
                                    </td>
                                    <td>
                                        <%# Eval("Website")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Phone:
                                    </td>
                                    <td>
                                        <%#Eval("Phone")%>
                                    </td>
                                </tr>
                            </table>
                        </td>
                        <td align="right" style="width: 25%; padding-left: 10px;">
                            <telerik:RadBinaryImage ID="RadBinaryImage1" runat="server" AlternateText="Contact Photo"
                                ToolTip="Contact Photo" Width="90px" Height="110px" ResizeMode="Fit" DataValue='<%# Eval("Photo") %>'>
                            </telerik:RadBinaryImage>
                        </td>
                    </tr>
                </table>
            </fieldset>
        </ItemTemplate>
        <AlternatingItemTemplate>
            <fieldset style="float: left; width: 420px;">
                <legend>Company:
                            <%#Eval("CompanyName")%>
                </legend>
                <table cellpadding="0" cellspacing="0">
                                <tr>
                                    <td style="width: 25%">Location:
                                    </td>
                                    <td style="width: 50%">
                                        <%#Eval("Location")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Address:
                                    </td>
                                    <td>
                                        <%#Eval("Address")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Contact:
                                    </td>
                                    <td>
                                        <%# Eval("Contact")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Email:
                                    </td>
                                    <td>
                                        <%# Eval("Email")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Website:
                                    </td>
                                    <td>
                                        <%# Eval("Website")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>Phone:
                                    </td>
                                    <td>
                                        <%#Eval("Phone")%>
                                    </td>
                                </tr>
                            </table>
                        </td>
                        <td align="right" style="width: 25%; padding-left: 10px;">
                            <telerik:RadBinaryImage ID="RadBinaryImage1" runat="server" AlternateText="Contact Photo"
                                ToolTip="Contact Photo" Width="90px" Height="110px" ResizeMode="Fit" DataValue='<%# Eval("Photo") %>'>
                            </telerik:RadBinaryImage>
                        </td>
                    </tr>
                </table>
            </fieldset>
        </AlternatingItemTemplate>
    </telerik:RadListView>
</div>




<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" EnableAJAX="true" DefaultLoadingPanelID="RadAjaxLoadingPanel1">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="NamesDDL">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="EventsGrid" LoadingPanelID="AjaxLoadingPanel1">
                </telerik:AjaxUpdatedControl>
                <telerik:AjaxUpdatedControl ControlID="NamesDDL"></telerik:AjaxUpdatedControl>
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server">
</telerik:RadAjaxLoadingPanel>
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Here is my Code Behind

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Sitefinity;
using Telerik.Sitefinity.GenericContent.Model;
using Telerik.Web.UI;
using System.ComponentModel;
using Telerik.Sitefinity.Web.DataResolving;
using Telerik.Sitefinity.Pages.Model;
using Telerik.Sitefinity.Events.Model;
using Telerik.Sitefinity.Modules.Events;
using Telerik.Sitefinity.Model;

using Telerik.Sitefinity.Workflow;
using System.Collections;
using System.Text;
using Telerik.OpenAccess;








namespace SitefinityWebApp.UserControls

    public partial class Events : System.Web.UI.UserControl
   
        protected void Page_Load(object sender, EventArgs e)
       

       





        protected void Submit_Click(object sender, EventArgs e)
       



            StringBuilder sb = new StringBuilder();
            IList<RadListBoxItem> collection = RadListBox1.CheckedItems;
            foreach (RadListBoxItem item in collection)
           
                sb.Append(item.Value + ",");
           

            String Catg;
            Catg = sb.ToString();


            StringBuilder sbTag = new StringBuilder();
            IList<RadListBoxItem> collectionTag = RadListBox1.CheckedItems;
            foreach (RadListBoxItem item in collectionTag)
           
                sbTag.Append(item.Value + ",");
           

            String Tags;
            Tags = sbTag.ToString();

            // new instance of eventsManager
            EventsManager eventsManager = new EventsManager("Events");


            //create a filer  
            List<IMetaSearchInfo> filter = new List<IMetaSearchInfo>();
            filter.Add(new MetaSearchInfo(MetaValueTypes.ShortText, "Category", Catg, SearchCondition.Equal, JoinType.And));
            filter.Add(new MetaSearchInfo(MetaValueTypes.ShortText, "Tags", Tags, SearchCondition.Equal, JoinType.And));
            filter.Add(new MetaSearchInfo(MetaValueTypes.ShortText, "Event_Start", RadDatePicker1.SelectedDate.Value.ToShortDateString(), SearchCondition.Equal, JoinType.And));
            filter.Add(new MetaSearchInfo(MetaValueTypes.ShortText, "Event_End", RadDatePicker2.SelectedDate.Value.ToShortDateString(), SearchCondition.Equal, JoinType.And));

            // get all events
            IList listOfAllEvents = eventsManager.Content.GetContent(0, 0, string.Empty, null, string.Empty, null, filter.ToArray());

            // foreach (IContent eventItem in listOfAllEvents)
            //   Response.Write(eventItem.GetMetaData("Title").ToString() + "<br />");

            RadListView1.DataSource = listOfAllEvents.ToString();
            RadListView1.DataBind();


            // filterBuilder.AddFilter(new ContentFilterStatement("Tag.Name", tag.TagName, ContentFilter.Condition.Equal, ContentFilter.JoinType.And));

       


   

Hello Rajeev,

First off, I'd like to refer you to Sitefinity's Developer's Guide. There you may find many references on how to use Sitefinity's components, managers, providers and content items (see some links I've included in the answer below).

For example, here is an article which shows how to correctly use EventsManager in order to retrieve events, and here is the documentation page about Events.
If you build your page/control with some powerful code-behind you may be get more flexibility and power, for example you may want to use Sitefinity's convenient, yet powerful, Fluent API.

To help you with your current attempt, I've produced an alternative to your code (it in a regular webform .aspx. You could, of course, wrap the code as a user-control, add it to the regular page's toolbox and then simply drag and drop it directly on a page with Sitefinity's page editor).

Here is the apsx client site markup, and some comments below it:

• My page uses regular ASP.NET drop-down lists. Those are populated dynamically by querying some data from Sitefinity's content (see the code to learn how), and not statically hard-coded in the markup.
• I use the same DatePickers you used, and slightly simpler RadListView, based on your HTML markup.

My server side code-behind:

• On the Page_Load event handler I populate the categories and location drop-downs.
  The categories selector is populated with all the categories defined in the system.
  Notice how I retrieve the manager by using the manager's static GetManager method, and not by instantiating it myself with a constructor.
  The location drop-down is populated with all the city locations which are included in any of the current events in the system.
• I hook the submit button's click event on the server side. This does not matter, you may still hook the handler via the markup if you like.
• On the click event, I retrieve events as a queryable collection, using the EventsManager. Notice there's a difference if you wish to retrieve events by a specific category or uncategorized directly.
  To control categories / tags I refer you to the Taxonomies documentation.
• Note I retrieve events which are of status Master. I refer you here to documentation about lifecycle in Sitefinity, to understand how it works and differentiates items by their publication status.
• I also set the current page of items by getting the page-size and current page number from the RadListView.
• Then Add filters by city and make sure the event's start date is between the 2 date selectors (You may, of course, add more filters as you wish or change the current implementation to select only events with explicit start and end dates as selected).
• The last part is simply binding the RadListView with the final queryable results.

I hope you find this information helpful in order to progress with your development.

Thanks for your help. I am kind of stuck on Two things. I did some
changes to the previous code.

1. Instead of Categories i am using TAGS. 
2. Now i am populating the Listbox in the Page_Init. 
3. Now i am using the Radlistview like this
   
   http://demos.telerik.com/aspnet-ajax/listview/examples/appearancestyling/customlayouts/defaultcs.aspx
4. I have added the telerik:RadDataPager.
5. I call the LoadData to load the values of the Listboxes. 
6.  I also changed
   
   RadListView1.PageSize * RadListView1.CurrentPageIndex,
   
   RadListView1.PageSize, ref totalCount).Cast<Event>().AsQueryable();to this
   
   0, 100, ref totalCount).Cast<Event>().AsQueryable();

Hi Rajeev,

Maybe you already tried this, but be sure to turn on the ViewState option inside the page properties where you host your UserControl.
I think that you need it in order to preserve the viewstate with the values of the selected listitems.

Regards,
Daniel

It is still not working