public override void Up() { var user = M3User.Create(UserName, DevPassword, "Customer", new M1Profile() { Email = "*****@*****.**", FirstName = "Chuck", LastName = "Norris", PhoneNumber = "+375296140302", PhoneNumberConfirmed = true } ); InsertUser(user); InsertClaims(user); InsertProfile(user); Execute.WithConnection((connection, transaction) => { var nowUtc = DateTime.UtcNow; var expireUtc = nowUtc.AddYears(10); var id = GetUserId(connection, transaction, UserName); var accountNo = "3014" + Seed.RandomStringOfNumbers(9); var account = M2Account.Create(accountNo, "USD", 999999999, nowUtc, expireUtc, "CardAccount"); var card1 = M2Card.Create(accountNo, id, UserName); var card2 = M2Card.Create(accountNo, id, UserName); InsertAccount(account, connection, transaction); InsertUserAccount(account.ToUserAccount(id), connection, transaction); InsertCard(card1, connection, transaction); InsertCard(card2, connection, transaction); }); }
public static M2Card Create(string accountNo, Guid userId, string userName) { return(new M2Card { CardId = Guid.NewGuid(), AccountNo = accountNo, UserId = userId, CardVendorId = "visa", ExpirationDateUtc = DateTime.Today.AddDays(360), HolderFirstName = userName.ToUpper(), HolderLastName = new string(userName.Reverse().ToArray()).ToUpper(), CardNo = "4666" + Seed.RandomStringOfNumbers(2) + "00" + Seed.RandomStringOfNumbers(8) }); }
public override void Up() { Execute.WithConnection((connection, transaction) => { var nowUtc = DateTime.UtcNow; var expireUtc = nowUtc.AddYears(1); foreach (var idPair in GetUserIdPairs(connection, transaction)) { var accountNo = "3014" + Seed.RandomStringOfNumbers(9); var account = M2Account.Create(accountNo, "USD", 10000, nowUtc, expireUtc, "CardAccount"); var card = M2Card.Create(accountNo, idPair.UserId, idPair.UserName); InsertAccount(account, connection, transaction); InsertUserAccount(account.ToUserAccount(idPair.UserId), connection, transaction); InsertCard(card, connection, transaction); } }); }
public override void Up() { Execute.WithConnection((connection, transaction) => { var userId = connection.Query <Guid>("SELECT [UserID] FROM [Membership].[User] WHERE [UserName] = @UserName", new { UserName = "******" }, transaction).First(); var accountParams = new { AccountNo = "3014" + Seed.RandomStringOfNumbers(9), CurrencyISOName = "USD", Balance = 10000m, OpenDateUtc = new DateTime(2014, 09, 1), ExpirationDateUtc = new DateTime(2015, 2, 1), Type = "CardAccount" }; connection.Execute(@"INSERT INTO [Accounting].[Account] ([AccountNo], [CurrencyISOName], [Balance], [OpenDateUtc], [ExpirationDateUtc], [Type]) " + "VALUES (@AccountNo, @CurrencyISOName, @Balance, @OpenDateUtc, @ExpirationDateUtc, @Type)", accountParams, transaction); connection.Execute(@"INSERT INTO [Accounting].[User_Account] ([AccountNo], [UserID]) VALUES (@AccountNo, @UserID)", new { AccountNo = accountParams.AccountNo, UserID = userId }, transaction); var cardParams = new { CardId = Guid.NewGuid(), CardNo = "4666" + Seed.RandomStringOfNumbers(2) + "00" + Seed.RandomStringOfNumbers(8), CardVendorId = "visa", HolderFirstName = "TERMINATOR", HolderLastName = "TERMINATOV", ExpirationDateUtc = new DateTime(2014, 12, 1) }; connection.Execute("INSERT INTO [Accounting].[Card] ([CardId], [CardNo], [CardVendorId], [HolderFirstName], [HolderLastName], [ExpirationDateUtc]) " + "VALUES (@CardId, @CardNo, @CardVendorId, @HolderFirstName, @HolderLastName, @ExpirationDateUtc)", cardParams, transaction); connection.Execute("INSERT INTO [Accounting].[User_Card_Account] ([CardId], [UserId], [AccountNo]) VALUES (@CardId, @UserId, @AccountNo)", new { CardId = cardParams.CardId, UserId = userId, AccountNo = accountParams.AccountNo }, transaction); connection.Execute("INSERT INTO [Accounting].[CardSettings] ([CardId], [Blocked], [LimitOperationsPerDayLocal], [LimitOperationsPerDayAbroad], [LimitAmountPerDayLocal], [LimitAmountPerDayAbroad]) " + "VALUES (@CardId, 0, 20, 10, 1000.0, 500.0)", new { CardId = cardParams.CardId }, transaction); }); }