public ResponseBo <ProductCategoryCheckUrlBo> CheckUrl(ProductCategoryCheckUrlCriteriaBo criteriaBo)
        {
            ResponseBo <ProductCategoryCheckUrlBo> responseBo = new ResponseBo <ProductCategoryCheckUrlBo>();

            List <dynamic> dList = new List <dynamic>();

            for (int i = 0; i < criteriaBo.UrlSegmentList.Count(); i++)
            {
                dynamic dItem = new ExpandoObject();
                dItem.Segment = criteriaBo.UrlSegmentList[i];
                dItem.Index   = i;
                dList.Add(dItem);
            }

            string UrlSegmentListRawJson = JsonConvert.SerializeObject(dList);

            try
            {
                using (SqlConnection conn = DbAccess.Connection.GetConn())
                {
                    var p = new DynamicParameters();
                    p.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 255);
                    p.Add("@IsSuccess", dbType: DbType.Boolean, direction: ParameterDirection.Output);

                    p.Add("@UrlSegmentListRawJson", UrlSegmentListRawJson, DbType.String, ParameterDirection.Input, 1000);

                    p.Add("@MyPersonId", criteriaBo.Session.MyPerson.Id, DbType.Int64, ParameterDirection.Input);
                    p.Add("@OperatorRealId", criteriaBo.Session.RealPerson.Id, DbType.Int64, ParameterDirection.Input);
                    p.Add("@LanguageId", criteriaBo.Session.RealPerson.LanguageId, DbType.Int32, ParameterDirection.Input);

                    responseBo.Bo        = conn.Query <ProductCategoryCheckUrlBo>("spProductCategoryCheckUrl", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
                    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 <ProductCategoryCheckUrlBo>();
            }

            return(responseBo);
        }
Beispiel #2
0
        public ResponseDto <ProductCategoryCheckUrlDto> CheckUrl(ProductCategoryCheckUrlCriteriaDto criteriaDto)
        {
            ProductCategoryCheckUrlCriteriaBo criteriaBo = new ProductCategoryCheckUrlCriteriaBo()
            {
                UrlSegmentList = criteriaDto.UrlSegmentList,

                Session = Session
            };

            ResponseBo <ProductCategoryCheckUrlBo> responseBo = productCategoryBusiness.CheckUrl(criteriaBo);

            ResponseDto <ProductCategoryCheckUrlDto> responseDto = responseBo.ToResponseDto <ProductCategoryCheckUrlDto, ProductCategoryCheckUrlBo>();

            if (responseBo.IsSuccess && responseBo.Bo != null)
            {
                responseDto.Dto = new ProductCategoryCheckUrlDto()
                {
                    ProductCategoryId = responseBo.Bo.ProductCategoryId
                };
            }

            return(responseDto);
        }