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