public async Task <IActionResult> GetByNumberAndPostalCode(int?number, string postal)
        {
            if (!number.HasValue || String.IsNullOrEmpty(postal))
            {
                return(StatusCode(400, "Invalid parameter(s)."));
            }

            //Get debtor address link
            var data = await _repo.GetAddressByPostalAndNumber(number.Value, postal);

            if (data == null)
            {
                return(StatusCode(500, "Debtor -> Address relation could not be found."));
            }

            //Convert to view model
            var result = new DebtorHasAddressViewModel();

            result.SetProperties(data);

            return(Ok(result));
        }
        public async Task <IActionResult> GetByDebtorId(string id)
        {
            if (String.IsNullOrEmpty(id))
            {
                return(StatusCode(400, "Invalid parameter(s)."));
            }

            //Get debtor address link
            var data = await _repo.GetAddressByDebtorId(id);

            if (data == null)
            {
                return(StatusCode(500, "Debtor -> Address relation could not be found."));
            }

            //Convert to view model
            var result = new DebtorHasAddressViewModel();

            result.SetProperties(data);

            return(Ok(result));
        }
        public async Task <IActionResult> Create([FromBody] DebtorHasAddressViewModel model)
        {
            if (model == null)
            {
                return(StatusCode(400, "Invalid parameter(s)."));
            }

            DebtorHasAddress debtorHasAddress = new DebtorHasAddress
            {
                DebtorId   = model.DebtorId,
                Number     = model.Number,
                PostalCode = model.PostalCode
            };

            //Insert relation between debtor and address
            var result = await _repo.Insert(debtorHasAddress);

            if (result == null)
            {
                return(StatusCode(500, "A problem occured while saving the record. Please try again!"));
            }

            return(Ok(result));
        }