public async Task ItIsPossibleToCarryOutTheZipCodeCrud()
{
using (var myContext = _serviceProvider.GetService <MyContext>())
{
CountyImplementation countyImplementation = new CountyImplementation(myContext);
CountyEntity countyEntity = new CountyEntity
{
Name = Faker.Address.City(),
CodeIbge = Faker.RandomNumber.Next(1000000, 9999999),
FederalUnitId = new Guid("e7e416de-477c-4fa3-a541-b5af5f35ccf6"),
};
var recordCounty = await countyImplementation.InsertAsync(countyEntity);
Assert.NotNull(recordCounty);
Assert.Equal(countyEntity.Name, recordCounty.Name);
Assert.Equal(countyEntity.CodeIbge, recordCounty.CodeIbge);
Assert.Equal(countyEntity.FederalUnitId, recordCounty.FederalUnitId);
Assert.False(recordCounty.Id == Guid.Empty);
ZipCodeImplementation zipCodeImplementation = new ZipCodeImplementation(myContext);
ZipCodeEntity zipCodeEntity = new ZipCodeEntity
{
ZipCode = "13.481-001",
PublicPlace = Faker.Address.StreetName(),
Number = "0 até 2000",
CountyId = recordCounty.Id
};
var recordZipCode = await zipCodeImplementation.InsertAsync(zipCodeEntity);
Assert.NotNull(recordZipCode);
Assert.Equal(zipCodeEntity.ZipCode, recordZipCode.ZipCode);
Assert.Equal(zipCodeEntity.PublicPlace, recordZipCode.PublicPlace);
Assert.Equal(zipCodeEntity.Number, recordZipCode.Number);
Assert.Equal(zipCodeEntity.CountyId, recordZipCode.CountyId);
Assert.False(recordZipCode.Id == Guid.Empty);
zipCodeEntity.PublicPlace = Faker.Address.StreetName();
zipCodeEntity.Id = recordZipCode.Id;
var recordUpdate = await zipCodeImplementation.UpdateAsync(zipCodeEntity);
Assert.NotNull(recordUpdate);
Assert.Equal(zipCodeEntity.ZipCode, recordUpdate.ZipCode);
Assert.Equal(zipCodeEntity.PublicPlace, recordUpdate.PublicPlace);
Assert.Equal(zipCodeEntity.Number, recordUpdate.Number);
Assert.Equal(zipCodeEntity.CountyId, recordUpdate.CountyId);
Assert.True(recordZipCode.Id == zipCodeEntity.Id);
var recordExists = await zipCodeImplementation.ExistAsync(recordUpdate.Id);
Assert.True(recordExists);
var recordSelect = await zipCodeImplementation.SelectAsync(recordUpdate.Id);
Assert.NotNull(recordSelect);
Assert.Equal(recordSelect.ZipCode, recordUpdate.ZipCode);
Assert.Equal(recordSelect.PublicPlace, recordUpdate.PublicPlace);
Assert.Equal(recordSelect.Number, recordUpdate.Number);
Assert.Equal(recordSelect.CountyId, recordUpdate.CountyId);
recordSelect = await zipCodeImplementation.SelectAsync(recordUpdate.ZipCode);
Assert.NotNull(recordSelect);
Assert.Equal(recordSelect.ZipCode, recordUpdate.ZipCode);
Assert.Equal(recordSelect.PublicPlace, recordUpdate.PublicPlace);
Assert.Equal(recordSelect.Number, recordUpdate.Number);
Assert.Equal(recordSelect.CountyId, recordUpdate.CountyId);
Assert.NotNull(recordSelect.County);
Assert.NotNull(recordSelect.County.Id);
Assert.Equal(recordSelect.County.Name, countyEntity.Name);
Assert.Equal(recordSelect.County.FederalUnit.Initials, "SP");
var recordSelectAll = await zipCodeImplementation.SelectAsync();
Assert.NotNull(recordSelectAll);
Assert.True(recordSelectAll.Count() > 0);
var recordDelete = await zipCodeImplementation.DeleteAsync(recordSelect.Id);
Assert.True(recordDelete);
recordSelectAll = await zipCodeImplementation.SelectAsync();
Assert.NotNull(recordSelectAll);
Assert.True(recordSelectAll.Count() == 0);
}
}
public async Task ItIsPossibleToCarryOutTheCountyCrud()
{
using (var myContext = _serviceProvider.GetService <MyContext>())
{
CountyImplementation countyImplementation = new CountyImplementation(myContext);
CountyEntity countyEntity = new CountyEntity
{
Name = Faker.Address.City(),
CodeIbge = Faker.RandomNumber.Next(1000000, 9999999),
FederalUnitId = new Guid("e7e416de-477c-4fa3-a541-b5af5f35ccf6"),
};
var record = await countyImplementation.InsertAsync(countyEntity);
Assert.NotNull(record);
Assert.Equal(countyEntity.Name, record.Name);
Assert.Equal(countyEntity.CodeIbge, record.CodeIbge);
Assert.Equal(countyEntity.FederalUnitId, record.FederalUnitId);
Assert.False(record.Id == Guid.Empty);
countyEntity.Name = Faker.Address.City();
countyEntity.Id = record.Id;
var recordUpdate = await countyImplementation.UpdateAsync(countyEntity);
Assert.NotNull(recordUpdate);
Assert.Equal(countyEntity.Name, recordUpdate.Name);
Assert.Equal(countyEntity.CodeIbge, recordUpdate.CodeIbge);
Assert.Equal(countyEntity.FederalUnitId, recordUpdate.FederalUnitId);
Assert.True(record.Id == countyEntity.Id);
var recordExists = await countyImplementation.ExistAsync(countyEntity.Id);
Assert.True(recordExists);
var recordSelect = await countyImplementation.SelectAsync(countyEntity.Id);
Assert.NotNull(recordSelect);
Assert.Equal(recordUpdate.Name, recordSelect.Name);
Assert.Equal(recordUpdate.CodeIbge, recordSelect.CodeIbge);
Assert.Equal(recordUpdate.FederalUnitId, recordSelect.FederalUnitId);
Assert.Null(recordSelect.FederalUnit);
recordSelect = await countyImplementation.GetCompleteByIbgeAsync(recordUpdate.CodeIbge);
Assert.NotNull(recordSelect);
Assert.Equal(recordUpdate.Name, recordSelect.Name);
Assert.Equal(recordUpdate.CodeIbge, recordSelect.CodeIbge);
Assert.Equal(recordUpdate.FederalUnitId, recordSelect.FederalUnitId);
Assert.NotNull(recordSelect.FederalUnit);
recordSelect = await countyImplementation.GetCompleteByIdAsync(recordUpdate.Id);
Assert.NotNull(recordSelect);
Assert.Equal(recordUpdate.Name, recordSelect.Name);
Assert.Equal(recordUpdate.CodeIbge, recordSelect.CodeIbge);
Assert.Equal(recordUpdate.FederalUnitId, recordSelect.FederalUnitId);
Assert.NotNull(recordSelect.FederalUnit);
var allRecord = await countyImplementation.SelectAsync();
Assert.NotNull(allRecord);
Assert.True(allRecord.Count() > 0);
var deleteRecord = await countyImplementation.DeleteAsync(recordSelect.Id);
Assert.True(deleteRecord);
allRecord = await countyImplementation.SelectAsync();
Assert.NotNull(allRecord);
Assert.True(allRecord.Count() == 0);
}
}
