public void SalesReportsImporterShouldImportCorrectDate()
{
var date = new DateTime(2015, 6, 10);
dbMock.Setup(db => db.Orders.Add(It.Is<Order>(
o => o.DeliveryDate == date))).Verifiable();
// first record is used to store the Client Name and Id for the file
var firstRecord = new List<Object>()
{
"CLient Name"
};
// second record and on are the orders entries for the particular client
var secondRecord = new List<Object>()
{
"1", // ProductId
"1", // quantity
"1", // unused value
"1", // Price
new DateTime(2015, 6, 10), // Date is inserted as last property
};
var salesReportImporter = new SalesReportsImporter();
salesReportImporter.Db = dbMock.Object;
salesReportImporter.ImportData(firstRecord);
salesReportImporter.ImportData(secondRecord);
dbMock.Verify(db => db.Orders.Add(It.Is<Order>(
o => o.DeliveryDate == date)));
}
public void SalesReportsImporterShouldImportCorrectDate()
{
var date = new DateTime(2015, 6, 10);
dbMock.Setup(db => db.Orders.Add(It.Is <Order>(
o => o.DeliveryDate == date))).Verifiable();
// first record is used to store the Client Name and Id for the file
var firstRecord = new List <Object>()
{
"CLient Name"
};
// second record and on are the orders entries for the particular client
var secondRecord = new List <Object>()
{
"1", // ProductId
"1", // quantity
"1", // unused value
"1", // Price
new DateTime(2015, 6, 10), // Date is inserted as last property
};
var salesReportImporter = new SalesReportsImporter();
salesReportImporter.Db = dbMock.Object;
salesReportImporter.ImportData(firstRecord);
salesReportImporter.ImportData(secondRecord);
dbMock.Verify(db => db.Orders.Add(It.Is <Order>(
o => o.DeliveryDate == date)));
}
public void SalesReportsImporterShouldThrowOnInvalidFirstDataRecord()
{
// first record is used to store the Client Name and Id for the file
var firstRecord = new List <Object>();
var salesReportImporter = new SalesReportsImporter();
salesReportImporter.Db = dbMock.Object;
salesReportImporter.ImportData(firstRecord);
}
public static void LoadSalesReports(string sourceArchiveFilePath)
{
var salesReportImporter = new SalesReportsImporter();
var excelFileLoader = new ExcelFileLoader();
excelFileLoader.AddDataImporter(salesReportImporter);
var zipArchiveLoader = new ZipArchiveLoader();
zipArchiveLoader.AddFileLoader(excelFileLoader);
zipArchiveLoader.Load(sourceArchiveFilePath);
}
public void SalesReportsImporterShouldNotThrowOnValidFirstDataRecordWithClientName()
{
// first record is used to store the Client Name and Id for the file
var firstRecord = new List<Object>()
{
"CLient Name"
};
var salesReportImporter = new SalesReportsImporter();
salesReportImporter.Db = dbMock.Object;
salesReportImporter.ImportData(firstRecord);
}
public static void LoadSalesReports(string sourceArchiveFilePath)
{
var salesReportImporter = new SalesReportsImporter();
var excelFileLoader = new ExcelFileLoader();
excelFileLoader.AddDataImporter(salesReportImporter);
var zipArchiveLoader = new ZipArchiveLoader();
zipArchiveLoader.AddFileLoader(excelFileLoader);
zipArchiveLoader.Load(sourceArchiveFilePath);
}
public void SalesReportsImporterShouldNotThrowOnValidSecondDataRecord()
{
// first record is used to store the Client Name and Id for the file
var firstRecord = new List <Object>()
{
"CLient Name"
};
var secondRecord = new List <Object>()
{
"ProductID", null, null, null
};
var salesReportImporter = new SalesReportsImporter();
salesReportImporter.Db = dbMock.Object;
salesReportImporter.ImportData(firstRecord);
salesReportImporter.ImportData(secondRecord);
}
public void SalesReportsImporterShouldThrowOnInvalidSecondDataRecordLength()
{
// first record is used to store the Client Name and Id for the file
var firstRecord = new List<Object>()
{
"CLient Name"
};
var secondRecord = new List<Object>()
{
1,1
};
var salesReportImporter = new SalesReportsImporter();
salesReportImporter.Db = dbMock.Object;
salesReportImporter.ImportData(firstRecord);
salesReportImporter.ImportData(secondRecord);
}
public void SalesReportsImporterShouldNotThrowOnValidSecondDataRecord()
{
// first record is used to store the Client Name and Id for the file
var firstRecord = new List<Object>()
{
"CLient Name"
};
var secondRecord = new List<Object>()
{
"ProductID",null,null,null
};
var salesReportImporter = new SalesReportsImporter();
salesReportImporter.Db = dbMock.Object;
salesReportImporter.ImportData(firstRecord);
salesReportImporter.ImportData(secondRecord);
}
