/// <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));
}