public static SubsubsubcategoryDetailsJson Subsubsubcategory(string accountNameKey, SubsubsubcategoryModel subsubsubcategoryIn, bool includeItems, bool includeHidden) { var subsubsubcategoryObjectOut = new SubsubsubcategoryDetailsJson(); subsubsubcategoryObjectOut.subsubsubcategory = new Models.Json.Categorization.SubsubsubcategoryJson(); #region include parent objects subsubsubcategoryObjectOut.category = new CategorizationParentItemJson { name = subsubsubcategoryIn.Category.CategoryName, nameKey = subsubsubcategoryIn.Category.CategoryNameKey, fullyQualifiedName = subsubsubcategoryIn.Category.FullyQualifiedName }; subsubsubcategoryObjectOut.subcategory = new CategorizationParentItemJson { name = subsubsubcategoryIn.Subcategory.SubcategoryName, nameKey = subsubsubcategoryIn.Subcategory.SubcategoryNameKey, fullyQualifiedName = subsubsubcategoryIn.Subcategory.FullyQualifiedName }; subsubsubcategoryObjectOut.subsubcategory = new CategorizationParentItemJson { name = subsubsubcategoryIn.Subsubcategory.SubsubcategoryName, nameKey = subsubsubcategoryIn.Subsubcategory.SubsubcategoryNameKey, fullyQualifiedName = subsubsubcategoryIn.Subsubcategory.FullyQualifiedName }; #endregion #region Build out product list if (includeItems) { var account = Common.GetAccountObject(accountNameKey); //Search products string filter = "(locationPath eq '" + subsubsubcategoryIn.FullyQualifiedName + "')"; var productResults = DataAccess.Search.SearchProducts(account, null, filter, "orderId asc", 0, 1000, false, null, includeHidden); subsubsubcategoryObjectOut.subsubsubcategory.items = Dynamics.Products.TransformDynamicProductsListForJson(productResults.Results); } #endregion //categoryObjectOut.count = categoryObjectOut.categories.Count; //Get images for this category subsubsubcategoryObjectOut.subsubsubcategory.images = Dynamics.Images.BuildDynamicImagesListForJson(accountNameKey, "subsubsubcategory", subsubsubcategoryIn.SubsubsubcategoryID.ToString(), false); //subcategoryObjectOut.subcategory.id = subcategoryIn.SubcategoryID.ToString(); subsubsubcategoryObjectOut.subsubsubcategory.name = subsubsubcategoryIn.SubsubsubcategoryName; subsubsubcategoryObjectOut.subsubsubcategory.nameKey = subsubsubcategoryIn.SubsubsubcategoryNameKey; subsubsubcategoryObjectOut.subsubsubcategory.fullyQualifiedName = subsubsubcategoryIn.FullyQualifiedName; subsubsubcategoryObjectOut.subsubsubcategory.description = subsubsubcategoryIn.Description; return(subsubsubcategoryObjectOut); }
public JsonNetResult Subsubcategory(string categoryNameKey, string subcategoryNameKey, string subsubcategoryNameKey, string subsubsubcategoryNameKey, bool includeHidden = false, bool includeItems = false) { ExecutionType executionType = ExecutionType.local; Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); //Get the subdomain (if exists) for the api call string accountNameKey = Common.GetSubDomain(Request.Url); if (String.IsNullOrEmpty(accountNameKey)) { return(new JsonNetResult { Data = "Not found" }); //return Request.CreateResponse(HttpStatusCode.NotFound); } SubsubsubcategoryModel subsubsubcategory = null; SubsubsubcategoryDetailsJson subsubsubcategoryDetailsObjectJson = null; string localCacheKey = accountNameKey + ":subsubsubcategory:" + categoryNameKey + ":" + subcategoryNameKey + ":" + subsubcategoryNameKey + ":" + subsubsubcategoryNameKey + ":includeHidden:" + includeHidden + "includeProducts:" + includeItems; #region (Plan A) Get json from local cache try { subsubsubcategoryDetailsObjectJson = (SubsubsubcategoryDetailsJson)HttpRuntime.Cache[localCacheKey]; } catch (Exception e) { var error = e.Message; //TODO: Log: error message for local cache call } #endregion if (subsubsubcategoryDetailsObjectJson == null) { #region (Plan B) Get Public json from second layer of Redis Cache IDatabase cache = CoreServices.RedisConnectionMultiplexers.RedisMultiplexer.GetDatabase(); string pathAndQuery = Common.GetApiPathAndQuery(Request.Url); string hashApiKey = accountNameKey + ":apicache"; string hashApiField = pathAndQuery; try { var redisApiValue = cache.HashGet(hashApiKey, hashApiField); if (redisApiValue.HasValue) { subsubsubcategoryDetailsObjectJson = JsonConvert.DeserializeObject <SubsubsubcategoryDetailsJson>(redisApiValue); executionType = ExecutionType.redis_secondary; } } catch { } #endregion if (subsubsubcategoryDetailsObjectJson == null) { #region (Plan C) Get category data from Redis Cache and rebuild try { //IDatabase cache = CoreServices.RedisConnectionMultiplexers.RedisMultiplexer.GetDatabase(); string hashMainKey = accountNameKey + ":categories"; string hashMainField = categoryNameKey + "/" + subcategoryNameKey + "/" + subsubcategoryNameKey + "/" + subsubsubcategoryNameKey + ":public"; if (includeHidden == true) { hashMainField = categoryNameKey + "/" + subcategoryNameKey + "/" + subsubcategoryNameKey + "/" + subsubsubcategoryNameKey + ":private"; } try { var redisValue = cache.HashGet(hashMainKey, hashMainField); if (redisValue.HasValue) { subsubsubcategory = JsonConvert.DeserializeObject <ApplicationCategorizationService.SubsubsubcategoryModel>(redisValue); executionType = ExecutionType.redis_main; } } catch { } } catch (Exception e) { var error = e.Message; //TODO: Log: error message for Redis call } #endregion if (subsubsubcategory == null) { #region (Plan D) Get data from WCF var applicationCategorizationServiceClient = new ApplicationCategorizationService.ApplicationCategorizationServiceClient(); try { applicationCategorizationServiceClient.Open(); subsubsubcategory = applicationCategorizationServiceClient.GetSubsubsubcategoryByNames(accountNameKey, categoryNameKey, subcategoryNameKey, subsubcategoryNameKey, subsubsubcategoryNameKey, Common.SharedClientKey); executionType = ExecutionType.wcf; WCFManager.CloseConnection(applicationCategorizationServiceClient); } catch (Exception e) { #region Manage Exception string exceptionMessage = e.Message.ToString(); var currentMethod = System.Reflection.MethodBase.GetCurrentMethod(); string currentMethodString = currentMethod.DeclaringType.FullName + "." + currentMethod.Name; // Abort the connection & manage the exception WCFManager.CloseConnection(applicationCategorizationServiceClient, exceptionMessage, currentMethodString); #endregion } #endregion } } #region Transform into json object, add images & cache locally or locally and radisAPI layer if (subsubsubcategoryDetailsObjectJson != null) { //Just cache locally (we got json from the api redis layer) HttpRuntime.Cache.Insert(localCacheKey, subsubsubcategoryDetailsObjectJson, null, DateTime.Now.AddMinutes(Common.CategorizationCacheTimeInMinutes), TimeSpan.Zero); } else if (subsubsubcategory != null) { //Transform categories into JSON and cache BOTH locally AND into redis subsubsubcategoryDetailsObjectJson = Transforms.Json.CategorizationTransforms.Subsubsubcategory(accountNameKey, subsubsubcategory, includeItems, includeHidden); HttpRuntime.Cache.Insert(localCacheKey, subsubsubcategoryDetailsObjectJson, null, DateTime.Now.AddMinutes(Common.CategorizationCacheTimeInMinutes), TimeSpan.Zero); try { cache.HashSet(hashApiKey, hashApiField, JsonConvert.SerializeObject(subsubsubcategoryDetailsObjectJson), When.Always, CommandFlags.FireAndForget); } catch { } } #endregion } if (subsubsubcategoryDetailsObjectJson == null) { //return empty return(new JsonNetResult()); } //Add execution data stopWatch.Stop(); subsubsubcategoryDetailsObjectJson.executionType = executionType.ToString(); subsubsubcategoryDetailsObjectJson.executionTime = stopWatch.Elapsed.TotalMilliseconds + "ms"; JsonNetResult jsonNetResult = new JsonNetResult(); jsonNetResult.Formatting = Newtonsoft.Json.Formatting.Indented; jsonNetResult.SerializerSettings.DateTimeZoneHandling = DateTimeZoneHandling.Local; //<-- Convert UTC times to LocalTime jsonNetResult.Data = subsubsubcategoryDetailsObjectJson; return(jsonNetResult); }