public async Task GeneratedExcelProductsAsync() { var productsBaseUrl = ConfigurationManager.AppSettings["ParseHubListProductsBaseUrl"]; var parseApiKey = ConfigurationManager.AppSettings["ParseHubApiKey"]; var path = String.Format(productsBaseUrl, parseApiKey); var parseHub = new ParseHub(); var product = await parseHub.GetProductsAsync(path); var mercadoLibreItems = new List <MercadoLibreItem>(); foreach (var item in product.ProductsCollection) { if (item != null && (item.Price_1 != null || item.Price_2 != null)) { var price = DataNormalizeHelper.GetProductPrice(item); if (price < 200) { var mercadoLibreItem = new MercadoLibreItem(); mercadoLibreItem.AvailityStock = 10; mercadoLibreItem.Category = ""; mercadoLibreItem.Condition = "Nuevo"; mercadoLibreItem.CreatedDate = DateTime.UtcNow.ToString("dd/MM/yyyy hh:MM"); var description = DataNormalizeHelper.NormalizeDescription(item.Description_1, item.Description_2); mercadoLibreItem.Description = DataNormalizeHelper.GetProductDescription(item.Name, description); mercadoLibreItem.Id = ""; mercadoLibreItem.Images = DataNormalizeHelper.GetListImages(item); mercadoLibreItem.PickUp = "Sí"; mercadoLibreItem.Price = DeterminateProductPrice(item); mercadoLibreItem.ShippingMethod = "Estándar a domicilio"; mercadoLibreItem.ShippingMode = "MercadoEnvios2"; mercadoLibreItem.ShippingPrice = 109.00; mercadoLibreItem.ShippingType = "Sí"; mercadoLibreItem.SKU = ""; mercadoLibreItem.State = "Activa"; mercadoLibreItem.Stock = 3; mercadoLibreItem.Title = DataNormalizeHelper.SortTitle(item.Name); mercadoLibreItem.TypePublication = "Premium"; mercadoLibreItem.Warranty = "Sin garantía"; mercadoLibreItems.Add(mercadoLibreItem); } } } DataNormalizeHelper.GnerateExcelFile(mercadoLibreItems); }
public async Task GeneratedExcelBooksAsync() { var booksBaseUrl = ConfigurationManager.AppSettings["ParseHubListBooksBaseUrl"]; var parseApiKey = ConfigurationManager.AppSettings["ParseHubApiKey"]; var path = String.Format(booksBaseUrl, parseApiKey); var parseHub = new ParseHub(); var books = await parseHub.GetBooksAsync(path); var mercadoLibreItems = new List <MercadoLibreItem>(); foreach (var item in books.BooksCollection) { if (item != null) { var price = DataNormalizeHelper.GetBookPrice(item); if (price > 0) { if (price < 200) { var paperback = ""; var ISBN10 = ""; var editor = ""; foreach (var detail in item.Details) { foreach (var dcictionary in detail) { if (dcictionary.Value.Contains("Paperback")) { paperback = Regex.Match(dcictionary.Value, @"\d+").Value; } if (dcictionary.Value.Contains("ISBN-10")) { ISBN10 = dcictionary.Value.Replace("ISBN-10: ", ""); } if (dcictionary.Value.Contains("Editor")) { editor = dcictionary.Value.Replace("Editor: ", ""); } } } var mercadoLibreItem = new MercadoLibreItem(); mercadoLibreItem.AvailityStock = 10; mercadoLibreItem.Category = ""; mercadoLibreItem.Condition = "Nuevo"; mercadoLibreItem.CreatedDate = DateTime.UtcNow.ToString("dd/MM/yyyy hh:MM"); mercadoLibreItem.Description = DataNormalizeHelper.GetBookDescription(item.Name, item.Description_1); mercadoLibreItem.Id = ""; mercadoLibreItem.Images = DataNormalizeHelper.GetListImages(item.Image_1); mercadoLibreItem.PickUp = "Sí"; mercadoLibreItem.Price = DeterminateBooktPrice(price); mercadoLibreItem.ShippingMethod = "Estándar a domicilio"; mercadoLibreItem.ShippingMode = "MercadoEnvios2"; mercadoLibreItem.ShippingPrice = 109.00; mercadoLibreItem.ShippingType = "Sí"; mercadoLibreItem.SKU = ""; mercadoLibreItem.State = "Activa"; mercadoLibreItem.Stock = 3; mercadoLibreItem.Title = DataNormalizeHelper.SortTitle(item.Name); mercadoLibreItem.TypePublication = "Premium"; mercadoLibreItem.Warranty = "Sin garantía"; mercadoLibreItem.Author = item.Author != null ? item.Author : ""; mercadoLibreItem.Editor = editor; mercadoLibreItem.Isbn10 = ISBN10; mercadoLibreItem.Paperback = paperback; mercadoLibreItems.Add(mercadoLibreItem); } } } DataNormalizeHelper.GnerateExcelBooksFile(mercadoLibreItems); } }