public ReturnDataToKendo ReturnTradeViewData(KendoGridItems item, 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", SetFillter(item, queryStringParameter)); var returnData = new ReturnDataToKendo(context); // Return query parameter together with Kendo Grid default parameters // Sorting and Filtering to be added return(returnData.ReturnKendoData <TradeListModel>(item, userName, source, parameters, storedProcedureName)); }
public ReturnDataToKendo ReturnFailedTradeGrid(string idList, string userName) { var parameters = new[] { new SqlParameter("@tdtradeList", idList), new SqlParameter("@user_name", userName) }; var returnData = new ReturnDataToKendo(_context); return(returnData.ReturnKendoData <usp_ReturnFailedTrade_Result>(userName, "FailEdit", parameters, "usp_ReturnFailedTrades")); }