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