private static void AddAccountOperationTest() { string connectionString = GetConnectionString("SULMAR-PC", "AdventureWorks", applicationName: "Santander"); SqlConnection connection = new SqlConnection(connectionString); IAccountOperationService accountOperationService = new DbAccountOperationService(connection); AccountOperationFaker accountOperationFaker = new AccountOperationFaker(); var accountOperations = accountOperationFaker.GenerateLazy(100_000); foreach (var accountOperation in accountOperations) { accountOperationService.Add(accountOperation); } //OperationType operationType = new OperationType //{ // Id = 1, // Name = "Operacja 1" //}; //AccountOperation accountOperation = new AccountOperation(operationType) //{ // Id = 10, // Account = "123490200", // OperationStatus = OperationStatus.OK, //}; // string connectionString = "Data Source=SULMAR-PC;Initial Catalog=AdventureWorks;Integrated Security=True;Application Name=Santander"; }
private static IAccountOperationService GetService() { string connectionString = GetConnectionString("SULMAR-PC", "AdventureWorks", applicationName: "Santander"); SqlConnection connection = new SqlConnection(connectionString); IAccountOperationService accountOperationService = new DbAccountOperationService(connection); return(accountOperationService); }
private static void GetAccountOperationsTest() { string connectionString = GetConnectionString("SULMAR-PC", "AdventureWorks", applicationName: "Santander"); SqlConnection connection = new SqlConnection(connectionString); IAccountOperationService accountOperationService = new DbAccountOperationService(connection); AccountOperationSearchCriteria criteria = new AccountOperationSearchCriteria { Account = "12348", From = DateTime.Parse("2019-05-01"), To = DateTime.Parse("2019-12-01"), }; var accountOperations = accountOperationService.Get(criteria); foreach (var operation in accountOperations) { // Console.WriteLine(operation.Account); } }