public ResponseBo <List <PersonTableListBo> > GetList(PersonTableGetListCriteriaBo criteriaBo) { ResponseBo <List <PersonTableListBo> > responseBo = new ResponseBo <List <PersonTableListBo> >(); try { using (SqlConnection conn = DbAccess.Connection.GetConn()) { var p = new DynamicParameters(); base.AddStandartSpParams(ref p, criteriaBo); p.Add("@GroupId", criteriaBo.GroupId, DbType.Int64, ParameterDirection.Input); p.Add("@PersonTableStatId", criteriaBo.PersonTableStatId, DbType.Int32, ParameterDirection.Input); responseBo.Bo = conn.Query <PersonTableListBo>("spPersonTableList", 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 <PersonTableListBo> >(); } return(responseBo); }
public ResponseDto <List <PersonTableListDto> > GetList(PersonTableGetListCriteriaDto criteriaDto) { PersonTableGetListCriteriaBo criteriaBo = new PersonTableGetListCriteriaBo() { GroupId = criteriaDto.GroupId, PersonTableStatId = criteriaDto.PersonTableStatId, Session = Session }; ResponseBo <List <PersonTableListBo> > responseBo = personTableBusiness.GetList(criteriaBo); ResponseDto <List <PersonTableListDto> > responseDto = responseBo.ToResponseDto <List <PersonTableListDto>, List <PersonTableListBo> >(); if (responseBo.IsSuccess && responseBo.Bo != null) { responseDto.Dto = new List <PersonTableListDto>(); foreach (PersonTableListBo itemBo in responseBo.Bo) { responseDto.Dto.Add(new PersonTableListDto() { Id = itemBo.Id, Name = itemBo.Name, PersonTableStatId = itemBo.PersonTableStatId, Order = itemBo.Order, LastTableFicheId = itemBo.LastTableFicheId, TableFicheStatId = itemBo.TableFicheStatId, FicheCurrencyId = itemBo.FicheCurrencyId, FicheDebtPersonId = itemBo.FicheDebtPersonId, FicheDebtPersonFullName = itemBo.FicheDebtPersonFullName, FicheGrandTotal = itemBo.FicheGrandTotal, FicheCreateDateNumber = itemBo.FicheCreateDate.ToNumberFromDateTimeNull() }); } } return(responseDto); }