// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.\r
//\r
\r
-#if NET_2_0\r
\r
using System;\r
using System.Web.Security;\r
string querySelect = "SELECT RoleName FROM aspnet_Roles WHERE ApplicationId = ? AND LoweredRoleName = ?";\r
OleDbCommand cmdSelect = new OleDbCommand (querySelect, (OleDbConnection) connection);\r
AddParameter (cmdSelect, "ApplicationId", appId);\r
- AddParameter (cmdSelect, "LoweredRoleName", rolename.ToLower ());\r
+ AddParameter (cmdSelect, "LoweredRoleName", rolename.ToLowerInvariant ());\r
\r
using (OleDbDataReader reader = cmdSelect.ExecuteReader ()) {\r
if (reader.Read ())\r
AddParameter (cmdInsert, "ApplicationId", appId);\r
AddParameter (cmdInsert, "RoleId", Guid.NewGuid ().ToString ());\r
AddParameter (cmdInsert, "RoleName", rolename);\r
- AddParameter (cmdInsert, "LoweredRoleName", rolename.ToLower ());\r
+ AddParameter (cmdInsert, "LoweredRoleName", rolename.ToLowerInvariant ());\r
cmdInsert.ExecuteNonQuery ();\r
\r
return 0;\r
string querySelect = "SELECT RoleName FROM aspnet_Roles WHERE ApplicationId = ? AND LoweredRoleName = ?";\r
OleDbCommand cmdSelect = new OleDbCommand (querySelect, (OleDbConnection) connection);\r
AddParameter (cmdSelect, "ApplicationId", appId);\r
- AddParameter (cmdSelect, "LoweredRoleName", rolename.ToLower ());\r
+ AddParameter (cmdSelect, "LoweredRoleName", rolename.ToLowerInvariant ());\r
\r
using (OleDbDataReader reader = cmdSelect.ExecuteReader ()) {\r
if (reader.Read ())\r
OleDbCommand cmdSelUsers = new OleDbCommand (querySelUsers, (OleDbConnection) connection);\r
AddParameter (cmdSelUsers, "ApplicationId", appId);\r
for (int i = 0; i < userNames.Length; i++)\r
- AddParameter (cmdSelUsers, "LoweredUserName", userNames [i].ToLower ());\r
+ AddParameter (cmdSelUsers, "LoweredUserName", userNames [i].ToLowerInvariant ());\r
\r
int userIndex = 0;\r
using (OleDbDataReader reader = cmdSelUsers.ExecuteReader ()) {\r
if (userNames.Length != userIndex) {\r
// find not existing users and create them\r
for (int j = 0; j < userNames.Length; j++)\r
- if (Array.IndexOf (loweredUsernames, userNames [j].ToLower ()) < 0) {\r
+ if (Array.IndexOf (loweredUsernames, userNames [j].ToLowerInvariant ()) < 0) {\r
string newUserId = Guid.NewGuid ().ToString ();\r
string queryAddUser = "INSERT INTO aspnet_Users (ApplicationId, UserId, UserName, " +\r
"LoweredUserName, IsAnonymous, LastActivityDate) VALUES (?, ?, ?, ?, ?, ?)";\r
AddParameter (cmdAddUser, "ApplicationId", appId);\r
AddParameter (cmdAddUser, "UserId", newUserId);\r
AddParameter (cmdAddUser, "UserName", userNames [j]);\r
- AddParameter (cmdAddUser, "LoweredUserName", userNames [j].ToLower ());\r
+ AddParameter (cmdAddUser, "LoweredUserName", userNames [j].ToLowerInvariant ());\r
AddParameter (cmdAddUser, "IsAnonymous", 0);\r
AddParameter (cmdAddUser, "LastActivityDate", DateTime.UtcNow);\r
cmdAddUser.ExecuteNonQuery ();\r
OleDbCommand cmdSelRoles = new OleDbCommand (querySelRoles, (OleDbConnection) connection);\r
AddParameter (cmdSelRoles, "ApplicationId", appId);\r
for (int i = 0; i < roleNames.Length; i++)\r
- AddParameter (cmdSelRoles, "LoweredRoleName", roleNames [i].ToLower ());\r
+ AddParameter (cmdSelRoles, "LoweredRoleName", roleNames [i].ToLowerInvariant ());\r
\r
using (OleDbDataReader reader = cmdSelRoles.ExecuteReader ()) {\r
int i = 0;\r
if (roleId == null)\r
return 2;\r
\r
- string querySelect = "SELECT usr.UserName FROM aspnet_Users usr, aspnet_UsersInRoles uir " +
- "WHERE usr.UserId = uir.UserId AND usr.ApplicationId = ? AND uir.RoleId = ? AND LoweredUserName LIKE ? " +
+ string querySelect = "SELECT usr.UserName FROM aspnet_Users usr, aspnet_UsersInRoles uir " +\r
+ "WHERE usr.UserId = uir.UserId AND usr.ApplicationId = ? AND uir.RoleId = ? AND LoweredUserName LIKE ? " +\r
"ORDER BY usr.UserName";\r
OleDbCommand cmdSelect = new OleDbCommand (querySelect, (OleDbConnection) connection);\r
AddParameter (cmdSelect, "ApplicationId", appId);\r
AddParameter (cmdSelect, "RoleId", roleId);\r
- AddParameter (cmdSelect, "LoweredUserName", "%" + userNameToMatch.ToLower() + "%");\r
+ AddParameter (cmdSelect, "LoweredUserName", "%" + userNameToMatch.ToLowerInvariant() + "%");\r
reader = cmdSelect.ExecuteReader ();\r
\r
return 0;\r
OleDbCommand cmdSelUsers = new OleDbCommand (querySelUsers, (OleDbConnection) connection);\r
AddParameter (cmdSelUsers, "ApplicationId", appId);\r
for (int i = 0; i < userNames.Length; i++)\r
- AddParameter (cmdSelUsers, "LoweredUserName", userNames [i].ToLower ());\r
+ AddParameter (cmdSelUsers, "LoweredUserName", userNames [i].ToLowerInvariant ());\r
\r
using (OleDbDataReader reader = cmdSelUsers.ExecuteReader ()) {\r
int i = 0;\r
OleDbCommand cmdSelRoles = new OleDbCommand (querySelRoles, (OleDbConnection) connection);\r
AddParameter (cmdSelRoles, "ApplicationId", appId);\r
for (int i = 0; i < roleNames.Length; i++)\r
- AddParameter (cmdSelRoles, "LoweredRoleName", roleNames [i].ToLower ());\r
+ AddParameter (cmdSelRoles, "LoweredRoleName", roleNames [i].ToLowerInvariant ());\r
\r
using (OleDbDataReader reader = cmdSelRoles.ExecuteReader ()) {\r
int i = 0;\r
string selectQuery = "SELECT RoleId FROM aspnet_Roles WHERE LoweredRoleName = ? AND ApplicationId = ?";\r
\r
OleDbCommand selectCmd = new OleDbCommand (selectQuery, (OleDbConnection) connection);\r
- AddParameter (selectCmd, "LoweredRoleName", rolename.ToLower ());\r
+ AddParameter (selectCmd, "LoweredRoleName", rolename.ToLowerInvariant ());\r
AddParameter (selectCmd, "ApplicationId", applicationId);\r
using (OleDbDataReader reader = selectCmd.ExecuteReader ()) {\r
if (reader.Read ())\r
string selectQuery = "SELECT UserId FROM aspnet_Users WHERE LoweredUserName = ? AND ApplicationId = ?";\r
\r
OleDbCommand selectCmd = new OleDbCommand (selectQuery, (OleDbConnection) connection);\r
- AddParameter (selectCmd, "LoweredUserName", username.ToLower ());\r
+ AddParameter (selectCmd, "LoweredUserName", username.ToLowerInvariant ());\r
AddParameter (selectCmd, "ApplicationId", applicationId);\r
using (OleDbDataReader reader = selectCmd.ExecuteReader ()) {\r
if (reader.Read ())\r
}\r
}\r
\r
-#endif
\ No newline at end of file