public ResponseBo <List <PersonTableGroupListBo> > GetGroupList(PersonTableGroupGetListCriteriaBo criteriaBo) { ResponseBo <List <PersonTableGroupListBo> > responseBo = new ResponseBo <List <PersonTableGroupListBo> >(); try { using (SqlConnection conn = DbAccess.Connection.GetConn()) { var p = new DynamicParameters(); base.AddStandartSpParams(ref p, criteriaBo); p.Add("@PersonId", criteriaBo.PersonId, DbType.Int64, ParameterDirection.Input); p.Add("@PersonTableGroupStatId", criteriaBo.PersonTableGroupStatId, DbType.Int32, ParameterDirection.Input); responseBo.Bo = conn.Query <PersonTableGroupListBo>("spPersonTableGroupList", 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 <PersonTableGroupListBo> >(); } return(responseBo); }
public ResponseDto <List <PersonTableGroupListDto> > GetGroupList(PersonTableGroupGetListCriteriaDto criteriaDto) { PersonTableGroupGetListCriteriaBo criteriaBo = new PersonTableGroupGetListCriteriaBo() { PersonId = criteriaDto.PersonId, PersonTableGroupStatId = criteriaDto.PersonTableGroupStatId, Session = Session }; ResponseBo <List <PersonTableGroupListBo> > responseBo = personTableBusiness.GetGroupList(criteriaBo); ResponseDto <List <PersonTableGroupListDto> > responseDto = responseBo.ToResponseDto <List <PersonTableGroupListDto>, List <PersonTableGroupListBo> >(); if (responseBo.IsSuccess && responseBo.Bo != null) { responseDto.Dto = new List <PersonTableGroupListDto>(); foreach (PersonTableGroupListBo itemBo in responseBo.Bo) { responseDto.Dto.Add(new PersonTableGroupListDto() { Id = itemBo.Id, Name = itemBo.Name, PersonTableGroupStatId = itemBo.PersonTableGroupStatId, Order = itemBo.Order, TableCountsList = itemBo.TableCountsList == null ? null : (from o in itemBo.TableCountsList select new PersonTableCountsDto() { PersonTableStatId = o.PersonTableStatId, Count = o.Count }).ToList() }); } } return(responseDto); }