/// <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 CSVGetStockEntriesTest()
{
CSVStockRepository stockRepo = new CSVStockRepository();
SQLFilterRepository filterRepo = new SQLFilterRepository();
Filter filter = new Filter();
filter = filterRepo.GetMinMaxValues();
stockRepo.GetStockEntries(filter);
}
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);
}