public async Task <IActionResult> Create()
{
AppIdentityUser _user = await _userManager.FindByNameAsync(User.Identity.Name);
ViewData["UserName"] = _user.UserName;
ViewData["Branch"] = _user.Branch;
var belongToId = _context.FncBranch.SingleOrDefault(x => x.BranchName == _user.Branch).BranchId;
var list_paymentType = _context.FncPaymentType.ToList();
ViewData["PaymentType"] = new SelectList(list_paymentType, "PaymentType", "PaymentType");
ViewData["StewardAccountsId"] = belongToId.ToString() + ConvertJson.DateTimeToStamp(DateTime.Now).ToString();
return(PartialView("~/Areas/Branch/Views/BrhStewardAccount/Create.cshtml"));
}
public async Task <JsonResult> Create([FromBody] Event2 event2)
{
AppIdentityUser _user = await _userManager.FindByNameAsync(User.Identity.Name);
var ScalpId = Convert.ToInt64(_user.BranchId.ToString() + ConvertJson.DateTimeToStamp(DateTime.Now).ToString());
event2.EnteringDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("China Standard Time"));
event2.ScalpId = ScalpId;
event2.id = ScalpId.ToString();
event2.resourceId = event2.HouseNumber;
event2.start = event2.StartDate.ToShortDateString();
event2.end = event2.EndDate.ToShortDateString();
var brhScalp = new BrhScalp();
var ParentType = typeof(BrhScalp);
var Properties = ParentType.GetProperties();
foreach (var Propertie in Properties)
{
//循环遍历属性
if (Propertie.CanRead && Propertie.CanWrite)
{
//进行属性拷贝
Propertie.SetValue(brhScalp, Propertie.GetValue(event2, null), null);
}
}
_context.Add(brhScalp);
await _context.SaveChangesAsync();
var total = _context.BrhScalp.Where(x => x.ImprestAccountsId == brhScalp.ImprestAccountsId && !x.IsMove).Sum(x => x.TotalPrice);
var brhImprestAccount = _context.BrhImprestAccounts.SingleOrDefault(x => x.ImprestAccountsId == brhScalp.ImprestAccountsId);
brhImprestAccount.Equity = brhImprestAccount.Balance - total;
_context.Update(brhImprestAccount);
await _context.SaveChangesAsync();
return(Json(event2));
}
public JsonResult GetMonthBase([FromBody] Params param)
{
//Get History,Account
var account = _context.FrxAccount.SingleOrDefault(x => x.AccountId == param.AccountId);
var positions = Position.GetPositions(param.ApiUrl, param.AccountId.ToString(), param.AccessToken);
var histories = _context.FrxHistory.Where(x => x.AccountId == param.AccountId).OrderByDescending(x => x.ClosingTimestamp).ToList();
var cashflow = _context.FrxCashflow.Where(x => x.AccountId == param.AccountId);
#region Get MonthBaseData
//Get XData
var lastHistory = histories[0];
var lastHisTimestamp = lastHistory.ClosingTimestamp;
var lastHisTime = ConvertJson.StampToDateTime(lastHistory.ClosingTimestamp);
var lastHisTimeYear = lastHisTime.Year;
var lastHisTimeMonth = lastHisTime.Month;
List <XData> xDatas = new List <XData>();
var xTime = new DateTime(lastHisTimeYear, lastHisTimeMonth, 1);
//Add Months
for (int i = 0; i < 12; i++)
{
var xt = xTime.AddMonths(i - 11);
var xn = xt.Month.ToString() + "月份";
XData xData = new XData(xn, xt);
xDatas.Add(xData);
}
//Add Year,Total
var yearBeginTime = new DateTime(lastHisTimeYear, 1, 1);
var totalBeginTime = ConvertJson.StampToDateTime(account.TraderRegistrationTimestamp);
var yearXData = new XData("全年", yearBeginTime);
var totalXData = new XData("总计", totalBeginTime);
xDatas.Add(yearXData);
xDatas.Add(totalXData);
//Get MonthBaseData
List <MonthBaseData> monthBaseData = new List <MonthBaseData>();
for (int i = 0; i < 14; i++)
{
MonthBaseData mdata = new MonthBaseData();
var tempHis = new List <FrxHistory>();
long endTimestamp;
mdata.XData = xDatas[i];
if (i < 12)
{
endTimestamp = ConvertJson.DateTimeToStamp(mdata.XData.XTime.AddMonths(1));
}
else
{
endTimestamp = lastHisTimestamp + 86400000;
}
tempHis = histories.Where(x => x.ClosingTimestamp > ConvertJson.DateTimeToStamp(mdata.XData.XTime) && x.ClosingTimestamp < endTimestamp).OrderBy(y => y.ClosingTimestamp).ToList();
if (tempHis.Count() != 0)
{
var list_bsData = tempHis.GroupBy(g => new
{
g.SymbolCode
}).Select(s => new BuySellData
{
SymbolCode = s.Key.SymbolCode,
Count = s.Count(),
Lots = s.Sum(a => a.Lot),
Pips = s.Sum(a => a.Pips * a.Lot) / s.Sum(a => a.Lot),
Profit = s.Sum(a => a.NetProfit),
BuyCount = s.Where(a => a.TradeType == TradeType.Buy).Count(),
BuyLots = s.Where(a => a.TradeType == TradeType.Buy).Sum(a => a.Lot),
BuyPips = s.Where(a => a.TradeType == TradeType.Buy).Sum(a => a.Pips * a.Lot) / s.Where(a => a.TradeType == TradeType.Buy).Sum(a => a.Lot),
BuyProfit = s.Where(a => a.TradeType == TradeType.Buy).Sum(a => a.NetProfit),
BuyRate = s.Where(t => t.TradeType == TradeType.Buy).Count() == 0 ? 0
: (s.Where(t => t.TradeType == TradeType.Sell).Count() == 0 ? 1
: Math.Round(s.Where(t => t.TradeType == TradeType.Buy).Sum(a => a.Lot) / s.Sum(b => b.Lot), 4)),
SellCount = s.Where(a => a.TradeType == TradeType.Sell).Count(),
SellLots = s.Where(a => a.TradeType == TradeType.Sell).Sum(a => a.Lot),
SellPips = s.Where(a => a.TradeType == TradeType.Sell).Sum(a => a.Pips * a.Lot) / s.Where(a => a.TradeType == TradeType.Sell).Sum(a => a.Lot),
SellProfit = s.Where(a => a.TradeType == TradeType.Sell).Sum(a => a.NetProfit),
SellRate = s.Where(t => t.TradeType == TradeType.Buy).Count() == 0 ? 1
: (s.Where(t => t.TradeType == TradeType.Sell).Count() == 0 ? 0
: (1 - Math.Round(s.Where(t => t.TradeType == TradeType.Buy).Sum(a => a.Lot) / s.Sum(b => b.Lot), 4))),
WinCount = s.Where(a => a.NetProfit > 0).Count(),
WinRate = s.Where(a => a.NetProfit > 0).Count() == 0 ? 0
: (s.Where(a => a.NetProfit <= 0).Count() == 0 ? 1
: Math.Round((double)s.Where(a => a.NetProfit > 0).Count() / (double)s.Count(), 4)),
LossCount = s.Where(a => a.NetProfit <= 0).Count(),
LossRate = s.Where(a => a.NetProfit > 0).Count() == 0 ? 1
: (s.Where(a => a.NetProfit <= 0).Count() == 0 ? 0
: (1 - Math.Round((double)s.Where(a => a.NetProfit > 0).Count() / (double)s.Count(), 4))),
}).ToList();
var initBalance = tempHis.ToList()[0].Balance - tempHis.ToList()[0].NetProfit;
var net = tempHis.Select(x => x.NetProfit).Sum();
var gain = net / initBalance;
var swap = tempHis.Select(x => x.Swap).Sum();
var pips = tempHis.Select(x => x.Pips).Sum();
var lots = tempHis.Select(x => x.Lot).Sum();
mdata.BuySellData = list_bsData;
mdata.Net = Math.Round(net, 2);
mdata.Gain = Math.Round(gain, 4);
mdata.Swap = Math.Round(swap, 2);
mdata.Pips = Math.Round(pips, 2);
mdata.Lots = Math.Round(lots, 2);
monthBaseData.Add(mdata);
}
else
{
mdata.BuySellData = new List <BuySellData>();
mdata.Net = 0;
mdata.Gain = 0;
mdata.Swap = 0;
mdata.Pips = 0;
mdata.Lots = 0;
monthBaseData.Add(mdata);
}
}
#endregion
#region GetAccountInfo
var deposit = 0.00;
var withdraw = 0.00;
foreach (var c in cashflow)
{
if (c.Type == "DEPOSIT")
{
deposit += c.Delta;
}
if (c.Type == "WITHDRAW")
{
withdraw += c.Delta;
}
}
var unrnet = 0.00;
if (positions.Count != 0)
{
unrnet = (double)positions.Sum(x => x.Commission * 2 + x.Swap + x.Profit) / 100;
}
var maxbalance = histories.Select(x => x.Balance).Max();
long maxtimestamp = histories.FirstOrDefault(x => x.Balance == maxbalance).ClosingTimestamp;
var maxdrawdown = histories.Select(x => Math.Round((x.Balance - x.Equity) / x.Balance, 4)).Max();
long maxdrawtimestamp = histories.FirstOrDefault(x => Math.Round((x.Balance - x.Equity) / x.Balance, 4) == maxdrawdown).ClosingTimestamp;
var totalswap = histories.Select(x => x.Swap).Sum();
var twr = 1.00;
foreach (var m in monthBaseData)
{
if (m.XData.XName != "全年" && m.XData.XName != "总计")
{
twr = (1 + m.Gain) * twr;
}
}
long lasttradetimestamp;
if (histories.Count() > 0)
{
lasttradetimestamp = lastHisTimestamp;
}
else
{
lasttradetimestamp = account.TraderRegistrationTimestamp;
}
var accountinfo = new AccountInfo
{
Gain = Math.Round(twr - 1, 4) * 100,
AbsGain = Math.Round((account.Balance - deposit + withdraw) / deposit, 4) * 100,
MaxDraw = maxdrawdown * 100,
MaxDrawTimestamp = maxdrawtimestamp,
Deposit = deposit,
Withdraw = withdraw,
Balance = account.Balance,
Equity = account.Balance + (double)unrnet,
MaxBalance = maxbalance,
MaxBalanceTimestamp = maxtimestamp,
TotalProfit = account.Balance - deposit + withdraw,
TotalSwap = Math.Round(totalswap, 2),
LastTradeTimestamp = lasttradetimestamp,
RigistrationTimestamp = account.TraderRegistrationTimestamp
};
#endregion
return(Json(new { monthBaseData, accountinfo }));
}
public async Task <IActionResult> Index(int?acId)
{
ConnectAPI connect = ConnectAPI.GetConnectAPI(_identitycontext, _context, User.Identity.Name, acId);
if (connect.AccountId == 0)
{
return(Redirect("/"));
}
var useraccounts = _identitycontext.AspNetUserForexAccount.Where(u => u.AppIdentityUserId == connect.UserId).ToList();
var accounts = _context.FrxAccount.Where(x => useraccounts.SingleOrDefault(s => s.AccountNumber == x.AccountNumber && s.Password == x.Password) != null).ToList();
var symbols = _context.FrxSymbol.ToList();
#region GetCashflow
var cashflow = CashflowHistory.GetCashflowHistory(connect.ApiUrl, connect.AccountId.ToString(), connect.AccessToken);
foreach (var c in cashflow)
{
var fc = new FrxCashflow();
fc.Id = Convert.ToInt32(c.CashflowId);
fc.AccountId = connect.AccountId;
fc.Balance = c.Balance;
fc.BalanceVersion = c.BalanceVersion;
fc.ChangeTimestamp = c.ChangeTimestamp;
fc.Type = c.Type;
fc.Delta = c.Delta / 100;
fc.Equity = c.Equity;
var tempfc = _context.FrxCashflow.SingleOrDefault(x => x.Id == fc.Id);
if (tempfc == null)
{
_context.FrxCashflow.Add(fc);
await _context.SaveChangesAsync();
}
}
#endregion
#region GetHistory
long fromTimestamp;
if (_context.FrxHistory.Count() != 0)
{
fromTimestamp = _context.FrxHistory.Select(x => x.ClosingTimestamp).Max() - 86400000;
}
else
{
fromTimestamp = connect.TraderRegistrationTimestamp - 86400000;
}
DateTime utcNow = DateTime.UtcNow;
long toTimestamp = ConvertJson.DateTimeToStamp(utcNow.AddDays(1));
var deal = Deal.GetDeals(connect.ApiUrl, connect.AccountId.ToString(), connect.AccessToken, fromTimestamp.ToString(), toTimestamp.ToString());
var deal_history = new List <Deal>();
foreach (var d in deal)
{
if (d.PositionCloseDetails != null)
{
deal_history.Add(d);
}
}
foreach (var h in deal_history)
{
FrxHistory fh = new FrxHistory();
fh.ClosingDealId = h.DealId;
fh.AccountId = connect.AccountId;
fh.Balance = h.PositionCloseDetails.Balance / 100;
fh.BalanceVersion = h.PositionCloseDetails.BalanceVersion;
fh.BaseToUSDConversionRate = h.BaseToUSDConversionRate;
fh.ClosedToDepoitConversionRate = h.PositionCloseDetails.ClosedToDepositConversionRate;
fh.ClosingTimestamp = h.ExecutionTimestamp;
fh.ClosingPrice = h.ExecutionPrice;
fh.Comment = h.Comment;
fh.Commissions = h.PositionCloseDetails.Commission / 100;
fh.EntryPrice = h.PositionCloseDetails.EntryPrice;
long tempTimestamp = h.ExecutionTimestamp;
foreach (var d in deal)
{
if (d.PositionId == h.PositionId)
{
if (d.ExecutionTimestamp < tempTimestamp)
{
tempTimestamp = d.ExecutionTimestamp;
}
}
}
fh.EntryTimestamp = tempTimestamp;
fh.Equity = h.PositionCloseDetails.Equity / 100;
fh.EquityBaseRoi = h.PositionCloseDetails.EquityBasedRoi / 100;
fh.GrossProfit = h.PositionCloseDetails.Profit / 100;
fh.Label = h.Label;
fh.MarginRate = h.MarginRate;
fh.Swap = h.PositionCloseDetails.Swap / 100;
fh.NetProfit = fh.GrossProfit + fh.Swap + fh.Commissions;
fh.Pips = h.PositionCloseDetails.ProfitInPips;
fh.PositionId = h.PositionId;
fh.SymbolCode = h.SymbolName;
fh.Volume = h.PositionCloseDetails.ClosedVolume / 100;
var symbol = symbols.SingleOrDefault(x => x.SymbolName == h.SymbolName);
var minVolume = symbol.MinOrderVolume;
var minLot = symbol.MinOrderLot;
var pipPosition = symbol.PipPosition;
fh.Lot = fh.Volume / minVolume * minLot;
fh.QuoteToDepositConversionRate = h.PositionCloseDetails.QuoteToDepositConversionRate;
fh.Roi = h.PositionCloseDetails.Roi;
fh.TradeType = h.TradeSide == "BUY" ? TradeType.Sell : TradeType.Buy;
fh.PipPosition = pipPosition;
var result = _context.FrxHistory.SingleOrDefault(x => x.ClosingDealId == fh.ClosingDealId);
if (result == null)
{
_context.Add(fh);
await _context.SaveChangesAsync();
}
}
var histories = _context.FrxHistory.Where(x => x.AccountId == connect.AccountId).ToList();
#endregion
return(View(Tuple.Create <ConnectAPI, List <FrxAccount> >(connect, accounts)));
}
public async Task <JsonResult> Create([FromBody] BranchModel branchModel)
{
AppIdentityUser _user = await _userManager.FindByNameAsync(User.Identity.Name);
List <Event> eves = new List <Event>();
if (branchModel.StartDate.Month == branchModel.EndDate.AddDays(-1).Month)
{
var frontId = Convert.ToInt64(_user.BranchId.ToString() + ConvertJson.DateTimeToStamp(DateTime.Now).ToString());
branchModel.EnteringDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("China Standard Time"));
branchModel.FrontDeskAccountsId = frontId;
if (branchModel.PayAmount != 0)
{
branchModel.Received = branchModel.PayAmount;
}
else
{
branchModel.Received = 0;
}
if (branchModel.Receivable == branchModel.Received)
{
branchModel.IsFinish = true;
}
eves.Add(AddFront(branchModel));
if (branchModel.SelectVal.Count > 0)
{
foreach (var sel in branchModel.SelectVal)
{
branchModel.FrontDeskAccountsId += 1;
branchModel.HouseNumber = sel;
eves.Add(AddFront(branchModel));
}
}
return(Json(eves));
}
else
{
var count1 = (branchModel.EndDate.AddDays(1 - branchModel.EndDate.Day) - branchModel.StartDate).Days;
var count2 = (branchModel.EndDate - branchModel.EndDate.AddDays(1 - branchModel.EndDate.Day)).Days;
var total = (branchModel.EndDate - branchModel.StartDate).Days;
var frontId1 = Convert.ToInt64(_user.BranchId.ToString() + ConvertJson.DateTimeToStamp(DateTime.Now).ToString());
BrhFrontDeskAccounts brhFrontDeskAccounts1 = new BrhFrontDeskAccounts();
BrhFrontDeskAccounts brhFrontDeskAccounts2 = new BrhFrontDeskAccounts();
decimal payAmount1 = 0;
decimal payAmount2 = 0;
if (branchModel.PayAmount != 0)
{
payAmount1 = branchModel.PayAmount / total * count1;
payAmount2 = branchModel.PayAmount / total * count2;
}
else
{
payAmount1 = 0;
payAmount2 = 0;
}
branchModel.EnteringDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("China Standard Time"));
var totalPrice = branchModel.TotalPrice;
var receivable = branchModel.Receivable;
var received = branchModel.Received;
var startDate = branchModel.StartDate;
var endDate = branchModel.EndDate;
branchModel.FrontDeskAccountsId = frontId1;
branchModel.TotalPrice = totalPrice / total * count1;
branchModel.Receivable = receivable / total * count1;
branchModel.Received = payAmount1;
if (branchModel.Receivable == branchModel.Received)
{
branchModel.IsFinish = true;
}
else
{
branchModel.IsFinish = false;
}
branchModel.Count = count1;
branchModel.StartDate = startDate;
branchModel.EndDate = endDate.AddDays(1 - endDate.Day);
branchModel.PayAmount = payAmount1;
eves.Add(AddFront(branchModel));
var tempNumber = branchModel.HouseNumber;
if (branchModel.SelectVal.Count > 0)
{
branchModel.FrontDeskAccountsId += 10000;
foreach (var sel in branchModel.SelectVal)
{
branchModel.FrontDeskAccountsId += 1;
branchModel.HouseNumber = sel;
eves.Add(AddFront(branchModel));
}
}
branchModel.FrontDeskAccountsId = frontId1 + 1;
branchModel.HouseNumber = tempNumber;
branchModel.TotalPrice = totalPrice / total * count2;
branchModel.Receivable = receivable / total * count2;
branchModel.Received = payAmount2;
if (branchModel.Receivable == branchModel.Received)
{
branchModel.IsFinish = true;
}
else
{
branchModel.IsFinish = false;
}
branchModel.Count = count2;
branchModel.StartDate = endDate.AddDays(1 - endDate.Day);
branchModel.EndDate = endDate;
branchModel.PayAmount = payAmount2;
eves.Add(AddFront(branchModel));
if (branchModel.SelectVal.Count > 0)
{
foreach (var sel in branchModel.SelectVal)
{
branchModel.FrontDeskAccountsId += 1;
branchModel.HouseNumber = sel;
eves.Add(AddFront(branchModel));
}
}
return(Json(eves));
}
}