//public static void UpdateSalePrices(IUnitOfWork db,
// long styleItemId,
// long saleId,
// decimal newSalePrice,
// decimal? newSFPSalePrice)
//{
// var rateForMarketplace = RateHelper.GetRatesByStyleItemId(db, styleItemId);
// var marketPrices = db.StyleItemSaleToMarkets.GetAll().Where(s => s.SaleId == saleId).ToList();
// foreach (var marketPrice in marketPrices)
// {
// if (marketPrice.SalePrice.HasValue)
// {
// var marketListings = db.StyleItemSaleToListings.GetAll().Where(l => l.SaleToMarketId == )
// marketPrice.SalePrice = RateHelper.CalculateForMarket((MarketType) marketPrice.Market,
// marketPrice.MarketplaceId,
// newSalePrice,
// rateForMarketplace[MarketplaceKeeper.AmazonComMarketplaceId],
// rateForMarketplace[MarketplaceKeeper.AmazonCaMarketplaceId],
// rateForMarketplace[MarketplaceKeeper.AmazonUkMarketplaceId],
// rateForMarketplace[MarketplaceKeeper.AmazonAuMarketplaceId],
// RateService.GetMarketShippingAmount(MarketType.Amazon, MarketplaceKeeper.AmazonComMarketplaceId),
// RateService.GetMarketShippingAmount((MarketType)marketPrice.Market, marketPrice.MarketplaceId),
// RateService.GetMarketExtraAmount((MarketType)marketPrice.Market, marketPrice.MarketplaceId));
// }
// }
// db.Commit();
//}
public static IList <MarketPriceEditViewModel> GetForStyleItemId(IUnitOfWork db,
IDbFactory dbFactory,
long styleItemId,
decimal?initSalePrice,
decimal?initSFPSalePrice)
{
var priceService = new PriceService(dbFactory);
var results = new List <MarketPriceEditViewModel>();
var allMarketplaces = UIMarketHelper.GetSalesMarketplaces();
var allListings = db.Listings.GetListingsAsListingDto()
.Where(l => l.StyleItemId == styleItemId)
.ToList()
.Where(l => !l.IsFBA)
.ToList();
var rateForMarketplace = RateHelper.GetRatesByStyleItemId(db, styleItemId);
var sale = db.StyleItemSales.GetAllAsDto().FirstOrDefault(s => s.StyleItemId == styleItemId && !s.IsDeleted);
var checkedListings = new List <StyleItemSaleToListingDTO>();
if (sale != null)
{
checkedListings = db.StyleItemSaleToListings.GetAllAsDto().Where(s => s.SaleId == sale.Id).ToList();
}
var checkedMarkets = new List <StyleItemSaleToMarketDTO>();
if (sale != null)
{
checkedMarkets = db.StyleItemSaleToMarkets.GetAllAsDto().Where(s => s.SaleId == sale.Id).ToList();
}
foreach (var market in allMarketplaces)
{
var checkedMarket = checkedMarkets.FirstOrDefault(l => l.Market == (int)market.Market &&
(l.MarketplaceId == market.MarketplaceId || String.IsNullOrEmpty(market.MarketplaceId)));
var marketListings = allListings
.Where(l => l.Market == (int)market.Market &&
(l.MarketplaceId == market.MarketplaceId ||
String.IsNullOrEmpty(market.MarketplaceId)))
.Select(l => new ListingPriceEditViewModel(l))
.ToList();
foreach (var listing in marketListings)
{
listing.IsChecked = sale == null ?
((listing.IsPrime || SkuHelper.IsPrime(listing.SKU)) ? initSFPSalePrice.HasValue : initSalePrice.HasValue) :
checkedListings.Any(l => l.ListingId == listing.ListingId);
}
var defaultPrice = //sale == null &&
initSalePrice.HasValue &&
marketListings.Any() ? priceService.GetMarketDefaultPrice(initSalePrice.Value,
market.Market,
market.MarketplaceId,
rateForMarketplace) : (decimal?)null;
foreach (var marketListing in marketListings)
{
var newDefaultPrice = priceService.ApplyMarketSpecified(defaultPrice,
initSFPSalePrice,
market.Market,
market.MarketplaceId,
marketListing.Weight,
marketListing.IsPrime,
marketListing.IsFBA);
if (newDefaultPrice != defaultPrice)
{
marketListing.OverrideSalePrice = newDefaultPrice;
}
}
var saleToMarket = new MarketPriceEditViewModel()
{
Id = checkedMarket != null ? checkedMarket.Id : 0,
Market = (MarketType)market.Market,
MarketplaceId = market.MarketplaceId,
MarketName = MarketHelper.GetMarketName((int)market.Market, market.MarketplaceId),
MarketCurrency = PriceHelper.GetCurrencySymbol(market.Market, market.MarketplaceId),
SalePrice = checkedMarket != null ? checkedMarket.SalePrice : defaultPrice,
SFPSalePrice = market.MarketplaceId == MarketplaceKeeper.AmazonComMarketplaceId ? initSFPSalePrice : null,
SalePercent = checkedMarket != null ? checkedMarket.SalePercent : null,
ApplyToNewListings = checkedMarket != null ? checkedMarket.ApplyToNewListings : false,
Listings = marketListings
};
results.Add(saleToMarket);
}
return(results);
}
