Exemple #1
0
        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);
        }