public static void Insert(MySqlConnection connection, OTContract_Profile_IdentityCreated model)
{
connection.Execute("INSERT INTO OTContract_Profile_IdentityCreated VALUES(@hash, @profile, @newIdentity, @contractAddress, @blockNumber, @GasPrice, @GasUsed, @BlockchainID)", new
{
hash = model.TransactionHash,
profile = model.Profile,
newIdentity = model.NewIdentity,
contractAddress = model.ContractAddress,
blockNumber = model.BlockNumber,
model.GasUsed,
model.GasPrice,
model.BlockchainID
});
}
public static void Update(MySqlConnection connection, OTContract_Profile_IdentityCreated model)
{
connection.Execute(@"UPDATE OTContract_Profile_IdentityCreated SET TransactionHash = @hash, BlockNumber = @blockNumber,
Profile = @profile, NewIdentity = @newIdentity, GasUsed = @GasUsed, GasPrice = @GasPrice,
ContractAddress = @contractAddress, BlockchainID = @BlockchainID WHERE TransactionHash = @hash AND BlockchainID = @BlockchainID", new
{
hash = model.TransactionHash,
profile = model.Profile,
newIdentity = model.NewIdentity,
contractAddress = model.ContractAddress,
blockNumber = model.BlockNumber,
model.GasUsed,
model.GasPrice,
model.BlockchainID
});
}
public static void InsertOrUpdate(MySqlConnection connection, OTContract_Profile_IdentityCreated model)
{
var count = connection.QueryFirstOrDefault <Int32>("SELECT COUNT(*) FROM OTContract_Profile_IdentityCreated WHERE TransactionHash = @hash AND BlockchainID = @BlockchainID", new
{
hash = model.TransactionHash,
model.BlockchainID
});
if (count == 0)
{
Insert(connection, model);
}
else
{
Update(connection, model);
}
}
