public static List <CsvProduct> ReadCsvPtoducts(string path) { var parse = new CsvParser(); var productParser = new CsvProductLine(); return(parse.ParseFile(path, productParser)); }
static void Run(string[] args) { List <string> lines = new List <string>(); List <string> sizes = new List <string>(); List <string> colors = new List <string>(); List <string> photos = new List <string>(); ProductInsertion insertion = new ProductInsertion(); var databaseDataFolder = @"../../../../../DatabaseData/"; var parsedData = "ParsedData"; var preparedData = "PreparedData"; var blouses = Path.Combine(databaseDataFolder, parsedData, "blouses_shirts.csv"); CsvParser parse = new CsvParser(); CsvProductLine productParser = new CsvProductLine(); var products = parse.ParseFile(blouses, productParser); foreach (var product in products) { float price = float.Parse(product.Price, CultureInfo.InvariantCulture.NumberFormat); lines.Add(insertion.ExecutableLine(product.VendorCode, product.Brand, "blouses_shirts", product.Color, product.Print, price, product.MadeInCountry, product.Link, product.PhotosUrls.First())); foreach (var productSize in product.Sizes) { sizes.Add(insertion.AddSize(product.VendorCode, productSize.RussianSize, productSize.IsAvailable, productSize.OtherCountry, productSize.CountryCode)); } foreach (var productPhoto in product.PhotosUrls) { photos.Add(insertion.AddPhotos(product.VendorCode, productPhoto)); } } var t = lines; var path = Path.Combine(databaseDataFolder, preparedData, "blouses.sql"); var path1 = Path.Combine(databaseDataFolder, preparedData, "sizes.sql"); var path2 = Path.Combine(databaseDataFolder, preparedData, "photos.sql"); WriteToFile(path, lines); WriteToFile(path1, sizes); WriteToFile(path2, photos); }