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