public JObject GetOAuthClient() { try { int pagesize = 100; int currentpage = 1; var responedata = _rDBService.Get <OAuthClientModelDbo>(OAUTH_CLIENT_TABLE, 100, 0, new JObject() { ["oauth_client"] = true }); List <OAuthClientModelDto> clientDto = new List <OAuthClientModelDto>(); foreach (var item in responedata.ToList()) { clientDto.Add(GetDto(item, GetOAuthClientRoles(item), GetOAuthClientIPs(item))); } return(_responseBuilder.SuccessPaggedData(clientDto.ToJArray(), currentpage, pagesize)); } catch (Exception ex) { _logger.Error(ex.Message, ex); return(_responseBuilder.ServerError()); } }
private List <T> GetDBValueAddToCache <T>(string tablename, List <T> input = null, JObject filter = null) where T : class { lock (lockobject) { if (input == null) { input = new List <T>(); } if (filter == null) { filter = new JObject(); } var r = _rdBService.Get <T>(tablename, DefaultGetpageLength, 0, filter); if (r != null && r.Any()) { input.AddRange(r.ToList()); } if (input.Any()) { _inMemoryCacheService.Put <List <T> >($"{cacheprefix}-{tablename}-{filter.ToString()}", input); } return(input); } }
public void GetDataWithSQL() { var events = _rDBService.Get <Event>("Select * from event"); }
public void GetData() { var d = _rDBService.Get <TenantRequestModel>("tenant", 10, 0, ""); }