public async Task <List <TransactionDomain> > GetTransactionsByBlockNumberAsync(SearchParameter searchParameter)
{
return(await Task.Run(() =>
{
//To connect to infura using .net451 and TLS2 you need to set it in advance
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
//Connection
var web3 = new Web3(Constants.ETHConnection1);
var blocksWithTransactions = web3.Eth.Blocks.GetBlockWithTransactionsByNumber.SendRequestAsync(new BlockParameter(searchParameter.BlockNumber)).Result;
List <TransactionDomain> transactionsDomains = new List <TransactionDomain>();
foreach (var transaction in blocksWithTransactions.Transactions)
{
TransactionDomain transactionDomain = new TransactionDomain();
transactionDomain.From = transaction.From;
transactionDomain.To = transaction.To;
transactionDomain.Value = transaction.Value.Value.ToString();
transactionDomain.TransactionHash = transaction.TransactionHash;
transactionDomain.TransactionIndex = (Int64)transaction.TransactionIndex.Value;
transactionDomain.Gas = (Int64)transaction.Gas.Value;
transactionDomain.GasPrice = (Int64)transaction.GasPrice.Value;
transactionDomain.Input = transaction.Input;
transactionsDomains.Add(transactionDomain);
}
return transactionsDomains;
}));
}
public IActionResult Retiro(TransactionsModel transac)
{
if (ModelState.IsValid)
{
TransactionDomain transaction = new TransactionDomain();
transaction.idPerson = string.IsNullOrEmpty(transac.idPerson) ? "0" : transac.idPerson;
transaction.accountNumber = string.IsNullOrEmpty(transac.accountNumber) ? "0" : transac.accountNumber;
transaction.accountNumberDestination = string.IsNullOrEmpty(transac.accountNumberDestination) ? "": transac.accountNumberDestination;
transaction.value = string.IsNullOrEmpty(transac.value) ? "0": transac.value;
transaction.idOperation = string.IsNullOrEmpty(transac.idOperation) ? "0" : transac.idOperation;
var url = $"https://localhost:44372/transact";
var request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "POST";
request.ContentType = "application/json";
request.Accept = "application/json";
using (var streamWriter = new StreamWriter(request.GetRequestStream()))
{
var objJson = JsonConvert.SerializeObject(transac);
streamWriter.Write(objJson);
}
var httpResponse = (HttpWebResponse)request.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
var result = streamReader.ReadToEnd();
}
}
return(View());
}
public static TransactionResponse ToResponse(this TransactionDomain domain) => new TransactionResponse
{
Id = domain.Id,
CategoryId = domain.CategoryId,
OtherWalletId = domain.OtherWalletId,
TargetLabel = domain.TargetLabel,
Amount = domain.Amount,
Timestamp = domain.Timestamp
};
private void ExecuteNoQueryTransaction(TransactionDomain transaction)
{
try
{
IDBConectionSqlServer dBConectionSqlServer;
dBConectionSqlServer = new Dao.Transactions.Implementation.DBConectionSqlServer();
int estado = dBConectionSqlServer.ExecuteNoQueryTransaction("", transaction);
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
}
public List <TransactionDomain> Get()
{
TransactionDomain transaction = new TransactionDomain();
transaction.idPerson = "0";
////transaction.idPerson = "123";
////transaction.accountNumber = "A";
////transaction.accountNumberDestination = "B";
////transaction.value = "9600000";
////transaction.idOperation = "1";
List <TransactionDomain> lst = ExecuteReaderTransaction(transaction);
return(lst);
}
private string ExecuteReaderIsValidTransaction(TransactionDomain transaction)
{
string valid = "0";
try
{
IDBConectionSqlServer dBConectionSqlServer;
dBConectionSqlServer = new Dao.Transactions.Implementation.DBConectionSqlServer();
valid = dBConectionSqlServer.ExecuteReaderIsValidTransaction("", transaction);
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
return(valid);
}
public List <TransactionDomain> ExecuteReaderTransaction(string sql, TransactionDomain transaction)
{
List <TransactionDomain> listTransactionDomain = new List <TransactionDomain>();
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
command.CommandText = "GET_TRANSACTIONS";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@idPerson", transaction.idPerson);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TransactionDomain transactionReader = new TransactionDomain();
transactionReader.idPerson = reader.GetString(0);
transactionReader.idOperation = reader.GetString(1);
transactionReader.initialValue = reader.GetDouble(2).ToString();
transactionReader.value = reader.GetDouble(3).ToString();
transactionReader.finalValue = reader.GetDouble(4).ToString();
transactionReader.gmf = reader.GetDouble(5).ToString();
listTransactionDomain.Add(transactionReader);
// Console.WriteLine("{0} {1}", reader.GetString(0), reader.GetString(1));
}
return(listTransactionDomain);
}
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
return(null);
}
protected override EmailParseResult Parse(MessageDetails message)
{
if (/*message.From != From ||*/ !_subjects.Contains(message.Subject))
{
return(EmailParseResult.CreateError("Email was not recognized as transaction"));
}
var tr = new TransactionDomain
{
Iban = GetIban(message),
Amount = GetAmount(message),
Note = GetNote(message),
Source = TransactionSource.ImportedFromEmail,
CreatedTime = DateTimeContext.Now
};
return(EmailParseResult.CreateSuccess(tr));
}
private List <TransactionDomain> ExecuteReaderTransaction(TransactionDomain transaction)
{
try
{
List <TransactionDomain> ListTransactionDomains = new List <TransactionDomain>();
IDBConectionSqlServer dBConectionSqlServer;
dBConectionSqlServer = new Dao.Transactions.Implementation.DBConectionSqlServer();
ListTransactionDomains = dBConectionSqlServer.ExecuteReaderTransaction("", transaction);
return(ListTransactionDomains);
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
return(null);
}
public string ExecuteReaderIsValidTransaction(string sql, TransactionDomain transaction)
{
string valid = "0";
List <TransactionDomain> listTransactionDomain = new List <TransactionDomain>();
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
command.CommandText = "GET_ISVALID_TRANSACTIONS";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@idPerson", transaction.idPerson);
command.Parameters.AddWithValue("@accountNumber", transaction.accountNumber);
command.Parameters.AddWithValue("@operation", transaction.idOperation);
command.Parameters.AddWithValue("@value", transaction.value);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
valid = reader.GetString(0);
}
return(valid);
}
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
return(valid);
}
public int ExecuteNoQueryTransaction(string sql, TransactionDomain transaction)
{
int estado = 0;
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
command.CommandText = "GENERATE_TRANSACTIONS";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@idPerson", transaction.idPerson);
command.Parameters.AddWithValue("@accountNumber", transaction.accountNumber);
command.Parameters.AddWithValue("@operation", transaction.idOperation);
command.Parameters.AddWithValue("@value", transaction.value);
command.Parameters.AddWithValue("@AccountNumberDestination", string.IsNullOrEmpty(transaction.accountNumberDestination) ? "" : transaction.accountNumberDestination);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
estado = 1;
}
}
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
return(estado);
}
public List <TransactionDomain> Post(TransactionDomain transac)
{
TransactionDomain transaction = new TransactionDomain();
transaction.idPerson = transac.idPerson;
transaction.accountNumber = transac.accountNumber;
transaction.accountNumberDestination = transac.accountNumberDestination;
transaction.value = transac.value;
transaction.idOperation = transac.idOperation;
if (ModelState.IsValid)
{
string valid = ExecuteReaderIsValidTransaction(transaction);
if (valid.Equals("1") && !transac.value.Equals("0"))
{
ExecuteNoQueryTransaction(transaction);
}
}
List <TransactionDomain> lst = ExecuteReaderTransaction(transaction);
return(lst);
}
public static EmailParseResult CreateSuccess(TransactionDomain transaction)
{
return(new EmailParseResult {
Transaction = transaction
});
}
