Пример #1
0
        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);
        }
Пример #2
0
        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);
        }