public override async Task <ClassResponseGetById> GetById(ClassRequestGetById request, ServerCallContext context) { string cacheKey = "Class.GetById::" + request.Id.ToString(); bool IsCached = true; Class cacheEntry; var response = new ClassResponseGetById(); try { if (!_cache.TryGetValue <Class>(cacheKey, out cacheEntry)) { cacheEntry = await _manager.GetById(request.Id); var cacheEntryOptions = new MemoryCacheEntryOptions().SetSlidingExpiration(TimeSpan.FromSeconds(_cacheTimeInSeconds)); _cache.Set(cacheKey, cacheEntry, cacheEntryOptions); IsCached = false; } response.Class = cacheEntry; response.Success = true; response.Status = RequestCodes.TWO_ZERO_ZERO + ", recived 1 row from " + (IsCached ? Cache.MemoryCache : Cache.Database); response.Error = ""; } catch (Exception e) { response.Success = false; response.Status = RequestCodes.FIVE_ZERO_ZERO; response.Error = e.ToString(); } return(await Task.FromResult <ClassResponseGetById>(response)); }
/// <summary> /// TryGetById, Includes (Cause, Effect) /// </summary> /// <param name="id"></param> /// <param name="onSuccess"></param> /// <param name="onFail"></param> /// <param name="state"></param> /// <returns></returns> public async Task TryGetById(int id, string includeProperties, Action <Class, string> onSuccess, Action <Exception, string> onFail, CascadingAppStateProvider state) { try { string key = ("causality_Class_trygetbyid_" + id).Replace(" ", "").ToLower(); Class data = new(); bool getFromServer = false; string source = ""; if (state.AppState.UseIndexedDB) { var result = await _indexedDBManager.GetRecordByIndex <string, Blob>(new StoreIndexQuery <string> { Storename = _indexedDBManager.Stores[0].Name, IndexName = "key", QueryValue = key }); if (result is not null) { data = JsonConvert.DeserializeObject <Class>(result.Value); source = "indexedDB"; } else if (await _onlineState.IsOnline()) { getFromServer = true; } else { throw new Exception("No connection"); } } else { getFromServer = true; } if (getFromServer) { ClassRequestGetById req = new() { Id = id }; ClassResponseGetById ret = await _classService.GetByIdAsync(req); if (ret.Success) { foreach (var includeProperty in includeProperties.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)) { if (includeProperty.ToLower().Equals("cause")) { CauseRequestGet _req = new() { Filter = "c => c.ClassId = " + ret.Class.Id, OrderBy = "Id", Ascending = true }; CauseResponseGet _ret = await _causeService.GetAsync(_req); ret.Class.Causes.Add(_ret.Causes); } if (includeProperty.ToLower().Equals("effect")) { EffectRequestGet _req = new() { Filter = "e => e.ClassId = " + ret.Class.Id, OrderBy = "Id", Ascending = true }; EffectResponseGet _ret = await _effectService.GetAsync(_req); ret.Class.Effects.Add(_ret.Effects); } } data = ret.Class; source = ret.Status; if (state.AppState.UseIndexedDB) { await _indexedDBManager.AddRecord(new StoreRecord <Blob> { Storename = "Blobs", Data = new Blob() { Key = key, Value = JsonConvert.SerializeObject(data) } }); } } else { throw new Exception("No connection"); } } onSuccess(data, RequestCodes.TWO_ZERO_ZERO + ", recived 1 record from " + source); } catch (Exception e) { onFail(e, RequestCodes.FIVE_ZERO_ZERO); } }