static void Main(string[] args) { Console.WriteLine("Reading CSV file"); //Openning file var csvFile = new StreamReader(Environment.CurrentDirectory + "\\ExcelTemplate\\TranslationTemplate.csv", Encoding.Default); string [] lineArray; string[] header; // Setting the repository saver var translationRep = new TextRepository_SQLToJSON(true); TextRepository translation; IdiomTranslation idiomTranslation; int contLines = 0; // Reading the header, to define how many idioms we got header = csvFile.ReadLine().Split(";".ToCharArray()); // Reading all the content do { translation = new TextRepository(); // Separate to array lineArray = csvFile.ReadLine().Split(";".ToCharArray()); translation.DOMElementID = lineArray[0]; // Only add a new translation, if it have a value if (translation.DOMElementID != "") { //Adding all idiom that exists for (int contColunms = 1; contColunms < header.Length; contColunms++) { idiomTranslation = new IdiomTranslation(); idiomTranslation.IdiomName = header[contColunms]; // Adding the title of the column, who have the idiom name idiomTranslation.Translation = lineArray[contColunms]; translation.AddTranslation(idiomTranslation); } // Saving the configuration of the idiom to the repository translationRep.SaveTextRepository(translation); } contLines++; Console.WriteLine("Saving line " + contLines); } while (csvFile.EndOfStream == false); // Finishing the text repository Console.WriteLine("The save operation is finish."); Console.ReadLine(); }
static void Main(string[] args) { Console.WriteLine("Reading CSV file"); //Openning file var csvFile = new StreamReader(Environment.CurrentDirectory + "\\ExcelTemplate\\TranslationTemplate.csv",Encoding.Default); string [] lineArray; string[] header; // Setting the repository saver var translationRep = new TextRepository_SQLToJSON(true); TextRepository translation; IdiomTranslation idiomTranslation; int contLines = 0; // Reading the header, to define how many idioms we got header = csvFile.ReadLine().Split(";".ToCharArray()); // Reading all the content do { translation = new TextRepository(); // Separate to array lineArray = csvFile.ReadLine().Split(";".ToCharArray()); translation.DOMElementID = lineArray[0]; // Only add a new translation, if it have a value if (translation.DOMElementID != "") { //Adding all idiom that exists for (int contColunms = 1; contColunms < header.Length; contColunms++) { idiomTranslation = new IdiomTranslation(); idiomTranslation.IdiomName = header[contColunms]; // Adding the title of the column, who have the idiom name idiomTranslation.Translation = lineArray[contColunms]; translation.AddTranslation(idiomTranslation); } // Saving the configuration of the idiom to the repository translationRep.SaveTextRepository(translation); } contLines ++; Console.WriteLine("Saving line " + contLines); } while (csvFile.EndOfStream == false ); // Finishing the text repository Console.WriteLine("The save operation is finish."); Console.ReadLine(); }