public async Task <string> HandleAsync(FindCurrencyDefault query) { using (ReadModelContext db = readModelContextFactory.Create()) { CurrencyEntity currency = await db.Currencies.WhereUserKey(query.UserKey).FirstOrDefaultAsync(c => c.IsDefault); return(currency?.UniqueCode); } }
private Product PrepareProduct(Product product, CurrencyEntity currency) { product.Reviews = _productRepository.GetReviewsByProduct(product.Id).Select(x => x.ReviewEntityToReview()).ToArray(); product.Images = _productRepository.GetImagesByProduct(product.Id).Select(x => x.PhysicalPath).ToArray(); product.TitleImage = product.Images.FirstOrDefault(x => Path.GetFileName(x) == product.TitleImage); product.Price = _productRepository.GetPricesByProduct(product.Id).FirstOrDefault(x => x.Currency == currency.Code)?.PriceEntityToPrice(currency); product.Properties = _productRepository.GetProductProperties(product.Id).Select(x => x.PropertyEntityToProperty()).ToArray(); return(product); }
public static Price PriceEntityToPrice(this PriceEntity price, CurrencyEntity currency) { return(new Price { List = Convert.ToDecimal(price.List), Sale = Convert.ToDecimal(price.Sale), Currency = currency.EntitiesToModel() }); }
public async Task HandleAsync(CurrencyDeleted payload) { using (ReadModelContext db = readModelContextFactory.Create()) { CurrencyEntity entity = db.Currencies.WhereUserKey(payload.UserKey).First(c => c.UniqueCode == payload.UniqueCode); entity.IsDeleted = true; await db.SaveChangesAsync(); } }
private Currency ToModel(CurrencyEntity entity) { return(new Currency() { Accuracy = entity.Accuracy, Id = entity.Id, Timestamp = entity.Timestamp, InterestRateMdsCode = entity.InterestRateMdsCode, }); }
public List <CurrencyEntity> LoadDataFromFile(BudgetProgressChangedEventHandler OnProgress, string fileName) { Excel.Application ExApp = new Excel.Application(); Excel.Workbook ExBook = ExApp.Workbooks.Open(fileName); Excel.Worksheet ExSheet = ExBook.Worksheets.Item[1]; Process[] excelList = ExcelUtil.GetProcesses(); List <CurrencyEntity> entityList = new List <CurrencyEntity>(); int count = 1; try { int rowIdx = 3; string strKey = ConvertUtil.ToString(ExSheet.Range["A" + rowIdx].Value).Trim(); while (!BudgetResource.Resource.ExcelDataEnd.Equals(strKey, StringComparison.OrdinalIgnoreCase) && !BudgetResource.Resource.ExcelDataBlank.Equals(strKey, StringComparison.OrdinalIgnoreCase)) { string strCurrencyCode = ConvertUtil.ToString(ExSheet.Range["A" + rowIdx].Value); //Currency Code string strCurrencyName = ConvertUtil.ToString(ExSheet.Range["B" + rowIdx].Value); //Currency Name string strPassword = ConvertUtil.ToString(ExSheet.Range["C" + rowIdx].Value); //Password CurrencyEntity entity = new CurrencyEntity(); entity.CurrencyCode = strCurrencyCode.Trim(); //Currency Code entity.CurrencyName = strCurrencyName.Trim(); //Currency Name entity.ReadOnly = true; entity.Row = rowIdx; entityList.Add(entity); if (OnProgress != null) { string InfomationMessage = string.Format("you are importing No. {0} data", count); int Percentage = (int)((count + 1) % BudgetConstant.ProgressBarMaximum); BudgetProgressChangedEventArgs args = new BudgetProgressChangedEventArgs(InfomationMessage, Percentage, null); OnProgress(this, args); } rowIdx++; count++; strKey = ConvertUtil.ToString(ExSheet.Range["A" + rowIdx].Value).Trim(); Thread.Sleep(10); } } catch (Exception ex) { throw; } finally { ExcelUtil.ReleaseResource(ExSheet, ExBook, ExApp); ExcelUtil.KillProcess(excelList); } return(entityList); }
/// <summary> /// Update. /// </summary> /// <param name="item">The item.</param> public void Update(ICurrencyDto item) { var entity = new CurrencyEntity { Id = item.Id, AlphabeticCode = item.AlphabeticCode }; _unitOfWork.CurrencyRepository.Update(entity); _unitOfWork.Commit(); }
public void InsertData(CurrencyEntity currencyEntity) { try { _connection.InsertOrReplaceWithChildren(currencyEntity); } catch (Exception e) { throw e; } }
public void ExportDataToFile(BudgetProgressChangedEventHandler OnProgress, string fileName) { string templateFilename = Path.Combine(Application.StartupPath, "ExcelTemplate", "Currency_Template.xls"); List <CurrencyEntity> entityList = GetDataFromDB(OnProgress); int count = entityList.Count; Excel.Application ExApp = new Excel.Application(); Excel.Workbook ExBook = ExApp.Workbooks.Open(templateFilename); Excel.Worksheet ExSheet = ExBook.Worksheets.Item[1]; Process[] excelList = ExcelUtil.GetProcesses(); try { int rowIdx = 3; ExSheet.Range["E" + 1].Value = DateTime.Now.ToString();//Date for (int i = 0; i < count; i++) { if (OnProgress != null) { string InfomationMessage = string.Format("you are processing No. {0} data", i + 1); int Percentage = (int)((i + 1) * BudgetConstant.ProgressBarMaximum / count); BudgetProgressChangedEventArgs args = new BudgetProgressChangedEventArgs(InfomationMessage, Percentage, null); OnProgress(this, args); } CurrencyEntity entity = entityList[i]; ExSheet.Range["A" + rowIdx].Value = ConvertUtil.ToString(entity.CurrencyCode); //Currency Code ExSheet.Range["B" + rowIdx].Value = ConvertUtil.ToString(entity.CurrencyName); //Currency Name rowIdx++; Thread.Sleep(10); } ExSheet.Range["A" + rowIdx].Value = BudgetResource.Resource.ExcelDataEnd;//End Flag ExBook.SaveCopyAs(fileName); } catch (Exception ex) { throw; } finally { ExcelUtil.ReleaseResource(ExSheet, ExBook, ExApp); ExcelUtil.KillProcess(excelList); } }
/// <summary> /// Takes the specified budget source property. /// </summary> /// <param name="currency">The budget source property.</param> /// <returns>System.Object[][].</returns> private object[] Take(CurrencyEntity currency) { return(new object[] { "@CurrencyID", currency.CurrencyId, "@CurrencyCode", currency.CurrencyCode, "@CurrencyName", currency.CurrencyName, "@Prefix", currency.Prefix, "@Suffix", currency.Suffix, "@IsMain", currency.IsMain, "@IsActive", currency.IsActive }); }
public void AlphabeticCode_Set_Success() { // Arrange const string alphabeticCode = "USD"; // Act var currencyEntity = new CurrencyEntity { AlphabeticCode = alphabeticCode }; // Assert Assert.Equal(alphabeticCode, currencyEntity.AlphabeticCode); }
public bool SaveCurrency(CurrencyEntity currency) { var currentCurrency = _connection.Table <CurrencyEntity>().FirstOrDefault(); var result = 0; if (currentCurrency != null) { result = _connection.Update(currency); } else { currency.Id = Guid.NewGuid().ToString(); result = _connection.Insert(currency); } return(result != -1); }
public Currency Get(CurrencyEntity currencyEntity) { var instance = new Currency { Base = currencyEntity.Base, Date = currencyEntity.Date, Rates = new Dictionary <string, decimal>() }; foreach (var item in currencyEntity.Rates) { instance.Rates.Add(item.CurrencyName, item.CurrencyRate); } return(instance); }
/// <summary> /// Updates the account category. /// </summary> /// <param name="accountCategoryEntity">The account category entity.</param> /// <returns>AccountCategoryResponse.</returns> public CurrencyResponse UpdateCurrency(CurrencyEntity currencyEntity) { var response = new CurrencyResponse { Acknowledge = AcknowledgeType.Success }; try { if (!currencyEntity.Validate()) { foreach (string error in currencyEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } var currencyExited = ICurrencyDao.GetCurrenciesByCurrencyCode(currencyEntity.CurrencyCode); if (currencyExited != null) { if (!currencyExited.CurrencyId.Equals(currencyEntity.CurrencyId)) { response.Acknowledge = AcknowledgeType.Failure; response.Message = @"Mã tiền tệ " + currencyExited.CurrencyCode.Trim() + @" đã tồn tại!"; return(response); } } response.Message = ICurrencyDao.UpdateCurrency(currencyEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.CurrencyId = currencyEntity.CurrencyId; return(response); } catch (Exception ex) { response.Acknowledge = AcknowledgeType.Failure; response.Message = ex.Message; return(response); } }
protected CountryRegionCurrencyEntity(SerializationInfo info, StreamingContext context) : base(info, context) { if (SerializationHelper.Optimization != SerializationOptimization.Fast) { _countryRegion = (CountryRegionEntity)info.GetValue("_countryRegion", typeof(CountryRegionEntity)); if (_countryRegion != null) { _countryRegion.AfterSave += new EventHandler(OnEntityAfterSave); } _currency = (CurrencyEntity)info.GetValue("_currency", typeof(CurrencyEntity)); if (_currency != null) { _currency.AfterSave += new EventHandler(OnEntityAfterSave); } this.FixupDeserialization(FieldInfoProviderSingleton.GetInstance()); } // __LLBLGENPRO_USER_CODE_REGION_START DeserializationConstructor // __LLBLGENPRO_USER_CODE_REGION_END }
public async Task HandleAsync(CurrencyDefaultChanged payload) { using (ReadModelContext db = readModelContextFactory.Create()) { CurrencyEntity entity = db.Currencies.WhereUserKey(payload.UserKey).FirstOrDefault(c => c.IsDefault); if (entity != null) { entity.IsDefault = false; } entity = db.Currencies.WhereUserKey(payload.UserKey).FirstOrDefault(c => c.UniqueCode == payload.UniqueCode); if (entity != null) { entity.IsDefault = true; } await db.SaveChangesAsync(); } }
public async Task Add(ICurrency currency) { using (var context = ContextFactory.CreateDbContext(null)) { var entity = new CurrencyEntity { Id = (int)currency.Code, Code = currency.Code.ToString(), Symbol = currency.Symbol, Label = currency.Label }; if (await context.Currency.FindAsync(entity.Id) == null) { await context.Currency.AddAsync(entity); await context.SaveChangesAsync(); } } }
public CurrencyEntity Get(Currency currency) { var instance = new CurrencyEntity { Base = currency.Base, Date = currency.Date, Rates = new List <RateEntity>(), LocalSavedDate = DateTime.Now }; foreach (var item in currency.Rates) { var rate = new RateEntity { CurrencyName = item.Key, CurrencyRate = item.Value }; instance.Rates.Add(rate); } return(instance); }
public CurrencyEntity GetCurrencyDetail(int StoreId, int LoggedInUserId, int currencyID = 0) { CurrencyEntity CurrencyDetail = new CurrencyEntity(); if (currencyID > 0) { try { SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("StoreId", StoreId); param[1] = new SqlParameter("LoggedInUserId", LoggedInUserId); param[2] = new SqlParameter("currency_id", currencyID); CurrencyDetail = CurrencyEntityGenericRepository.ExecuteSQL <CurrencyEntity>("EXEC GetCurrencyDetails", param).ToList <CurrencyEntity>().FirstOrDefault(); } catch (Exception) { throw; } } return(CurrencyDetail); }
public List <CurrencyEntity> GetCurrency(string connectionString) { List <CurrencyEntity> listCurrency = new List <CurrencyEntity>(); using (var context = new MISAEntity(connectionString)) { var categories = context.CCies.ToList(); foreach (var result in categories) { var currency = new CurrencyEntity { CurrencyCode = result.CurrencyID, CurrencyName = result.CurrencyName, IsMain = result.CurrencyID.Contains("VND"), IsActive = result.Inactive != true }; listCurrency.Add(currency); } } return(listCurrency); }
/// <summary> /// Updates the currency. /// </summary> /// <param name="currency">The currency.</param> /// <returns>System.String.</returns> public string UpdateCurrency(CurrencyEntity currency) { const string sql = "uspUpdate_Currency"; return(Db.Update(sql, true, Take(currency))); }
/// <summary> /// Inserts the currency. /// </summary> /// <param name="currency">The currency.</param> /// <returns>System.Int32.</returns> public string InsertCurrency(CurrencyEntity currency) { const string sql = "uspInsert_Currency"; return(Db.Insert(sql, true, Take(currency))); }
public HttpResponseMessage CreateOrUpdateCurrency(int StoreId, int LoggedInUserId, CurrencyEntity CurrencyEntity) { try { var result = _CurrencyService.CreateOrUpdateCurrency(StoreId, LoggedInUserId, CurrencyEntity); return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception) { throw; } }
/// <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(); }