private ReturnPrice GetPriceOuro(ReturnPrice baseReturnPrice, long storeId, MedalCode medalCode)
{
MedalDiscount medalDiscount = GetMedalDiscount(baseReturnPrice.ProductId, storeId, medalCode);
ReturnPrice returnPrice = new ReturnPrice
{
DiscountType = DiscountType.Ouro,
MaximumPrice = baseReturnPrice.SalePrice,
PercentageDiscount = medalDiscount.PercentualDesconto,
ProductId = baseReturnPrice.ProductId,
SalePrice = baseReturnPrice.SalePrice - Decimal.Multiply(baseReturnPrice.SalePrice, medalDiscount.PercentualDesconto / 100)
};
return(returnPrice);
}
public PriceEncarte GetPriceEncarte(long productId, long storeId, MedalCode medalCode)
{
var sql = PriceScripts.SELECT_PRECO_ENCARTE_POR_FILIAL_E_CODIGO;
using (var connection = new SqlConnection(_connectionString))
{
var parameters = new DynamicParameters();
parameters.Add("@StoreId", storeId, DbType.Int32, ParameterDirection.Input);
parameters.Add("@ProductId", productId, DbType.Int32, ParameterDirection.Input);
parameters.Add("@MedalCode", medalCode, DbType.Int32, ParameterDirection.Input);
PriceEncarte priceEncarte = connection.QueryFirstOrDefault <PriceEncarte>(sql, parameters);
return(priceEncarte);
}
}
public MedalDiscount GetMedalDiscount(long productCode, long storeId, MedalCode medalCode)
{
var sql = PriceScripts.SELECT_SEGMENTACAO_DESCONTO_POR_FILIAL_CODIGO_PRODUTO_E_CODIGO_MEDALHA;
using (var connection = new SqlConnection(_connectionString))
{
var parameters = new DynamicParameters();
parameters.Add("@Filial", storeId, DbType.Int32, ParameterDirection.Input);
parameters.Add("@CodigoProduto", productCode, DbType.Int32, ParameterDirection.Input);
parameters.Add("@CodigoMedalha", medalCode, DbType.Int32, ParameterDirection.Input);
MedalDiscount returnDiscount = connection.QueryFirstOrDefault <MedalDiscount>(sql, parameters);
return(returnDiscount);
}
}
private MedalDiscount GetMedalDiscount(long productId, long storeId, MedalCode medalCode)
{
MedalDiscount medalDiscount = _precoRepository.GetMedalDiscount(productId, storeId, medalCode);
return(medalDiscount);
}
