예제 #1
0
        public async Task <int> RemoveAllAsync(string subjectId, string clientId)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("delete from identityserver ");
                strSql.Append(" where SubjectId=@SubjectId and ClientId=@ClientId");
                MySqlParameter[] parameters =
                {
                    new MySqlParameter("@SubjectId", MySqlDbType.VarChar, 1000),
                    new MySqlParameter("@ClientId",  MySqlDbType.VarChar, 1000)
                };

                parameters[0].Value = subjectId;
                parameters[1].Value = clientId;

                return(await DbHelperMySQL.ExecuteSqlAsync(DBConnection.UsersSystem, strSql.ToString(), parameters));
            }
            catch (Exception err)
            {
                throw err;
            }
        }