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); } }