public List <PersonPhoneResponseDto> SelectPersonPhone(PersonPhoneResponseDto request)
{
var data = (from phone in _context.PersonPhone
join person in _context.Person
on phone.BusinessEntityID equals person.BusinessEntityID
join phoneType in _context.PhoneNumberType
on phone.PhoneNumberTypeID equals phoneType.PhoneNumberTypeID
where phone.PhoneNumber.Contains(request.PhoneNumber)
select new PersonPhoneResponseDto
{
PersonName = person.Name,
BusinessEntityID = person.BusinessEntityID,
PhoneNumber = phone.PhoneNumber,
PhoneNumberTypeID = phoneType.PhoneNumberTypeID,
PhoneType = phoneType.Name
}).ToList();
return(data);
}
public PersonPhoneResponse SelectPersonPhone(string phoneNumber)
{
var request = new PersonPhoneResponseDto()
{
PhoneNumber = phoneNumber,
};
var response = new PersonPhoneResponse();
try
{
var result = _personPhoneService.SelectPersonPhone(request);
response.Success = true;
response.PersonObjects = result;
}
catch (Exception ex)
{
response.Success = false;
response.Errors.Add(ex);
}
return(response);
}
public PersonPhoneResponse UpdatePersonPhone(PersonPhoneResponseDto objReq, string newPhoneNumber)
{
var request = new PersonPhone()
{
BusinessEntityID = objReq.BusinessEntityID,
PhoneNumber = objReq.PhoneNumber,
PhoneNumberTypeID = objReq.PhoneNumberTypeID,
};
var response = new PersonPhoneResponse();
try
{
var result = _personPhoneService.UpdatePersonPhone(request, newPhoneNumber);
response.Success = result;
}
catch (Exception ex)
{
response.Success = false;
response.Errors.Add(ex);
}
return(response);
}
public IActionResult UpdatePersonPhone([FromBody] PersonPhoneResponseDto request, [FromQuery] string newPhoneNumber)
{
var response = _facadePhone.UpdatePersonPhone(request, newPhoneNumber);
return(Response(response));
}
public IActionResult InsertPersonPhone(PersonPhoneResponseDto request)
{
var response = _facadePhone.InsertPersonPhone(request);
return(Response(response));
}
