public void Write(Common.Shop shop, string outputPath)
{
var results = new List <Item>();
var current = new Item();
foreach (var sell in _sell)
{
var matched = MatchingHelper.Match(sell, _cost);
var sku = shop == Common.Shop.Lazada ?
sell.SKU :
sell.Model;
results.Add(new Item()
{
LazName = sell.Name,
SKU = sku,
Sell = sell.Price,
Cost = matched.Matched ? matched.Price : 0,
Matched = matched.Matched,
IsOverPrice = matched.Matched ? matched.Price > sell.Price : false,
Amount = sell.Amount,
CostType = matched.Matched ? matched.CostType : string.Empty
});
}
using (FileStream stream = new FileStream(outputPath, FileMode.CreateNew, FileAccess.Write))
{
var workbook = new XSSFWorkbook();
var sheet = workbook.CreateSheet("profit");
var row = 0;
var headerRow = sheet.CreateRow(row);
headerRow.CreateCell(0).SetCellValue("lazName");
headerRow.CreateCell(1).SetCellValue("SKU");
headerRow.CreateCell(2).SetCellValue("Sell");
headerRow.CreateCell(3).SetCellValue("Cost");
headerRow.CreateCell(4).SetCellValue("Matched");
headerRow.CreateCell(5).SetCellValue("Over Price");
headerRow.CreateCell(6).SetCellValue("Type");
headerRow.CreateCell(7).SetCellValue("Amount");
foreach (var result in results)
{
var rowtemp = sheet.CreateRow(++row);
rowtemp.CreateCell(0).SetCellValue(result.LazName);
rowtemp.CreateCell(1).SetCellValue(result.SKU);
rowtemp.CreateCell(2).SetCellValue(result.Sell.ToString(CultureInfo.InvariantCulture));
rowtemp.CreateCell(3).SetCellValue(result.Cost.ToString(CultureInfo.InvariantCulture));
rowtemp.CreateCell(4).SetCellValue(result.Matched ? "" : "NO");
rowtemp.CreateCell(5).SetCellValue(result.IsOverPrice ? "YES" : "");
rowtemp.CreateCell(6).SetCellValue(result.CostType);
rowtemp.CreateCell(7).SetCellValue(result.Amount.ToString(CultureInfo.InvariantCulture));
}
workbook.Write(stream);
}
}
private void WriteShopee(string outputPath)
{
var results = new List <Item>();
foreach (var tergetStock in _targetStock)
{
var matched = MatchingHelper.Match(tergetStock, _baseStock);
results.Add(new Item()
{
Name = tergetStock.Name,
Model = tergetStock.Model,
MatchedModel = matched.Matched && !string.IsNullOrEmpty(matched.Model) ? matched.Model + " : " + matched.Stock : string.Empty,
Stock = matched.Matched ? matched.Stock : tergetStock.Stock,
Matched = matched.Matched,
MultiStocks = matched.MultiStocks,
MultiPrices = matched.MultiPrices
});
}
using (FileStream stream = new FileStream(outputPath, FileMode.CreateNew, FileAccess.Write))
{
var workbook = new XSSFWorkbook();
var sheet = workbook.CreateSheet("sheet1");
var row = 0;
var headerRow = sheet.CreateRow(row);
headerRow.CreateCell(0).SetCellValue("Name");
headerRow.CreateCell(1).SetCellValue("Model");
headerRow.CreateCell(2).SetCellValue("Matched Model");
headerRow.CreateCell(3).SetCellValue("Stock");
headerRow.CreateCell(4).SetCellValue("Matched");
headerRow.CreateCell(5).SetCellValue("MultiStocks");
headerRow.CreateCell(6).SetCellValue("MultiPrices");
foreach (var result in results)
{
var rowtemp = sheet.CreateRow(++row);
rowtemp.CreateCell(0).SetCellValue(result.Name);
rowtemp.CreateCell(1).SetCellValue(result.Model);
rowtemp.CreateCell(2).SetCellValue(result.MatchedModel);
rowtemp.CreateCell(3).SetCellValue(result.Stock.ToString(CultureInfo.InvariantCulture));
rowtemp.CreateCell(4).SetCellValue(!result.Matched ? "NO" : string.Empty);
rowtemp.CreateCell(5).SetCellValue(result.MultiStocks);
rowtemp.CreateCell(6).SetCellValue(result.MultiPrices);
}
workbook.Write(stream);
}
}
private void WriteLazada(string outputPath)
{
var shopee = _sources;
var lazada = _descs;
var results = new List <Item>();
foreach (var laz in lazada)
{
var matched = MatchingHelper.Match(laz, shopee);
results.Add(new Item()
{
LazName = laz.Name,
SKU = laz.SKU,
LazPrice = laz.Price,
ShopPrice = matched.Matched ? matched.Price : 0
//IsOverPrice = (matched.Matched ? matched.Price : 0) > laz.Price ? "Yes" : "",
});
}
using (FileStream stream = new FileStream(outputPath, FileMode.CreateNew, FileAccess.Write))
{
var workbook = new XSSFWorkbook();
var sheet = workbook.CreateSheet("profit");
var row = 0;
var headerRow = sheet.CreateRow(row);
headerRow.CreateCell(0).SetCellValue("lazName");
headerRow.CreateCell(1).SetCellValue("SKU");
headerRow.CreateCell(2).SetCellValue("LazPrice");
headerRow.CreateCell(3).SetCellValue("ShopPrice");
headerRow.CreateCell(4).SetCellValue("IsOverPrice");
foreach (var result in results)
{
var rowtemp = sheet.CreateRow(++row);
rowtemp.CreateCell(0).SetCellValue(result.LazName);
rowtemp.CreateCell(1).SetCellValue(result.SKU);
rowtemp.CreateCell(2).SetCellValue(result.LazPrice.ToString(CultureInfo.InvariantCulture));
rowtemp.CreateCell(3).SetCellValue(result.ShopPrice.ToString(CultureInfo.InvariantCulture));
rowtemp.CreateCell(4).SetCellValue(result.IsOverPrice);
}
workbook.Write(stream);
}
}
