using System; using System.Data; using System.Web; using System.Web.UI; using CMS.Controls; using CMS.GlobalHelper; using CMS.PortalControls; public partial class CMSWebParts_Viewers_Query_queryrepeater : CMSAbstractWebPart { #region "Document properties" /// /// Load pages individually. /// public bool LoadPagesIndividually { get { return ValidationHelper.GetBoolean(GetValue("LoadPagesIndividually"), false); } set { SetValue("LoadPagesIndividually", value); } } /// /// Gets or sets the cache item name. /// public override string CacheItemName { get { return base.CacheItemName; } set { base.CacheItemName = value; repItems.CacheItemName = value; } } /// /// Cache dependencies, each cache dependency on a new line. /// public override string CacheDependencies { get { return ValidationHelper.GetString(base.CacheDependencies, repItems.CacheDependencies); } set { base.CacheDependencies = value; repItems.CacheDependencies = value; } } /// /// Gets or sets the cache minutes. /// public override int CacheMinutes { get { return base.CacheMinutes; } set { base.CacheMinutes = value; repItems.CacheMinutes = value; } } /// /// Gets or sets the order by clause. /// public string OrderBy { get { return DataHelper.GetNotEmpty(ValidationHelper.GetString(GetValue("OrderBy"), repItems.OrderBy), repItems.OrderBy); } set { SetValue("OrderBy", value); repItems.OrderBy = value; } } /// /// Gets or sets the where condition. /// public string WhereCondition { get { return DataHelper.GetNotEmpty(GetValue("WhereCondition"), repItems.WhereCondition); } set { SetValue("WhereCondition", value); repItems.WhereCondition = value; } } /// /// Gets or sets the number which indicates how many documents should be displayed. /// public int SelectTopN { get { return ValidationHelper.GetInteger(GetValue("SelectTopN"), repItems.SelectTopN); } set { SetValue("SelectTopN", value); repItems.SelectTopN = value; } } #endregion #region "Pager properties" /// /// Gets or sets the value that indicates whether paging is enabled. /// public bool EnablePaging { get { return ValidationHelper.GetBoolean(GetValue("EnablePaging"), repItems.EnablePaging); } set { SetValue("EnablePaging", value); repItems.EnablePaging = value; } } /// /// Gets or sets the pager position. /// public PagingPlaceTypeEnum PagerPosition { get { return repItems.PagerControl.GetPagerPosition(DataHelper.GetNotEmpty(GetValue("PagerPosition"), repItems.PagerControl.PagerPosition.ToString())); } set { SetValue("PagerPosition", value.ToString()); repItems.PagerControl.PagerPosition = value; } } /// /// Gets or sets the number of the documents displayed on each sigle page. /// public int PageSize { get { return ValidationHelper.GetInteger(GetValue("PageSize"), repItems.PageSize); } set { SetValue("PageSize", value); repItems.PageSize = value; } } /// /// Gets or sets the pager query string key. /// public string QueryStringKey { get { return DataHelper.GetNotEmpty(ValidationHelper.GetString(GetValue("QueryStringKey"), repItems.PagerControl.QueryStringKey), repItems.PagerControl.QueryStringKey); } set { SetValue("QueryStringKey", value); repItems.PagerControl.QueryStringKey = value; } } /// /// Gets or sets whether PostBack or QueryString should be used for the paging. /// public PagingModeTypeEnum PagingMode { get { return repItems.PagerControl.GetPagingMode(DataHelper.GetNotEmpty(GetValue("PagingMode"), repItems.PagerControl.PagingMode.ToString())); } set { SetValue("PagingMode", value.ToString()); repItems.PagerControl.PagingMode = value; } } /// /// Gets or sets the navigation mode. /// public BackNextLocationTypeEnum BackNextLocation { get { return repItems.PagerControl.GetBackNextLocation(DataHelper.GetNotEmpty(GetValue("BackNextLocation"), repItems.PagerControl.BackNextLocation.ToString())); } set { SetValue("BackNextLocation", value.ToString()); repItems.PagerControl.BackNextLocation = value; } } /// /// Gets or sets the value that indicates whether first and last page is shown if paging is allowed. /// public bool ShowFirstLast { get { return ValidationHelper.GetBoolean(GetValue("ShowFirstLast"), repItems.PagerControl.ShowFirstLast); } set { SetValue("ShowFirstLast", value); repItems.PagerControl.ShowFirstLast = value; } } /// /// Gets or sets the html before pager. /// public string PagerHTMLBefore { get { return ValidationHelper.GetString(GetValue("PagerHTMLBefore"), repItems.PagerControl.PagerHTMLBefore); } set { SetValue("PagerHTMLBefore", value); repItems.PagerControl.PagerHTMLBefore = value; } } /// /// Gets or sets the html after pager. /// public string PagerHTMLAfter { get { return ValidationHelper.GetString(GetValue("PagerHTMLAfter"), repItems.PagerControl.PagerHTMLAfter); } set { SetValue("PagerHTMLAfter", value); repItems.PagerControl.PagerHTMLAfter = value; } } /// /// Gets or sets the results position. /// public ResultsLocationTypeEnum ResultsPosition { get { return repItems.PagerControl.GetResultPosition(ValidationHelper.GetString(GetValue("ResultsPosition"), "")); } set { SetValue("ResultsPosition", value); repItems.PagerControl.ResultsLocation = value; } } /// /// Gets or sets the page numbers separator. /// public string PageNumbersSeparator { get { return ValidationHelper.GetString(GetValue("PageNumbersSeparator"), repItems.PagerControl.PageNumbersSeparator); } set { SetValue("PageNumbersSeparator", value); repItems.PagerControl.PageNumbersSeparator = value; } } #endregion #region "Public properties" /// /// Gets or sets the value that indicates whether control should be hidden if no data found. /// public bool HideControlForZeroRows { get { return ValidationHelper.GetBoolean(GetValue("HideControlForZeroRows"), repItems.HideControlForZeroRows); } set { SetValue("HideControlForZeroRows", value); repItems.HideControlForZeroRows = value; } } /// /// Gets or sets the text which is displayed for zero rows result. /// public string ZeroRowsText { get { return DataHelper.GetNotEmpty(ValidationHelper.GetString(GetValue("ZeroRowsText"), repItems.ZeroRowsText), repItems.ZeroRowsText); } set { SetValue("ZeroRowsText", value); repItems.ZeroRowsText = value; } } /// /// Gets or sets the separator (tetx, html code) which is displayed between displayed items. /// public string ItemSeparator { get { return DataHelper.GetNotEmpty(GetValue("ItemSeparator"), repItems.ItemSeparator); } set { SetValue("ItemSeparator", value); repItems.ItemSeparator = value; } } /// /// Filter name. /// public string FilterName { get { return ValidationHelper.GetString(GetValue("FilterName"), repItems.FilterName); } set { SetValue("FilterName", value); repItems.FilterName = value; } } /// /// Gets or sets query string key name. Presence of the key in query string indicates, /// that some item should be selected. The item is determined by query string value. /// public string SelectedQueryStringKeyName { get { return ValidationHelper.GetString(GetValue("SelectedQueryStringKeyName"), repItems.SelectedQueryStringKeyName); } set { SetValue("SelectedQueryStringKeyName", value); repItems.SelectedQueryStringKeyName = value; } } /// /// Gets or sets columns name by which the item is selected. /// public string SelectedDatabaseColumnName { get { return ValidationHelper.GetString(GetValue("SelectedDatabaseColumnName"), repItems.SelectedDatabaseColumnName); } set { SetValue("SelectedDatabaseColumnName", value); repItems.SelectedDatabaseColumnName = value; } } /// /// Gets or sets validation type for query string value which determines selected item. /// Options are int, guid and string. /// public string SelectedValidationType { get { return ValidationHelper.GetString(GetValue("SelectedValidationType"), repItems.SelectedValidationType); } set { SetValue("SelectedValidationType", value); repItems.SelectedValidationType = value; } } #endregion #region "Data binding properties" /// /// Gets or sets the value that indicates whether databind will be proceeded automatically. /// public bool DataBindByDefault { get { return ValidationHelper.GetBoolean(GetValue("DataBindByDefault"), repItems.DataBindByDefault); } set { SetValue("DataBindByDefault", value); repItems.DataBindByDefault = value; } } /// /// Gets or sets the query name. /// public string QueryName { get { return DataHelper.GetNotEmpty(ValidationHelper.GetString(GetValue("QueryName"), repItems.QueryName), repItems.QueryName); } set { SetValue("QueryName", value); repItems.QueryName = value; } } /// /// Gets or sets selected columns. /// public string Columns { get { return ValidationHelper.GetString(GetValue("Columns"), repItems.Columns); } set { SetValue("Columns", value); repItems.SelectedColumns = value; } } #endregion #region "Transformation properties" /// /// Gets or sets the name of the transforamtion which is used for displaying the results. /// public string TransformationName { get { return DataHelper.GetNotEmpty(ValidationHelper.GetString(GetValue("TransformationName"), repItems.TransformationName), repItems.TransformationName); } set { SetValue("TransformationName", value); repItems.TransformationName = value; } } /// /// Gets or sets the name of the transforamtion which is used for displaying the alternate results. /// public string AlternatingTransformationName { get { return DataHelper.GetNotEmpty(ValidationHelper.GetString(GetValue("AlternatingTransformationName"), repItems.AlternatingTransformationName), repItems.AlternatingTransformationName); } set { SetValue("AlternatingTransformationName", value); repItems.AlternatingTransformationName = value; } } /// /// Gets or sets ItemTemplate for selected item. /// public string SelectedItemTransformationName { get { return ValidationHelper.GetString(GetValue("SelectedItemTransformationName"), ""); } set { SetValue("SelectedItemTransformationName", value); repItems.SelectedItemTransformationName = value; } } #endregion #region "Editing mode buttons properties" /// /// Gets or sets the value that indicates whether edit and delete buttons should be displayed. /// public bool ShowEditDeleteButtons { get { return ValidationHelper.GetBoolean(GetValue("ShowEditDeleteButtons"), repItems.ShowEditDeleteButtons); } set { SetValue("ShowEditDeleteButtons", value); repItems.ShowEditDeleteButtons = value; } } #endregion #region "Stop processing" /// /// Returns true if the control processing should be stopped. /// public override bool StopProcessing { get { return base.StopProcessing; } set { base.StopProcessing = value; repItems.StopProcessing = value; } } #endregion /// /// Content loaded event handler. /// public override void OnContentLoaded() { base.OnContentLoaded(); SetupControl(); } /// /// Initializes the control properties. /// protected void SetupControl() { if (StopProcessing) { repItems.StopProcessing = true; } else { // Add query repeater to the filter collection CMSControlsHelper.SetFilter(ValidationHelper.GetString(GetValue("WebPartControlID"), ClientID), repItems); // Setup the control repItems.ControlContext = ControlContext; // Document properties repItems.LoadPagesIndividually = LoadPagesIndividually; repItems.CacheItemName = CacheItemName; repItems.CacheDependencies = CacheDependencies; repItems.CacheMinutes = CacheMinutes; repItems.OrderBy = OrderBy; repItems.SelectTopN = SelectTopN; repItems.WhereCondition = WhereCondition; repItems.ItemSeparator = ItemSeparator; repItems.FilterName = FilterName; repItems.SelectedQueryStringKeyName = SelectedQueryStringKeyName; repItems.SelectedDatabaseColumnName = SelectedDatabaseColumnName; repItems.SelectedValidationType = SelectedValidationType; // Pager repItems.EnablePaging = EnablePaging; repItems.PageSize = PageSize; repItems.PagerControl.PagerPosition = PagerPosition; repItems.PagerControl.QueryStringKey = QueryStringKey; repItems.PagerControl.PagingMode = PagingMode; repItems.PagerControl.BackNextLocation = BackNextLocation; repItems.PagerControl.ShowFirstLast = ShowFirstLast; repItems.PagerControl.PagerHTMLBefore = PagerHTMLBefore; repItems.PagerControl.PagerHTMLAfter = PagerHTMLAfter; repItems.PagerControl.ResultsLocation = ResultsPosition; repItems.PagerControl.PageNumbersSeparator = PageNumbersSeparator; // Public repItems.HideControlForZeroRows = HideControlForZeroRows; repItems.ZeroRowsText = ZeroRowsText; // Binding repItems.DataBindByDefault = DataBindByDefault; // Transformations repItems.AlternatingTransformationName = AlternatingTransformationName; repItems.TransformationName = TransformationName; repItems.SelectedItemTransformationName = SelectedItemTransformationName; repItems.QueryName = QueryName; repItems.ShowEditDeleteButtons = ShowEditDeleteButtons; repItems.Columns = Columns; } } /// /// OnPrerender override (Set visibility). /// protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); Visible = repItems.Visible && !StopProcessing; if (DataHelper.DataSourceIsEmpty(repItems.DataSource) && repItems.HideControlForZeroRows) { Visible = false; } } /// /// Reloads the data. /// public override void ReloadData() { base.ReloadData(); SetupControl(); repItems.ReloadData(true); } /// /// Clears cache. /// public override void ClearCache() { repItems.ClearCache(); } }