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;
}
