public ActionResult InsertCost(string selectLevel, string selectProd, string quantity, string quantityLots, string costTotal, string selectLogic, string selectProvider) { string script = ""; InboundTransaction inboundTransaction = new InboundTransaction(); inboundTransaction.product.id_product = Convert.ToInt32(selectProd); inboundTransaction.level.id_level = Convert.ToInt32(selectProd); inboundTransaction.provider.id_provider = Convert.ToInt32(selectProvider); inboundTransaction.quantityProds = Convert.ToInt32(quantity); inboundTransaction.quantityLots = Convert.ToInt32(quantityLots); inboundTransaction.totalCost = float.Parse(costTotal); inboundTransaction.logic = selectLogic; if (cost_Logic.addCostInboundTransaction(inboundTransaction)) { script = "<script>alert('Se ingreso correctamente');</script>"; } else { script = "<script>alert('No se ingreso');</script>"; } return(Content(script)); }
private void ProcessTransaction(InboundTransaction transaction) { var dbTransaction = _repository.GetInboundTransaction(transaction.TransactionId).Result; if (dbTransaction == null) { NewTransaction(transaction).Wait(); } else if (dbTransaction.Status != transaction.Status) { UpdatedTransaction(dbTransaction, transaction.Status).Wait(); } }
public async Task <List <InboundTransaction> > CheckForTransactions(DateTime blockDateTime, int?numberOfConfirmations = null) { var recievedTransactions = new List <InboundTransaction>(); var accountTransactions = await _transactionService.GetBlockchainTransactions(_accountId.ToString(), blockDateTime, TransactionSubType.PaymentOrdinaryPayment, numberOfConfirmations : numberOfConfirmations); foreach (var transaction in accountTransactions.Transactions.Where(t => t.Recipient == _accountId).OrderBy(t => t.BlockTimestamp).ThenBy(t => t.Timestamp)) { var inboundTransaction = new InboundTransaction(transaction) { DecryptedMessage = await DecryptMessage(transaction) }; recievedTransactions.Add(inboundTransaction); } return(recievedTransactions); }
public List <InboundTransaction> GetInboundTransactions(string nameProd, string nameLogic) { List <InboundTransaction> list = new List <InboundTransaction>(); try { sqlConnection.Open(); sqlCommand = new SqlCommand("getInboundTransactions", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter p_nameProd = new SqlParameter(); p_nameProd.ParameterName = "@name_prod"; p_nameProd.SqlDbType = SqlDbType.VarChar; p_nameProd.Value = nameProd; SqlParameter p_logic = new SqlParameter(); p_logic.ParameterName = "@logic"; p_logic.SqlDbType = SqlDbType.VarChar; p_logic.Value = nameLogic; sqlCommand.Parameters.Add(p_nameProd); sqlCommand.Parameters.Add(p_logic); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { InboundTransaction inbound = new InboundTransaction(); inbound.idInboundTransaction = Convert.ToInt32(sqlDataReader["id_inbound"]); inbound.quantityProds = Convert.ToInt32(sqlDataReader["quantityProduct"]); inbound.product.name = sqlDataReader["name_product"].ToString(); inbound.product.description = sqlDataReader["descripttion"].ToString(); inbound.logic = sqlDataReader["logic"].ToString(); inbound.date = sqlDataReader["date_transaction"].ToString(); list.Add(inbound); } sqlConnection.Close(); } catch (Exception e) { throw; } return(list); }
private async Task UpdatedTransaction(InboundTransaction transaction, TransactionStatus status) { await _repository.UpdateTransactionStatus(transaction.TransactionId, status); OnUpdatedTransactionStatus(new StatusUpdatedEventArgs(transaction, status)); }
private async Task NewTransaction(InboundTransaction transaction) { await _repository.AddInboundTransaction(transaction); OnIncomingTransaction(new IncomingTransactionEventArgs(transaction)); }
public StatusUpdatedEventArgs(InboundTransaction transaction, TransactionStatus previousStatus) { Transaction = transaction; PreviousStatus = previousStatus; }
public bool addCostInboundTransaction(InboundTransaction inbound) { return(costData.addCostInboundTransaction(inbound)); }
// INSERTAR LOTES public bool addCostInboundTransaction(InboundTransaction inbound) { bool response = false; float priceProduct = 0; try { sqlConnection.Open(); sqlCommand = new SqlCommand("insertInboundTransaction", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter p_idProd = new SqlParameter(); p_idProd.ParameterName = "@fkIdProd"; p_idProd.SqlDbType = SqlDbType.Int; p_idProd.Value = inbound.product.id_product; priceProduct = product_Data.getCostProductById(inbound.product.id_product); SqlParameter p_idWarehouse = new SqlParameter(); p_idWarehouse.ParameterName = "@fkIdLevel"; p_idWarehouse.SqlDbType = SqlDbType.Int; p_idWarehouse.Value = inbound.level.id_level; SqlParameter p_idProvider = new SqlParameter(); p_idProvider.ParameterName = "@fkIdProvider"; p_idProvider.SqlDbType = SqlDbType.Int; p_idProvider.Value = inbound.provider.id_provider; SqlParameter p_quantity = new SqlParameter(); p_quantity.ParameterName = "@quantityProd"; p_quantity.SqlDbType = SqlDbType.Int; p_quantity.Value = inbound.quantityProds; SqlParameter p_quantityLots = new SqlParameter(); p_quantityLots.ParameterName = "@quantityLots"; p_quantityLots.SqlDbType = SqlDbType.Int; p_quantityLots.Value = inbound.quantityLots; SqlParameter p_costProd = new SqlParameter(); p_costProd.ParameterName = "@costProd"; p_costProd.SqlDbType = SqlDbType.Float; p_costProd.Value = priceProduct; SqlParameter p_totalCost = new SqlParameter(); p_totalCost.ParameterName = "@totalCost"; p_totalCost.SqlDbType = SqlDbType.Float; p_totalCost.Value = inbound.totalCost; SqlParameter p_logic = new SqlParameter(); p_logic.ParameterName = "@logic"; p_logic.SqlDbType = SqlDbType.VarChar; p_logic.Value = inbound.logic; sqlCommand.Parameters.Add(p_idProd); sqlCommand.Parameters.Add(p_idWarehouse); sqlCommand.Parameters.Add(p_idProvider); sqlCommand.Parameters.Add(p_quantity); sqlCommand.Parameters.Add(p_quantityLots); sqlCommand.Parameters.Add(p_costProd); sqlCommand.Parameters.Add(p_totalCost); sqlCommand.Parameters.Add(p_logic); sqlCommand.ExecuteNonQuery(); response = true; sqlConnection.Close(); } catch (Exception e) { throw; } return(response); }
public IncomingTransactionEventArgs(InboundTransaction transaction) { Transaction = transaction; }