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);
}
internal void LodeData(string path)
{
Console.WriteLine("Dropping old records");
ClearTable();
delimiter = "|";
isETF = false;
isMutualFund = false;
string[] columnNames = { "Symbol", "Security Name" };
var fileName = @"symboldirectory/nasdaqlisted.txt";
Console.WriteLine($"Processing {fileName}");
LoadCompanyList(path, fileName, columnNames);
isMutualFund = true;
columnNames = new string[] { "Fund Symbol", "Fund Name" };
fileName = @"symboldirectory/mfundslist.txt";
Console.WriteLine($"Processing {fileName}");
LoadCompanyList(path, fileName, columnNames);
isMutualFund = false;
columnNames = new string[] { "NASDAQ Symbol", "Security Name" };
fileName = @"symboldirectory/otherlisted.txt";
Console.WriteLine($"Processing {fileName}");
LoadCompanyList(path, fileName, columnNames);
isETF = true;
delimiter = ",";
columnNames = new string[] { "Symbol", "Name" };
fileName = @"symboldirectory/ETFList.txt";
Console.WriteLine($"Processing {fileName}");
ProcessETFList(path, fileName, columnNames);
//LoadCompanyList(path, fileName, columnNames);
isETF = false;
delimiter = ",";
columnNames = new string[] { "Symbol", "Sector", "industry", "IPOyear", "Name" };
fileName = @"symboldirectory/AMEXCompanyList.csv";
Console.WriteLine($"Processing {fileName}");
LoadCompanyDetails(path, fileName, columnNames);
delimiter = ",";
columnNames = new string[] { "Symbol", "Sector", "industry", "IPOyear", "Name" };
fileName = @"symboldirectory/NYSECompanyList.csv";
Console.WriteLine($"Processing {fileName}");
LoadCompanyDetails(path, fileName, columnNames);
delimiter = ",";
columnNames = new string[] { "Symbol", "Sector", "industry", "IPOyear", "Name" };
fileName = @"symboldirectory/NASDAQCompanyList.csv";
Console.WriteLine($"Processing {fileName}");
LoadCompanyDetails(path, fileName, columnNames);
loadFileToDb.SaveRecordsToDb(_repository);
}
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 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);
}
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);
}
