/// <summary> /// Load filter control according filterpath. /// </summary> private void LoadFilter() { if (this.mFilterControl == null) { if (this.FilterControlPath != null) { try { if (File.Exists(Server.MapPath(this.FilterControlPath))) { this.mFilterControl = (this.Page.LoadControl(this.FilterControlPath)) as CMSAbstractBaseFilterControl; if (this.mFilterControl != null) { this.mFilterControl.ID = "filterControl"; this.Controls.AddAt(0, this.mFilterControl); this.mFilterControl.FilterName = this.FilterName; if (this.Page != null) { this.mFilterControl.Page = this.Page; } } } } catch (Exception ex) { EventLogProvider log = new EventLogProvider(); log.LogEvent("Filter control", "LOADFILTER", ex); } } } }
/// <summary> /// Loads dynamically custom filter if is defined. /// </summary> private void LoadFilter() { // Use user filter if (!String.IsNullOrEmpty(filterControl)) { pnlFilter.Controls.Clear(); searchControl = (CMSAbstractBaseFilterControl)LoadUserControl(filterControl); if (searchControl != null) { searchControl.Parameters = parameters; searchControl.FilteredControl = this; searchControl.OnFilterChanged += searchControl_OnFilterChanged; searchControl.ID = "filterElem"; searchControl.SelectedValue = hidItem.Value.Replace(valuesSeparator, string.Empty); searchControl.FilterMode = filterMode; pnlFilter.Controls.Add(searchControl); pnlFilter.Visible = true; // Get init filter where condition FilterWhere = SqlHelper.AddWhereCondition(string.Empty, searchControl.WhereCondition); // When both filters are rendered, mark the first as followed by another if (useDefaultNameFilter) { pnlFilter.CssClass += " header-panel-not-last"; } } } }
/// <summary> /// Load filter control according filterpath. /// </summary> private void LoadFilter() { if (mFilterControl == null) { if (FilterControlPath != null) { try { if (File.Exists(Server.MapPath(FilterControlPath))) { mFilterControl = (Page.LoadUserControl(FilterControlPath)) as CMSAbstractBaseFilterControl; if (mFilterControl != null) { mFilterControl.ID = "filterControl"; Controls.AddAt(0, mFilterControl); mFilterControl.FilterName = FilterName; if (Page != null) { mFilterControl.Page = Page; } } } } catch (Exception ex) { EventLogProvider.LogException("Filter control", "LOADFILTER", ex); } } } }
/// <summary> /// Load filter control according filterpath. /// </summary> private void LoadFilter() { if (mFilterControl == null) { if (FilterControlPath != null) { try { mFilterControl = (Page.LoadUserControl(FilterControlPath)) as CMSAbstractBaseFilterControl; if (mFilterControl != null) { mFilterControl.ID = "filterControl"; Controls.AddAt(0, mFilterControl); mFilterControl.FilterName = FilterName; if (Page != null) { mFilterControl.Page = Page; } } } catch (Exception ex) { EventLogProvider.LogException("Filter control", "LOADFILTER", ex, loggingPolicy: LoggingPolicy.ONLY_ONCE); } } } }
/// <summary> /// Loads dynamically custom filter if is defined. /// </summary> private void LoadFilter() { // Use user filter if (!String.IsNullOrEmpty(filterControl)) { pnlFilter.Controls.Clear(); searchControl = (CMSAbstractBaseFilterControl)LoadUserControl(filterControl); if (searchControl != null) { searchControl.Parameters = parameters; searchControl.FilteredControl = this; searchControl.OnFilterChanged += searchControl_OnFilterChanged; searchControl.ID = "filterElem"; searchControl.SelectedValue = hidItem.Value.Replace(valuesSeparator, string.Empty); searchControl.FilterMode = filterMode; pnlFilter.Controls.Add(searchControl); pnlFilter.Visible = true; // Get init filter where condition FilterWhere = SqlHelperClass.AddWhereCondition("", searchControl.WhereCondition); } } }
/// <summary> /// Gets SQL Where condition for a state. /// </summary> private string GetStateCondition(CMSAbstractBaseFilterControl filter) { string originalQuery = filter.WhereCondition; if (!String.IsNullOrEmpty(originalQuery)) { return(String.Format("AccountStateID IN (SELECT StateID FROM CMS_State WHERE {0})", originalQuery)); } return(originalQuery); }
/// <summary> /// Gets SQL Where condition for owner's fullname. /// </summary> private string GetOwnerCondition(CMSAbstractBaseFilterControl filter) { string originalQuery = filter.WhereCondition; if (!String.IsNullOrEmpty(originalQuery)) { return(String.Format("ContactOwnerUserID IN (SELECT UserID FROM CMS_User WHERE {0})", originalQuery)); } return(originalQuery); }
/// <summary> /// Loads dynamically custom filter if is defined. /// </summary> private void LoadFilter() { // Use user filter if (!String.IsNullOrEmpty(filterControl)) { pnlFilter.Controls.Clear(); searchControl = (CMSAbstractBaseFilterControl)LoadUserControl(filterControl); if (searchControl != null) { searchControl.Parameters = parameters; searchControl.FilteredControl = this; searchControl.OnFilterChanged += searchControl_OnFilterChanged; searchControl.ID = "filterElem"; searchControl.SelectedValue = hidItem.Value.Replace(valuesSeparator, string.Empty); searchControl.FilterMode = filterMode; pnlFilter.Controls.Add(searchControl); pnlFilter.Visible = true; // Get init filter where condition FilterWhere = SqlHelperClass.AddWhereCondition("", searchControl.WhereCondition); } } }
/// <summary> /// Load filter control according filterpath. /// </summary> private void LoadFilter() { if (this.mFilterControl == null) { if (this.FilterControlPath != null) { try { if (File.Exists(Server.MapPath(this.FilterControlPath))) { this.mFilterControl = (this.Page.LoadControl(this.FilterControlPath)) as CMSAbstractBaseFilterControl; if (this.mFilterControl != null) { this.mFilterControl.ID = "filterControl"; this.Controls.AddAt(0, this.mFilterControl); this.mFilterControl.FilterName = this.FilterName; if (this.Page != null) { this.mFilterControl.Page = this.Page; } } } } catch (Exception ex) { EventLogProvider log = new EventLogProvider(); log.LogEvent("Filter control", "LOADFILTER", ex); } } } }
/// <summary> /// Gets SQL Where condition for a state. /// </summary> private string GetStateCondition(CMSAbstractBaseFilterControl filter) { string originalQuery = filter.WhereCondition; if (!String.IsNullOrEmpty(originalQuery)) { return String.Format("ContactStateID IN (SELECT StateID FROM CMS_State WHERE {0})", originalQuery); } return originalQuery; }
/// <summary> /// Load filter control according filterpath. /// </summary> private void LoadFilter() { if (mFilterControl == null) { if (FilterControlPath != null) { try { if (File.Exists(Server.MapPath(FilterControlPath))) { mFilterControl = (Page.LoadUserControl(FilterControlPath)) as CMSAbstractBaseFilterControl; if (mFilterControl != null) { mFilterControl.ID = "filterControl"; Controls.AddAt(0, mFilterControl); mFilterControl.FilterName = FilterName; if (Page != null) { mFilterControl.Page = Page; } } } } catch (Exception ex) { EventLogProvider.LogException("Filter control", "LOADFILTER", ex); } } } }
/// <summary> /// Loads dynamically custom filter if is defined. /// </summary> private void LoadFilter() { // Use user filter if (!String.IsNullOrEmpty(filterControl)) { pnlFilter.Controls.Clear(); searchControl = (CMSAbstractBaseFilterControl)LoadUserControl(filterControl); if (searchControl != null) { searchControl.Parameters = parameters; searchControl.FilteredControl = this; searchControl.OnFilterChanged += searchControl_OnFilterChanged; searchControl.ID = "filterElem"; searchControl.SelectedValue = hidItem.Value.Replace(valuesSeparator, string.Empty); searchControl.FilterMode = filterMode; pnlFilter.Controls.Add(searchControl); pnlFilter.Visible = true; // Get init filter where condition FilterWhere = SqlHelper.AddWhereCondition(string.Empty, searchControl.WhereCondition); // When both filters are rendered, mark the first as followed by another if (useDefaultNameFilter) { pnlFilter.CssClass += " header-panel-not-last"; } } } }
/// <summary> /// Gets SQL Where condition for a country. /// </summary> private string GetCountryCondition(CMSAbstractBaseFilterControl filter) { string originalQuery = filter.WhereCondition; if (!String.IsNullOrEmpty(originalQuery)) { return String.Format("AccountCountryID IN (SELECT CountryID FROM CMS_Country WHERE {0})", originalQuery); } return originalQuery; }