示例#1
0
        public static string RemoveFav(string xml)
        {
            var result = string.Empty;
            var dt     = new System.Data.DataTable();
            var data   = new AnalyticsData(xml, AnalyticsType.Favorite, AnalyticsAction.Delete);

            try
            {
                var qExec = new QueryExecutor(SPContext.Current.Web);
                dt = qExec.ExecuteEpmLiveQuery(
                    FRFQueryFactory.GetQuery(data),
                    FRFQueryParamFactory.GetParam(data));
                ClearCache(data);
                if (dt.Rows.Count > 0)
                {
                    result = string.Join(",", CleanItemArray(dt.Rows[0].ItemArray));
                }
                else
                {
                    throw new APIException(21000, "[FavoritesService-RemoveFav] ");
                }
            }
            catch (Exception e)
            {
                throw new APIException(21000, "[FavoritesService-RemoveFav] " + e.Message);
            }

            return(result);
        }
        public static string Create(string xml)
        {
            var result = string.Empty;
            var dt     = new System.Data.DataTable();
            var data   = new AnalyticsData(xml, AnalyticsType.Frequent, AnalyticsAction.Create);

            try
            {
                var exec = new QueryExecutor(SPContext.Current.Web);
                dt = exec.ExecuteEpmLiveQuery(
                    FRFQueryFactory.GetQuery(data),
                    FRFQueryParamFactory.GetParam(data));
                if (dt != null && dt.Rows.Count > 0)
                {
                    result = string.Join(",", dt.Rows[0].ItemArray);
                }


                ClearCache(data);
            }
            catch (Exception e)
            {
                result = "error: " + e.Message;
            }
            return(result);
        }
示例#3
0
        // insert data
        public static string AddFavWorkspace(string xml)
        {
            var result = string.Empty;
            var dt     = new System.Data.DataTable();
            var data   = new AnalyticsData(xml, AnalyticsType.FavoriteWorkspace, AnalyticsAction.Create);

            try
            {
                var qExec = new QueryExecutor(SPContext.Current.Web);
                dt = qExec.ExecuteEpmLiveQuery(
                    FRFQueryFactory.GetQuery(data),
                    FRFQueryParamFactory.GetParam(data));
                ClearCache(data);
                if (dt.Rows != null && dt.Rows.Count > 0)
                {
                    result = string.Join(",", dt.Rows[0].ItemArray);
                }
                else
                {
                    throw new APIException(21000, "[FavoritesWorkspaceService-AddFavWorkspace] No new fav was added.");
                }
            }
            catch (Exception e)
            {
                throw new APIException(21000, "[FavoritesWorkspaceService-AddFavWorkspace] " + e.Message);
            }

            return(result);
        }
示例#4
0
        public static string IsFav(string xml)
        {
            var result = "false";
            var data   = new AnalyticsData(xml, AnalyticsType.Favorite, AnalyticsAction.Read);

            try
            {
                var qExec = new QueryExecutor(SPContext.Current.Web);
                var table = qExec.ExecuteEpmLiveQuery(
                    FRFQueryFactory.GetQuery(data),
                    FRFQueryParamFactory.GetParam(data));
                if (table != null)
                {
                    result = table.Rows[0][0].ToString();
                }
            }
            catch (Exception e)
            {
                throw new APIException(21000, "[FavoritesService-IsFav] " + e.Message);
            }

            return(result);
        }