public async Task <DataTransaction> GetDataTransactiontTrans() { DataTransactiontTrans = new DataTransaction(); DataTransactiontTrans = await ViewTransaction.GetTransactionData(); return(DataTransactiontTrans); }
public override int Insert(Entity entity, DataTransaction tran) { Entities.HorarioMaestros item = entity as Entities.HorarioMaestros; DataEntities.SpFwkHorarioMaestrosIns sp = new DataEntities.SpFwkHorarioMaestrosIns(); sp.ClaEmpleado = item.Empleado.ID; sp.ClaCampus = item.ClaCampus.ID; sp.ClaHorario = item.ClaHorario; sp.Lun = item.Lun; sp.Mar = item.Mar; sp.Mie = item.Mie; sp.Jue = item.Jue; sp.Vie = item.Vie; sp.Sab = item.Sab; sp.Dom = item.Dom; sp.OrdenLun = item.OrdenLun; sp.OrdenMar = item.OrdenMar; sp.OrdenMie = item.OrdenMie; sp.OrdenJue = item.OrdenJue; sp.OrdenVie = item.OrdenVie; sp.OrdenSab = item.OrdenSab; sp.OrdenDom = item.OrdenDom; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public override int Insert(Entity entity, DataTransaction tran) { Entities.Citas item = entity as Entities.Citas; DataEntities.SpCitasIns sp = new DataEntities.SpCitasIns(); sp.IdCita = item.ID; sp.ClaCampus = item.Campus.ID; //sp.IdCita = item.IdCita; //sp.ClaCampus = item.Campus.ID; sp.Matricula = item.Matricula; sp.ClaProfesor = item.ClaProfesor; sp.FechaHora = item.FechaHora; sp.TipoClase = item.TipoClase; sp.Estatus = item.Estatus; sp.ClaNivel = item.ClaNivel; sp.ClaLeccion = item.ClaLeccion; sp.FechaHoraOriginal = item.FechaHoraOriginal; sp.Observaciones = item.Observaciones; sp.ModManual = item.ModManual; sp.FechaHoraAsistencia = item.FechaHoraAsistencia; sp.Aprobo = item.Aprobo; // if (tran != null) // { // return sp.ExecuteNonQuery(tran); // } // else // { return(sp.ExecuteNonQuery(this.ConnectionString)); // } }
public override int Insert(Entity entity, DataTransaction tran) { Entities.ExtensionesCurso item = entity as Entities.ExtensionesCurso; DataEntities.SpExtensionesCursoIns sp = new DataEntities.SpExtensionesCursoIns(); sp.IdRegistro = item.IdRegistro; sp.ClaCampus = item.Campus.ID; sp.Matricula = item.Matricula; sp.FechaIni = item.FechaIni; sp.FechaFin = item.FechaFin; sp.Comentarios = item.Comentarios; sp.Estatus = item.Estatus; sp.ClaNivel = item.ClaNivel; sp.ClaLeccion = item.ClaLeccion; sp.TipoRegistro = item.TipoRegistro; // if (tran != null) // { // return sp.ExecuteNonQuery(tran); // } // else // { return(sp.ExecuteNonQuery(this.ConnectionString)); // } }
/// <summary> /// Method for get Rates for pins on the World /// </summary> /// <param name="jsonData">Specific json string</param> /// <returns>Result is List <see cref="DataPin"/></returns> public static DataTransaction GetRates(string jsonData) { var obj = JToken.Parse(jsonData); //JToken obj = data.Properties().Select(p => p.Value); try { var dataTrx = new DataTransaction { Hash160 = (string)obj["hash160"], Address = (string)obj["address"], NumberTransaction = (int)obj["n_tx"], TotalRecived = (long)obj["total_received"], TotalSent = (long)obj["total_sent"], FinalBalance = (long)obj["final_balance"], ListTransactions = GetListTransaction(obj["txs"]) }; return(dataTrx); } catch (Exception e) { return(new DataTransaction()); //throw new Exception($"Maybe is bad key for parsing! Exception {e}"); } }
public string PutData(PrivateKeyAccount account, DictionaryObject entries, decimal?fee = null) { var tx = new DataTransaction(ChainId, account.PublicKey, entries, fee); tx.Sign(account); return(Broadcast(tx)); }
public int HandleDataTransaction(DataTransaction dataTransaction) { if (dataTransaction is null) { return(-1); } switch (dataTransaction.Data) { case Account a: return(accountsService.HandleTransaction(dataTransaction.Action, a)); case Activity a: return(activitiesService.HandleTransaction(dataTransaction.Action, a)); case Category c: return(categoriesService.HandleTransaction(dataTransaction.Action, c)); case TimeEntry t: return(timeEntriesService.HandleTransaction(dataTransaction.Action, t)); case Transaction t: return(transactionsService.HandleTransaction(dataTransaction.Action, t)); default: throw new ArgumentException("Unkown data type " + dataTransaction.Data.GetType().Name); } }
public Task <DataTransaction> ExecuteAsync( Entity entity, DataTransaction transaction = null, IDictionary <string, object> inputValues = null, object context = null, bool force = false) { return(ExecuteAsync(new[] { entity }, transaction, inputValues, context, force)); }
public override int Insert(Entity entity, DataTransaction tran) { Entities.Asistencia item = entity as Entities.Asistencia; DataEntities.SpAsistenciaIns sp = new DataEntities.SpAsistenciaIns(); sp.IdRegistro = item.ID; sp.ClaCampus = item.Campus.ID; // sp.IdRegistro = item.ID; //sp.ClaCampus = item.Campus.ID; sp.Matricula = item.Matricula; sp.ClaEmpleado = item.Empleado.ID; sp.TipoPersona = item.TipoPersona; sp.FechaHora = item.FechaHora; sp.Mensaje = item.Mensaje; sp.IdCita = item.idCita; sp.RegistroValido = item.RegistroValido; // if (tran != null) // { // return sp.ExecuteNonQuery(tran); // } // else // { return(sp.ExecuteNonQuery(this.ConnectionString)); // } }
private static async Task <UInt256> DeployDataAsync(string nodeAddress, PrivateKey initiatorPrivateKey, UInt256 witness, params DataAction[] actions) { var initiatorAddress = initiatorPrivateKey.GetAddress(signAlgorithm); var tran = new DataTransaction(initiatorAddress, null, witness, actions); var unlockscript = signAlgorithm.Sign((byte[])tran.GetLockHash(), initiatorPrivateKey); tran.UnlockScripts = new UnlockScripts(new[] { new ScriptToken(unlockscript.ToString()) }); tran.Sign(signAlgorithm, initiatorPrivateKey); var signature = tran.Signature.ToString(); var response = await new JsonRpcRequest { Method = Commands.CreateDataTransaction, Parameters = new CreateDataTransactionRpcRequest { Initiator = initiatorAddress.ToString(), Signature = signature.ToString(), WitnessBlock = witness, UnlockScripts = tran.UnlockScripts, Actions = actions, } }.ConnectAndRequest <CreateTransactionRpcResponse>(nodeAddress); if (response.Error != null) { throw new EvaluateException($"error when deploy transaction: [{response.Error.Code}]{response.Error.Message}"); } return(response.Result.TransactionId); }
public override int Insert(Entity entity, DataTransaction tran) { DataEntities.SpMedicinaGeneralIns sp = new DataEntities.SpMedicinaGeneralIns(); Entities.MedicinaGeneral item = entity as Entities.MedicinaGeneral; sp.IdConsultaMG = item.ID; sp.IdMedico = item.Medico.ID; sp.IdPaciente = item.Paciente.ID; sp.MotivoConsulta = item.MotivoConsulta; sp.ProblemasActuales = item.ProblemasActuales; sp.Medicamentos = item.Medicamentos; sp.Observaciones = item.Observaciones; sp.EnfermedadesCronicas = item.EnfermedadesCronicas; sp.EnfermedadesImportantes = item.EnfermedadesImportantes; sp.Diagnstico = item.Diagnstico; int rowsAffected = 0; if (tran != null) { rowsAffected = sp.ExecuteNonQuery(tran); } else { rowsAffected = sp.ExecuteNonQuery(this.ConnectionString); } return(rowsAffected); }
private void GetData(byte[] data) { DataTransaction dataTransaction = Serialyze.UnserializeDataTransaction(Encoding.Default.GetString(data)); //Console.WriteLine("[ST] Analyse transaction"); string PubKeySender = dataTransaction.PubKey; string SenderAddress = dataTransaction.EncodeFromAddress; //Rsa.Decrypt(PubKeySender, dataTransaction.EncodeFromAddress); string ToAddress = dataTransaction.ToAddress; // Rsa.Decrypt(PubKeySender, dataTransaction.ToAddress); string Amount = dataTransaction.Amount; //Rsa.Decrypt(PubKeySender, dataTransaction.Amount); int Amountint; try { Amountint = int.Parse(Amount); } catch (Exception e) { return; } if (Amountint <= 0) { return; } if (Hash.CpuGenerate(PubKeySender) != SenderAddress) { return; } Transaction newTransaction = new Transaction(SenderAddress, ToAddress, Amountint); this.Coin.AddTransaction(newTransaction); }
public async Task <IActionResult> GetTransactionWithDataAsync([FromBody] PrivateWalletDataTransaction ethTransaction) { if (!ModelState.IsValid) { throw new ClientSideException(ExceptionType.WrongParams, JsonConvert.SerializeObject(ModelState.Errors())); } string serialized = JsonConvert.SerializeObject(ethTransaction); await _log.WriteInfoAsync("PrivateWalletController", "GetTransaction", serialized, "Get transaction for signing", DateTime.UtcNow); var transaction = new DataTransaction() { FromAddress = ethTransaction.FromAddress, GasAmount = BigInteger.Parse(ethTransaction.GasAmount), GasPrice = BigInteger.Parse(ethTransaction.GasPrice), ToAddress = ethTransaction.ToAddress, Value = BigInteger.Parse(ethTransaction.Value), Data = ethTransaction.Data }; await _privateWalletService.ValidateInputAsync(transaction); string transactionHex = await _privateWalletService.GetDataTransactionForSigning(transaction); await _log.WriteInfoAsync("PrivateWalletController", "GetTransaction", $"{serialized} + TransactionHex:{transactionHex}", "Recieved transaction for signing", DateTime.UtcNow); return(Ok(new EthTransactionRaw() { FromAddress = ethTransaction.FromAddress, TransactionHex = transactionHex })); }
public override int Update(Entity entity, DataTransaction tran) { DataEntities.SpMedicoUpd sp = new DataEntities.SpMedicoUpd(); Entities.Medico item = entity as Entities.Medico; sp.IdMedico = item.ID; sp.Nombre = item.Nombre; sp.ApellidoP = item.ApellidoP; sp.ApellidoM = item.ApellidoM; sp.Edad = item.Edad; sp.FechaNac = item.FechaNac; sp.EstadoCiv = item.EstadoCiv; sp.Area = item.Area; sp.Telefono1 = item.Telefono1; sp.Telefono2 = item.Telefono2; sp.Email = item.Email; int rowsAffected = 0; if (tran != null) { rowsAffected = sp.ExecuteNonQuery(tran); } else { rowsAffected = sp.ExecuteNonQuery(this.ConnectionString); } return(rowsAffected); }
/// <summary> Called to save a pdu into the database </summary> /// <param name="dataTransaction"></param> /// <param name="logKey"></param> /// <param name="smscServiceId"></param> /// <param name="pduDirectionType"></param> /// <param name="commandLength"></param> /// <param name="commandSet"></param> /// <param name="commandStatus"></param> /// <param name="sequenceNumber"></param> /// <param name="details"></param> /// <param name="pduDataBlocks"></param> /// <returns> long </returns> public static Guid?Insert(DataTransaction dataTransaction, string logKey, int smscServiceId, PduDirectionTypes pduDirectionType, long commandLength, CommandSet commandSet, CommandStatus commandStatus, long sequenceNumber, List <PduPropertyDetail> details, List <byte[]> pduDataBlocks) { Guid?pduHeaderId = null; // Prepare the database call using (DbCommand dbCommand = dataTransaction.GetStoredProcCommand("spSMPP_Pdu_Insert")) { // Prepare the call dataTransaction.AddInParameterString(dbCommand, "LogKey", logKey); dataTransaction.AddInParameterInteger(dbCommand, "SMSCServiceID", smscServiceId); dataTransaction.AddInParameterShort(dbCommand, "Direction", (short)pduDirectionType); dataTransaction.AddInParameterLong(dbCommand, "CommandLength", commandLength); dataTransaction.AddInParameterString(dbCommand, "CommandId", commandSet.ToString()); dataTransaction.AddInParameterString(dbCommand, "CommandStatusId", commandStatus.ToString()); dataTransaction.AddInParameterLong(dbCommand, "SequenceNumber", sequenceNumber); dataTransaction.AddInParameterTable(dbCommand, "PduPropertyDetails", new PduPropertyDetails(details)); dataTransaction.AddInParameterTable(dbCommand, "PduDataBlocks", new SMSCPduDataBlocks(pduDataBlocks)); dataTransaction.AddOutParameterGuid(dbCommand, "PduHeaderId"); dataTransaction.ExecuteNonQuery(dbCommand); pduHeaderId = dataTransaction.GetParameterValueGuid(dbCommand, "PduHeaderId"); } return(pduHeaderId); }
public override int Update(Entity entity, DataTransaction tran) { DataEntities.SpPacienteUpd sp = new DataEntities.SpPacienteUpd(); Entities.Paciente item = entity as Entities.Paciente; sp.IdPaciente = item.ID; sp.Nombre = item.Nombre; sp.ApellidoP = item.ApellidoP; sp.ApellidoM = item.ApellidoM; sp.Edad = item.Edad; sp.FechaNac = item.FechaNac; sp.LugardeNacimiento = item.LugardeNacimiento; sp.LugardeResidencia = item.LugardeResidencia; sp.EstadoCiv = item.EstadoCiv; sp.Escolaridad = item.Escolaridad; sp.Ocupacion = item.Ocupacion; sp.Direccion = item.Direccion; sp.Telefono = item.Telefono; sp.Email = item.Email; int rowsAffected = 0; if (tran != null) { rowsAffected = sp.ExecuteNonQuery(tran); } else { rowsAffected = sp.ExecuteNonQuery(this.ConnectionString); } return(rowsAffected); }
public DataSource(string name) { if (name == null) { throw new ArgumentNullException("name"); } disposed = false; _name = name; _type = DataSourceType.Unknown; _provider = null; _trans = new DataTransaction(this); _locker = new VersionLocker(); _pscount = 0; ConnectionStringSettings settings = System.Configuration.ConfigurationManager.ConnectionStrings[_name]; if (settings == null) { throw new SettingsPropertyNotFoundException(string.Concat("配置文件中不存在名为“", _name, "”的数据库连接字符串")); } DbProviderFactory factory = DbProviderFactories.GetFactory(settings.ProviderName); _conn = factory.CreateConnection(); _conn.ConnectionString = settings.ConnectionString; _conn.Open(); lock (_locker.Locker) _locker.Increment(); }
public override int Insert(Entity entity, DataTransaction tran) { Entities.Kardex item = entity as Entities.Kardex; DataEntities.SpKardexIns sp = new DataEntities.SpKardexIns(); sp.IdCalificacion = item.ID; sp.Matricula = item.Matricula; sp.ClaCampus = item.Campus.ID; sp.ClaNivel = item.Nivel.ID; sp.ClaLeccion = item.Leccion.Clave; sp.ClaProfesor = item.Profesor; sp.Calificacion = item.Calificacion; sp.TipoClase = item.TipoClase; sp.Fecha = item.Fecha; sp.ClaCalificacion = item.ClaCalificacion; sp.IdCita = item.IdCita; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public override int Insert(Entity entity, DataTransaction tran) { DataEntities.SpPsicologiaIns sp = new DataEntities.SpPsicologiaIns(); Entities.Psicologia item = entity as Entities.Psicologia; sp.IdConsultaPs = item.ID; sp.IdMedico = item.Medico.ID; sp.IdPaciente = item.Paciente.ID; sp.Motivo = item.Motivo; sp.Antecedentes = item.Antecedentes; sp.RelacionFamiliar = item.RelacionFamiliar; sp.DescripcionCircAmigos = item.DescripcionCircAmigos; sp.ActividadesIndividuales = item.ActividadesIndividuales; sp.Casado = item.Casado; sp.UnionLibre = item.UnionLibre; sp.Soltero = item.Soltero; sp.Alcohol = item.Alcohol; sp.Fuma = item.Fuma; sp.Sustancias = item.Sustancias; sp.ExpectativaTerapia = item.ExpectativaTerapia; sp.Compromisos = item.Compromisos; sp.Resultados = item.Resultados; sp.Recomendaciones = item.Recomendaciones; int rowsAffected = 0; if (tran != null) { rowsAffected = sp.ExecuteNonQuery(tran); } else { rowsAffected = sp.ExecuteNonQuery(this.ConnectionString); } return(rowsAffected); }
public void TestDataTransaction() { var node = new Node(); var data = new DictionaryObject { { "test long", -1001L }, { "test true", true }, { "test false", false }, { "test bytes", new byte[] { 1, 2, 3, 4, 5 } }, { "test string", "Hello, Waves!" }, { "test russian", "Привет" } }; var tx = new DataTransaction(Accounts.Alice.PublicKey, data).Sign(Accounts.Alice); Console.WriteLine("Tx size: " + tx.GetBody().Length); Console.WriteLine("Response tx id: " + node.Broadcast(tx.GetJsonWithSignature())); var addressData = node.GetAddressData(Accounts.Alice.Address); Assert.AreEqual(-1001L, addressData["test long"]); Assert.AreEqual(true, addressData["test true"]); Assert.AreEqual(false, addressData["test false"]); Assert.AreEqual("Hello, Waves!", addressData["test string"]); Assert.AreEqual("Привет", addressData["test russian"]); CollectionAssert.AreEquivalent(new byte[] { 1, 2, 3, 4, 5 }, (byte[])addressData["test bytes"]); }
public void Dispose_MultipleCallsDoNothing() { var conn = new TestDbConnection(); var target = new DataTransaction(conn.BeginTransaction()); //Act target.Dispose(); target.Dispose(); }
public DataTransaction SetStage(Entity entity, object stageId, DataTransaction transaction = null) { if (entity == null) { throw new ArgumentNullException(nameof(entity)); } return(SetStage(new[] { entity }, stageId, transaction)); }
public override int Insert(Entity entity, DataTransaction tran) { Entities.Nivel item = entity as Entities.Nivel; DataEntities.SpNivelesIns sp = new DataEntities.SpNivelesIns(); sp.ClaNivel = item.ID; sp.NomNivel = item.Nombre; sp.ClubConversacion = item.ClubConversacion; return(sp.ExecuteNonQuery(this.ConnectionString)); }
public void Commit_MultipleCallsFail() { var conn = new TestDbConnection(); var target = new DataTransaction(conn.BeginTransaction()); target.Commit(); Action action = () => target.Commit(); action.Should().Throw <InvalidOperationException>(); }
Task <HeleusClientResponse> SendDataTransactionWithCoreAccount(DataTransaction transaction, bool awaitResponse) { if (CurrentCoreAccount == null) { Log.Trace($"Sending data transaction {transaction.GetType().Name} with core account failed, no core account set.", this); return(Task.FromResult(new HeleusClientResponse(HeleusClientResultTypes.InternalError))); } return(SendDataTransaction(transaction, awaitResponse, CurrentCoreAccount)); }
public async void setData(int id, TextBox id_transaksi, TextBox alamat_pembeli, TextBox namaPembeli, TextBox totalHarga) { this.id = id; transaction = UtilProvider.getDataTransaction().getData()[id]; this.id = transaction.getId(); id_transaksi.Text = transaction.getPoNumber(); alamat_pembeli.Text = transaction.getAddress(); namaPembeli.Text = transaction.getCustomerId().ToString(); totalHarga.Text = transaction.price.ToString(); }
public Task <HeleusClientResponse> SendDataTransaction(DataTransaction transaction, bool awaitResponse) { if (CurrentServiceAccount == null) { Log.Trace($"Sending chain transaction {transaction.GetType().Name} failed, no chain account set.", this); return(Task.FromResult(new HeleusClientResponse(HeleusClientResultTypes.InternalError))); } return(SendDataTransaction(transaction, awaitResponse, CurrentServiceAccount)); }
public async Task <int> AddTransaction(DataTransaction dataTransaction) { var result = HandleDataTransaction(dataTransaction); if (!await networkService.Add(dataTransaction)) { return(-1); } return(result); }
public string SendTransaction(DataTransaction transaction) { try { return(Network.SendTransaction(transaction)); } catch (Exception e) { return(e.Message); } }
public void Execute_Should_Check_Errors_On_Xlsx(int idLine, string errorMessage) { var dt = new DataTransaction(); var results = dt.Execute(@"..\..\Datas\Business\FakeFiles\BadDatas.xlsx"); var message = results.Messages.FirstOrDefault(x => x.IdLine == idLine); Assert.IsNotNull(message); Assert.AreEqual(errorMessage, message.Messages.FirstOrDefault()); Assert.AreEqual(DataTransactionState.Ignored, message.State); Assert.AreEqual(0, Repositories.Informations.FindAll().Count); }
/// <summary> /// Method for get List all transaction max. 50 records /// </summary> /// <returns>Result is list transaction</returns> private async Task <List <TransRow> > GetListTranstion() { DataTransaction dataTransaction = new DataTransaction(); List <TransRow> listTrans = new List <TransRow>(); dataTransaction = await ViewTransaction.GetTransactionData(); //update data if (dataTransaction.ListTransactions.Count > 0) // test for count { BalanceHelper.DataTransactiontTrans = dataTransaction; } else // from chace data { if (BalanceHelper.DataTransactiontTrans.ListTransactions.Count > 0) { dataTransaction = BalanceHelper.DataTransactiontTrans; } } if (dataTransaction.ListTransactions.Count > 0) // test for count { foreach (var transaction in dataTransaction.ListTransactions) { TransRow item; if (string.Compare(transaction.ListInputs[0].PrevOut.Address, transaction.TupleOuts.Item2.Address) == 0) // is True = Send Transaction { item = new TransRow { BitcoinAddress = transaction.TupleOuts.Item1.Address, // where send is here Type = TypeTrans.Send, // or TypeTrans.Send Value = transaction.TupleOuts.Item1.Value, Date = transaction.Time }; } else // is False = Recieve Transaction { item = new TransRow { BitcoinAddress = transaction.TupleOuts.Item1.Address, // where recieve is here Type = TypeTrans.Recieve, // or TypeTrans.Send Value = transaction.TupleOuts.Item1.Value, Date = transaction.Time }; } //Debug.WriteLine($"zapis hodnoty: {item.Value}"); listTrans.Add(item); } } return(listTrans); }
public void Execute_Should_Add_Information_On_Xlsx() { var dt = new DataTransaction(); var results = dt.Execute(@"..\..\Datas\Business\FakeFiles\GoodDatas.xlsx"); foreach (var dataTransaction in results.Messages) { Assert.IsNotNull(dataTransaction); Assert.AreEqual(0, dataTransaction.Messages.Count); Assert.AreEqual(DataTransactionState.Valid, dataTransaction.State); } var resultDatas = Repositories.Informations.FindAll(); Assert.AreEqual(1, resultDatas.Count); Assert.AreEqual(10.55, resultDatas.ElementAt(0).Amount); }
public ActionResult Upload(HttpPostedFileBase file) { ViewBag.Title = Common.Upload_Title; var response = new DataTransactionResponse(); if (ModelState.IsValid && file != null && file.IsValidForUpload()) { var dataTransaction = new DataTransaction(); response = dataTransaction.Execute(SaveFile(file)); ViewBag.Message = InformationMessage.Success_File_Uploaded; } else { ViewBag.Message = InformationMessage.Error_File_Is_Invalid; } return View(response); }