public async Task <PersonDTO> GetPersonByIdWithRelatedPersonsAndPhoneNumbers(int id)
{
return(await _context.People.Include(x => x.RelatedPeople).Include(x => x.PhoneNumbers).Where(x => x.Id == id)
.Select(x => PersonDTO.CreateFrom(x, x.RelatedPeople.Select(r => RelatedPersonDTO.CreateFrom(r.Id, r.PersonId, (int)r.Type, PersonDTO.CreateFrom(_context.People.FirstOrDefault(p => p.Id == r.RPersonId), null)))))
.FirstOrDefaultAsync());
}
public HttpResponseMessage Modify(int idRelatedPerson, [FromBody] RelatedPersonDTO dto)
{
// CAD, CEN, returnValue
RelatedPersonRESTCAD relatedPersonRESTCAD = null;
RelatedPersonCEN relatedPersonCEN = null;
RelatedPersonDTOA returnValue = null;
// HTTP response
HttpResponseMessage response = null;
string uri = null;
try
{
SessionInitializeTransaction();
relatedPersonRESTCAD = new RelatedPersonRESTCAD(session);
relatedPersonCEN = new RelatedPersonCEN(relatedPersonRESTCAD);
// Modify
relatedPersonCEN.Modify(idRelatedPerson,
dto.Name
,
dto.Description
);
// Return modified object
returnValue = RelatedPersonAssembler.Convert(relatedPersonRESTCAD.ReadOIDDefault(idRelatedPerson), session);
SessionCommit();
}
catch (Exception e)
{
SessionRollBack();
if (e.GetType() == typeof(HttpResponseException))
{
throw e;
}
else if (e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.ModelException) && e.Message.Equals("El token es incorrecto"))
{
throw new HttpResponseException(HttpStatusCode.Forbidden);
}
else if (e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.ModelException) || e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.DataLayerException))
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
else
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
finally
{
SessionClose();
}
// Return 404 - Not found
if (returnValue == null)
{
return(this.Request.CreateResponse(HttpStatusCode.NotFound));
}
// Return 200 - OK
else
{
response = this.Request.CreateResponse(HttpStatusCode.OK, returnValue);
return(response);
}
}
public static RelatedPersonEN Convert(RelatedPersonDTO dto)
{
RelatedPersonEN newinstance = null;
try
{
if (dto != null)
{
newinstance = new RelatedPersonEN();
if (dto.UserRelatedPerson_oid != -1)
{
MoSIoTGenNHibernate.CAD.MosIoT.IUserCAD userCAD = new MoSIoTGenNHibernate.CAD.MosIoT.UserCAD();
newinstance.UserRelatedPerson = userCAD.ReadOIDDefault(dto.UserRelatedPerson_oid);
}
newinstance.Id = dto.Id;
newinstance.Name = dto.Name;
if (dto.OriginAssociation_oid != null)
{
MoSIoTGenNHibernate.CAD.MosIoT.IAssociationCAD associationCAD = new MoSIoTGenNHibernate.CAD.MosIoT.AssociationCAD();
newinstance.OriginAssociation = new System.Collections.Generic.List <MoSIoTGenNHibernate.EN.MosIoT.AssociationEN>();
foreach (int entry in dto.OriginAssociation_oid)
{
newinstance.OriginAssociation.Add(associationCAD.ReadOIDDefault(entry));
}
}
if (dto.TargetAssociation_oid != null)
{
MoSIoTGenNHibernate.CAD.MosIoT.IAssociationCAD associationCAD = new MoSIoTGenNHibernate.CAD.MosIoT.AssociationCAD();
newinstance.TargetAssociation = new System.Collections.Generic.List <MoSIoTGenNHibernate.EN.MosIoT.AssociationEN>();
foreach (int entry in dto.TargetAssociation_oid)
{
newinstance.TargetAssociation.Add(associationCAD.ReadOIDDefault(entry));
}
}
if (dto.Scenario_oid != -1)
{
MoSIoTGenNHibernate.CAD.MosIoT.IIoTScenarioCAD ioTScenarioCAD = new MoSIoTGenNHibernate.CAD.MosIoT.IoTScenarioCAD();
newinstance.Scenario = ioTScenarioCAD.ReadOIDDefault(dto.Scenario_oid);
}
newinstance.Description = dto.Description;
if (dto.Operations != null)
{
MoSIoTGenNHibernate.CAD.MosIoT.IEntityOperationCAD entityOperationCAD = new MoSIoTGenNHibernate.CAD.MosIoT.EntityOperationCAD();
newinstance.Operations = new System.Collections.Generic.List <MoSIoTGenNHibernate.EN.MosIoT.EntityOperationEN>();
foreach (EntityOperationDTO entry in dto.Operations)
{
newinstance.Operations.Add(EntityOperationAssemblerDTO.Convert(entry));
}
}
if (dto.Attributes != null)
{
MoSIoTGenNHibernate.CAD.MosIoT.IEntityAttributesCAD entityAttributesCAD = new MoSIoTGenNHibernate.CAD.MosIoT.EntityAttributesCAD();
newinstance.Attributes = new System.Collections.Generic.List <MoSIoTGenNHibernate.EN.MosIoT.EntityAttributesEN>();
foreach (EntityAttributesDTO entry in dto.Attributes)
{
newinstance.Attributes.Add(EntityAttributesAssemblerDTO.Convert(entry));
}
}
if (dto.States != null)
{
MoSIoTGenNHibernate.CAD.MosIoT.IEntityStateCAD entityStateCAD = new MoSIoTGenNHibernate.CAD.MosIoT.EntityStateCAD();
newinstance.States = new System.Collections.Generic.List <MoSIoTGenNHibernate.EN.MosIoT.EntityStateEN>();
foreach (EntityStateDTO entry in dto.States)
{
newinstance.States.Add(EntityStateAssemblerDTO.Convert(entry));
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(newinstance);
}
public HttpResponseMessage New_([FromBody] RelatedPersonDTO dto)
{
// CAD, CEN, returnValue, returnOID
RelatedPersonRESTCAD relatedPersonRESTCAD = null;
RelatedPersonCEN relatedPersonCEN = null;
RelatedPersonDTOA returnValue = null;
int returnOID = -1;
// HTTP response
HttpResponseMessage response = null;
string uri = null;
try
{
SessionInitializeTransaction();
relatedPersonRESTCAD = new RelatedPersonRESTCAD(session);
relatedPersonCEN = new RelatedPersonCEN(relatedPersonRESTCAD);
// Create
returnOID = relatedPersonCEN.New_(
dto.Name //Atributo Primitivo: p_name
,
//Atributo OID: p_scenario
// attr.estaRelacionado: true
dto.Scenario_oid // association role
, dto.Description //Atributo Primitivo: p_description
,
//Atributo OID: p_userRelatedPerson
// attr.estaRelacionado: true
dto.UserRelatedPerson_oid // association role
);
SessionCommit();
// Convert return
returnValue = RelatedPersonAssembler.Convert(relatedPersonRESTCAD.ReadOIDDefault(returnOID), session);
}
catch (Exception e)
{
SessionRollBack();
if (e.GetType() == typeof(HttpResponseException))
{
throw e;
}
else if (e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.ModelException) && e.Message.Equals("El token es incorrecto"))
{
throw new HttpResponseException(HttpStatusCode.Forbidden);
}
else if (e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.ModelException) || e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.DataLayerException))
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
else
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
finally
{
SessionClose();
}
// Return 201 - Created
response = this.Request.CreateResponse(HttpStatusCode.Created, returnValue);
// Location Header
/*
* Dictionary<string, object> routeValues = new Dictionary<string, object>();
*
* // TODO: y rolPaths
* routeValues.Add("id", returnOID);
*
* uri = Url.Link("GetOIDRelatedPerson", routeValues);
* response.Headers.Location = new Uri(uri);
*/
return(response);
}
