Example #1
0
        public static bool Remove(DataTransferErrorProfile profile)
        {
            string filePath = ProfilePath;

            if (!File.Exists(filePath))
            {
                return(false);
            }

            XDocument doc  = XDocument.Load(filePath);
            XElement  root = doc.Root;

            XElement profileElement = root.Elements("Item").FirstOrDefault(item =>
                                                                           item.Attribute("SourceServer")?.Value == profile.SourceServer &&
                                                                           item.Attribute("SourceDatabase")?.Value == profile.SourceDatabase &&
                                                                           item.Attribute("TargetServer")?.Value == profile.TargetServer &&
                                                                           item.Attribute("TargetDatabase")?.Value == profile.TargetDatabase
                                                                           );

            if (profileElement != null)
            {
                profileElement.Remove();
                doc.Save(filePath);
                return(true);
            }

            return(false);
        }
Example #2
0
        public static bool Save(DataTransferErrorProfile profile)
        {
            if (!Directory.Exists(ProfileFolder))
            {
                Directory.CreateDirectory(ProfileFolder);
            }

            string filePath = ProfilePath;

            if (!File.Exists(filePath))
            {
                using (StreamWriter sw = File.CreateText(filePath))
                {
                    sw.WriteLine(
                        $@"<?xml version=""1.0"" encoding=""utf-8""?>
<Config>
</Config>
");
                    sw.Flush();
                }
            }

            lock (obj)
            {
                XDocument doc  = XDocument.Load(filePath);
                XElement  root = doc.Root;

                XElement profileElement = root.Elements("Item").FirstOrDefault(item =>
                                                                               item.Attribute("SourceServer")?.Value == profile.SourceServer &&
                                                                               item.Attribute("SourceDatabase")?.Value == profile.SourceDatabase &&
                                                                               item.Attribute("TargetServer")?.Value == profile.TargetServer &&
                                                                               item.Attribute("TargetDatabase")?.Value == profile.TargetDatabase
                                                                               );

                if (profileElement == null)
                {
                    profileElement = new XElement("Item",
                                                  new XAttribute("SourceServer", profile.SourceServer),
                                                  new XAttribute("SourceDatabase", profile.SourceDatabase),
                                                  new XAttribute("SourceTableName", profile.SourceTableName),
                                                  new XAttribute("TargetServer", profile.TargetServer),
                                                  new XAttribute("TargetDatabase", profile.TargetDatabase),
                                                  new XAttribute("TargetTableName", profile.TargetTableName)
                                                  );
                    root.Add(profileElement);
                }
                else
                {
                    profileElement.Attribute("SourceTableName").Value = profile.SourceTableName;
                    profileElement.Attribute("TargetTableName").Value = profile.TargetTableName;
                }

                doc.Save(filePath);
            }

            return(true);
        }
Example #3
0
        public static DataTransferErrorProfile GetProfile(ConnectionInfo sourceConnectionInfo, ConnectionInfo targetConnectionInfo)
        {
            DataTransferErrorProfile profile = null;
            string filePath = ProfilePath;

            if (!File.Exists(filePath) || sourceConnectionInfo == null || targetConnectionInfo == null)
            {
                return(null);
            }

            XDocument doc  = XDocument.Load(filePath);
            XElement  root = doc.Root;

            XElement profileElement = root.Elements("Item").FirstOrDefault(item =>
                                                                           item.Attribute("SourceServer")?.Value == sourceConnectionInfo.Server &&
                                                                           item.Attribute("SourceDatabase")?.Value == sourceConnectionInfo.Database &&
                                                                           item.Attribute("TargetServer")?.Value == targetConnectionInfo.Server &&
                                                                           item.Attribute("TargetDatabase")?.Value == targetConnectionInfo.Database
                                                                           );

            if (profileElement != null)
            {
                profile = new DataTransferErrorProfile()
                {
                    SourceServer    = sourceConnectionInfo.Server,
                    SourceDatabase  = sourceConnectionInfo.Database,
                    SourceTableName = profileElement.Attribute("SourceTableName")?.Value,

                    TargetServer    = targetConnectionInfo.Server,
                    TargetDatabase  = targetConnectionInfo.Database,
                    TargetTableName = profileElement.Attribute("TargetTableName")?.Value
                };
            }

            return(profile);
        }