Example #1
0
        /// <summary>
        /// Get a Collection of all views visible to the current user
        /// </summary>
        public Dictionary <CswNbtViewId, CswNbtView> getVisibleViews(string OrderBy, ICswNbtUser User, bool IncludeEmptyViews, bool MobileOnly, bool SearchableOnly, CswEnumNbtViewRenderingMode ViewRenderingMode, CswCommaDelimitedString LimitToViews = null)
        {
            DataTable ViewsTable = null;

            return(getVisibleViews(OrderBy, User, IncludeEmptyViews, MobileOnly, SearchableOnly, ViewRenderingMode, out ViewsTable, LimitToViews));
        }
Example #2
0
        /// <summary>
        /// Get a Collection of all views visible to the current user, and the DataTable
        /// </summary>
        public Dictionary <CswNbtViewId, CswNbtView> getVisibleViews(string OrderBy, ICswNbtUser User, bool IncludeEmptyViews, bool MobileOnly, bool SearchableOnly, CswEnumNbtViewRenderingMode ViewRenderingMode, out DataTable ViewsTable, CswCommaDelimitedString LimitToViews = null, bool ForEdit = false)
        {
            CswTimer VisibleViewsTimer = new CswTimer();

            ViewsTable = null;

            Dictionary <CswNbtViewId, CswNbtView> Ret = new Dictionary <CswNbtViewId, CswNbtView>();

            if (null != User && CswTools.IsPrimaryKey(User.UserId) && CswTools.IsPrimaryKey(User.RoleId))
            {
                if (null == LimitToViews || LimitToViews.Count > 0)
                {
                    CswStaticSelect ViewsSelect = _CswNbtResources.makeCswStaticSelect("getVisibleViews_select", "getVisibleViewInfo");
                    ViewsSelect.S4Parameters.Add("getroleid", new CswStaticParam("getroleid", User.RoleId.PrimaryKey.ToString()));
                    ViewsSelect.S4Parameters.Add("getuserid", new CswStaticParam("getuserid", User.UserId.PrimaryKey.ToString()));
                    string AddClause = " ";
                    if (MobileOnly)
                    {
                        AddClause += "and formobile = '" + CswConvert.ToDbVal(true) + "'";
                    }
                    if (ViewRenderingMode != CswEnumNbtViewRenderingMode.Any)
                    {
                        AddClause += "and viewmode = '" + ViewRenderingMode.ToString() + "'";
                    }
                    if (null != LimitToViews)
                    {
                        AddClause += "and nodeviewid in (" + LimitToViews.ToString() + ")";
                    }
                    ViewsSelect.S4Parameters.Add("addclause", new CswStaticParam("addclause", AddClause, true));
                    if (OrderBy != string.Empty)
                    {
                        ViewsSelect.S4Parameters.Add("orderbyclause", new CswStaticParam("orderbyclause", OrderBy));
                    }
                    else
                    {
                        ViewsSelect.S4Parameters.Add("orderbyclause", new CswStaticParam("orderbyclause", "lower(v.viewname)"));
                    }
                    ViewsTable = ViewsSelect.getTable();

                    _CswNbtResources.logTimerResult("CswNbtView.getVisibleViews() data fetched", VisibleViewsTimer.ElapsedDurationInSecondsAsString);

                    Collection <DataRow> RowsToRemove = new Collection <DataRow>();
                    foreach (DataRow Row in ViewsTable.Rows)
                    {
                        CswNbtView ThisView = new CswNbtView(_CswNbtResources);
                        ThisView.LoadXml(Row["viewxml"].ToString());

                        if (isVisible(ThisView, User, IncludeEmptyViews, SearchableOnly, ForEdit))
                        {
                            Ret.Add(ThisView.ViewId, ThisView);
                        }
                        else
                        {
                            RowsToRemove.Add(Row);
                        }
                    } // foreach( DataRow Row in ViewsTable.Rows )
                    foreach (DataRow Row in RowsToRemove)
                    {
                        ViewsTable.Rows.Remove(Row);
                    }
                } // if( null == LimitToViews || LimitToViews.Count > 0 )
            }     // if( null != User && CswTools.IsPrimaryKey( User.UserId ) && CswTools.IsPrimaryKey( User.RoleId ) )

            _CswNbtResources.logTimerResult("CswNbtView.getVisibleViews() finished", VisibleViewsTimer.ElapsedDurationInSecondsAsString);

            return(Ret);
        }
Example #3
0
 /// <summary>
 /// Get a DataTable of all views visible to the current user
 /// </summary>
 public Dictionary <CswNbtViewId, CswNbtView> getVisibleViews(CswEnumNbtViewRenderingMode ViewRenderingMode)
 {
     return(getVisibleViews(string.Empty, _CswNbtResources.CurrentNbtUser, false, false, false, ViewRenderingMode));
 }