public ResponseDto <List <PersonAccountActivityListDto> > GetActivityList(PersonAccountActivityGetListCriteriaDto criteriaDto) { PersonAccountActivityGetListCriteriaBo criteriaBo = new PersonAccountActivityGetListCriteriaBo() { OwnerPersonId = criteriaDto.OwnerPersonId, AccountIdList = criteriaDto.AccountIdList, ApprovalStatIdList = criteriaDto.ApprovalStatIdList, GrandTotalMin = criteriaDto.GrandTotalMin, GrandTotalMax = criteriaDto.GrandTotalMax, IssueDateStart = criteriaDto.IssueDateStartNumber.ToDateTimeFromNumberNull(), IssueDateEnd = criteriaDto.IssueDateEndNumber.ToDateTimeFromNumberNull(), CurrencyId = criteriaDto.CurrencyId, PageOffSet = criteriaDto.PageOffSet, Session = Session }; ResponseBo <List <PersonAccountActivityListBo> > responseBo = personAccountBusiness.GetActivityList(criteriaBo); ResponseDto <List <PersonAccountActivityListDto> > responseDto = responseBo.ToResponseDto <List <PersonAccountActivityListDto>, List <PersonAccountActivityListBo> >(); if (responseBo.IsSuccess && responseBo.Bo != null) { responseDto.Dto = new List <PersonAccountActivityListDto>(); foreach (PersonAccountActivityListBo itemBo in responseBo.Bo) { responseDto.Dto.Add(new PersonAccountActivityListDto() { Id = itemBo.Id, Total = itemBo.Total, AccountId = itemBo.AccountId, AccountName = itemBo.AccountName, AccountTypeId = itemBo.AccountTypeId, IsDebt = itemBo.IsDebt, OwnerPersonId = itemBo.OwnerPersonId, FicheId = itemBo.FicheId, FicheCurrencyId = itemBo.FicheCurrencyId, FicheApprovalStatId = itemBo.FicheApprovalStatId, FicheIssueDateNumber = itemBo.FicheIssueDate.ToNumberFromDateTime() }); } } return(responseDto); }
public ResponseBo <List <PersonAccountActivityListBo> > GetActivityList(PersonAccountActivityGetListCriteriaBo criteriaBo) { ResponseBo <List <PersonAccountActivityListBo> > responseBo = new ResponseBo <List <PersonAccountActivityListBo> >(); 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("@OwnerPersonId", criteriaBo.OwnerPersonId, DbType.Int64, ParameterDirection.Input); p.Add("@AccountIdList", criteriaBo.AccountIdList.ToStrSeparated(), DbType.String, ParameterDirection.Input, 4000); p.Add("@ApprovalStatIdList", criteriaBo.ApprovalStatIdList.ToStrSeparated(), DbType.String, ParameterDirection.Input, 50); p.Add("@IssueDateStart", criteriaBo.IssueDateStart?.Date, DbType.Date, ParameterDirection.Input); p.Add("@IssueDateEnd", criteriaBo.IssueDateEnd?.Date, DbType.Date, ParameterDirection.Input); p.Add("@GrandTotalMin", criteriaBo.GrandTotalMin, DbType.Decimal, ParameterDirection.Input); p.Add("@GrandTotalMax", criteriaBo.GrandTotalMax, DbType.Decimal, ParameterDirection.Input); p.Add("@CurrencyId", criteriaBo.CurrencyId, DbType.Int32, ParameterDirection.Input); p.Add("@PageOffSet", criteriaBo.PageOffSet, DbType.Int32, 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 <PersonAccountActivityListBo>("spPersonAccountActivityList", 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 <PersonAccountActivityListBo> >(); } return(responseBo); }