public AlertMsg DeleteSymmetricCryptoKey(long cryptoKeyID)
{
var helper = new SQLiteHelper();
var idParam = new SQLiteParameter("id", cryptoKeyID);
var effResult = helper.ExecNonQuery("DELETE FROM OAuthSymmetricCryptoKey WHERE ID = @id;", idParam);
AlertMsg result = effResult;
result.IsSuccess = effResult.EffectLines == 1;
return(result);
}
public AlertMsg AddOAuthUsers(OAuthUsers user)
{
var helper = new SQLiteHelper();
var claimedParam = new SQLiteParameter("claimed", user.Claimed);
var friendlyParam = new SQLiteParameter("friendly", user.Friendly);
var effResult = helper.ExecNonQuery("INSERT INTO OAuthUsers(Claimed, Friendly) VALUES(@claimed, @friendly)", claimedParam, friendlyParam);
AlertMsg result = effResult;
result.IsSuccess = effResult.EffectLines == 1;
return(result);
}
public AlertMsg AddOAuthNonce(OAuthNonce nonce)
{
var helper = new SQLiteHelper();
var contextParam = new SQLiteParameter("context", nonce.Context);
var codeParam = new SQLiteParameter("code", nonce.Code);
var timeParam = new SQLiteParameter("time", nonce.Time.Ticks);
var effResult = helper.ExecNonQuery("INSERT INTO OAuthNonce (Context, Code, Time) VALUES (@context, @code, @time);", contextParam, codeParam, timeParam);
AlertMsg result = effResult;
result.IsSuccess = effResult.EffectLines == 1;
return(result);
}
public AlertMsg AddOAuthSymmetricCryptoKey(OAuthSymmetricCryptoKey cryptoKey)
{
var helper = new SQLiteHelper();
var bucketParam = new SQLiteParameter("bucket", cryptoKey.Bucket);
var handleParam = new SQLiteParameter("handle", cryptoKey.Handle);
var secretParam = new SQLiteParameter("secret", Encoding.Unicode.GetString(cryptoKey.Secret));
var expiresUtcParam = new SQLiteParameter("expiresUtc", cryptoKey.ExpiresUtc.Ticks);
var effResult = helper.ExecNonQuery("INSERT INTO OAuthSymmetricCryptoKey (Bucket, Handle, Secret, ExpiresUtc) VALUES (@bucket, @handle, @secret, @expiresUtc);", bucketParam, handleParam, secretParam, expiresUtcParam);
AlertMsg result = effResult;
result.IsSuccess = effResult.EffectLines == 1;
return(result);
}
public AlertMsg AddOAuthClientAuthor(OAuthClientAuthor client)
{
var helper = new SQLiteHelper();
var clientIdParam = new SQLiteParameter("clientId", client.ClientID);
var userIdParam = new SQLiteParameter("userId", client.UserID);
var scopeParam = new SQLiteParameter("scope", client.Scope);
var expireUtcParam = new SQLiteParameter("expireUtc", client.ExpireUtc.Ticks);
var timeParam = new SQLiteParameter("time", client.Time.Ticks);
var effResult = helper.ExecNonQuery("INSERT INTO OAuthClientAuthor (ClientId, UserId, Scope, ExpireUtc, Time) VALUES (@clientId, @userId, @scope, @expireUtc, @time);", clientIdParam, userIdParam, scopeParam, expireUtcParam, timeParam);
AlertMsg result = effResult;
result.IsSuccess = effResult.EffectLines == 1;
return(result);
}
public AlertMsg AddOAuthClient(OAuthClient client)
{
var helper = new SQLiteHelper();
var clientParam = new SQLiteParameter("client", client.Client);
var secretParam = new SQLiteParameter("secret", client.Secret);
var callbackParam = new SQLiteParameter("callback", client.Callback);
var nameParam = new SQLiteParameter("name", client.Name);
var typeParam = new SQLiteParameter("type", client.Type);
var timeParam = new SQLiteParameter("time", client.Time.Ticks);
var effResult = helper.ExecNonQuery("INSERT INTO OAuthClient(Client, Secret, Callback, Name, Type, Time) VALUES(@client, @secret, @callback, @name, @type, @time)", clientParam, secretParam, callbackParam, nameParam, typeParam, timeParam);
AlertMsg result = effResult;
result.IsSuccess = effResult.EffectLines == 1;
return(result);
}