/// <summary>
/// ResultsetFunctionFindByCompany
/// </summary>
/// <param name="dataTable"></param>
/// <returns></returns>
public static IEnumerable <ResultSetReinvestment> FindByCompany(DataTable dataTable)
{
List <ResultSetReinvestment> listOfResultSets = new List <ResultSetReinvestment>();
foreach (DataRow row in dataTable.Rows)
{
ResultSetReinvestment resultSet = new ResultSetReinvestment();
resultSet.Symbol = (string)row["Symbol"];
resultSet.Name = (string)row["Name"];
listOfResultSets.Add(resultSet);
}
return(listOfResultSets);
}
/// <summary>
/// ResultsetFunctionCompounder
/// </summary>
/// <param name="dataTable"></param>
/// <returns></returns>
public static IEnumerable <ResultSetReinvestment> Compounder(DataTable dataTable)
{
List <ResultSetReinvestment> listOfResultSets = new List <ResultSetReinvestment>();
foreach (DataRow row in dataTable.Rows)
{
ResultSetReinvestment resultSet = new ResultSetReinvestment();
resultSet.Symbol = (string)row["Symbol"];
resultSet.Date = (string)row["Date"];
resultSet.Equity = row["Equity"] == DBNull.Value ? null : (double)row["Equity"];
resultSet.Debt = row["Debt"] == DBNull.Value ? null : (double)row["Debt"];
resultSet.NetIncome = row["NetIncome"] == DBNull.Value ? null : (double)row["NetIncome"];
resultSet.Roe = row["Roe"] == DBNull.Value ? null : Math.Round((double)row["Roe"], 0);
resultSet.ReinvestmentRate = row["ReinvestmentRate"] == DBNull.Value ? null : Math.Round((double)row["ReinvestmentRate"], 0);
resultSet.DebtEquityRatio = row["DebtEquityRatio"] == DBNull.Value ? null : Math.Round((double)row["DebtEquityRatio"], 2);
listOfResultSets.Add(resultSet);
}
return(listOfResultSets);
}
