private static void RemoveFindSortState(string userName, TdmsDbContext context)
{
var removeStateFindSort = new ReturnQuickFindSort(context);
removeStateFindSort.RemoveLastUsedTodaySortingForUsername(userName);
removeStateFindSort.RemoveLastUsedTodayFindUserName(userName);
}
public ReturnDataToKendo ReturnTradeViewDataAll(string userName, TdmsDbContext context)
{
const string source = "TradeBrowser";
const string storedProcedureName = "usp_returnTradeList_Query";
var returnQuickFind = new ReturnQuickFindSort(context);
// Create required Parameter for a query
var parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("user_name", userName);
var tempSortQ = returnQuickFind.ReturnQuickSort(userName, source);
if (!string.IsNullOrWhiteSpace(tempSortQ.Trim()))
{
tempSortQ = string.Format(" Order By {0}", tempSortQ.Trim());
}
var queryStringParameter = string.Format(" {0} {1}", returnQuickFind.ReturnQueryString(userName, source),
tempSortQ);
parameters[1] = new SqlParameter("QueryString", queryStringParameter);
var returnData = new ReturnDataToKendo(context);
// Return query parameter together with Kendo Grid default parameters
// Sorting and Filtering to be added
return(returnData.ReturnKendoDataAll <TradeListModel>(userName, source, parameters, storedProcedureName));
}
public IActionResult TradeSortUpdate(int quickSortId)
{
//Update QuickSort
var sortUpdate = new ReturnQuickFindSort(_context);
sortUpdate.UpdateSorting(User.Identity.Name, "TradeBrowser", quickSortId);
return(Json(new { success = true }));
}
public IActionResult TradeFindUpdate(int quickFindtId)
{
//Update QuickSort table LastUsedToday column
var findUpdate = new ReturnQuickFindSort(_context);
findUpdate.UpdateFind(User.Identity.Name, "TradeBrowser", quickFindtId);
return(Json(new { success = true }));
}
public JsonResult TradeFind()
{
var newTradeViewFind = new ReturnQuickFindSort(_context);
return(Json(newTradeViewFind.ReturnQuickFind(User.Identity.Name, "TradeBrowser", true)));
}
public JsonResult ReturnSortName(string userName, string source)
{
var quickSortName = new ReturnQuickFindSort(_context);
return(Json(quickSortName.ReturnQuickSort(userName, source)));
}
