private void CheckName(Item xbrlItem, ref Company comp)
{
if (xbrlItem.Name.Contains("EntityRegistrantName"))
{
comp.CompanyName = xbrlItem.Value;
}
}
private void CheckFilerCategory(Item xbrlItem, ref Company comp)
{
if (xbrlItem.Name.Contains("EntityFilerCategory"))
{
comp.Industry = xbrlItem.Value;
}
}
public void UpdateCompany(Company company)
{
if (CompanyExists(company.Symbol))
{
_dao.UpdateCompany(company);
}
else
{
_dao.InsertCompany(company);
}
}
public Company Populate(XbrlDocument xbrlDoc, string symbol)
{
Company comp = new Company();
comp.Symbol = symbol;
foreach (XbrlFragment frag in xbrlDoc.XbrlFragments)
{
foreach (Item xbrlItem in frag.Facts)
{
comp = CheckItem(xbrlItem, comp);
}
}
return comp;
}
private void CreateCompanyObject(string symbol, JeffFerguson.Gepsio.XbrlDocument xbrlDoc, Dictionary<string, Object> yahooStats)
{
XbrlCompanyFilter compFilter = new XbrlCompanyFilter();
Company compToAdd = new Company();
compToAdd = compFilter.Populate(xbrlDoc, symbol);
compToAdd.Industry = Convert.ToString(yahooStats["Industry"]);
compToAdd.Sector = Convert.ToString(yahooStats["Sector"]);
CompanyBL.Instance.UpdateCompany(compToAdd);
}
private static void SetCompanyParameters(Company company, MySqlParameter[] parms)
{
parms[0].Value = company.Symbol;
parms[1].Value = company.CompanyName;
parms[2].Value = company.Industry;
parms[3].Value = company.Sector;
}
private Company ConvertReaderToCompanyObject(MySqlDataReader rdr)
{
Company cmp = new Company();
cmp.Symbol = MySqlHelper.ConvertReaderToString(rdr, "SYMBOL");
cmp.CompanyName = MySqlHelper.ConvertReaderToString(rdr, "COMPANY_NAME");
cmp.Industry = MySqlHelper.ConvertReaderToString(rdr, "INDUSTRY");
cmp.Sector = MySqlHelper.ConvertReaderToString(rdr, "SECTOR");
return cmp;
}
public void UpdateCompany(Company company)
{
MySqlParameter[] parms = GetCompanyParameters();
SetCompanyParameters(company, parms);
using (MySqlConnection conn = new MySqlConnection(MySqlHelper.SV_CONN_STRING))
{
conn.Open();
MySqlHelper.ExecuteNonQuery(conn, SQL_UPDATE_COMPANY, parms);
}
}
private Company CheckItem(Item xbrlItem, Company comp)
{
CheckName(xbrlItem, ref comp);
return comp;
}
private CompanyValuationStatistics GetCompanyValuationStatistics(Company comp)
{
IncomeStatementProjectionBL incProjectionBL = new IncomeStatementProjectionBL();
CompanyValuationStatistics cvs = new CompanyValuationStatistics();
cvs.Symbol = comp.Symbol;
cvs.Year = IncomeStatementBL.Instance.GetLastYear(comp.Symbol);
cvs.NoOfYears = 5;
cvs.CompanyName = comp.CompanyName;
cvs.NoGrowthProjections = incProjectionBL.ProjectIncomeStatementsNoRevenueGrowth(comp.Symbol, cvs.Year, cvs.NoOfYears);
cvs.AvgGrowthProjections = incProjectionBL.ProjectIncomeStatementsAvgRevenueGrowth(comp.Symbol, cvs.Year, cvs.NoOfYears);
cvs.DecayGrowthProjections = incProjectionBL.ProjectIncomeStatementsDecayRevenueGrowth(comp.Symbol, cvs.Year, cvs.NoOfYears, (decimal)-0.05);
DCFMngr().GetDiscountedCashFlows(cvs);
return cvs;
}
private void EnterIntoCompanyTableFromYahooApi(string symbol)
{
YahooApiGateway api = new YahooApiGateway();
Dictionary<string, Object> stats = new Dictionary<string, object>();
api.RetrieveYahooCompanyInfo(symbol, ref stats);
Company comp = new Company(symbol, Convert.ToString(stats["Name"]), Convert.ToString(stats["Industry"]), Convert.ToString(stats["Sector"]));
CompanyBL.Instance.UpdateCompany(comp);
}
