public ResponseDto <List <PersonProfileProductListDto> > GetListForProfile(PersonProfileProductGetListCriteriaDto criteriaDto)
{
PersonProfileProductGetListCriteriaBo criteriaBo = new PersonProfileProductGetListCriteriaBo()
{
PersonProductId = criteriaDto.PersonProductId,
ShopId = criteriaDto.ShopId,
CurrencyId = criteriaDto.CurrencyId,
CategoryId = criteriaDto.CategoryId,
StockStatId = criteriaDto.StockStatId,
IsSaleForOnline = criteriaDto.IsSaleForOnline,
IsTemporarilyUnavaible = criteriaDto.IsTemporarilyUnavaible,
ProductNameCode = criteriaDto.ProductNameCode,
PageOffSet = criteriaDto.PageOffSet,
Session = Session
};
ResponseBo <List <PersonProfileProductListBo> > responseBo = personProductBusiness.GetListForProfile(criteriaBo);
ResponseDto <List <PersonProfileProductListDto> > responseDto = responseBo.ToResponseDto <List <PersonProfileProductListDto>, List <PersonProfileProductListBo> >();
if (responseBo.IsSuccess && responseBo.Bo != null)
{
responseDto.Dto = new List <PersonProfileProductListDto>();
foreach (PersonProfileProductListBo itemBo in responseBo.Bo)
{
responseDto.Dto.Add(new PersonProfileProductListDto()
{
Id = itemBo.Id,
ProductId = itemBo.ProductId,
ProductName = itemBo.ProductName,
ProductTypeId = itemBo.ProductTypeId,
OnlineSalePrice = itemBo.OnlineSalePrice,
StarCount = itemBo.StarCount,
StarSum = itemBo.StarSum,
SaleVatRate = itemBo.SaleVatRate,
Balance = itemBo.Balance,
IsSaleForOnline = itemBo.IsSaleForOnline,
IsTemporarilyUnavaible = itemBo.IsTemporarilyUnavaible,
Notes = itemBo.Notes,
PortraitImageUniqueIdStr = base.GetImageName(itemBo.PortraitImageUniqueId, itemBo.PortraitImageFileTypeId)
});
}
}
return(responseDto);
}
public ResponseBo <List <PersonProfileProductListBo> > GetListForProfile(PersonProfileProductGetListCriteriaBo criteriaBo)
{
ResponseBo <List <PersonProfileProductListBo> > responseBo = new ResponseBo <List <PersonProfileProductListBo> >();
try
{
using (SqlConnection conn = DbAccess.Connection.GetConn())
{
var p = new DynamicParameters();
base.AddStandartSpParams(ref p, criteriaBo);
p.Add("@PersonProductId", criteriaBo.PersonProductId, DbType.Int64, ParameterDirection.Input);
p.Add("@ShopId", criteriaBo.ShopId, DbType.Int64, ParameterDirection.Input);
p.Add("@CurrencyId", criteriaBo.CurrencyId, DbType.Int32, ParameterDirection.Input);
p.Add("@CategoryId", criteriaBo.CategoryId, DbType.Int32, ParameterDirection.Input);
p.Add("@StockStatId", criteriaBo.StockStatId, DbType.Int32, ParameterDirection.Input);
p.Add("@IsSaleForOnline", criteriaBo.IsSaleForOnline, DbType.Boolean, ParameterDirection.Input);
p.Add("@IsTemporarilyUnavaible", criteriaBo.IsTemporarilyUnavaible, DbType.Boolean, ParameterDirection.Input);
p.Add("@ProductNameCode", criteriaBo.ProductNameCode, DbType.String, ParameterDirection.Input, 255);
p.Add("@PageOffSet", criteriaBo.PageOffSet, DbType.Int32, ParameterDirection.Input);
responseBo.Bo = conn.Query <PersonProfileProductListBo>("spPersonProfileProductList", 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 <PersonProfileProductListBo> >();
}
return(responseBo);
}
