public ResponseBo <List <PersonRelationListBo> > GetList(PersonRelationGetListCriteriaBo criteriaBo) { ResponseBo <List <PersonRelationListBo> > responseBo = new ResponseBo <List <PersonRelationListBo> >(); 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("@PersonId", criteriaBo.PersonId, DbType.Int64, ParameterDirection.Input); p.Add("@CurrencyId", criteriaBo.CurrencyId, DbType.Int32, ParameterDirection.Input); p.Add("@RelationTypeIdList", criteriaBo.RelationTypeIdList.ToStrSeparated(), DbType.String, ParameterDirection.Input, 255); p.Add("@LanguageId", criteriaBo.Session.RealPerson.LanguageId, DbType.Int32, ParameterDirection.Input); p.Add("@IsOppositeOperation", criteriaBo.IsOppositeOperation, DbType.Boolean, ParameterDirection.Input); p.Add("@SearchRelationTypeOpp", criteriaBo.SearchRelationTypeOpp, DbType.Boolean, ParameterDirection.Input); p.Add("@OperatorRealId", criteriaBo.Session.RealPerson.Id, DbType.Int64, ParameterDirection.Input); p.Add("@Name", criteriaBo.Name, DbType.String, ParameterDirection.Input, 50); p.Add("@PageOffSet", criteriaBo.PageOffSet, DbType.Int32, ParameterDirection.Input); p.Add("@PersonRelationId", criteriaBo.PersonRelationId, DbType.Int64, ParameterDirection.Input); p.Add("@BalanceStatIdList", criteriaBo.BalanceStatIdList.ToStrSeparated(), DbType.String, ParameterDirection.Input, 50); responseBo.Bo = conn.Query <PersonRelationListBo>("spPersonRelationList", 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 <PersonRelationListBo> >(); } return(responseBo); }
public static SessionMyPerson GetMyPerson(PersonChangeMyPersonDto myPersonDto, Session session) { // Getting my person // // Code below must return just one row. PersonRelationBusiness personRelationBusiness = new PersonRelationBusiness(); PersonRelationGetListCriteriaBo criteriaBo = new PersonRelationGetListCriteriaBo(); criteriaBo.PersonId = session.RealPerson.Id; criteriaBo.PersonRelationId = myPersonDto.PersonRelationId; criteriaBo.CurrencyId = myPersonDto.DefaultCurrencyId; criteriaBo.Session = session; PersonRelationListBo myPersonRelationBo = personRelationBusiness.GetList(criteriaBo).Bo[0]; SessionMyPerson myPerson = new SessionMyPerson(); myPerson.Id = myPersonDto.MyPersonId; myPerson.FullName = myPersonRelationBo.RelatedPersonFullName; myPerson.PersonTypeId = myPersonRelationBo.RelatedPersonTypeId; myPerson.RelationTypeId = myPersonRelationBo.RelationTypeId; myPerson.DefaultCurrencyId = myPersonRelationBo.RelatedPersonDefaultCurrencyId; myPerson.SelectedCurrencyId = myPerson.DefaultCurrencyId; return(myPerson); }
public ResponseDto <List <PersonRelationListDto> > GetList(PersonRelationGetListCriteriaDto criteriaDto) { PersonRelationGetListCriteriaBo criteriaBo = new PersonRelationGetListCriteriaBo() { PersonId = criteriaDto.PersonId, RelationTypeIdList = criteriaDto.RelationTypeIdList, IsOppositeOperation = criteriaDto.IsOppositeOperation, SearchRelationTypeOpp = criteriaDto.SearchRelationTypeOpp, CurrencyId = criteriaDto.CurrencyId, Name = criteriaDto.Name.IsNull() ? null : criteriaDto.Name.Trim(), PageOffSet = criteriaDto.PageOffSet, PersonRelationId = criteriaDto.PersonRelationId, BalanceStatIdList = criteriaDto.BalanceStatIdList, Session = Session }; criteriaBo.Name = criteriaBo.Name.IsNull() ? null : criteriaBo.Name; if (criteriaBo.Name != null) { criteriaBo.Name = criteriaBo.Name.Trim(); } ResponseBo <List <PersonRelationListBo> > responseBo = personRelationBusiness.GetList(criteriaBo); ResponseDto <List <PersonRelationListDto> > responseDto = responseBo.ToResponseDto <List <PersonRelationListDto>, List <PersonRelationListBo> >(); if (responseBo.IsSuccess && responseBo.Bo != null) { responseDto.Dto = new List <PersonRelationListDto>(); responseDto.Dto = responseBo.Bo.GroupBy(x => x.RelatedPersonId).Select(x => x.First()). Select( x => new PersonRelationListDto() { Id = x.Id, RelatedPersonId = x.RelatedPersonId, RelatedPersonTypeId = x.RelatedPersonTypeId, RelatedPersonFullName = x.RelatedPersonFullName, RelatedPersonDefaultCurrencyId = x.RelatedPersonDefaultCurrencyId, RelatedPersonUrlName = x.RelatedPersonUrlName, IsMaster = x.IsMaster, IsAlone = x.IsAlone, Balance = x.Balance, BalanceStatId = x.BalanceStatId, //ApprovalStatId = x.ApprovalStatId, //RelationTypeIdList = responseBo.Bo.Where(y => y.RelatedPersonId == x.RelatedPersonId).Select(y => y.RelationTypeId).ToList(), RelationSubList = (from y in responseBo.Bo where y.RelatedPersonId == x.RelatedPersonId select new PersonRelationSubListDto { PersonRelationId = y.Id, ApprovalStatId = y.ApprovalStatId, RelationTypeId = y.RelationTypeId, ApprovalRelationId = y.ApprovalRelationId }).ToList() }).ToList(); // responseDto.Dto = Business.Stc.EnumShopTypeList. //GroupBy(x => x.GroupId).Select(x => x.First()). //Select( //x => new ShopTypeGroupDto() //{ // Id = x.GroupId, // Name = x.GroupName, // TypeList = Business.Stc.EnumShopTypeList.Where(y => y.GroupId == x.GroupId).Select( // y => new ShopTypeDto() // { // Id = y.Id, // Name = y.TypeName // }).ToList() //}).ToList(); //foreach (PersonRelationListBo itemBo in responseBo.Bo) //{ // responseDto.Dto.Add(new PersonRelationListDto() // { // Id = itemBo.Id, // RelatedPersonId = itemBo.RelatedPersonId, // RelatedPersonTypeId = itemBo.RelatedPersonTypeId, // RelatedPersonFullName = itemBo.RelatedPersonFullName, // IsMaster = itemBo.IsMaster, // RelationTypeId = itemBo.RelationTypeId, // RelationStateId = itemBo.RelationStateId // }); //} } return(responseDto); }