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); } }