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