public override string[] GetRolesForUser(string username) { if (!Initialized) { return(_prevProvider.GetRolesForUser(username)); } if (string.IsNullOrEmpty(username)) { MySqlSimpleMembershipProvider.NullArgumentException("username"); } string connString = ConnectionString; int userid = MySqlSimpleMembershipProvider.GetUserId(username, connString, UserTableName, UserIdColumn, UserNameColumn); if (userid > 0) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(connString)) { var roles = dbConn.ExecuteQuery(string.Format("select rt.rolename from {0} as urt join {1} as rt on urt.roleid = rt.roleid where urt.userid=?;", _userInRolesTable, _rolesTable), userid); if (roles.Count() > 0) { return(roles.Select(role => role[0].ToString()).ToArray()); } } } return(null); }
private bool UserHasRole(int userid, int roleid) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { return(dbConn.ExecuteQuery(string.Format("select count(*) from {0} where userid=? and roleid=?;", _userInRolesTable), userid, roleid).Count() > 0); } }
public override string[] GetUsersInRole(string roleName) { if (!Initialized) { return(_prevProvider.GetUsersInRole(roleName)); } if (string.IsNullOrEmpty(roleName)) { MySqlSimpleMembershipProvider.NullArgumentException("roleName"); } int roleid = GetRoleId(roleName); if (roleid > 0) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(ConnectionString)) { var users = dbConn.ExecuteQuery(string.Format("select ut.{0} from {1} as urt join {2} as ut on urt.userid = ut.{3} where urt.roleid=?;", UserNameColumn, _userInRolesTable, UserTableName, UserIdColumn), roleid); if (users.Count() > 0) { return(users.Select(role => role[0].ToString()).ToArray()); } } } return(null); }
public override bool IsUserInRole(string username, string roleName) { if (!Initialized) { return(_prevProvider.IsUserInRole(username, roleName)); } string connString = ConnectionString; if (string.IsNullOrEmpty(username)) { MySqlSimpleMembershipProvider.NullArgumentException("username"); } if (string.IsNullOrEmpty(roleName)) { MySqlSimpleMembershipProvider.NullArgumentException("roleName"); } int userid = MySqlSimpleMembershipProvider.GetUserId(username, connString, UserTableName, UserIdColumn, UserNameColumn); int roleid = GetRoleId(roleName); if (userid <= 0 || roleid <= 0) { return(false); } using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(connString)) { return((dbConn.ExecuteQuery(string.Format("select count(userid) from {0} where userid=? and roleid=?;", _userInRolesTable), userid, roleid)).Count() > 0); } }
private bool IsRoleInUse(int roleid) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(ConnectionString)) { return(dbConn.ExecuteQuery(string.Format("select count(*) from {0} where roleid=?;", _userInRolesTable), roleid).Count() > 0); } }
public override string[] FindUsersInRole(string roleName, string usernameToMatch) { if (!Initialized) { return(_prevProvider.FindUsersInRole(roleName, usernameToMatch)); } if (string.IsNullOrEmpty(roleName)) { MySqlSimpleMembershipProvider.NullArgumentException("roleName"); } if (string.IsNullOrEmpty(usernameToMatch)) { return(GetUsersInRole(roleName)); } using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(ConnectionString)) { var usersName = dbConn.ExecuteQuery(string.Format("select ut.{0} from {1} as rt join {2} as urt on rt.roleid=urt.roleid join {3} as ut on rt.userid=ut.{4} where rt.rolename=? and ut.name like '%?%'", UserNameColumn, _rolesTable, _userInRolesTable, UserTableName, UserIdColumn), roleName, usernameToMatch); if (usersName.Count() > 0) { return(usersName.Select(username => username[0].ToString()).ToArray()); } } return(null); }
internal static bool VerifyIfTableExists(string connectionString, string tableName) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(connectionString)) { var tables = dbConn.ExecuteQuery("show tables;"); return(tables.Where(record => record[0].ToString().Equals(tableName, StringComparison.OrdinalIgnoreCase)).Count() > 0); } }
public override bool HasLocalAccount(int userId) { IsValidOperation(true); using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { return(dbConn.ExecuteQuery(string.Format("select userid from {0} where userid=?;", _membershipTable), userId).Count() > 0); } }
public override string[] GetAllRoles() { if (!Initialized) { return(_prevProvider.GetAllRoles()); } using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(ConnectionString)) { var roles = dbConn.ExecuteQuery(string.Format("select rolename from {0};", _rolesTable)); if (roles.Count() > 0) { return(roles.Select(role => role[0].ToString()).ToArray()); } } return(null); }
public override ICollection <OAuthAccountData> GetAccountsForUser(string userName) { IsValidOperation(true); int userid = GetUserId(userName); if (userid > 0) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { var records = dbConn.ExecuteQuery(string.Format("select provider, provideruserid from {0} where userid=?", _oauthMembershipTable), userid); if (records != null && records.Count() > 0) { var accounts = new List <OAuthAccountData>(); records.ToList().ForEach(record => accounts.Add(new OAuthAccountData(record["provider"].ToString(), record["provideruserid"].ToString()))); return(accounts); } } } return(new OAuthAccountData[0]); }
public override string[] GetRolesForUser(string username) { if (!Initialized) return _prevProvider.GetRolesForUser(username); if (string.IsNullOrEmpty(username)) MySqlSimpleMembershipProvider.NullArgumentException("username"); string connString = GetConnectionString(); int userid = MySqlSimpleMembershipProvider.GetUserId(username, connString, UserTableName, UserIdColumn, UserNameColumn); if (userid > 0) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(connString)) { var roles = dbConn.ExecuteQuery(string.Format("select rt.rolename from {0} as urt join {1} as rt on urt.roleid = rt.roleid where urt.userid=?;", _userInRolesTable, _rolesTable), userid); if (roles.Count() > 0) return roles.Select(role => role[0].ToString()).ToArray(); } } return null; }
public override ICollection<OAuthAccountData> GetAccountsForUser(string userName) { IsValidOperation(true); int userid = GetUserId(userName); if (userid > 0) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { var records = dbConn.ExecuteQuery(string.Format("select provider, provideruserid from {0} where userid=?", _oauthMembershipTable), userid); if (records != null && records.Count() > 0) { var accounts = new List<OAuthAccountData>(); records.ToList().ForEach(record => accounts.Add(new OAuthAccountData(record["provider"].ToString(), record["provideruserid"].ToString()))); return accounts; } } } return new OAuthAccountData[0]; }
public override string[] GetUsersInRole(string roleName) { if (!Initialized) return _prevProvider.GetUsersInRole(roleName); if (string.IsNullOrEmpty(roleName)) MySqlSimpleMembershipProvider.NullArgumentException("roleName"); int roleid = GetRoleId(roleName); if (roleid > 0) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { var users = dbConn.ExecuteQuery(string.Format("select ut.{0} from {1} as urt join {2} as ut on urt.userid = ut.{3} where urt.roleid=?;", UserNameColumn, _userInRolesTable, UserTableName, UserIdColumn), roleid); if (users.Count() > 0) return users.Select(role => role[0].ToString()).ToArray(); } } return null; }
public override bool IsUserInRole(string username, string roleName) { if (!Initialized) return _prevProvider.IsUserInRole(username, roleName); string connString = GetConnectionString(); if (string.IsNullOrEmpty(username)) MySqlSimpleMembershipProvider.NullArgumentException("username"); if (string.IsNullOrEmpty(roleName)) MySqlSimpleMembershipProvider.NullArgumentException("roleName"); int userid = MySqlSimpleMembershipProvider.GetUserId(username, connString, UserTableName, UserIdColumn, UserNameColumn); int roleid = GetRoleId(roleName); if (userid <= 0 || roleid <= 0) return false; using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(connString)) { return (dbConn.ExecuteQuery(string.Format("select count(userid) from {0} where userid=? and roleid=?;", _userInRolesTable), userid, roleid)).Count() > 0; } }
private bool IsRoleInUse(int roleid) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { return (dbConn.ExecuteQuery(string.Format("select count(*) from {0} where roleid=?;", _userInRolesTable), roleid).Count() > 0); } }
public override bool HasLocalAccount(int userId) { IsValidOperation(true); using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { return (dbConn.ExecuteQuery(string.Format("select userid from {0} where userid=?;", _membershipTable), userId).Count() > 0); } }
public override string[] GetAllRoles() { if (!Initialized) return _prevProvider.GetAllRoles(); using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { var roles = dbConn.ExecuteQuery(string.Format("select rolename from {0};", _rolesTable)); if (roles.Count() > 0) return roles.Select(role => role[0].ToString()).ToArray(); } return null; }
internal static bool VerifyIfTableExists(string connectionString, string tableName) { using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(connectionString)) { var tables = dbConn.ExecuteQuery("show tables;"); return tables.Where(record => record[0].ToString().Equals(tableName, StringComparison.OrdinalIgnoreCase)).Count() > 0; } }
public override string[] FindUsersInRole(string roleName, string usernameToMatch) { if (!Initialized) { return _prevProvider.FindUsersInRole(roleName, usernameToMatch); } if (string.IsNullOrEmpty(roleName)) MySqlSimpleMembershipProvider.NullArgumentException("roleName"); if (string.IsNullOrEmpty(usernameToMatch)) return GetUsersInRole(roleName); using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString())) { var usersName = dbConn.ExecuteQuery(string.Format("select ut.{0} from {1} as rt join {2} as urt on rt.roleid=urt.roleid join {3} as ut on rt.userid=ut.{4} where rt.rolename=? and ut.name like '%?%'", UserNameColumn, _rolesTable, _userInRolesTable, UserTableName, UserIdColumn), roleName, usernameToMatch); if (usersName.Count() > 0) return usersName.Select(username => username[0].ToString()).ToArray(); } return null; }