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, "");
}
