public ResponseDto <List <PersonListDto> > GetList(PersonGetListCriteriaDto criteriaDto) { PersonGetListCriteriaBo criteriaBo = new PersonGetListCriteriaBo() { PersonTypeIdList = criteriaDto.PersonTypeIdList, CurrencyId = criteriaDto.CurrencyId, Session = Session }; ResponseBo <List <PersonListBo> > responseBo = personBusiness.GetList(criteriaBo); ResponseDto <List <PersonListDto> > responseDto = responseBo.ToResponseDto <List <PersonListDto>, List <PersonListBo> >(); if (responseBo.IsSuccess && responseBo.Bo != null) { responseDto.Dto = new List <PersonListDto>(); foreach (PersonListBo itemBo in responseBo.Bo) { responseDto.Dto.Add(new PersonListDto() { Id = itemBo.Id, FullName = itemBo.FullName, StatId = itemBo.StatId, PersonTypeId = itemBo.PersonTypeId, Balance = itemBo.Balance, BalanceStatId = itemBo.BalanceStatId, DefaultCurrencyId = itemBo.DefaultCurrencyId, ShopTypeId = itemBo.ShopTypeId, MasterRelationTypeId = itemBo.MasterRelationTypeId, UrlName = itemBo.UrlName, Address = itemBo.Address == null ? null : new PersonAddressListDto() { Id = itemBo.Address.Id, AddressTypeId = itemBo.Address.AddressTypeId, StatId = itemBo.Address.StatId, Name = itemBo.Address.Name, InvolvedPersonName = itemBo.Address.InvolvedPersonName, CountryName = itemBo.Address.CountryName, StateName = itemBo.Address.StateName, CityName = itemBo.Address.CityName, DistrictName = itemBo.Address.DistrictName, LocalityName = itemBo.Address.LocalityName, Notes = itemBo.Address.Notes, Phone = itemBo.Address.Phone } }); } } return(responseDto); }
public ResponseBo <List <PersonListBo> > GetList(PersonGetListCriteriaBo criteriaBo) { ResponseBo <List <PersonListBo> > responseBo = new ResponseBo <List <PersonListBo> >(); 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("@PersonTypeIdList", criteriaBo.PersonTypeIdList.ToStrSeparated(), DbType.String, ParameterDirection.Input, 50); p.Add("@CurrencyId", criteriaBo.CurrencyId, 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 <PersonListBo>("spPersonList", p, commandType: CommandType.StoredProcedure).ToList(); responseBo.Message = p.Get <string>("@Message"); responseBo.IsSuccess = p.Get <bool>("@IsSuccess"); foreach (var item in responseBo.Bo) { item.BalanceStatId = item.Balance == 0 ? Enums.BalanceStats.xZero : item.Balance > 0 ? Enums.BalanceStats.xCreditor : Enums.BalanceStats.xDebtor; item.Balance = Math.Abs(item.Balance); } } } catch (Exception ex) { responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, criteriaBo).ToResponse <List <PersonListBo> >(); } return(responseBo); }