public static bool ValidateTradeWithUser(int pTradeId) { bool validTrade = false; //getTradeRequest tradeRequest = new getTradeRequest(); //tradeRequest.tradeIdList = tradeId.ToString(); //getTrades request = new getTrades(); //request.tradeRequest = tradeRequest; //getTradesResponse response = trackingMain.getTrades(request); //if ([email protected] == "OK") //{ // if ([email protected] != null && [email protected] > 0) // { // validTrade = true; // } //} VPcTradeSummaryDal pcTradeSummaryDal = new VPcTradeSummaryDal(sqlConnectionString); validTrade = pcTradeSummaryDal.IsValidTradeId(pTradeId); return(validTrade); }
private void PopulateTradingSysList() { try { //Israel 10/26/15 Removed hard-coded trading system codes //string[] semperators = {";"}; //string[] tradeSysCodes = (Properties.Settings.Default.TradeSystems).Split(semperators, StringSplitOptions.None); string extSvcBaseUrl = Properties.Settings.Default.ExtSvcAPIBaseUrl; string extSvcUserName = Properties.Settings.Default.ExtSvcAPIUserName; string extSvcPassword = Properties.Settings.Default.ExtSvcAPIPassword; ConfirmMgrAPIDal confirmMgrAPIDal = new ConfirmMgrAPIDal(extSvcBaseUrl, extSvcUserName, extSvcPassword); List <string> permKeyList = new List <string>(); bool isSuperUser = false; permKeyList = confirmMgrAPIDal.GetPermissionKeys(frmMain.p_UserId, out isSuperUser); //permKeyList.Add("AMPH US"); //permKeyList.Add("MERC US"); //If isSuperUser == True then pass a blank permKeyDBInClauseStr to the DB call. string permKeyDBInClauseStr = ""; //Only get the IN clause if isSuperUser == false. Else, a blank IN clause will retrieve all rows if (!isSuperUser && permKeyList.Count > 0) { permKeyDBInClauseStr = confirmMgrAPIDal.GetPermissionKeyDBInClause(permKeyList); } List <string> tradeSysCodeList = new List <string>(); VPcTradeSummaryDal vpcTradeSummaryDal = new VPcTradeSummaryDal(sqlConnectionStr); tradeSysCodeList = vpcTradeSummaryDal.GetAllTradingSysCodes(permKeyDBInClauseStr); cmboTradingSystem.Properties.Items.Add(""); cmboTradingSystem.Properties.Items.AddRange(tradeSysCodeList); } catch (Exception ex) { } }
public void Test_VPcTradeSummaryDal() { messageSeqNo = 0; VPcTradeSummaryDal vpcTradeSummaryDal = new VPcTradeSummaryDal(sqlConnectionString); List<SummaryData> tradeSummaryList = new List<SummaryData>(); tradeSummaryList = vpcTradeSummaryDal.GetAllStub(); expectedCount = 3; actualCount = tradeSummaryList.Count; Assert.AreEqual(expectedCount, actualCount, "Selected list count."); expectedValue = "COLUMBIA-TCO"; foreach (SummaryData tradeSummaryData in tradeSummaryList) { if (tradeSummaryData.Id == 155037) { actualValue = tradeSummaryData.LocationSn; break; } } Assert.AreEqual(expectedValue, actualValue, getMessage("Stub data: Trade Summary Text found.")); tradeSummaryList = vpcTradeSummaryDal.GetAll("THIS DEFINATLEY WILL FAIL BUT AT LEAST IT WILL COMPILE"); expectedValue = "ELEC"; foreach (SummaryData tradeSummaryData in tradeSummaryList) { if (tradeSummaryData.Id == 2) { actualValue = tradeSummaryData.CdtyCode; break; } } Assert.AreEqual(expectedValue, actualValue, getMessage("Live data: Trade Summary Text found.")); }