public string ReturnQuickSort(string userName, string source)
{
var returnQFindSort = new ReturnQuickFindSort(_context);
var resultLastSort = from sort in returnQFindSort.ReturnQuickSort(userName, source, true)
where sort.LastUsedToday == 1
select sort.QuickSort_Query;
// var lastSort = resultLastSort as string[] ?? resultLastSort.ToArray();
if (resultLastSort.Any())
{
var sortReturn = string.Join(" ", resultLastSort);
return(sortReturn);
}
else
{
var result = from sort in returnQFindSort.ReturnQuickSort(userName, source, true)
where sort.LastUsed == true
select sort.QuickSort_Query;
var sortReturn = "";
if (result.Any())
{
sortReturn = string.Join(" ", result);
}
return(sortReturn);
}
}
public string ReturnQueryString(string userName, string source)
{
var returnQFindSort = new ReturnQuickFindSort(_context);
var qiuckFind = returnQFindSort.ReturnQuickFind(userName, source, true);
var quickfindMcs = qiuckFind as QuickfindMC[] ?? qiuckFind.ToArray();
var query = (from find in quickfindMcs
where find.LastUsedToday == 1
select find.QuickfindID);
var quickFindId = -1;
var enumerable = query as int[] ?? query.ToArray();
if (enumerable.Any())
{
quickFindId = enumerable.FirstOrDefault();
}
else
{
quickFindId = (from find in quickfindMcs
where find.LastUsed == true
select find.QuickfindID).FirstOrDefault();
}
return(returnQFindSort.ReturnQuickFindQueryString(userName, source, true, quickFindId));
}
public IEnumerable<QuickSort> GetQuickSortName(string userName, string source, TdmsDbContext context)
{
var newItem = new ReturnQuickFindSort(context);
return newItem.ReturnQuickSort(userName, source, true);
}
