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