public void UpdateDatabaseWithCompanyDetailsTest()
{
ClearTable();
string[] columnNames = { "NASDAQ Symbol", "Security Name" };
var fileName = @"symboldirectory/otherlisted.txt";
LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName);
columnNames = new string[] { "Symbol", "Sector", "industry", "IPOyear" };
var temppath = Path.GetTempPath();
fileName = @"symboldirectory/NYSECompanyList.csv";
var delimiter = ",";
fileName = temppath + fileName;
lftdb.FileName = fileName;
lftdb.Columns = columnNames;
lftdb.Delimiter = delimiter;
var loadResult = lftdb.ParseCompanyDetailsFile();
var resultCount = lftdb.SaveRecordsToDb(_repository);
Assert.IsTrue(loadResult);
var testRcd = _context.CompanyDetails.FirstOrDefault(s => s.Symbol.Equals("ICE"));
Assert.AreEqual(2005, testRcd.IPOyear);
Assert.AreEqual("Finance", testRcd.Sector);
}
public void ParseFileTest()
{
var fileName = @"symboldirectory/nasdaqlisted.txt";
var temppath = Path.GetTempPath();
fileName = temppath + fileName;
string[] columnNames = { "Symbol", "Security Name" };
var lftdb = new LoadFileToDb(fileName, columnNames);
var loadResult = lftdb.ParseSecurityListingFile();
Assert.IsTrue(loadResult);
}
public void SaveRecordsToDbEmptyTableTest()
{
ClearTable();
string[] columnNames = { "Symbol", "Security Name" };
var fileName = @"symboldirectory/nasdaqlisted.txt";
LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName);
var resultCount = lftdb.SaveRecordsToDb(_repository);
Assert.AreEqual(resultCount, lftdb.CompanyDetails.Count);
Console.WriteLine(_context.CompanyDetails.Count(r => r.IsExTrdFund == true));
}
public LoadExternalFilesToDb(StockReporterContext context, IGenericRepository <CompanyDetail, string> repository)
{
_context = context;
_repository = repository;
delimiter = "|";
isETF = false;
isMutualFund = false;
string[] columnNames = { };
var fileName = "";
loadFileToDb = new LoadFileToDb(fileName, columnNames);
}
public void SaveOtherListedToDbEmptyTableTest()
{
ClearTable();
string[] columnNames = { "NASDAQ Symbol", "Security Name" };
var fileName = @"symboldirectory/otherlisted.txt";
LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName);
var resultCount = lftdb.SaveRecordsToDb(_repository);
Assert.AreEqual(resultCount, lftdb.CompanyDetails.Count);
var ibmRecord = _repository.Get("IBM");
Assert.AreEqual("International Business Machines Corporation Common Stock", ibmRecord.SecurityName);
}
public void SaveETFRecordsToDbEmptyTableTest()
{
isETF = true;
ClearTable();
string[] columnNames = { "Symbol", "Name" };
var fileName = @"symboldirectory/ETFList.csv";
LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName, ",");
var resultCount = lftdb.SaveRecordsToDb(_repository);
Assert.AreEqual(resultCount, lftdb.CompanyDetails.Count);
var iwoRecord = _context.CompanyDetails.FirstOrDefault(r => r.Symbol.Equals("IWO"));
Assert.IsTrue(iwoRecord.IsExTrdFund);
}
private LoadFileToDb PrepareCompanyDetailsList(string[] columnNames, ref string fileName, string delimiter = "|")
{
var temppath = Path.GetTempPath();
fileName = temppath + fileName;
var lftdb = new LoadFileToDb(fileName, columnNames)
{
Delimiter = delimiter,
IsETF = isETF,
IsMutaulFund = isMutalFund
};
var loadResult = lftdb.ParseSecurityListingFile();
return(lftdb);
}
public void SaveMutualFundsToDbEmptyTableTest()
{
ClearTable();
isMutalFund = true;
string[] columnNames = { "Fund Symbol", "Fund Name" };
var fileName = @"symboldirectory/mfundslist.txt";
LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName);
lftdb.IsMutaulFund = true;
var resultCount = lftdb.SaveRecordsToDb(_repository);
Assert.AreEqual(resultCount, lftdb.CompanyDetails.Count);
var fairxRecord = _repository.Get("FAIRX");
Assert.AreEqual("Fairholme Fd", fairxRecord.SecurityName);
}
