public static async Task InsertIfNotExist(MySqlConnection connection, OTIdentity model)
{
var count = await GetCount(connection, model.Identity);
if (count == 0)
{
await Insert(connection, model);
}
}
public static async Task Insert(MySqlConnection connection, OTIdentity model)
{
await connection.ExecuteAsync(
@"INSERT INTO OTIdentity(Identity, TransactionHash, Version, BlockchainID)
VALUES(@Identity, @TransactionHash, @Version, @BlockchainID)",
new
{
model.Identity,
model.TransactionHash,
model.Version,
model.BlockchainID
});
}
public static async Task UpdateLastSyncedTimestamp(MySqlConnection connection, OTIdentity model)
{
await connection.ExecuteAsync(@"UPDATE OTIdentity
SET LastSyncedTimestamp = @LastSyncedTimestamp
WHERE Identity = @Identity AND BlockchainID = @BlockchainID", new
{
model.Identity,
model.LastSyncedTimestamp,
model.BlockchainID
});
}
public static async Task UpdateFromPaidoutAndApprovedCalculation(MySqlConnection connection, OTIdentity model)
{
await connection.ExecuteAsync(@"UPDATE OTIdentity
SET Paidout = @Paidout, Approved = @Approved, ActiveOffers = @ActiveOffers, OffersLast7Days = @OffersLast7Days, TotalOffers = @TotalOffers, ManagementWallet = @ManagementWallet, LastActivityTimestamp = @LastActivityTimestamp
WHERE Identity = @Identity AND BlockchainID = @BlockchainID", new
{
model.Identity,
Paidout = model.Paidout ?? 0,
Approved = model.Approved ?? false,
ActiveOffers = model.ActiveOffers ?? 0,
OffersLast7Days = model.OffersLast7Days ?? 0,
TotalOffers = model.TotalOffers ?? 0,
ManagementWallet = model.ManagementWallet,
model.BlockchainID,
model.LastActivityTimestamp
});
}
public static async Task UpdateFromProfileFunction(MySqlConnection connection, OTIdentity model)
{
await connection.ExecuteAsync(@"UPDATE OTIdentity
SET Stake = @Stake, StakeReserved = @StakeReserved, Reputation = @Reputation, WithdrawalPending = @WithdrawalPending, WithdrawalTimestamp = @WithdrawalTimestamp, WithdrawalAmount = @WithdrawalAmount, NodeId = @NodeId, LastSyncedTimestamp = @LastSyncedTimestamp
WHERE Identity = @Identity AND BlockchainID = @BlockchainID", new
{
model.Identity,
Stake = model.Stake ?? 0,
StakeReserved = model.StakeReserved ?? 0,
model.Reputation,
model.WithdrawalAmount,
model.WithdrawalPending,
model.WithdrawalTimestamp,
model.NodeId,
model.LastSyncedTimestamp,
model.BlockchainID
});
}
