public ResponseDto <List <AddressCityDto> > GetCityList(AddressGetCityListCriteriaDto criteriaDto) { AddressGetCityListCriteriaBo criteriaBo = new AddressGetCityListCriteriaBo() { CountryId = criteriaDto.CountryId, StateId = criteriaDto.StateId, Session = Session }; ResponseBo <List <AddressCityBo> > responseBo = addressBusiness.GetCityList(criteriaBo); ResponseDto <List <AddressCityDto> > responseDto = responseBo.ToResponseDto <List <AddressCityDto>, List <AddressCityBo> >(); if (responseBo.IsSuccess && responseBo.Bo != null) { responseDto.Dto = new List <AddressCityDto>(); foreach (AddressCityBo itemBo in responseBo.Bo) { responseDto.Dto.Add(new AddressCityDto() { Id = itemBo.Id, Name = itemBo.Name, Plate = itemBo.Plate, StatedId = itemBo.StatedId, CountryId = itemBo.CountryId }); } } return(responseDto); }
public ResponseBo <List <AddressCityBo> > GetCityList(AddressGetCityListCriteriaBo criteriaBo) { ResponseBo <List <AddressCityBo> > responseBo = new ResponseBo <List <AddressCityBo> >(); try { using (SqlConnection conn = DbAccess.Connection.GetConn()) { var p = new DynamicParameters(); base.AddStandartSpParams(ref p, criteriaBo); p.Add("@CountryId", criteriaBo.CountryId, DbType.Int32, ParameterDirection.Input); p.Add("@StateId", criteriaBo.StateId, DbType.Int32, ParameterDirection.Input); responseBo.Bo = conn.Query <AddressCityBo>("spAddressCityList", p, commandType: CommandType.StoredProcedure).ToList(); responseBo.Message = p.Get <string>("@Message"); responseBo.IsSuccess = p.Get <bool>("@IsSuccess"); } } catch (Exception ex) { responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, criteriaBo).ToResponse <List <AddressCityBo> >(); } return(responseBo); }