public static void ADOCanAddSale()
{
Sales saleToAdd = new Sales();
var repo = new SalesRepositoryADO();
saleToAdd.CustomerId = 1;
saleToAdd.VehicleId = 25;
saleToAdd.FinancingId = 1;
saleToAdd.UserId = "00000000-0000-0000-0000-000000000000";
saleToAdd.SaleAmount = 7400.51M;
saleToAdd.SaleDate = DateTime.Parse("07/23/2018 00.00.00 AM", System.Globalization.CultureInfo.InvariantCulture);
repo.AddSale(saleToAdd);
var sales = repo.GetAllSales().ToList();
Assert.IsNotNull(sales[13]);
Assert.AreEqual(14, sales.Count);
Assert.AreEqual(14, sales[13].SaleId);
Assert.AreEqual(1, sales[13].CustomerId);
Assert.AreEqual(25, sales[13].VehicleId);
Assert.AreEqual(1, sales[13].FinancingId);
Assert.AreEqual("00000000-0000-0000-0000-000000000000", sales[13].UserId);
Assert.AreEqual(7400.51, sales[13].SaleAmount);
Assert.AreEqual(DateTime.Parse("07/23/2018 00.00.00 AM", System.Globalization.CultureInfo.InvariantCulture), sales[13].SaleDate);
}
public void ADOCanSearchSalesForReportReturnNullList()
{
var repo = new SalesRepositoryADO();
var report = repo.GetSalesForReport(new SalesReportSearchParameters {
ToDate = "12/1/2017"
}).ToList();
Assert.AreEqual(0, report.Count());
}
public void ADOCanSearchSalesForReportNoParams()
{
var repo = new SalesRepositoryADO();
var report = repo.GetSalesForReport(new SalesReportSearchParameters {
}).ToList();
Assert.AreEqual(235000M, report[0].TotalSales);
Assert.AreEqual(5, report[0].TotalVehicles);
}
public void ADOCanSearchSalesForReportBogusDate()
{
var repo = new SalesRepositoryADO();
var report = repo.GetSalesForReport(new SalesReportSearchParameters {
ToDate = "bbbb", FromDate = "mmmm"
}).ToList();
Assert.AreEqual(235000M, report[0].TotalSales);
Assert.AreEqual(5, report[0].TotalVehicles);
}
public void ADOCanSearchSalesForReportAllParams()
{
var repo = new SalesRepositoryADO();
var report = repo.GetSalesForReport(new SalesReportSearchParameters {
ToDate = "12/31/2017", FromDate = "1-1-2017", UserId = "33333333-3333-3333-3333-333333333333"
}).ToList();
Assert.AreEqual(30000M, report[0].TotalSales);
Assert.AreEqual(1, report[0].TotalVehicles);
}
public void ADOCanSearchSalesForReportForTwoParameters()
{
var repo = new SalesRepositoryADO();
var report = repo.GetSalesForReport(new SalesReportSearchParameters {
ToDate = "05/1/2018", UserId = "11111111-1111-1111-1111-111111111111"
}).ToList();
Assert.AreEqual(10500M, report[0].TotalSales);
Assert.AreEqual(1, report[0].TotalVehicles);
report = repo.GetSalesForReport(new SalesReportSearchParameters {
FromDate = "05/1/2018", UserId = "11111111-1111-1111-1111-111111111111"
}).ToList();
Assert.AreEqual(116000M, report[0].TotalSales);
Assert.AreEqual(3, report[0].TotalVehicles);
report = repo.GetSalesForReport(new SalesReportSearchParameters {
ToDate = "06/30/2018", FromDate = "5-1-2018"
}).ToList();
Assert.AreEqual(99500M, report[0].TotalSales);
Assert.AreEqual(2, report[0].TotalVehicles);
}
public void ADOCanSearchSalesForReportOneParameter()
{
var repo = new SalesRepositoryADO();
var report = repo.GetSalesForReport(new SalesReportSearchParameters {
UserId = "22222222-2222-2222-2222-222222222222"
}).ToList();
Assert.AreEqual(110000M, report[0].TotalSales);
Assert.AreEqual(4, report[0].TotalVehicles);
report = repo.GetSalesForReport(new SalesReportSearchParameters {
FromDate = "04/01/2018"
}).ToList();
Assert.AreEqual(126500M, report[0].TotalSales);
Assert.AreEqual(4, report[0].TotalVehicles);
report = repo.GetSalesForReport(new SalesReportSearchParameters {
ToDate = "04/01/2018"
}).ToList();
Assert.AreEqual(132000M, report[0].TotalSales);
Assert.AreEqual(3, report[0].TotalVehicles);
}
