using System;

using DocuWareImport.Models;

using System.Collections.Generic;

using System.Xml.Serialization;

using System.IO;

using System.Xml;

using System.Configuration;

​

namespace DocuWareImportFromCSV

{

    class Program

    {

        static void Main(string[] args)

        {

            //Datei einlesen und Felder

​

            //var inputFilename = @"C:\temp\config_csv\test.csv";

            var inputFilename = @ConfigurationManager.AppSettings["inputFilename"];

            //var outputDirectory = @"C:\Temp";

            var outputDirectory = @ConfigurationManager.AppSettings["outputDirectory"];

​

            //Console.WriteLine("Dateipfad - input: " + inputFilename + " | " + "Dateipfad - Output: " + outputDirectory);

            //string text = File.ReadAllText("C:\\test.csv");

​

            //Gesamtes Textfile in Zeilen aufteilen

​

            string[] csvFile = File.ReadAllLines(inputFilename);

            foreach (string sourceLines in csvFile)

            {

            // Zeile in Felder (Spalten) aufteilen

                Console.WriteLine(sourceLines);

                //string sourceLine = sourceLines;

                char delimiter = ';';

                string[] sourceFields = sourceLines.Split(delimiter);

                foreach (var sourceField in sourceFields) //Console.WriteLine(sourceField);

                { 

                    //Definiton der Variablen für die Ausgabedatei

                    var filecabinet = ConfigurationManager.AppSettings["fileCabinet"] as String;

                    var lastName = Convert.ToString(sourceFields[0]);

                    var surName = Convert.ToString(sourceFields[1]);

                    var birthday = Convert.ToString(sourceFields[2]);

                    var yearsInAction = Convert.ToString(sourceFields[3]);

                    var eMail = Convert.ToString(sourceFields[4]);

                    var salary = Convert.ToString(sourceFields[5]);

                    var docNumber = Convert.ToString(sourceFields[6]);

                    var docFilename = Convert.ToString(sourceFields[7]);

                    var clientID = Convert.ToString(sourceFields[8]);

                    var area = Convert.ToString(sourceFields[9]);

                    var directory = Convert.ToString(sourceFields[10]);

                    var register = Convert.ToString(sourceFields[11]);

​

                    Console.WriteLine(lastName, surName, birthday, yearsInAction, eMail, salary, docNumber, docFilename, clientID, area, directory, register);

                    WriteXml(outputDirectory, lastName, surName, birthday, yearsInAction, eMail, salary, docNumber, docFilename, clientID, area, directory, register);

​

                }

​

            }

​

            Console.ReadKey();

        }

​

        private static void WriteXml(string outputDirectory, string lastName, string surName, string birthday, string yearsInAction, string eMail, string salary, string docNumber, string docFilename, string clientID, string area, string directory, string register)

        {

​

            var controlStatement = new ControlStatements();

            controlStatement.Page = new Page();

            controlStatement.Page.FileCabinet = new FileCabinet();

            controlStatement.Page.Fields = new List<Field>();

            controlStatement.Page.SelectConfiguration = new SelectConfiguration();

            controlStatement.Page.FileCabinet.Name = ConfigurationManager.AppSettings["fileCabinet"];

            controlStatement.Page.SelectConfiguration.Name = ConfigurationManager.AppSettings["fileCabinet"];

​

            var field = new Field()

            {

                DbName = "NAME",

                Type = "Text",

                Value = lastName

            };

            controlStatement.Page.Fields.Add(field);

            //<Fields dbName="NAME" type="Text" value="Mius" />

​

            field = new Field()

            {

                DbName = "VORNAME",

                Type = "Text",

                Value = surName

            };

            controlStatement.Page.Fields.Add(field);

            //<Fields dbName="VORNAME" type="Text" value="Manni" />

​

            field = new Field()

            {

                DbName = "GEBURTSTAG",

                Type = "Date",

                Value = birthday

             // Konvertierung lösen

             //   Value = birthday.ToString("yyyy-MM-dd"),

             //   Culture = "en-US",

             //   Format = "yyyy-MM-dd"               

            };

            controlStatement.Page.Fields.Add(field);

            //<Fields dbName="GEBURTSTAG" type="Date" value="2000-01-02" culture="en-US" format="yyyy-MM-dd" />

​

            field = new Field()

            {

                DbName = "DIENSTJAHRE",

                Type = "Text",

                Value = yearsInAction

            };

            controlStatement.Page.Fields.Add(field);

            //<Fields dbName="DIENSTJAHRE" type="Numeric" value="6" culture="de-DE" />

​

            field = new Field()

            {

                DbName = "EMAIL",

                Type = "Text",

                Value = eMail

            };

            controlStatement.Page.Fields.Add(field);

            //<Fields dbName="EMAIL" type="Text" value="mami@muster.de" />

​

            field = new Field()

            {

                DbName = "GEHALT",

                Type = "Text",

                Value = salary

            };

            controlStatement.Page.Fields.Add(field);

            //<Fields dbName="GEHALT" type="Numeric" value="31,2" culture="de-DE" />

​

            field = new Field()

            {

                DbName = "DOCUMENT_NUMBER",

                Type = "Text",

                Value = docNumber

            };

            controlStatement.Page.Fields.Add(field);

            //<Fields dbName="DOCUMENT_NUMBER" type="Text" value="4713" />

​

            field = new Field()

            {

                DbName = "DATEINAME",

                Type = "Text",

                Value = docFilename

            };

            controlStatement.Page.Fields.Add(field);

            //<Field dbName="DATEINAME" type="Text" value="4713.pdf"/>

​

            field = new Field()

            {

                DbName = "MANDANTENID",

                Type = "Text",

                Value = clientID

            };

            controlStatement.Page.Fields.Add(field);

            //<Field dbName="MANDANTENID" type="Text" value="683"/> 

​

            field = new Field()

            {

                DbName = "BEREICH",

                Type = "Text",

                Value = area

            };

            controlStatement.Page.Fields.Add(field);

            //<Field dbName="BEREICH" type="Text" value="Personal"/> 

​

            field = new Field()

            {

                DbName = "ORDNER",

                Type = "Text",

                Value = directory

            };

            controlStatement.Page.Fields.Add(field);

            //<Field dbName="ORDNER" type = "Text" value = "Mitarbeiter" />

​

            field = new Field()

            {

                DbName = "REGISTER",

                Type = "Text",

                Value = register

            };

            controlStatement.Page.Fields.Add(field);

            //<Field dbName="REGISTER" type = "Text" value = "aktiv" />

​

            field = new Field()

            {

                DbName = "IMPORTSTATUS",

                Type = "Text",

                Value = "1/2"

            };

            controlStatement.Page.Fields.Add(field);

            //< Field dbName = "IMPORTSTATUS" type = "Text" value = "1/2" />

​

            string docFilenameWithoutExtension = Path.GetFileNameWithoutExtension(docFilename);

​

            string outputFilename = Path.Combine(outputDirectory, $"{docFilenameWithoutExtension}.dwcontrol");

​

            if (File.Exists(outputFilename))

            {

                File.Delete(outputFilename);

            }

​

            using (var fs = new FileStream(outputFilename, FileMode.CreateNew, FileAccess.ReadWrite))

            {

                using (var xmlWriter = XmlWriter.Create(fs, new XmlWriterSettings() { OmitXmlDeclaration = true, Indent = true }))

                {

                    var xmlSerializer = new XmlSerializer(typeof(ControlStatements));

                    xmlSerializer.Serialize(xmlWriter, controlStatement);

                }

​

            }

​

            //throw new NotImplementedException();

        }

    }

}

​