/// <summary>Get list of symbols</summary>
public IEnumerable <string> GetSymbols()
{
List <string> response = new List <string>();
SQLFilterRepository filterRepo = new SQLFilterRepository();
response = filterRepo.GetSymbols() as List <string>;
return(response);
}
public void CSVGetStockEntriesTest()
{
CSVStockRepository stockRepo = new CSVStockRepository();
SQLFilterRepository filterRepo = new SQLFilterRepository();
Filter filter = new Filter();
filter = filterRepo.GetMinMaxValues();
stockRepo.GetStockEntries(filter);
}
/// <summary>Get min and max values</summary>
public Filter GetMinMaxValues()
{
Filter response = new Filter();
SQLFilterRepository filterRepo = new SQLFilterRepository();
response = filterRepo.GetMinMaxValues();
return(response);
}
public void CSVAddStockEntriesTest()
{
CSVStockRepository stockRepo = new CSVStockRepository();
List <StockEntry> stockEntries = new List <StockEntry>();
SQLStockRepository sqlStockRepo = new SQLStockRepository();
SQLFilterRepository filterRepo = new SQLFilterRepository();
Filter filter = new Filter();
string actualResponse;
string expectedResponse = "Stock entries saved";
filter = filterRepo.GetMinMaxValues();
stockEntries = sqlStockRepo.GetStockEntries(filter) as List <StockEntry>;
actualResponse = stockRepo.AddStockEntries(stockEntries);
Assert.AreEqual(expectedResponse, actualResponse);
}
public void GetStockEntriesByFilterTest()
{
//-- Arrange
SQLStockRepository stockRepo = new SQLStockRepository();
List <StockEntry> actual;
SQLFilterRepository filterRepo = new SQLFilterRepository();
Filter filter = new Filter();
int expected = 102580;
//-- Act
filter = filterRepo.GetMinMaxValues();
actual = stockRepo.GetStockEntries(filter) as List <StockEntry>;
//-- Assert
Assert.AreEqual(expected, actual.Count);
}
public void GetMinMaxTest()
{
Filter actual = new Filter();
Filter expected = new Filter()
{
DateStart = DateTime.Parse("2000-01-03"),
DateEnd = DateTime.Parse("2010-02-08"),
VolumeMin = uint.Parse("0"),
VolumeMax = uint.Parse("242106500"),
};
expected.OpenMin.Amount = 0.35m;
expected.OpenMax.Amount = 183.50m;
expected.CloseMin.Amount = 0.35m;
expected.CloseMax.Amount = 182.62m;
expected.CloseAdjustedMin.Amount = 0.35m;
expected.CloseAdjustedMax.Amount = 134.92m;
expected.HighMin.Amount = 0.40m;
expected.HighMax.Amount = 185.50m;
expected.LowMin.Amount = 0.32m;
expected.LowMax.Amount = 170.00m;
SQLFilterRepository filterRepo = new SQLFilterRepository();
actual = filterRepo.GetMinMaxValues();
Assert.AreEqual(expected.DateStart, actual.DateStart);
Assert.AreEqual(expected.DateEnd, actual.DateEnd);
Assert.AreEqual(expected.VolumeMin, actual.VolumeMin);
Assert.AreEqual(expected.VolumeMax, actual.VolumeMax);
Assert.AreEqual(expected.OpenMin.Amount, actual.OpenMin.Amount);
Assert.AreEqual(expected.OpenMax.Amount, actual.OpenMax.Amount);
Assert.AreEqual(expected.CloseMin.Amount, actual.CloseMin.Amount);
Assert.AreEqual(expected.CloseMax.Amount, actual.CloseMax.Amount);
Assert.AreEqual(expected.CloseAdjustedMin.Amount, actual.CloseAdjustedMin.Amount);
Assert.AreEqual(expected.CloseAdjustedMax.Amount, actual.CloseAdjustedMax.Amount);
Assert.AreEqual(expected.HighMin.Amount, actual.HighMin.Amount);
Assert.AreEqual(expected.HighMax.Amount, actual.HighMax.Amount);
Assert.AreEqual(expected.LowMin.Amount, actual.LowMin.Amount);
Assert.AreEqual(expected.LowMax.Amount, actual.LowMax.Amount);
}
/// <summary>Resets the filter values by retrieving the values from the database</summary>
private void ResetFilter()
{
try
{
LoggingService.Log("Reseting Filter", "Log.txt");
Mouse.OverrideCursor = Cursors.Wait;
SQLFilterRepository filterRepo = new SQLFilterRepository();
FilterBound = filterRepo.GetFilter();
FilterPanel.DataContext = FilterBound;
FilterBound.Validate();
FilterError.Text = "";
FilterError.Visibility = Visibility.Collapsed;
}
catch (Exception ex)
{
FilterError.Text = ex.Message;
FilterError.Visibility = Visibility.Visible;
LoggingService.Log(ex, "Log.txt");
}
Mouse.OverrideCursor = Cursors.Arrow;
}
public void GetSymbolsTest()
{
List <string> actual = new List <string>();
List <string> expected = new List <string>();
expected.Add("all symbols");
expected.Add("AMG");
expected.Add("ATT");
expected.Add("AMP");
expected.Add("AFG");
expected.Add("ATU");
expected.Add("AVB");
expected.Add("ARG");
expected.Add("AEO");
expected.Add("ASI");
expected.Add("ADI");
expected.Add("ARM");
expected.Add("ARD");
expected.Add("AGD");
expected.Add("ASP");
expected.Add("AGM");
expected.Add("ABB");
expected.Add("ASF");
expected.Add("AHS");
expected.Add("ARK");
expected.Add("AKP");
expected.Add("APF");
expected.Add("APL");
expected.Add("AEA");
expected.Add("ALV");
expected.Add("ATV");
expected.Add("AOL");
expected.Add("AHD");
expected.Add("ADY");
expected.Add("ATE");
expected.Add("ASG");
expected.Add("ALZ");
expected.Add("AVA");
expected.Add("AXE");
expected.Add("AHT");
expected.Add("AEG");
expected.Add("AIT");
expected.Add("AKT");
expected.Add("AVK");
expected.Add("AVT");
expected.Add("AMX");
expected.Add("ACM");
expected.Add("AEB");
expected.Add("ABK");
expected.Add("ABM");
expected.Add("AFB");
expected.Add("AWH");
expected.Add("APD");
expected.Add("ACH");
expected.Add("ARO");
expected.Add("ASA");
expected.Add("AA");
SQLFilterRepository filter = new SQLFilterRepository();
actual = filter.GetSymbols() as List <string>;
foreach (string symbol in actual)
{
Console.WriteLine(symbol);
}
CollectionAssert.AreEquivalent(expected, actual);
}