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