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