public List <TotalAccountTableModel> GetTableData(IEnumerable <long> idMasterAccounts, IEnumerable <long> idTradeAccounts)
{
var list = new List <TotalAccountTableModel>();
var idMasterAccountsArr = idMasterAccounts.ToArray();
var idTradeAccountsArr = idTradeAccounts.ToArray();
var borrowing = new TotalAccountTableModel()
{
RowName = "BORROWING",
LastDay = 0,
MTD = 0,
LastMonth = 0,
AvgDailyMonth = 0,
AvgDailyYear = 0
};
var tradingComissions = new TotalAccountTableModel()
{
RowName = "TRADING COMMISSIONS",
LastDay = NewClientsTableData("LD", idMasterAccountsArr, idTradeAccountsArr, true),
MTD = NewClientsTableData("MTD", idMasterAccountsArr, idTradeAccountsArr, true),
LastMonth = NewClientsTableData("LM", idMasterAccountsArr, idTradeAccountsArr, true),
AvgDailyMonth = NewClientsTableData("MAVG", idMasterAccountsArr, idTradeAccountsArr, true),
AvgDailyYear = NewClientsTableData("12MAVG", idMasterAccountsArr, idTradeAccountsArr, true)
};
var interest = new TotalAccountTableModel()
{
RowName = "INTEREST",
LastDay = NewClientsTableData("LD", idMasterAccountsArr, idTradeAccountsArr, false),
MTD = NewClientsTableData("MTD", idMasterAccountsArr, idTradeAccountsArr, false),
LastMonth = NewClientsTableData("LM", idMasterAccountsArr, idTradeAccountsArr, false),
AvgDailyMonth = NewClientsTableData("MAVG", idMasterAccountsArr, idTradeAccountsArr, false),
AvgDailyYear = NewClientsTableData("12MAVG", idMasterAccountsArr, idTradeAccountsArr, false)
};
var totalIncome = new TotalAccountTableModel()
{
RowName = "TOTAL INCOME",
LastDay = borrowing.LastDay + tradingComissions.LastDay + interest.LastDay,
MTD = borrowing.MTD + tradingComissions.MTD + interest.MTD,
LastMonth = borrowing.LastMonth + tradingComissions.LastMonth + interest.LastMonth,
AvgDailyMonth = borrowing.AvgDailyMonth + tradingComissions.AvgDailyMonth + interest.AvgDailyMonth,
AvgDailyYear = borrowing.AvgDailyYear + tradingComissions.AvgDailyYear + interest.AvgDailyYear
};
list.Add(totalIncome);
list.Add(tradingComissions);
list.Add(interest);
list.Add(borrowing);
return(list);
}
public List <TotalAccountTableModel> GetTableData(string clientId)
{
var list = new List <TotalAccountTableModel>();
var totalTrades = new TotalAccountTableModel()
{
RowName = "TOTAL TRADES",
LastDay = NewClientsTableData("LD", clientId, null, true),
MTD = NewClientsTableData("MTD", clientId, null, true),
LastMonth = NewClientsTableData("LM", clientId, null, true),
AvgDailyMonth = NewClientsTableData("MAVG", clientId, null, true),
AvgDailyYear = NewClientsTableData("12MAVG", clientId, null, true)
};
var avgTradeSize = new TotalAccountTableModel()
{
RowName = "AVG TRADE SIZE",
LastDay = NewClientsTableData("LD", clientId, null, false),
MTD = NewClientsTableData("MTD", clientId, null, false),
LastMonth = NewClientsTableData("LM", clientId, null, false),
AvgDailyMonth = NewClientsTableData("MAVG", clientId, null, false),
AvgDailyYear = NewClientsTableData("12MAVG", clientId, null, false)
};
var volumeQ = new TotalAccountTableModel()
{
RowName = "STOCKS VOLUME(Q)",
LastDay = NewClientsTableData("LD", clientId, "STK", false),
MTD = NewClientsTableData("MTD", clientId, "STK", false),
LastMonth = NewClientsTableData("LM", clientId, "STK", false),
AvgDailyMonth = NewClientsTableData("MAVG", clientId, "STK", false),
AvgDailyYear = NewClientsTableData("12MAVG", clientId, "STK", false)
};
var optionsQ = new TotalAccountTableModel()
{
RowName = "OPTIONS VOLUME(Q)",
LastDay = NewClientsTableData("LD", clientId, "OPT", false),
MTD = NewClientsTableData("MTD", clientId, "OPT", false),
LastMonth = NewClientsTableData("LM", clientId, "OPT", false),
AvgDailyMonth = NewClientsTableData("MAVG", clientId, "OPT", false),
AvgDailyYear = NewClientsTableData("12MAVG", clientId, "OPT", false)
};
var fururesQ = new TotalAccountTableModel()
{
RowName = "FUTURES VOLUME(Q)",
LastDay = NewClientsTableData("LD", clientId, "FUT", false),
MTD = NewClientsTableData("MTD", clientId, "FUT", false),
LastMonth = NewClientsTableData("LM", clientId, "FUT", false),
AvgDailyMonth = NewClientsTableData("MAVG", clientId, "FUT", false),
AvgDailyYear = NewClientsTableData("12MAVG", clientId, "FUT", false)
};
list.Add(totalTrades);
list.Add(avgTradeSize);
list.Add(volumeQ);
list.Add(optionsQ);
list.Add(fururesQ);
return(list);
}
