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);
});
}
private void InsertClaims(M3User user)
{
foreach (var claim in user.Claims)
{
Insert.IntoTable("UserClaim").InSchema("Membership").Row(new
{
UserId = user.UserId,
Type = claim.Type,
Value = claim.Value
});
}
}
private void InsertProfile(M3User user)
{
if (user.Profile != null)
{
Insert.IntoTable("UserProfile").InSchema("Membership").Row(new
{
UserId = user.UserId,
FirstName = new ExplicitUnicodeString(user.Profile.FirstName),
LastName = new ExplicitUnicodeString(user.Profile.LastName),
Email = user.Profile.Email,
PhoneNumber = user.Profile.PhoneNumber,
SecretPhrase = new ExplicitUnicodeString(user.Profile.SecretPhrase),
PhoneNumberConfirmed = user.Profile.PhoneNumberConfirmed
});
}
}
public static M3User Create(string login, string password, string role, M1Profile profile = null)
{
var user = new M3User
{
UserId = Guid.NewGuid(),
UserName = login,
Password = Password.Create(password),
Claims = new List<Claim>
{
new Claim(ClaimTypes.Name, login),
new Claim(ClaimTypes.Role, role)
},
Profile = profile
};
user.Claims.Add(new Claim(ClaimTypes.Sid, user.UserId.ToString()));
var credentials = user.Claims.OrderBy(x => x.Type).Select(x => x.ToString());
return user;
}
public static M3User Create(string login, string password, string role, M1Profile profile = null)
{
var user = new M3User
{
UserId = Guid.NewGuid(),
UserName = login,
Password = Password.Create(password),
Claims = new List <Claim>
{
new Claim(ClaimTypes.Name, login),
new Claim(ClaimTypes.Role, role)
},
Profile = profile
};
user.Claims.Add(new Claim(ClaimTypes.Sid, user.UserId.ToString()));
var credentials = user.Claims.OrderBy(x => x.Type).Select(x => x.ToString());
return(user);
}
private void InsertUser(M3User user)
{
Insert.IntoTable("User").InSchema("Membership").Row(user.ToTableRow());
}
private void InsertProfile(M3User user)
{
if (user.Profile != null)
{
Insert.IntoTable("UserProfile").InSchema("Membership").Row(new
{
UserId = user.UserId,
FirstName = new ExplicitUnicodeString(user.Profile.FirstName),
LastName = new ExplicitUnicodeString(user.Profile.LastName),
Email = user.Profile.Email,
PhoneNumber = user.Profile.PhoneNumber,
SecretPhrase = new ExplicitUnicodeString(user.Profile.SecretPhrase),
PhoneNumberConfirmed = user.Profile.PhoneNumberConfirmed
});
}
}
private void InsertClaims(M3User user)
{
foreach (var claim in user.Claims)
{
Insert.IntoTable("UserClaim").InSchema("Membership").Row(new
{
UserId = user.UserId,
Type = claim.Type,
Value = claim.Value
});
}
}
private void InsertUser(M3User user)
{
Insert.IntoTable("User").InSchema("Membership").Row(user.ToTableRow());
}
