public async Task Should_create_address_update_and_then_delete()
{
var req = Setup.CreateCustomerRequest();
var customerId = await endpoint.Create(req);
//Create address
var addressEndpoint = endpoint.Endpoints.Address(customerId);
var areq = new AddressCreateRequest
{
City = Faker.Address.City(),
CountryCode = Faker.Address.CountryCode(),
Lines = new List <string>
{
Faker.Address.SecondaryAddress()
},
PostalCode = Faker.Address.ZipCode(),
State = Faker.Address.State()
};
await addressEndpoint.Create(areq);
//Get Address
var savedAddress = await addressEndpoint.Get();
Assert.Equal(areq.CountryCode, savedAddress.Country);
Assert.Equal(areq.City, savedAddress.City);
Assert.Equal(areq.Lines, savedAddress.Lines);
Assert.Equal(areq.PostalCode, savedAddress.PostalCode);
Assert.Equal(areq.State, savedAddress.State);
//Update address
areq.City = "Kathmandu";
areq.CountryCode = "NP";
areq.PostalCode = "12345";
await addressEndpoint.Update(areq);
savedAddress = await addressEndpoint.Get();
Assert.Equal(areq.CountryCode, savedAddress.Country);
Assert.Equal(areq.City, savedAddress.City);
Assert.Equal(areq.Lines, savedAddress.Lines);
Assert.Equal(areq.PostalCode, savedAddress.PostalCode);
Assert.Equal(areq.State, savedAddress.State);
//delete address
await addressEndpoint.Delete();
savedAddress = await addressEndpoint.Get();
Assert.Null(savedAddress.Country);
Assert.Null(savedAddress.City);
Assert.Empty(savedAddress.Lines);
Assert.Null(savedAddress.PostalCode);
Assert.Null(savedAddress.State);
}
public AddressCreateResponse CreateAddress(AddressCreateRequest createRequest)
{
var response = new AddressCreateResponse();
var validationErrors = _validation.createRequestValidation.Validate(createRequest);
var dbErrors = new List <DatabaseErrors>();
if (validationErrors.Count != 0)
{
response.ValidationErrors = validationErrors;
}
else
{
try
{
var address = AddAddressToDB(createRequest);
var addresses = new List <Address>();
addresses.Add(address);
if (address == null)
{
throw new NullReferenceException("Address not Found");
}
response.Addresses = addresses;
} catch (NullReferenceException)
{
dbErrors.Add(DatabaseErrors.DB_CONNECTION_FAILED);
}
response.DBErrors = dbErrors;
}
return(response);
}
public override StoreCreateResponse Execute(StoreCreateRequest request)
{
var storeDto = request.Store;
var addressCreateRequest = new AddressCreateRequest
{
Address = _mapper.Map <AddressDto, AddressCreateOrUpdateDto>(storeDto.Address)
};
var addressCreateResponse = _internalCommandService.Execute(addressCreateRequest);
var entity = new Entities.StoreModule.Store
{
Name = storeDto.Name,
Logo = storeDto.Logo,
Phone = storeDto.Phone,
Email = storeDto.Email,
AddressId = addressCreateResponse.AddressId,
TimezoneId = storeDto.Timezone
};
_storeRepository.Add(entity);
return(new StoreCreateResponse());
}
private Address AddAddressToDB(AddressCreateRequest createRequest)
{
return(_repository.Create(
new Address
{
Country = createRequest.Country,
City = createRequest.City,
Street = createRequest.Street,
House_Number = createRequest.House_Number,
Flat_Number = createRequest.Flat_Number,
Additional_Info = createRequest.Additional_Info,
Phone = createRequest.Phone,
User_Id = createRequest.User_Id
}
));
}
public AddressCreateDTO PostAddress([FromBody] AddressCreateRequest addressRequest)
{
var responseJson = new AddressCreateDTO();
var address = _addressService.CreateAddress(addressRequest);
if (address.HasValidationErrors() || address.HasDBErrors())
{
responseJson.validationErrors = _convertErrorsToString <AddressValidationErrors>(address.ValidationErrors);
responseJson.dbErrors = address.DBErrors;
}
else
{
responseJson.AddressResponse = address;
}
return(responseJson);
}
public async Task <int> Create(AddressCreateRequest request)
{
var adderss = new Ib_address()
{
Ib_customer_address_city = request.Ib_customer_address_city,
Ib_customer_address_line_1 = request.Ib_customer_address_line_1,
Ib_customer_address_line_2 = request.Ib_customer_address_line_2,
Ib_customer_address_phone_1 = request.Ib_customer_address_phone_1,
Ib_customer_address_phone_2 = request.Ib_customer_address_phone_2,
Ib_customer_address_postal_code = request.Ib_customer_address_postal_code,
Ib_customer_address_state = request.Ib_customer_address_state,
Ib_customer_address_website_url = request.Ib_customer_address_website_url,
Ib_customer_id = request.Ib_customer_id,
};
db.Ib_addresses.Add(adderss);
return(await db.SaveChangesAsync());
}
public HttpResponseMessage Create(AddressCreateRequest model, int userId)
{
if (!IsValidRequest(model))
{
return(GetErrorResponse(model));
}
if (userId != model.UserId)
{
ErrorResponse error = new ErrorResponse("The userId in the route and request do not match");
return(Request.CreateResponse(HttpStatusCode.BadRequest, error));
}
Guid id = _addressService.Create(model);
ItemResponse <Guid> responseData = new ItemResponse <Guid>();
responseData.Item = id;
return(Request.CreateResponse(HttpStatusCode.OK, responseData));
}
public Guid Create(AddressCreateRequest model)
{
Guid createId = Guid.Empty;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Addresses_Insert",
inputParamMapper : delegate(SqlParameterCollection parameters)
{
parameters.AddWithValue("@UserId", model.UserId);
parameters.AddWithValue("@Name", model.Name);
if (model.Street == null)
{
parameters.AddWithValue("@Street", DBNull.Value);
}
else
{
parameters.AddWithValue("@Street", model.Street);
}
if (model.Street2 == null)
{
parameters.AddWithValue("@Street2", DBNull.Value);
}
else
{
parameters.AddWithValue("@Street2", model.Street2);
}
if (model.City == null)
{
parameters.AddWithValue("@City", DBNull.Value);
}
else
{
parameters.AddWithValue("@City", model.City);
}
if (model.State == null)
{
parameters.AddWithValue("@State", DBNull.Value);
}
else
{
parameters.AddWithValue("@State", model.State);
}
if (model.PostalCode == null)
{
parameters.AddWithValue("@PostalCode", DBNull.Value);
}
else
{
parameters.AddWithValue("@PostalCode", model.PostalCode);
}
parameters.Add(new SqlParameter
{
DbType = DbType.Guid,
Direction = ParameterDirection.Output,
ParameterName = "@Id"
});
},
returnParameters : delegate(SqlParameterCollection parameters)
{
createId = Guid.Parse(parameters["@Id"].Value.ToString());
}
);
return(createId);
}
