public static CONFIG_MYSQL GetInfoSQL()
{
if (IsLoadSQL)
return ConfMysql;
XmlReaderSettings setting = new XmlReaderSettings();
setting.ConformanceLevel = ConformanceLevel.Fragment;
setting.IgnoreWhitespace = true;
setting.IgnoreComments = true;
if (!File.Exists("ConfigSQL.xml"))
{
return new CONFIG_MYSQL();
}
using (XmlReader reader = XmlReader.Create("ConfigSQL.xml", setting))
{
CONFIG_MYSQL f_name = new CONFIG_MYSQL();
reader.Read();
reader.ReadStartElement("head");
reader.ReadStartElement("FolderFile");
reader.ReadStartElement("IP");
f_name.IP = reader.Value;
reader.Read();
reader.ReadEndElement();
reader.ReadStartElement("USER");
f_name.USER = reader.Value;
reader.Read();
reader.ReadEndElement();
reader.ReadStartElement("PASS");
f_name.PASS = reader.Value;
reader.Read();
if(f_name.PASS != "")
reader.ReadEndElement();
reader.ReadStartElement("DATA");
f_name.DATA = reader.Value;
reader.Close();
ConfMysql = f_name;
IsLoadSQL = true;
return f_name;
}
}
public static void CreateSQL(CONFIG_MYSQL mysql)
{
try
{
XmlTextWriter textWriter = new XmlTextWriter("ConfigSQL.xml", Encoding.UTF8);
XmlDocument document = new XmlDocument();
textWriter.WriteStartDocument();
textWriter.WriteStartElement("head");
textWriter.WriteEndElement();
textWriter.Close();
document.Load("ConfigSQL.xml");
XmlNode element = document.CreateElement("FolderFile");
document.DocumentElement.AppendChild(element);
CreateSubElement(ref document,ref element, "IP", mysql.IP);
CreateSubElement(ref document, ref element, "USER", mysql.USER);
CreateSubElement(ref document, ref element, "PASS", mysql.PASS);
CreateSubElement(ref document, ref element, "DATA", mysql.DATA);
document.Save("ConfigSQL.xml");
}
catch (Exception ex)
{
// TODO: Написать окно
}
}
