public void Insert(AccessTokenInfo accessTokenInfo) { var token = TranslateUtils.EncryptStringBySecretKey(StringUtils.Guid()); var sqlString = $@"INSERT INTO {TableName} ({nameof(AccessTokenInfo.Title)}, {nameof(AccessTokenInfo.Token)}, {nameof(AccessTokenInfo.Scopes)}, {nameof(AccessTokenInfo.RateLimit)}, {nameof(AccessTokenInfo.AddDate)}, {nameof(AccessTokenInfo.UpdatedDate)}) VALUES (@{nameof(AccessTokenInfo.Title)}, @{nameof(AccessTokenInfo.Token)}, @{nameof(AccessTokenInfo.Scopes)}, @{nameof(AccessTokenInfo.RateLimit)}, @{nameof(AccessTokenInfo.AddDate)}, @{nameof(AccessTokenInfo.UpdatedDate)})"; IDataParameter[] parameters = { GetParameter(nameof(accessTokenInfo.Title), DataType.VarChar, 200, accessTokenInfo.Title), GetParameter(nameof(accessTokenInfo.Token), DataType.VarChar, 200, token), GetParameter(nameof(accessTokenInfo.Scopes), DataType.VarChar, 200, accessTokenInfo.Scopes), GetParameter(nameof(accessTokenInfo.RateLimit), DataType.Integer, accessTokenInfo.RateLimit), GetParameter(nameof(accessTokenInfo.AddDate), DataType.DateTime, DateTime.Now), GetParameter(nameof(accessTokenInfo.UpdatedDate), DataType.DateTime, DateTime.Now) }; ExecuteNonQuery(sqlString, parameters); AccessTokenManager.ClearCache(); }
public void Delete(int id) { if (id <= 0) { return; } var sqlString = $"DELETE FROM {TableName} WHERE {nameof(AccessTokenInfo.Id)} = {id}"; ExecuteNonQuery(sqlString); AccessTokenManager.ClearCache(); }
public string Regenerate(int id) { var token = TranslateUtils.EncryptStringBySecretKey(StringUtils.Guid()); var sqlString = $@"UPDATE {TableName} SET {nameof(AccessTokenInfo.Token)} = @{nameof(AccessTokenInfo.Token)}, {nameof(AccessTokenInfo.UpdatedDate)} = @{nameof(AccessTokenInfo.UpdatedDate)} WHERE {nameof(AccessTokenInfo.Id)} = @{nameof(AccessTokenInfo.Id)}"; IDataParameter[] parameters = { GetParameter(nameof(AccessTokenInfo.Token), DataType.VarChar, 200, token), GetParameter(nameof(AccessTokenInfo.UpdatedDate), DataType.DateTime, DateTime.Now), GetParameter(nameof(AccessTokenInfo.Id), DataType.Integer, id) }; ExecuteNonQuery(sqlString, parameters); AccessTokenManager.ClearCache(); return(token); }
public void Update(AccessTokenInfo accessTokenInfo) { var sqlString = $@"UPDATE {TableName} SET {nameof(AccessTokenInfo.Title)} = @{nameof(AccessTokenInfo.Title)}, {nameof(AccessTokenInfo.Scopes)} = @{nameof(AccessTokenInfo.Scopes)}, {nameof(AccessTokenInfo.RateLimit)} = @{nameof(AccessTokenInfo.RateLimit)}, {nameof(AccessTokenInfo.UpdatedDate)} = @{nameof(AccessTokenInfo.UpdatedDate)} WHERE {nameof(AccessTokenInfo.Id)} = @{nameof(AccessTokenInfo.Id)}"; IDataParameter[] parameters = { GetParameter(nameof(accessTokenInfo.Title), DataType.VarChar, 200, accessTokenInfo.Title), GetParameter(nameof(accessTokenInfo.Scopes), DataType.VarChar, 200, accessTokenInfo.Scopes), GetParameter(nameof(accessTokenInfo.RateLimit), DataType.VarChar, 200, accessTokenInfo.RateLimit), GetParameter(nameof(accessTokenInfo.UpdatedDate), DataType.DateTime, DateTime.Now), GetParameter(nameof(accessTokenInfo.Id), DataType.Integer, accessTokenInfo.Id) }; ExecuteNonQuery(sqlString, parameters); AccessTokenManager.ClearCache(); }