Example #1
0
        public static SiteMapCollection Search(SearchFilter value)
        {
            SiteMapCollection items = new SiteMapCollection();
            string            key   = string.Format(SETTINGS_Search_KEY, value.CompanyID + value.Keyword + value.Page + value.PageSize + value.OrderBy + value.OrderDirection);

            if (SystemConfig.AllowSearchCache)
            {
                object obj2 = HttpCache.Get(key);

                if ((obj2 != null))
                {
                    return((SiteMapCollection)obj2);
                }
            }

            using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
            {
                HttpResponseMessage response = client.PostAsJsonAsync(Resource + "?method=search", value).GetAwaiter().GetResult();

                if (response.IsSuccessStatusCode)
                {
                    items = response.Content.ReadAsAsync <SiteMapCollection>().GetAwaiter().GetResult();
                }
            }

            if (SystemConfig.AllowSearchCache)
            {
                HttpCache.Max(key, items);
            }
            return(items);
        }
Example #2
0
        //change by pham thanh
        public static AccessRights InsertOrUpdateItem(AccessRights model)
        {
            SiteMapCollection      listSiteMap = SiteMapManager.GetAllItem(model.CompanyID);
            AccessRights           itemAccess  = new AccessRights();
            AccessRightsCollection ListAccess  = GetItemByID(model.RoleName, model.CompanyID, model.ApplicationName, null);
            int count = model.ListAccess.Count;

            foreach (var item in listSiteMap)
            {
                if (!string.IsNullOrEmpty(item.Url) && item.Url.Trim() != "/")
                {
                    if (ListAccess.Count != 0)
                    {
                        itemAccess = ListAccess.Where(m => m.NodeID.Equals(item.NodeID)).FirstOrDefault();
                        if (itemAccess == null)
                        {
                            itemAccess = new AccessRights();
                        }
                    }
                    model.Access = 0;
                    model.NodeID = item.NodeID;
                    bool isUpdate = false;
                    if (count > 0)
                    {
                        foreach (var access in model.ListAccess)
                        {
                            if (access.NodeID == item.NodeID)
                            {
                                model.Access = access.Access;
                                isUpdate     = true;
                                break;
                            }
                        }
                    }
                    if (itemAccess.RoleName != null)
                    {
                        if (isUpdate)
                        {
                            SqlHelper.ExecuteReader(CommandType.StoredProcedure, "AccessRights_InsertOrUpdate", CreateSqlParameter(model));
                        }
                    }
                    else
                    {
                        ///chưa tồn tại trong db
                        ///
                        SqlHelper.ExecuteReader(CommandType.StoredProcedure, "AccessRights_InsertOrUpdate", CreateSqlParameter(model));
                    }
                }
            }
            return(model);
        }
Example #3
0
        public static SiteMapCollection GetbyUser(string CreatedUser, int CompanyID)
        {
            SiteMapCollection collection = new SiteMapCollection();
            SiteMap           obj;
            var sqlParams = new SqlParameter[]
            {
                new SqlParameter("@CreatedUser", CreatedUser),
                new SqlParameter("@CompanyID", CompanyID),
            };

            using (var reader = SqlHelper.ExecuteReader("SiteMap_GetAll_byUser", sqlParams))
            {
                while (reader.Read())
                {
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
Example #4
0
        public static SiteMapCollection GetAllItem(int CompanyID)
        {
            SiteMapCollection collection = new SiteMapCollection();

            var sqlParams = new SqlParameter[]
            {
                new SqlParameter("@CompanyID", CompanyID),
            };

            using (var reader = SqlHelper.ExecuteReader("SiteMap_GetAll", sqlParams))
            {
                while (reader.Read())
                {
                    SiteMap obj = new SiteMap();
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
Example #5
0
        public static SiteMapCollection GetAll(int CompanyID)
        {
            SiteMapCollection items = new SiteMapCollection();
            string            key   = String.Format(SETTINGS_ALL_KEY, CompanyID);
            object            obj2  = HttpCache.Get(key);

            if ((obj2 != null))
            {
                return((SiteMapCollection)obj2);
            }
            using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
            {
                HttpResponseMessage response = client.GetAsync(string.Format(Resource + "?CompanyID={0}", CompanyID)).GetAwaiter().GetResult();

                if (response.IsSuccessStatusCode)
                {
                    items = response.Content.ReadAsAsync <SiteMapCollection>().GetAwaiter().GetResult();
                }
            }
            HttpCache.Max(key, items);
            return(items);
        }