1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
| protected void Button1_Click(object sender, EventArgs e)
{
try
{
//
// Test de NpgsqlMembershipProvider
//
NpgsqlMembershipProvider tester = new NpgsqlMembershipProvider();
NameValueCollection config = new NameValueCollection();
MembershipUser user;
MembershipCreateStatus status;
NpgsqlProviderUserKey provideruserkey;
int tot;
config.Add("applicationName", "/");
config.Add("maxInvalidPasswordAttempts", "5");
config.Add("passwordAttemptWindow", "10");
config.Add("minRequiredNonAlphanumericCharacters", "1");
config.Add("minRequiredPasswordLength", "7");
config.Add("passwordStrengthRegularExpression", "");
config.Add("enablePasswordReset", "true");
config.Add("enablePasswordRetrieval", "true");
config.Add("requiresQuestionAndAnswer", "false");
config.Add("requiresUniqueEmail", "true");
config.Add("passwordFormat", "Encrypted");
config.Add("connectionStringName", "PgsqlLocalServer");
tester.Initialize(null, config);
user = tester.CreateUser("name", "password", "email", "question", "answer", true, null, out status);
switch (status)
{
case MembershipCreateStatus.DuplicateEmail :
throw new Exception("DuplicateEmail");
case MembershipCreateStatus.DuplicateProviderUserKey :
throw new Exception("DuplicateProviderUserKey");
case MembershipCreateStatus.DuplicateUserName :
throw new Exception("DuplicateUserName");
case MembershipCreateStatus.InvalidAnswer :
throw new Exception("InvalidAnswer");
case MembershipCreateStatus.InvalidEmail :
throw new Exception("InvalidEmail");
case MembershipCreateStatus.InvalidPassword :
throw new Exception("InvalidPassword");
case MembershipCreateStatus.InvalidProviderUserKey :
throw new Exception("InvalidProviderUserKey");
case MembershipCreateStatus.InvalidQuestion :
throw new Exception("InvalidQuestion");
case MembershipCreateStatus.InvalidUserName :
throw new Exception("InvalidUserName");
case MembershipCreateStatus.ProviderError :
throw new Exception("ProviderError");
case MembershipCreateStatus.UserRejected :
throw new Exception("UserRejected");
}
tester.ChangePassword("name", "password", "newone");
tester.ChangePasswordQuestionAndAnswer("name", "newone", "pouet", "pouetpouet");
tester.FindUsersByEmail("email", 0, 1, out tot);
tester.FindUsersByName("name", 0, 1, out tot);
tester.GetAllUsers(0, 10, out tot);
tester.GetNumberOfUsersOnline();
tester.GetPassword("name", "pouetpouet");
provideruserkey = new NpgsqlProviderUserKey();
provideruserkey.UserName = "name";
provideruserkey.ApplicationName = "/";
tester.GetUser(provideruserkey, false);
tester.GetUserNameByEmail("email");
tester.ResetPassword("name", "pouetpouet");
tester.UnlockUser("name");
tester.UpdateUser(user);
tester.ValidateUser("name", "newone");
//
// Test de NpgsqlRoleProvider
//
NpgsqlRoleProvider role = new NpgsqlRoleProvider();
role.Initialize("NpgsqlRoleProvider", config);
role.CreateRole("role");
string[] users = { "name" };
string[] roles = { "role" };
role.AddUsersToRoles(users, roles);
role.FindUsersInRole("role", "name");
role.GetAllRoles();
role.GetRolesForUser("name");
role.GetUsersInRole("admin");
role.IsUserInRole("name", "admin");
role.RemoveUsersFromRoles(users, roles);
role.RoleExists("role");
role.DeleteRole("role", true);
tester.DeleteUser("name", true);
Resultm.Text = "c'est tout bon :)";
}
catch (NpgsqlException n)
{
Resultm.Text = n.Line + " : " + n.Message;
}
} |
