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 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); }