/// <inheritdoc /> /// TODO Edit XML Comment Template for GetDataTableList public object GetDataTableList(LocalizedGroupDataItemDataTablesInput o) { string sQuery = $"EXEC [dbo].[sp_GetLocalizedGroupDataItemsDt] @sSearch=@sSearch, @nRowStart=@nRowStart, @nPageSize=@nPageSize, @sSortCol=@sSortCol, @sSortDir=@sSortDir, @sGroupKey=@sGroupKey, @sGroupFilter=@sGroupFilter"; var dt = new DataTablesBase(o, _dbClient); dt.AddExtraParams("sSortCol", o?.columns?.ElementAtOrDefault(o?.order?.FirstOrDefault()?.column ?? 0)?.data); dt.AddExtraParams("sSortDir", o?.order?.FirstOrDefault()?.dir); dt.AddExtraParams("sGroupKey", o.GroupKey); dt.AddExtraParams("sGroupFilter", string.IsNullOrWhiteSpace(o.GroupFilter) ? null : o.GroupFilter); dt.SetDebug(false); return(dt.FetchQuery(_connString, sQuery)); }
/// <inheritdoc /> /// TODO Edit XML Comment Template for GetDataTableList public object GetDataTableList(LocalizedContentTextDataTablesInput o) { string sQuery = $"EXEC [dbo].[sp_GetLocalizedContentTextDt] @sSearch=@sSearch, @nRowStart=@nRowStart, @nPageSize=@nPageSize, @sSortCol=@sSortCol, @sSortDir=@sSortDir, @sGroupKey = @sGroupKey, @sFieldKey = @sFieldKey, @sLanguage = @sLanguage, @sParentKey=@sParentKey"; var dt = new DataTablesBase(o, _dbClient); if (!dt.UseOrderedPaging) { sQuery = $"EXEC [dbo].[sp_GetLocalizedContentTextDt] @sSearch=@sSearch, @nRowStart=0, @nPageSize=1000, @sSortCol=@sSortCol, @sSortDir=@sSortDir, @sGroupKey = @sGroupKey, @sFieldKey = @sFieldKey, @sLanguage = @sLanguage, @sParentKey=@sParentKey"; } dt.AddExtraParams("sSortCol", o?.columns?.ElementAtOrDefault(o?.order?.FirstOrDefault()?.column ?? 0)?.data); dt.AddExtraParams("sSortDir", o?.order?.FirstOrDefault()?.dir); dt.AddExtraParams("sFieldKey", o?.FieldKey); dt.AddExtraParams("sParentKey", o?.ParentKey); dt.AddExtraParams("sGroupKey", o?.GroupKey); dt.AddExtraParams("sLanguage", o?.Language); dt.SetDebug(false); return(dt.FetchQuery(_connString, sQuery)); }