public static IDataReader GetAccessTokenByAccessToken(Guid accessToken, AccessTokenTypes type) { return SqlHelper.ExecuteReader( ConnectionString, CommandType.StoredProcedure, "GetAccessTokenByAccessToken", new SqlParameter("@AccessToken", accessToken), new SqlParameter("@TokenType", type) ); }
public static void DeleteAccessToken(Guid accessToken, AccessTokenTypes type) { SqlHelper.ExecuteNonQuery( ConnectionString, CommandType.StoredProcedure, "DeleteAccessToken", new SqlParameter("@AccessToken", accessToken), new SqlParameter("@TokenType", type) ); }
public static int AddAccessToken(Guid accessToken, int accountId, int itemId, DateTime expirationDate, AccessTokenTypes type) { SqlParameter prmId = new SqlParameter("@TokenID", SqlDbType.Int); prmId.Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery( ConnectionString, CommandType.StoredProcedure, "AddAccessToken", prmId, new SqlParameter("@AccessToken", accessToken), new SqlParameter("@ExpirationDate", expirationDate), new SqlParameter("@AccountID", accountId), new SqlParameter("@ItemId", itemId), new SqlParameter("@TokenType", (int)type) ); // read identity return Convert.ToInt32(prmId.Value); }