public string SendEquityData(Equity obj) { PropertyInfo[] properties = obj.GetType().GetProperties(); if (obj == null) return "False"; else { DataTable tempTable = new DataTable(); List<string> columnList = DataAccessLayer.DAL.GetColumnNames("Equity", true); for (int i = 0; i < columnList.Count && columnList[i] != ""; i++) { DataColumn dc = new DataColumn(columnList[i], typeof(string)); tempTable.Columns.Add(dc); } DataRow dr = tempTable.NewRow(); foreach (PropertyInfo p in properties) { dr[p.Name] = p.GetValue(obj, null).ToString(); } tempTable.Rows.Add(dr); return DataAccessLayer.DAL.SendDataToDB(tempTable, "Equity").ToString(); } }
public string SendEquityData(Equity obj) { if (obj == null) return "False"; else { DataTable tempTable = new DataTable(); List<string> columnList = DataAccessLayer.DAL.GetColumnNames("Equity"); for (int i = 0; i < columnList.Count && columnList[i]!=""; i++) { DataColumn dc = new DataColumn(columnList[i], typeof(string)); tempTable.Columns.Add(dc); } tempTable.Rows.Add(new Object[] { obj.securityName, obj.securityDescription, obj.hasPosition, obj.isActive, obj.roundLotSize,obj.bloombergUniqueName,obj.cusip,obj.isin, obj.sedol,obj.bloombergTicker,obj.bloombergUniqueID,obj.bloombergGlobalID, obj.bloombergTickerAndExchange,obj.IsAdr,obj.adrUnderlyingTicker,obj.adrUnderlyingCurrency, obj.sharesPerADR,obj.ipoDate,obj.priceCurrency,obj.settleDays, obj.sharesOutstanding,obj.votingRightsPerShare,obj.TwentyDayAvgVolume,obj.Beta, obj.shortInterest,obj.ytdReturn,obj.priceVolatility,obj.formPFAssetClass, obj.formPFCountry,obj.formPFCreditRating,obj.formPFCurrency,obj.formPFInstrument, obj.formPFLiquidityProfile,obj.formPFMaturity,obj.formPFNAICSCode,obj.formPFRegion, obj.formPFSector,obj.formPFSubAssetClass,obj.issueCountry,obj.exchange, obj.issuer,obj.issueCurrency,obj.tradingCurrency,obj.bloombergIndustrySubGroup, obj.bloombergIndustryGroup,obj.bloombergIndustrySector,obj.countryOfIncorporation,obj.riskCurrency, obj.openPrice,obj.closePrice,obj.volume,obj.lastPrice, obj.askPrice,obj.bidPrice,obj.peRatio,obj.declaredDate, obj.exDate,obj.recordDate,obj.payDate,obj.amount, obj.frequency,obj.dividendType }); Console.WriteLine(tempTable.Columns.Count); DataAccessLayer.DAL.SendDataToDB(tempTable, "Equity"); return "True"; } }