public ResponseBo <List <PersonProductListBo> > GetList(PersonProductGetListCriteriaBo criteriaBo)
{
ResponseBo <List <PersonProductListBo> > responseBo = new ResponseBo <List <PersonProductListBo> >();
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("@ProductTypeId", criteriaBo.ProductTypeId, DbType.Int32, ParameterDirection.Input);
p.Add("@StockStatId", criteriaBo.StockStatId, DbType.Int32, ParameterDirection.Input);
p.Add("@ProductNameCode", criteriaBo.ProductNameCode, DbType.String, ParameterDirection.Input, 255);
p.Add("@PageOffSet", criteriaBo.PageOffSet, DbType.Int32, ParameterDirection.Input);
p.Add("@MyPersonId", criteriaBo.Session.MyPerson.Id, DbType.Int64, 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 <PersonProductListBo>("spPersonProductList", p, commandType: CommandType.StoredProcedure).ToList();
responseBo.Message = p.Get <string>("@Message");
responseBo.IsSuccess = p.Get <bool>("@IsSuccess");
if (responseBo.Bo != null)
{
foreach (PersonProductListBo item in responseBo.Bo)
{
if (item.PriceRawJson.IsNotNull())
{
item.Price = JsonConvert.DeserializeObject <ProductPriceBo>(item.PriceRawJson);
}
if (item.CodeListRawJson.IsNotNull())
{
item.CodeList = JsonConvert.DeserializeObject <List <ProductCodeBo> >(item.CodeListRawJson);
}
}
}
}
}
catch (Exception ex)
{
responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, criteriaBo).ToResponse <List <PersonProductListBo> >();
}
return(responseBo);
}
public ResponseDto <List <PersonProductListDto> > GetList(PersonProductGetListCriteriaDto criteriaDto)
{
PersonProductGetListCriteriaBo criteriaBo = new PersonProductGetListCriteriaBo()
{
ProductNameCode = criteriaDto.ProductNameCode,
ProductTypeId = criteriaDto.ProductTypeId,
StockStatId = criteriaDto.StockStatId,
PersonId = criteriaDto.PersonId,
CurrencyId = criteriaDto.CurrencyId,
PageOffSet = criteriaDto.PageOffSet,
Session = Session
};
ResponseBo <List <PersonProductListBo> > responseBo = personProductBusiness.GetList(criteriaBo);
ResponseDto <List <PersonProductListDto> > responseDto = responseBo.ToResponseDto <List <PersonProductListDto>, List <PersonProductListBo> >();
if (responseBo.IsSuccess && responseBo.Bo != null)
{
responseDto.Dto = new List <PersonProductListDto>();
foreach (PersonProductListBo itemBo in responseBo.Bo)
{
responseDto.Dto.Add(new PersonProductListDto()
{
Id = itemBo.Id,
ProductId = itemBo.ProductId,
ProductName = itemBo.ProductName,
ProductTypeId = itemBo.ProductTypeId,
VateRate = itemBo.VateRate,
Balance = itemBo.Balance,
PortraitImageUniqueIdStr = base.GetImageName(itemBo.PortraitImageUniqueId, itemBo.PortraitImageFileTypeId),
CodeList = (from x in itemBo.CodeList
select new ProductCodeDto()
{
Code = x.Code,
ProductCodeTypeId = x.ProductCodeTypeId,
ProductId = x.ProductId
}).ToList(),
Price = itemBo.Price == null ? null :
new ProductPriceDto()
{
PurhasePrice = itemBo.Price.PurhasePrice,
SalePrice = itemBo.Price.SalePrice,
OnlineSalePrice = itemBo.Price.OnlineSalePrice,
CurrencyId = itemBo.Price.CurrencyId,
FromPool = itemBo.Price.FromPool
}
});
}
}
return(responseDto);
}