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