public BaseApiResponse CheckUniqueCounty(CountyEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param =
{
new SqlParameter("countyId", (object)model.CountyId ?? (object)DBNull.Value)
, new SqlParameter("countyName", (object)model.CountyName ?? (object)DBNull.Value)
, new SqlParameter("stateId", (object)model.StateId ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <int>("CheckUniqueCounty", param).FirstOrDefault();
if (result == 0)
{
response.Success = false;
}
else
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse InsertCounty(CountyEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("countyName", (object)model.CountyName ?? (object)DBNull.Value)
, new SqlParameter("stateID", (object)model.StateId ?? (object)DBNull.Value)
, new SqlParameter("isActive", (object)model.IsActive ?? (object)DBNull.Value)
, new SqlParameter("createdBy", (object)model.CreatedBy ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <int>("InsertCounty", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public void ItIsPossibleToMapTheModelsCounty()
{
var countyModel = new CountyModel
{
Id = Guid.NewGuid(),
Name = Faker.Address.City(),
CodeIbge = Faker.RandomNumber.Next(1000000, 9999999),
FederalUnitId = Guid.NewGuid(),
CreateAt = DateTime.Now,
UpdateAt = DateTime.Now
};
var listCountyEntity = new List <CountyEntity>();
for (int i = 0; i < 5; i++)
{
var itemCountyEntity = new CountyEntity
{
Id = Guid.NewGuid(),
Name = Faker.Address.City(),
CodeIbge = Faker.RandomNumber.Next(1, 100000),
FederalUnitId = Guid.NewGuid(),
CreateAt = DateTime.Now,
UpdateAt = DateTime.Now,
FederalUnit = new FederalUnitEntity
{
Id = Guid.NewGuid(),
Name = Faker.Address.UsState(),
Initials = Faker.Address.UsState().Substring(1, 3)
}
};
listCountyEntity.Add(itemCountyEntity);
}
#region Model => Entity
//Model => Entity
var countyEntity = Mapper.Map <CountyEntity>(countyModel);
Assert.Equal(countyEntity.Id, countyModel.Id);
Assert.Equal(countyEntity.Name, countyModel.Name);
Assert.Equal(countyEntity.CodeIbge, countyModel.CodeIbge);
Assert.Equal(countyEntity.FederalUnitId, countyModel.FederalUnitId);
Assert.Equal(countyEntity.CreateAt, countyModel.CreateAt);
Assert.Equal(countyEntity.UpdateAt, countyModel.UpdateAt);
#endregion
#region Entity => Dto
//Entity => Dto
var countyDto = Mapper.Map <CountyDto>(countyEntity);
Assert.Equal(countyDto.Id, countyEntity.Id);
Assert.Equal(countyDto.Name, countyEntity.Name);
Assert.Equal(countyDto.CodeIbge, countyEntity.CodeIbge);
Assert.Equal(countyDto.FederalUnitId, countyEntity.FederalUnitId);
#endregion
#region CompleteDto => Entity
// CompleteDto => Entity
var countyCompleteDto = Mapper.Map <CountyCompleteDto>(listCountyEntity.FirstOrDefault());
Assert.Equal(countyCompleteDto.Id, listCountyEntity.FirstOrDefault().Id);
Assert.Equal(countyCompleteDto.Name, listCountyEntity.FirstOrDefault().Name);
Assert.Equal(countyCompleteDto.CodeIbge, listCountyEntity.FirstOrDefault().CodeIbge);
Assert.Equal(countyCompleteDto.FederalUnitId, listCountyEntity.FirstOrDefault().FederalUnitId);
Assert.NotNull(countyCompleteDto.FederalUnit);
#endregion
#region List CountyDto => List CountyEntity
// List CountyDto => List CountyEntity
var listCountyDto = Mapper.Map <List <CountyDto> >(listCountyEntity);
Assert.True(listCountyDto.Count() == listCountyEntity.Count());
for (int i = 0; i < listCountyDto.Count(); i++)
{
Assert.Equal(listCountyDto[i].Id, listCountyEntity[i].Id);
Assert.Equal(listCountyDto[i].Name, listCountyEntity[i].Name);
Assert.Equal(listCountyDto[i].CodeIbge, listCountyEntity[i].CodeIbge);
Assert.Equal(listCountyDto[i].FederalUnitId, listCountyEntity[i].FederalUnitId);
}
#endregion
#region County Entity => County Create Result Dto
// County Entity => County Create Result Dto
var countyCreateResultDto = Mapper.Map <CountyCreateResultDto>(countyEntity);
Assert.Equal(countyCreateResultDto.Id, countyEntity.Id);
Assert.Equal(countyCreateResultDto.Name, countyEntity.Name);
Assert.Equal(countyCreateResultDto.CodeIbge, countyEntity.CodeIbge);
Assert.Equal(countyCreateResultDto.FederalUnitId, countyEntity.FederalUnitId);
#endregion
#region County Entity => County Update Result Dto
// County Entity => County Update Result Dto
var countyUpdateResultDto = Mapper.Map <CountyUpdateResultDto>(countyEntity);
Assert.Equal(countyUpdateResultDto.Id, countyEntity.Id);
Assert.Equal(countyUpdateResultDto.Name, countyEntity.Name);
Assert.Equal(countyUpdateResultDto.CodeIbge, countyEntity.CodeIbge);
Assert.Equal(countyUpdateResultDto.FederalUnitId, countyEntity.FederalUnitId);
#endregion
#region Dto => Model
// Dto => Model
var model = Mapper.Map <CountyModel>(countyDto);
Assert.Equal(model.Id, countyDto.Id);
Assert.Equal(model.Name, countyDto.Name);
Assert.Equal(model.CodeIbge, countyDto.CodeIbge);
Assert.Equal(model.FederalUnitId, countyDto.FederalUnitId);
#endregion
#region Model => Create Dto
//Model => Create Dto
var countyCreateDto = Mapper.Map <CountyCreateDto>(model);
Assert.Equal(countyCreateDto.Name, model.Name);
Assert.Equal(countyCreateDto.CodeIbge, model.CodeIbge);
Assert.Equal(countyCreateDto.FederalUnitId, model.FederalUnitId);
#endregion
#region Model => Update Dto
//Model => Update Dto
var countyUpdateDto = Mapper.Map <CountyUpdateDto>(model);
Assert.Equal(countyUpdateDto.Id, model.Id);
Assert.Equal(countyUpdateDto.Name, model.Name);
Assert.Equal(countyUpdateDto.CodeIbge, model.CodeIbge);
Assert.Equal(countyUpdateDto.FederalUnitId, model.FederalUnitId);
#endregion
}
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);
}
}
