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