public override bool IsUserInRole(string username, string rolename) { var parameters = new[] { new MySqlParameter("?rolename", rolename), new MySqlParameter("?username", username) }; var obj = _helper.ExecuteOdbcScalar("SELECT COUNT(*) FROM `Users` U JOIN `UserRoles` UR ON (U.`id_user` = UR.`id_user`) JOIN `Roles` R ON (R.`id_role` = UR.`id_role`) WHERE R.`name` = ?rolename AND U.`userName` = ?username; ", parameters); return(obj != DBNull.Value ? Convert.ToInt32(obj) > 0 : false); }
// // MembershipProvider.GetNumberOfUsersOnline // public override int GetNumberOfUsersOnline() { var onlineSpan = new TimeSpan(0, Membership.UserIsOnlineTimeWindow, 0); DateTime compareTime = DateTime.Now.Subtract(onlineSpan); var parameters = new[] { new MySqlParameter("?lActiveDate", compareTime) }; var result = _helper.ExecuteOdbcScalar("SELECT COUNT(*) FROM `Users` WHERE `lastActivityDate` > ?lActiveDate;", parameters); return(result != DBNull.Value ? Convert.ToInt32(result) : 0); }