public void GenerateXml() { DatabaseTableModel table = new DatabaseTableModel(); File.Delete(AppDomain.CurrentDomain.BaseDirectory + @"\MyFile.xml"); table.SourceConnectionString = AppDomain.CurrentDomain.BaseDirectory + @"\myfile.csv"; table.SourceDatabaseType = AtlasDataConvert.Enumerations.DatabaseType.CSV; table.SourceName = "MyFile"; table.DestinationConnectionString = AppDomain.CurrentDomain.BaseDirectory + @"\myfleConverted.csv"; table.DestinationDatabaseType = AtlasDataConvert.Enumerations.DatabaseType.CSV; table.DestinationName = "MyFileConverted"; table.Fields = new List <DatabaseField>(); table.Fields.Add(new DatabaseField() { SourceName = "Field1", DestinationName = "FieldConverted1" }); table.Fields.Add(new DatabaseField() { SourceName = "Field2", DestinationName = "FieldConverted2" }); table.Fields.Add(new DatabaseField() { SourceName = "Field3", DestinationName = "FieldConverted3" }); ProcessDataFilesService.GenerateModelXml(table, AppDomain.CurrentDomain.BaseDirectory + @"\MyFile.xml"); }
public static DatabaseTableModel LoadTableModel(string databaseTablePath) { DatabaseTableModel result = null; XmlSerializer serializer = new XmlSerializer(typeof(DatabaseTableModel)); serializer.UnknownNode += new XmlNodeEventHandler(serializer_UnknownNode); serializer.UnknownAttribute += new XmlAttributeEventHandler(serializer_UnknownAttribute); FileStream fs = new FileStream(databaseTablePath, FileMode.Open); result = (DatabaseTableModel)serializer.Deserialize(fs); return(result); }
public static bool GenerateModelXml(DatabaseTableModel tableModel, string outputFileName) { bool success = false; try { XmlSerializer serializer = new XmlSerializer(typeof(DatabaseTableModel)); TextWriter writer = new StreamWriter(outputFileName); serializer.Serialize(writer, tableModel); writer.Close(); success = true; } catch (Exception ex) { LogService.LogMessage(string.Format("Error::{0}{1}{2}{3}{2}", System.DateTime.Now, ex.Message, Environment.NewLine, ex.StackTrace)); } return(success); }
static void Main(string[] args) { DatabaseTableModel table = new DatabaseTableModel(); string[] splitLine; string required; DatabaseField field = new DatabaseField(); string directory = @"C:\Development\ProjectAtlas\DataConversion\CapsysTemplates";// AppDomain.CurrentDomain.BaseDirectory; //string directory = AppDomain.CurrentDomain.BaseDirectory; foreach (string fileName in Directory.GetFiles(directory + @"\Input")) { Console.WriteLine("Processing::{0}", fileName); table = new DatabaseTableModel(); table.DestinationDatabaseType = DatabaseType.CSV; table.SourceDatabaseType = DatabaseType.FoxPro; table.SourceCommandType = CommandType.Table; table.DestinationConnectionString = ""; table.DestinationName = Path.GetFileNameWithoutExtension(fileName); table.SourceName = Path.GetFileNameWithoutExtension(fileName); table.SourceConnectionString = table.SourceName; table.Fields = new List <DatabaseField>(); foreach (string line in File.ReadAllLines(fileName)) { field = new DatabaseField(); splitLine = line.Split(','); field.DataLength = splitLine[5]; field.DestinationName = splitLine[2]; field.FieldDataType = GetDataTypeFromString(splitLine[0]); field.SourceName = splitLine[3]; required = splitLine[12].ToUpper(); field.IsRequired = required == "TRUE" ? true : false; if (!splitLine[0].Contains("Formula") && !splitLine[0].Contains("Address")) { table.Fields.Add(field); } } File.Delete(fileName.Replace("Input", "Output").Replace(".csv", ".xml")); ProcessDataFilesService.GenerateModelXml(table, fileName.Replace("Input", "Output").Replace(".csv", ".xml")); } Console.ReadKey(); }
public void LoadXml() { DatabaseTableModel table = new DatabaseTableModel(); table = ProcessDataFilesService.LoadTableModel(@"C:\Development\ProjectAtlas\DataConversion\AtlasDataConvert\MappingFIles\MyFile.xml"); }