private FTjson PnlRightJsonfromFt(FT ft, string operationtype) { var p = new FTjson(); p.operationType = operationtype; p.symbolId = ft.BOSymbol; p.asset = ft.counterccy; p.amount = ft.ValueCCY.ToString(); p.timestamp = ((DateTime) ft.TradeDate).ToString("yyyy-MM-dd HH:mm:ss"); p.comment = ft.Comment; p.internalComment = ft.symbol; return p; }
private void button5_Click(object sender, EventArgs e) { // const string conStr = "https://backoffice-recon.exante.eu:443/api/v1.5/accounts/"; // "ZAM1452.001/trade"; // var token = GetToken("https://authdb-recon.exante.eu/api/1.0/auth/session", "backoffice"); const string conStr = "https://backoffice.exante.eu:443/api/v1.5/accounts/"; // "ZAM1452.001/trade"; string token = GetToken("https://authdb.exante.eu/api/1.0/auth/session", "backoffice"); DateTime reportdate = ABNDate.Value; var db = new EXANTE_Entities(_currentConnection); DateTime nextdate = reportdate.AddDays(1); var cptradefromDb = (from ft in db.FT where ft.valid == 1 && ft.brocker == "OPEN" && ft.Type == "AF" && ft.ReportDate >= reportdate.Date && ft.ReportDate < (nextdate.Date) && ft.ValueCCY != 0 && ft.Reference == null group ft by new {ft.account_id, ft.symbol, ft.ccy} into g select new { g.Key.account_id, g.Key.symbol, BOSymbol = g.Key.symbol, value = g.Sum(t => t.value), g.Key.ccy, ValueCCY = g.Sum(t => t.ValueCCY) }).ToList(); int tradesqty = 0; foreach (var VARIABLE in cptradefromDb) { var p = new FTjson(); p.operationType = "COMMISSION"; p.comment = "Additional fees from cp: " + VARIABLE.BOSymbol + " for " + reportdate.ToShortDateString(); p.asset = VARIABLE.ccy; p.symbolId = VARIABLE.BOSymbol; // p.asset = VARIABLE.counterccy; p.accountId = VARIABLE.account_id; p.amount = Math.Round((double) VARIABLE.value, 2).ToString(); p.timestamp = reportdate.ToString("yyyy-MM-dd HH:mm:ss"); string requestFTload = JsonConvert.SerializeObject(p); if (!SendJson(requestFTload, conStr + VARIABLE.account_id + "/transaction", token)) // if (!SendJson(requestFTload, conStr + "TST1149.TST" + "/transaction", token)) // if (!SendJson(requestFTload, conStr + "ZAM1452.001" + "/transaction", token)) { LogTextBox.AppendText("\r\n Error in sending Left side VM to BO for : " + VARIABLE.account_id + " " + VARIABLE.symbol); } } if (tradesqty > 0) { db.SaveChanges(); db.Dispose(); LogTextBox.AppendText("\r\n Uploaded trades for " + reportdate.ToShortDateString() + ": " + tradesqty.ToString() + "/" + cptradefromDb.Count); } }
private FTjson FeeJsonfromCpTrade(CpTrade cptrade) { var p = new FTjson(); p.operationType = "COMMISSION"; p.symbolId = cptrade.BOSymbol; p.asset = cptrade.ExchFeeCcy; p.accountId = cptrade.account; double amount = 0; if (cptrade.ExchangeFees != null) { amount = -Math.Abs((double) cptrade.ExchangeFees); } if (cptrade.Fee != null) { amount = amount - Math.Abs((double) cptrade.Fee); } p.amount = amount.ToString(); p.timestamp = ((DateTime) cptrade.TradeDate).ToString("yyyy-MM-dd HH:mm:ss"); p.comment = cptrade.exchangeOrderId; p.internalComment = cptrade.Symbol; return p; }
private void button29_Click(object sender, EventArgs e) { const string conStr = "https://backoffice.exante.eu:443/api/v1.5/accounts/"; // "ZAM1452.001/trade"; string token = GetToken("https://authdb.exante.eu/api/1.0/auth/session", "backoffice"); DateTime reportdate = ABNDate.Value; var db = new EXANTE_Entities(_currentConnection); DateTime nextdate = reportdate.AddDays(1); var cptradefromDb = (from ft in db.FT where ft.valid == 1 && ft.cp == "Manual" && ft.ReportDate >= reportdate.Date && ft.ReportDate < (nextdate.Date) && ft.Posted == null select new { ft.account_id, ft.symbol, BOSymbol = ft.symbol, ft.value, type = ft.Type, ft.ccy, ft.counterccy, ft.ValueCCY, ft.Comment, tradeDate = ft.TradeDate, id = ft.fullid }).ToList(); int tradesqty = 0; foreach (var VARIABLE in cptradefromDb) { var p = new FTjson(); p.operationType = VARIABLE.type; p.comment = VARIABLE.Comment; p.asset = VARIABLE.ccy; p.symbolId = VARIABLE.BOSymbol; p.accountId = VARIABLE.account_id; p.amount = Math.Round((double) VARIABLE.value, 2).ToString(); p.timestamp = VARIABLE.tradeDate.Value.ToString("yyyy-MM-dd HH:mm:ss"); string requestFTload = JsonConvert.SerializeObject(p); if (!SendJson(requestFTload, conStr + VARIABLE.account_id + "/transaction", token)) { LogTextBox.AppendText("\r\n Error in sending FT for : " + VARIABLE.id); } else { db.Database.ExecuteSqlCommand("update FT SET Posted= NOW() where fullid=" + VARIABLE.id); } } if (tradesqty > 0) { db.SaveChanges(); db.Dispose(); LogTextBox.AppendText("\r\n Uploaded FT for " + reportdate.ToShortDateString() + ": " + tradesqty.ToString() + "/" + cptradefromDb.Count); } }