/// <summary>
/// The get savings.
/// </summary>
/// <param name="owner">
/// The owner.
/// </param>
/// <param name="currentAccount">
/// The current account.
/// </param>
/// <param name="code">
/// The code.
/// </param>
/// <param name="input">
/// The input.
/// </param>
/// <returns>
/// The <see cref="SavingAccountEntity"/>.
/// </returns>
private static SavingAccountEntity GetSavings(Guid owner, Guid currentAccount, Guid code, SavingAccountIn input)
{
var output = new SavingAccountEntity
{
Code = code,
Owner = owner,
Holder = input.Holder,
IsArchived = input.IsArchived,
Bank = input.Bank,
Description = input.Description,
Amount = input.Amount,
Currency = input.Currency,
Number = input.Number,
StartDate = input.StartDate,
AutomaticRenovation = input.AutomaticRenovation,
InterestCapitalization = input.InterestCapitalization,
InterestPayment = input.InterestPayment,
SavingEndDate = input.SavingEndDate,
SavingInterestRate = input.SavingInterestRate
};
if (currentAccount != Guid.Empty)
{
output.SavingRelatedAccount = currentAccount;
}
return(output);
}
/// <summary>
/// The get saving out.
/// </summary>
/// <param name="a">
/// The account.
/// </param>
/// <param name="holder">
/// The holder.
/// </param>
/// <returns>
/// The <see cref="SavingAccountOut"/>.
/// </returns>
private SavingAccountOut GetSavingOut(SavingAccountEntity a, HumanOut holder)
{
return(new SavingAccountOut
{
ChangeAt = a.ChangeAt,
Currency = this.cacheProvider.Currencies.FirstOrDefault(o => o.Code == a.Currency),
StartDate = a.StartDate,
Amount = a.Amount,
Bank = this.cacheProvider.Banks.FirstOrDefault(o => o.Code == a.Bank),
Description = a.Description,
CreatedAt = a.CreatedAt,
Holder = holder,
IsArchived = a.IsArchived,
Number = a.Number,
AutomaticRenovation = a.AutomaticRenovation,
InterestCapitalization = a.InterestCapitalization,
InterestPayment = a.InterestPayment,
SavingEndDate = a.SavingEndDate,
SavingInterestRate = a.SavingInterestRate
});
}
/// <summary>
/// The seed.
/// </summary>
/// <param name="context">
/// The context.
/// </param>
protected override void Seed(BankingDbContext context)
{
var format = Constants.DayFormat;
var provider = CultureInfo.InvariantCulture;
var bankMilleniumGuid = Guid.Parse("{1496DD29-14BF-4753-AACC-35203E3947B7}");
var bankBcpGuid = Guid.Parse("{740ED738-D34C-4918-9CD9-9EC280F3C093}");
var bankMontepioGuid = Guid.Parse("F8C95B7D-A8EA-4FE6-95B5-930122E9A5A2");
var bankCaixaGuid = Guid.Parse("752ABB7E-FECE-4673-B561-690C56FC44D2");
var bankMillenium = new BankEntity {
Code = bankMilleniumGuid, Name = "Bank Millennium", Country = "Pl", Swift = "BIGBPLPW", Url = "http://www.bankmillennium.pl"
};
var bankBcp = new BankEntity {
Code = bankBcpGuid, Name = "Millennium BCP", Country = "Pt", Swift = "MillePt", Url = "http://www.millenniumbcp.pt"
};
var bankMontepio = new BankEntity {
Code = bankMontepioGuid, Name = "Montepio Geral", Country = "Pt", Swift = "MPIOPTPL", Url = "http://www.montepio.pt"
};
var bankCaixa = new BankEntity {
Code = bankCaixaGuid, Name = "Caixa Geral de Depositos", Country = "Pt", Swift = "caixa", Url = "http://www.cgd.pt"
};
var euro = new CurrencyEntity {
Currency = Constants.Eur, Order = 1, Name = "Euro", ReasonToOneEuro = 0
};
var pln = new CurrencyEntity {
Currency = "Pln", Order = 2, Name = "Zloty", ReasonToOneEuro = 4.20m
};
context.SeedAddOrUpdate(
p => p.Code,
p => new { p.Country, p.Name, p.Swift, p.Url, p.ChangeAt },
bankMillenium,
bankBcp,
bankMontepio,
bankCaixa);
context.SeedAddOrUpdate(
p => p.Currency,
p => new { p.ReasonToOneEuro, p.Order, p.ChangeAt },
euro,
pln,
new CurrencyEntity {
Currency = "USD", Name = "Dollar", Order = 3, ReasonToOneEuro = 1.20m
});
var goncaloGuid = Guid.Parse("9B8B32D1-A950-4C11-B77D-6FEFFAA4C17B");
var guiGuid = Guid.Parse("AF47E41B-344A-42AA-AEFF-07FE41E5D53C");
var vascoGuid = Guid.Parse("C7EC913C-95A7-4BAC-9C2E-96A5E5B9C420");
var isildaGuid = Guid.Parse("99B84DE3-2D7F-4D56-9592-092CEBA834B8");
var filipaGuid = Guid.Parse("43E1428A-454B-4E6F-B83E-5E44BD28346D");
var goncaloUser = new UserEntity
{
Code = goncaloGuid,
Name = "Goncalo",
Surname = "Gaspar",
Email = "*****@*****.**",
IdNumber = "xxxxx",
IdNumberExpirationDate = DateTime.Today.AddYears(2),
Nif = "xxxYYyyyx",
HealthCare = "xxxxx",
HealthCareExpirationDate = DateTime.Today.AddMonths(-5).AddDays(5),
SocialSecurity = "xxxxxx",
};
context.SeedAddOrUpdate(
p => p.Code,
p =>
new
{
p.Name,
p.Surname,
p.Email,
p.IdNumber,
p.IdNumberExpirationDate,
p.Passport,
p.PassportExpirationDate,
p.Nif,
p.HealthCare,
p.HealthCareExpirationDate,
p.SocialSecurity,
p.ChangeAt
},
goncaloUser);
var goncaloPerson = new PersonEntity {
Code = goncaloGuid, Name = "Goncalo", Surname = "Gaspar", Email = "*****@*****.**", IsArchived = false, OwnerCode = goncaloGuid
};
var guilhermePerson = new PersonEntity {
Code = guiGuid, Name = "Guilherme", Surname = "Gaspar", Email = "*****@*****.**", IsArchived = false, OwnerCode = goncaloGuid
};
var vascoPerson = new PersonEntity {
Code = vascoGuid, Name = "Vasco", Surname = "Gaspar", Email = "*****@*****.**", IsArchived = false, OwnerCode = goncaloGuid
};
var isildaPerson = new PersonEntity {
Code = isildaGuid, Name = "Isilda", Surname = "Gaspar", Email = "*****@*****.**", IsArchived = false, OwnerCode = goncaloGuid
};
var filipaPerson = new PersonEntity {
Code = filipaGuid, Name = "Filipa", Surname = "Viegas", Email = "*****@*****.**", IsArchived = false, OwnerCode = goncaloGuid
};
context.SeedAddOrUpdate(
p => p.Code,
p => new { p.Name, p.Surname, p.Email, p.IsArchived, p.IsMe, p.ChangeAt },
goncaloPerson,
guilhermePerson,
vascoPerson,
isildaPerson,
filipaPerson);
var currentGoncaloGuid = Guid.Parse("303B2432-C710-4DD6-A034-17EB10793CEB");
var currentGoncalo = new CurrentAccountEntity
{
Code = currentGoncaloGuid,
Description = "Conta ordenado",
Number = "029.10.012311-5",
Iban = "PT50.0036.0029.99100123115.13",
Currency = Constants.Eur,
Amount = 462.52m,
StartDate = DateTime.ParseExact("01/02/2008", format, provider),
Holder = goncaloGuid,
Owner = goncaloGuid,
Bank = bankMontepioGuid,
IsArchived = false
};
var currentPlGoncaloGuid = Guid.Parse("28244669-e675-4f28-bfeb-3074eb556c40");
var currentPlGoncalo = new CurrentAccountEntity
{
Code = currentPlGoncaloGuid,
Description = "Conta Polonia",
Number = "0247914561",
Iban = "PL92.1160.2202.00000002479145.61",
Currency = "PLN",
Amount = 1000.55m,
StartDate = DateTime.ParseExact("04/10/2013", format, provider),
Holder = goncaloGuid,
Owner = goncaloGuid,
Bank = bankMilleniumGuid,
IsArchived = false
};
var currentPlEuroGoncalo = new CurrentAccountEntity
{
Code = Guid.Parse("BFC9DF65-8650-4925-AEFF-31BC2062C357"),
Description = "Conta Polonia Euros",
Number = "0248923401",
Iban = "PL79.1160.2202.00000002489234.01",
Currency = Constants.Eur,
Amount = 0m,
StartDate = DateTime.ParseExact("21/10/2013", format, provider),
Holder = goncaloGuid,
Owner = goncaloGuid,
Bank = bankMilleniumGuid,
IsArchived = false
};
var currentGuiGuid = Guid.Parse("9D73C73A-7E1F-40A9-A52E-460010566B4F");
var currentGuilherme = new CurrentAccountEntity
{
Code = currentGuiGuid,
Description = "Conta fun",
Number = "029.10.013309-8",
Iban = "PT50.0036.0029.99100133098.37",
Currency = Constants.Eur,
Amount = 707.93m,
StartDate = DateTime.ParseExact("01/01/2015", format, provider),
Holder = guiGuid,
Owner = goncaloGuid,
Bank = bankMontepioGuid,
IsArchived = false
};
var currentVasco = new CurrentAccountEntity
{
Code = Guid.Parse("4F248CC3-73FC-47D8-B772-49EF64E35D4D"),
Description = "Conta Corrente",
Number = "63566423095",
Iban = "PT50.0035.0995.00635664230.95",
Currency = Constants.Eur,
Amount = 0,
StartDate = DateTime.Today.AddYears(-2),
Holder = vascoGuid,
Owner = goncaloGuid,
Bank = bankCaixaGuid,
IsArchived = false
};
var currentFilipa = new CurrentAccountEntity
{
Code = Guid.Parse("DF756217-78C0-4877-BB7B-E210A88603C0"),
Description = "Conta Corrente",
Number = "4956598449",
Iban = "PT50.0033.0000.00049565984.49",
Currency = Constants.Eur,
Amount = 0m,
StartDate = DateTime.Today.AddYears(-2),
Holder = filipaGuid,
Owner = goncaloGuid,
Bank = bankBcpGuid,
IsArchived = false
};
var loanGoncalo = new LoanAccountEntity
{
Code = Guid.Parse("f03f8057-e33e-4ebd-8b50-7005d8bd2188"),
Description = "Conta Casa",
Number = "029.21.100472-5",
Currency = Constants.Eur,
Amount = 47580.38m,
StartDate = DateTime.ParseExact("23/07/2008", format, provider),
Holder = goncaloGuid,
Owner = goncaloGuid,
Bank = bankMontepioGuid,
InitialAmount = 70000,
PremiumPercentage = 0,
InterestNetRate = 0.189m,
LoanEndDate = DateTime.ParseExact("28/07/2033", format, provider),
LoanInterestRate = 5.441m,
LoanRelatedAccount = currentGoncaloGuid,
IsArchived = false
};
var loan2Goncalo = new LoanAccountEntity
{
Code = Guid.Parse("5e919e86-0d5a-4eca-b805-0a22471443cb"),
Description = "Conta Carro",
Number = "029.27.100168-6",
Currency = Constants.Eur,
Amount = 23618.64m,
StartDate = DateTime.ParseExact("16/07/2010", format, provider),
Holder = goncaloGuid,
Owner = goncaloGuid,
Bank = bankMontepioGuid,
InitialAmount = 38500,
PremiumPercentage = 0,
InterestNetRate = 3.298m,
LoanEndDate = DateTime.ParseExact("16/07/2033", format, provider),
LoanInterestRate = 4.328m,
LoanRelatedAccount = currentGoncaloGuid,
IsArchived = false
};
var savingGoncalo = new SavingAccountEntity
{
Code = Guid.Parse("ec7bdd2c-a3fe-42f0-9e91-b2e4333b9ae9"),
Description = "Poupanca Activa",
Number = "732.15.420299-6",
Currency = Constants.Eur,
Amount = 1058.38m,
StartDate = DateTime.ParseExact("03/08/2016", format, provider),
Holder = goncaloGuid,
Owner = goncaloGuid,
Bank = bankMontepioGuid,
AutomaticRenovation = AutomaticRenovation.No,
InterestCapitalization = true,
InterestPayment = Cadence.Yearly,
SavingEndDate = DateTime.ParseExact("03/08/2017", format, provider),
SavingInterestRate = 0.8m,
SavingRelatedAccount = currentGoncaloGuid,
IsArchived = false
};
var savingGui = new SavingAccountEntity
{
Code = Guid.Parse("AA111116-70F2-47CC-9C21-01A161D10D92"),
Description = "Poupanca Bue",
Number = "732.15.417187-8",
Currency = Constants.Eur,
Amount = 400.00m,
StartDate = DateTime.ParseExact("08/07/2015", format, provider),
Holder = guiGuid,
Owner = goncaloGuid,
Bank = bankMontepioGuid,
AutomaticRenovation = AutomaticRenovation.YesSamePeriod,
InterestCapitalization = false,
InterestPayment = Cadence.Yearly,
SavingEndDate = DateTime.ParseExact("08/07/2016", format, provider),
SavingInterestRate = 1.0m,
SavingRelatedAccount = currentGuiGuid,
IsArchived = false
};
var saving2Gui = new SavingAccountEntity
{
Code = Guid.Parse("7D2E570A-BBC3-41D6-B2E3-B47BB491D60C"),
Description = "Poupanca Bue",
Number = "732.15.430705-0",
Currency = Constants.Eur,
Amount = 250.00m,
StartDate = DateTime.ParseExact("13/11/2015", format, provider),
Holder = guiGuid,
Owner = goncaloGuid,
Bank = bankMontepioGuid,
AutomaticRenovation = AutomaticRenovation.YesSamePeriod,
InterestCapitalization = false,
InterestPayment = Cadence.Yearly,
SavingEndDate = DateTime.ParseExact("13/11/2017", format, provider),
SavingInterestRate = 1.0m,
SavingRelatedAccount = currentGuiGuid,
IsArchived = false
};
context.SeedAddOrUpdate(
p => p.Code,
p => new { p.Description, p.Number, p.Iban, p.Amount, p.ChangeAt, p.IsArchived },
currentGoncalo,
currentGuilherme,
currentVasco,
currentFilipa,
currentPlGoncalo,
currentPlEuroGoncalo);
context.SeedAddOrUpdate(
p => p.Code,
p => new { p.Description, p.Number, p.Amount, p.ChangeAt, InicialAmount = p.InitialAmount, p.InterestNetRate, p.LoanEndDate, p.LoanInterestRate, p.PremiumPercentage, p.LoanRelatedAccount, p.IsArchived },
loanGoncalo,
loan2Goncalo);
context.SeedAddOrUpdate(
p => p.Code,
p => new { p.Description, p.Number, p.Amount, p.ChangeAt, p.InterestCapitalization, p.SavingEndDate, p.SavingInterestRate, p.SavingRelatedAccount, p.IsArchived },
savingGoncalo,
savingGui,
saving2Gui);
var visa = new CreditCardEntity
{
Code = Guid.Parse("951C4C66-EA1C-4285-B122-308CDF0243D5"),
CardNumber = "5731",
CardProvider = CardProvider.Visa,
Description = "Visa Cinza",
PaymentDay = 7,
Limit = 1000,
UsedLimit = 300,
Expire = DateTime.ParseExact("31/01/2020", format, provider),
Account = currentGoncaloGuid,
Bank = bankMontepioGuid,
Currency = Constants.Eur,
Holder = goncaloGuid,
Owner = goncaloGuid,
IsArchived = false
};
context.SeedAddOrUpdate(
p => p.Code,
p => new { p.Description, p.Code, p.CardNumber, p.PaymentDay, p.Limit, p.UsedLimit, p.Expire, p.Account, p.Bank, p.Currency, p.Holder, p.Owner, p.ChangeAt },
visa);
var currentMontepio = new DebitCardEntity
{
Code = Guid.Parse("B22056AC-91FD-4769-9056-E235F2757A43"),
CardNumber = "5594",
CardProvider = CardProvider.VisaElectron,
Description = "Debito Amarelo",
Expire = DateTime.ParseExact("30/09/2019", format, provider),
Account = currentGoncaloGuid,
Bank = bankMontepioGuid,
Currency = Constants.Eur,
Holder = goncaloGuid,
Owner = goncaloGuid,
IsArchived = false
};
var currentMille = new DebitCardEntity
{
Code = Guid.Parse("1C3E3692-1AD9-401D-B4AA-C06A31967A95"),
CardNumber = "5505",
CardProvider = CardProvider.Visa,
Description = "Debito Cinza",
Expire = DateTime.ParseExact("30/09/2019", format, provider),
Account = currentPlGoncaloGuid,
Bank = bankMilleniumGuid,
Currency = "PLN",
Holder = goncaloGuid,
Owner = goncaloGuid,
IsArchived = false
};
context.SeedAddOrUpdate(
p => p.Code,
p => new { p.Description, p.Code, p.CardNumber, p.Expire, p.Account, p.Bank, p.Currency, p.Holder, p.Owner, p.ChangeAt, p.IsArchived },
currentMontepio,
currentMille);
var preMille = new PrePaidCardEntity
{
Code = Guid.Parse("283FBB3A-B988-42A7-95F6-8A377D0C9CC1"),
CardNumber = "9102",
CardProvider = CardProvider.Maestro,
Description = "PrePago Preto",
Expire = DateTime.ParseExact("31/05/2019", format, provider),
Account = currentPlGoncaloGuid,
Bank = bankMilleniumGuid,
Currency = "PLN",
Holder = goncaloGuid,
Owner = goncaloGuid,
AvailableAmount = 500,
MaximumAmount = 500,
IsArchived = false
};
var preMontepio = new PrePaidCardEntity
{
Code = Guid.Parse("905FADBF-F44D-4DFC-850D-0368DA41CF58"),
CardNumber = "5555",
CardProvider = CardProvider.VisaElectron,
Description = "PrePago Mae",
Expire = DateTime.ParseExact("31/05/2019", format, provider),
Account = currentGoncaloGuid,
Bank = bankMilleniumGuid,
Currency = Constants.Eur,
Holder = isildaGuid,
Owner = goncaloGuid,
AvailableAmount = 50,
MaximumAmount = 1500,
IsArchived = false
};
context.SeedAddOrUpdate(
p => p.Code,
p => new { p.Description, p.Code, p.CardNumber, p.AvailableAmount, p.MaximumAmount, p.Expire, p.Account, p.Bank, p.Currency, p.Holder, p.Owner, p.ChangeAt, p.IsArchived },
preMontepio,
preMille);
context.SaveChanges();
}
