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