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