public void ParseXmlToDb(string pathToFile, IList<string> columnOrder) { var reader = new XmlReader(); var content = reader.XMLToStringSet(pathToFile, columnOrder); var parser = new StringSetToAutoPart(); parser.InsertDataIntoDB(content,columnOrder); }
public void ParseZipToDB(string inputZip, IList<string> format) { var reader = new XlsReader(); var allRows = new List<string>(); var zipArchiver = new ZipToMultipleXls(); var allFiles = zipArchiver.GetFiles(inputZip); foreach (var file in allFiles) { allRows.AddRange(reader.ProvideContent(Constants.PathToFiles + "/" + file, "Parts", format)); } var parser = new StringSetToAutoPart(); parser.InsertDataIntoDB(allRows, format); }
public void ParseZipToDB(string inputZip, IList <string> format) { var reader = new XlsReader(); var allRows = new List <string>(); var zipArchiver = new ZipToMultipleXls(); var allFiles = zipArchiver.GetFiles(inputZip); foreach (var file in allFiles) { allRows.AddRange(reader.ProvideContent(Constants.PathToFiles + "/" + file, "Parts", format)); } var parser = new StringSetToAutoPart(); parser.InsertDataIntoDB(allRows, format); }