public async Task Should_Load_Entities_Modify_And_Save_Correctly() { var expectedCode = String.Empty; using (var dbConnection = _sqlExecutor.OpenNewDbConnection()) { if (dbConnection != null) { var resultData = await dbConnection.GetPagedAsync <COMISIO>(1, 2); var resultItem = resultData.FirstOrDefault(); expectedCode = resultItem?.NUM_COMI; } } var value = new ComisioViewObject { NUM_COMI = expectedCode }; var dtoValue = await _dataLoader.LoadValueAsync(value.NUM_COMI); Assert.AreEqual(value.NUM_COMI, dtoValue.NUM_COMI); value.NOMBRE = "BasicSupplier"; var result = await _dataSaver.SaveAsync(value); Assert.AreEqual(result, true); }
public async Task Should_Insert_CommissionAgent() { var id = _commissionAgentDataServices.NewId(); var commissionAgent = _commissionAgentDataServices.GetNewDo(id); var commissionAgentTypeData = new CommissionAgentTypeData(); commissionAgentTypeData.Code = "2"; commissionAgentTypeData.Name = "KARVE INFORMATICA S.L"; // commissionAgent.Type = commissionAgentTypeData; var dataCountry = new CountryData(); dataCountry.Code = "34"; dataCountry.CountryName = "Spain"; // commissionAgent.Country = dataCountry; ComisioViewObject comisio = (ComisioViewObject)commissionAgent.Value; comisio.NUM_COMI = _commissionAgentDataServices.NewId(); Assert.NotNull(comisio.NUM_COMI); comisio.TIPOCOMI = "2"; comisio.CP = "080012"; comisio.NOMBRE = "Giorgio"; comisio.DIRECCION = "Via Augusta 32"; comisio.EMAIL = "*****@*****.**"; commissionAgent.Value = comisio; bool cAgent = await _commissionAgentDataServices.SaveAsync(commissionAgent); Assert.True(cAgent); }
public async Task Should_Update_CommissionAgent() { // arrange IDictionary <string, string> fields = new Dictionary <string, string>(); fields.Add(CommissionAgent.Comisio, "NUM_COMI,NOMBRE,DIRECCION,PERSONA,NIF,NACIOPER,TIPOCOMI"); fields.Add(CommissionAgent.Tipocomi, "NUM_TICOMI, ULTMODI, USUARIO, NOMBRE"); fields.Add(CommissionAgent.Visitas, " * "); fields.Add(CommissionAgent.Branches, "* "); string numComi = await GetFirstId(); ICommissionAgent commissionAgent = await _commissionAgentDataServices.GetCommissionAgentDo(numComi).ConfigureAwait(false); // check if the condition is valid. Assert.True(commissionAgent.Valid); ComisioViewObject internalValue = (ComisioViewObject)commissionAgent.Value; IEnumerable <BranchesViewObject> branchesDto = commissionAgent.BranchesDto; IEnumerable <ContactsViewObject> contactsDtos = commissionAgent.ContactsDto; IEnumerable <VisitsViewObject> visitsDtos = commissionAgent.VisitsDto; internalValue.NOMBRE = "Karve2Comission"; commissionAgent.Value = internalValue; // act bool isSaved = await _commissionAgentDataServices.SaveAsync(commissionAgent).ConfigureAwait(false); // assert Assert.True(isSaved); }
public async Task Should_Load_And_Have_TheSame_NumComi() { IDictionary <string, string> query = new Dictionary <string, string>(); string primaryKeyValue = await GetFirstId(); using (IDbConnection connection = _sqlExecutor.OpenNewDbConnection()) { var brokers = await connection.GetPagedAsync <COMISIO>(1, 20); var singleBroker = brokers.FirstOrDefault(); if (singleBroker != null) { primaryKeyValue = singleBroker.NUM_COMI; } } query["COMISIO"] = "NUM_COMI,PERSONA,NIF,TIPOCOMI,VENDE_COMI,MERCADO,NEGOCIO,CANAL,CLAVEPPTO,ORIGEN_COMI,ZONAOFI," + "direccion,cp,poblacion,provincia,nacioper,telefono,fax,Movil,alta_comi," + "baja_comi,idioma,IATA,IVASINO,RETENSINO,NACIONAL,CONCEPTOS_COND,AGENCIA,TRADUCE_WS," + "TRUCK_RENTAL_BROKER,COMBUS_PREPAGO_COMI,NO_GENERAR_AUTOFAC,TODOS_EXTRAS,AUTO_ONEWAY,COT_INCLUIDOS_SIN_GRUPO," + "NO_MAIL_RES,AUTOFAC_SIN_IVA,COMISION_SIN_IVA_COM"; ICommissionAgent agent = await _commissionAgentDataServices.GetCommissionAgentDo(primaryKeyValue, query); Assert.NotNull(agent); Assert.NotNull(agent.Value); ComisioViewObject comisio = (ComisioViewObject)agent.Value; Assert.NotNull(comisio.NUM_COMI, primaryKeyValue); }
/// <summary> /// Create a domain wrapper for the commission agent transfer object /// </summary> /// <param name="viewObject">Data Transfer Object.</param> /// <returns></returns> public virtual async Task <ICommissionAgent> CreateCommissionAgentAsync(ComisioViewObject viewObject) { ICommissionAgent data = await _services.GetCommissionAgentDataServices().GetCommissionAgentDo(viewObject.NUM_COMI); data.Value = viewObject; return(data); }
public void Should_Throw_Entities_NotCorrectSavedData() { ComisioViewObject value = new ComisioViewObject { NUM_COMI = "" }; Assert.ThrowsAsync <DataLayerException>(async() => await _dataSaver.SaveAsync(value)); }
private COMISIO ConvertBack(ComisioViewObject comisio) { var c = new COMISIO(); if (_mapper != null) { c = _mapper.Map <ComisioViewObject, COMISIO>(comisio); } return(c); }
private ComisioViewObject Convert(COMISIO comisio) { var dto = new ComisioViewObject(); if (_mapper != null) { dto = _mapper.Map <COMISIO, ComisioViewObject>(comisio); } return(dto); }
public async Task Should_Entity_Insert_And_Delete_A_Correctly() { var value = new ComisioViewObject { NUM_COMI = "891892", NOMBRE = "Lucia" }; bool result = await _dataSaver.SaveAsync(value); Assert.IsTrue(result); bool dataDeleter = await _dataDeleter.DeleteAsync(value); Assert.IsTrue(dataDeleter); }
public override async Task <ICommissionAgent> CreateCommissionAgentAsync(ComisioViewObject viewObject) { ICommissionAgent agent = await _services.GetCommissionAgentDataServices().GetCommissionAgentDo(viewObject.NUM_COMI).ConfigureAwait(false); return(agent); }
public async Task Should_InsertContacts_Correctly() { // arrange IDictionary <string, string> fields; fields = new Dictionary <string, string> { { CommissionAgent.Comisio, "NUM_COMI,NOMBRE,DIRECCION,PERSONA,NIF,NACIOPER,TIPOCOMI" }, { CommissionAgent.Tipocomi, "NUM_TICOMI, ULTMODI, USUARIO, NOMBRE" }, { CommissionAgent.Visitas, " * " }, { CommissionAgent.Branches, "* " } }; string numComi = await GetFirstId(); ICommissionAgent commissionAgent = await _commissionAgentDataServices.GetCommissionAgentDo(numComi); // check if the condition is valid. Assert.True(commissionAgent.Valid); ComisioViewObject internalValue = (ComisioViewObject)commissionAgent.Value; ContactsViewObject contactsViewObject = new ContactsViewObject(); string contactosId = string.Empty; int comiDelega = 0; // this open a db connection and ensure that the primary key is unique. using (var dbconnection = _sqlExecutor.OpenNewDbConnection()) { CONTACTOS_COMI comi = new CONTACTOS_COMI(); contactosId = dbconnection.UniqueId(comi); var allDelega = await dbconnection.GetAsyncAll <COMI_DELEGA>(); var singleDelega = allDelega.FirstOrDefault(); if (singleDelega != null) { comiDelega = singleDelega.cldIdDelega; } } Random random = new Random(); contactsViewObject.ContactId = contactosId; contactsViewObject.ContactName = "Pineapple"; contactsViewObject.ContactsKeyId = internalValue.NUM_COMI; contactsViewObject.Nif = "Y171559F"; contactsViewObject.Email = "*****@*****.**"; contactsViewObject.Movil = "33409304"; contactsViewObject.State = 0; contactsViewObject.ResponsabilitySource = new PersonalPositionViewObject(); contactsViewObject.ResponsabilitySource.Code = "1"; contactsViewObject.ResponsabilitySource.Name = "GERENTE"; contactsViewObject.CurrentDelegation = comiDelega.ToString(); contactsViewObject.IsDirty = true; contactsViewObject.IsNew = true; IHelperDataServices helper = _dataServices.GetHelperDataServices(); IList <ContactsViewObject> entities = new List <ContactsViewObject>(); entities.Add(contactsViewObject); // act bool inserted = await helper.ExecuteBulkInsertAsync <ContactsViewObject, CONTACTOS_COMI>(entities); var allSavedContacts = await helper.GetMappedAllAsyncHelper <ContactsViewObject, CONTACTOS_COMI>(); var singleContact = allSavedContacts.FirstOrDefault(x => x.ContactId == contactosId); Assert.True(inserted); Assert.NotNull(singleContact); Assert.AreEqual(singleContact.ContactsKeyId, contactsViewObject.ContactsKeyId); Assert.AreEqual(singleContact.Email, contactsViewObject.Email); Assert.AreEqual(singleContact.Nif, contactsViewObject.Nif); Assert.AreEqual(singleContact.Movil, contactsViewObject.Movil); Assert.AreEqual(singleContact.State, contactsViewObject.State); Assert.AreEqual(singleContact.ResponsabilitySource.Code, contactsViewObject.ResponsabilitySource.Code); Assert.AreEqual(singleContact.ResponsabilitySource.Name, contactsViewObject.ResponsabilitySource.Name); }