public static RealizedPLData Create(DataRow dr) { RealizedPLData data = new RealizedPLData(); CreateHelper(dr, data); data.EquvAmount = dr.EscapeDBNULL<decimal>("TradePLValued"); data.MonthlyChangeRate = data.ExchangeRate; data.OriginAmount = data.EquvAmount / data.ExchangeRate; data.Type = BusinessTypeEnum.RealizedPL; data.ProductName = dr.EscapeDBNULL<string>("ProductName"); return data; }
public static FloatingPLData Create(DataRow dr) { FloatingPLData data = new FloatingPLData(); CreateHelper(dr, data); data.EquvAmount = dr.EscapeDBNULL<decimal>("TradePLFloat"); data.MonthlyChangeRate = data.ExchangeRate; data.OriginAmount = data.EquvAmount / data.ExchangeRate; data.Type = BusinessTypeEnum.FloatingPL; data.ProductName = dr.EscapeDBNULL<string>("ProductName"); data.AskPrice = dr.EscapeDBNULL<string>("Ask"); data.BidPrice = dr.EscapeDBNULL<string>("Bid"); data.TradingAmount = dr.EscapeDBNULL<decimal>("TradingAmount"); InitializeBeforeData(data, dr); return data; }
private static void InitializeBeforeData(FloatingPLData data,DataRow dr) { data.LastFloatingPLData = new FloatingPLData(); var lastPL = data.LastFloatingPLData; lastPL.Type = data.Type; lastPL.FromMt4LoginID = data.FromMt4LoginID; lastPL.ToMt4LoginID = data.ToMt4LoginID; lastPL.CurrencyCode = data.CurrencyCode; if (dr["BfAccountingCurrencyRate"] == DBNull.Value) { throw new ArgumentNullException("BfAccountingCurrencyRate"); } lastPL.ExchangeRate = (decimal)dr.EscapeDBNULL<double>("BfAccountingCurrencyRate"); lastPL.EquvAmount = dr.EscapeDBNULL<decimal>("BfTradePLFloat"); lastPL.MonthlyChangeRate = lastPL.ExchangeRate; lastPL.OriginAmount = lastPL.EquvAmount / lastPL.ExchangeRate; lastPL.TradingAmount = dr.EscapeDBNULL<decimal>("BfTradingAmount"); lastPL.AskPrice = dr.EscapeDBNULL<string>("BfAsk"); lastPL.BidPrice = dr.EscapeDBNULL<string>("BfBid"); lastPL.ProductName = data.ProductName; }
protected static void CreateHelper(DataRow dr, PLData data) { data.FromMt4LoginID = dr.EscapeDBNULL<int>("MT4LoginId").ToString(); if (dr["AccountingMappingCode"] == DBNull.Value) { throw new ArgumentNullException("AccountingMappingCode"); } data.ToMt4LoginID = dr.EscapeDBNULL<int>("AccountingMappingCode").ToString(); data.CurrencyCode = dr.EscapeDBNULL<string>("AccountingCurrencyName"); if (dr["AccountingCurrencyRate"] == DBNull.Value) { throw new ArgumentNullException("AccountingCurrencyRate"); } data.ExchangeRate = (decimal)dr.EscapeDBNULL<double>("AccountingCurrencyRate"); var otherPlData = data as InterestStorageLevyCommisionPLData; if (otherPlData != null) { otherPlData.CustomerCode = dr.EscapeDBNULL<string>("CustomerCode"); otherPlData.CustomerName = dr.EscapeDBNULL<string>("CustomerDesc"); otherPlData.ProductName = dr.EscapeDBNULL<string>("ProductName"); } }
private DepositData Fill(DataRow dr, string baseCurrencyName, BusinessTypeEnum businessType) { DepositData data = new DepositData(); data.Type = dr.EscapeDBNULL<int>("Type"); data.AccountCode = dr.EscapeDBNULL<string>("AccountCode"); data.MT4Code = dr.EscapeDBNULL<int>("MT4LoginId").ToString(); data.TransactionNo = dr.EscapeDBNULL<string>("Code"); data.SourceCustomerCode = dr.EscapeDBNULL<string>("CustomerCode"); data.SourceCustomerName = dr.EscapeDBNULL<string>("CustomerName"); data.SourceCustomerAliasCode = dr.EscapeDBNULL<string>("CustomerAlias"); data.AccountingDesription = dr.EscapeDBNULL<string>("AccountingDesription"); data.SourceAmount = dr.EscapeDBNULL<decimal>("TargetAmount"); data.SourceCurrency = dr.EscapeDBNULL<Guid>("TargetCurrencyID"); data.UpdateTime = dr.EscapeDBNULL<DateTime>("UpdateTime"); data.MarginReference = dr.EscapeDBNULL<long>("MarginReference"); if (dr["iExchangeCurrencyName"] == DBNull.Value) return null; data.SourceCurrencyName = dr.EscapeDBNULL<string>("iExchangeCurrencyName"); if (dr["iExchangeCurrencyRate"] == DBNull.Value) return null; data.SourceCurrencyRate = (decimal)(dr.EscapeDBNULL<double>("iExchangeCurrencyRate")); if (businessType == BusinessTypeEnum.Withdraw || businessType == BusinessTypeEnum.Deposit) { data.BankName = dr.EscapeDBNULL<string>("BankName"); data.AccountName = dr.EscapeDBNULL<string>("AccountName"); data.BankCode = dr.EscapeDBNULL<string>("BankCode"); if (dr["BankCurrencyRate"] == DBNull.Value) return null; if (dr["BankCurrencyName"] == DBNull.Value) return null; if (dr["BankMt4LoginId"] == DBNull.Value) return null; if (dr["BankCurrencyId"] == DBNull.Value) return null; data.TargetMt4 = dr.EscapeDBNULL<int>("BankMt4LoginId").ToString(); data.TargetAmount = dr.EscapeDBNULL<decimal>("AmountRecevided"); data.TargetCurrency = dr.EscapeDBNULL<Guid>("BankCurrencyId"); data.TargetCurrencyRate = (decimal)(dr.EscapeDBNULL<double>("BankCurrencyRate")); data.TargetCurrencyName = dr.EscapeDBNULL<string>("BankCurrencyName"); if (data.SourceCurrency != data.TargetCurrency) { if (dr["DayTradeRate1"] == DBNull.Value || dr["DayTradeRate2"] == DBNull.Value) { return null; } var dtr1 = dr.EscapeDBNULL<double>("DayTradeRate1"); var dtr2 = dr.EscapeDBNULL<double>("DayTradeRate2"); data.DayTradeRate = Math.Max(dtr1, dtr2); } } int? iExchangePlAccount = this._AccountService.GetExchangePlAccount(); if (iExchangePlAccount == null) return null; data.iExchangePlMT4LoginID = iExchangePlAccount.Value.ToString(); data.BaseCurrencyName = baseCurrencyName; return data; }