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 ReturnDataToKendo TdmsManualMatchData <T>(string tdTrade, bool chkPortNo, bool chkTraded, bool chkSecId, bool chkBs, bool chkBrokerFin, string confirmRefNo, string userName, string source, string storeProcedure) { var paramSourceName = new[] { new SqlParameter("tdTrade", tdTrade), new SqlParameter("PortNo", ReturnInt(chkPortNo)), new SqlParameter("Traded", ReturnInt(chkTraded)), new SqlParameter("CUSIP", ReturnInt(chkSecId)), new SqlParameter("BS", ReturnInt(chkBs)), new SqlParameter("BrokerFIN", ReturnInt(chkBrokerFin)), new SqlParameter("ConfirmRefNo", confirmRefNo) }; var returnData = new ReturnDataToKendo(_context); return(returnData.ReturnKendoDataAll <ManualMatchTrade>(userName, source, paramSourceName, storeProcedure)); }
public ReturnDataToKendo TdmsManualMatchData <T>(string userName, string idList, string source, string storeProcedureName) { var parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("user_name", userName); if (!string.IsNullOrWhiteSpace(idList)) { parameters[1] = new SqlParameter("Querystring", "tdTrade IN (" + idList + ")"); } else { return(null); } var returnData = new ReturnDataToKendo(_context); return(returnData.ReturnKendoDataAll <ManualMatchTrade>(userName, source, parameters, storeProcedureName)); }