public CardService(TinyBankDBContext dbContext, IAccountsService account) { _dbContext = dbContext; _account = account; _mapper = new MapperConfiguration(cfg => cfg.CreateMap <RegisterCardOptions, Card>()).CreateMapper(); }
public void Get_Customer() { using var dbContext = new TinyBankDBContext(GetDBOptions().Options); var customers = dbContext.Set <Customer>() .Where(c => c.VatNumber == "123456789") .ToList(); }
public void Add_New_Account() { using var dbContext = new TinyBankDBContext(GetDBOptions().Options); var account = new Accounts() { State = AccountStateTypes.Active, AccountDescription = "My Personal Account", AccountNumber = "1558642182", Currency = "EUR", Balance = 1500.0m }; dbContext.Add(account); dbContext.SaveChanges(); }
public void Add_New_Customer_With_Service() { using var dbContext = new TinyBankDBContext(GetDBOptions().Options); var customerService = new CustomerService(dbContext); var customer = customerService.Register(new RegisterCustomerOptions() { CustomerBankID = "CUSTBNK0001", Name = "Ioannis", SureName = "Ioannopoulos", VATNumber = "033456789", CustType = CustomerType.Personal, Address = "Cust Address 1" }); Assert.NotNull(customer); }
public void Add_New_Customer() { using var dbContext = new TinyBankDBContext(GetDBOptions().Options); var customer = new Customer() { Active = true, Address = "Test Address", CustBankID = "032846778", CustType = CustomerType.Personal, Name = "Kostas", SureName = "Parginos", VatNumber = "123456789" }; dbContext.Add(customer); dbContext.SaveChanges(); }
public void Add_New_Transaction_To_Account() { var config = new ConfigurationBuilder() .SetBasePath($"{AppDomain.CurrentDomain.BaseDirectory}") .AddJsonFile("appsettings.json", false) .Build(); var connString = config.ReadAppConfiguration(); var options = new DbContextOptionsBuilder <TinyBankDBContext>(); options.UseSqlServer(connString.ConnString, options => { options.MigrationsAssembly("TinyBank"); }); using var dbContext = new TinyBankDBContext(options.Options); var savedCustomer = dbContext.Set <Customer>() .Where(c => c.CustBankID == "032846778") .SingleOrDefault(); Assert.NotNull(savedCustomer); var savedAccount = dbContext.Set <Accounts>() .Where(a => a.AccountNumber == "1558642182") .SingleOrDefault(); Assert.NotNull(savedAccount); savedAccount.Transactions.Add(new Transaction() { Amount = 150.0m, TransDescr = "Tablet purchase", Type = TransactionType.Credit }); dbContext.Update(savedAccount); dbContext.SaveChanges(); }
public void Add_New_Account_To_Customer() { var config = new ConfigurationBuilder() .SetBasePath($"{AppDomain.CurrentDomain.BaseDirectory}") .AddJsonFile("appsettings.json", false) .Build(); var connString = config.ReadAppConfiguration(); var options = new DbContextOptionsBuilder <TinyBankDBContext>(); options.UseSqlServer(connString.ConnString, options => { options.MigrationsAssembly("TinyBank"); }); using var dbContext = new TinyBankDBContext(options.Options); var savedCustomer = dbContext.Set <Customer>() .Where(c => c.CustBankID == "032846778") .SingleOrDefault(); Assert.NotNull(savedCustomer); savedCustomer.Accounts.Add(new Accounts() { State = AccountStateTypes.Active, AccountDescription = "My Personal Account", AccountNumber = "1558642123", Currency = "EUR", Balance = 1800.0m }); dbContext.Update(savedCustomer); dbContext.SaveChanges(); }
public AccountsService(TinyBankDBContext dBContext, ICustomerService customer) { _dBContext = dBContext; _customer = customer; }
/// <summary> /// Constructor /// </summary> /// <param name="dbContext">The DBContext to be use by the rest of the methods when accessing the database</param> public CustomerService(TinyBankDBContext dbContext) { _dbContext = dbContext; }
public TransactionService(TinyBankDBContext dBContext, IAccountsService account) { _dBContext = dBContext; _account = account; }