public ResponseBo <List <FicheProductListBo> > GetList(FicheProductGetListCriteriaBo criteriaBo)
{
ResponseBo <List <FicheProductListBo> > responseBo = new ResponseBo <List <FicheProductListBo> >();
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("@FicheId", criteriaBo.FicheId, DbType.Int64, 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 <FicheProductListBo>("spFicheProductList", 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 <FicheProductListBo> >();
}
return(responseBo);
}
public ResponseDto <List <FicheProductListDto> > GetList(FicheProductGetListCriteriaDto criteriaDto)
{
FicheProductGetListCriteriaBo criteriaBo = new FicheProductGetListCriteriaBo()
{
FicheId = criteriaDto.FicheId,
Session = Session
};
ResponseBo <List <FicheProductListBo> > responseBo = ficheProductBusiness.GetList(criteriaBo);
ResponseDto <List <FicheProductListDto> > responseDto = responseBo.ToResponseDto <List <FicheProductListDto>, List <FicheProductListBo> >();
if (responseBo.IsSuccess && responseBo.Bo != null)
{
responseDto.Dto = new List <FicheProductListDto>();
foreach (FicheProductListBo itemBo in responseBo.Bo)
{
responseDto.Dto.Add(new FicheProductListDto()
{
Id = itemBo.Id,
ProductId = itemBo.ProductId,
ProductName = itemBo.ProductName,
ProductTypeId = itemBo.ProductTypeId,
Quantity = itemBo.Quantity,
UnitPrice = itemBo.UnitPrice,
Total = itemBo.Total,
DiscountRate = itemBo.DiscountRate,
DiscountTotal = itemBo.DiscountTotal,
VatRate = itemBo.VatRate,
VatTotal = itemBo.VatTotal,
GrandTotal = itemBo.GrandTotal,
Notes = itemBo.Notes,
IsDeleted = itemBo.IsDeleted
});
}
}
return(responseDto);
}
