/// <summary> /// Gets the saved external database connection parameters from the project XML file. /// </summary> /// <param name="filePath"></param> /// <returns></returns> public static List <ExternalDBModel> GetDatabaseModel(string filePath) { List <ExternalDBModel> models = new List <ExternalDBModel>(); using (XmlReader _Reader = XmlReader.Create(new FileStream(filePath, FileMode.Open), new XmlReaderSettings() { CloseInput = true })) { while (_Reader.Read()) //while reader can read { ExternalDBModel model = new ExternalDBModel(); if ((_Reader.NodeType == XmlNodeType.Element) && (_Reader.Name == "Data")) //looks for xml parent node type of "project" (will look like <Data /> { if (_Reader.HasAttributes) //if current line has attributes { //read each attribute in the line if it matches the definition model.Type = _Reader.GetAttribute("Type"); model.Server = _Reader.GetAttribute("Server"); model.Database = _Reader.GetAttribute("Database"); model.UserID = _Reader.GetAttribute("UserID"); model.PassWord = _Reader.GetAttribute("Password"); models.Add(model); } } }//end of while } return(models); }
/// <summary> /// Gets the saved external database connection parameters from the project XML file. /// </summary> /// <param name="filePath"></param> /// <returns></returns> public static ExternalDBModel GetExternalProjectDBSettings(string workingFolder, string projectXMLFile) { var fqFilePath = Path.Combine(workingFolder, projectXMLFile); if (File.Exists(fqFilePath)) { using (XmlReader _Reader = XmlReader.Create(new FileStream(fqFilePath, FileMode.Open), new XmlReaderSettings() { CloseInput = true })) { ExternalDBModel model = new ExternalDBModel(); while (_Reader.Read()) //while reader can read { if ((_Reader.NodeType == XmlNodeType.Element) && (_Reader.Name == "ExternalDatabase")) //looks for xml parent node type of "project" (will look like <Data /> { if (_Reader.HasAttributes) //if current line has attributes { //read each attribute in the line if it matches the definition model.Type = _Reader.GetAttribute("Type"); model.Server = _Reader.GetAttribute("Server"); model.Database = _Reader.GetAttribute("Database"); model.UserID = _Reader.GetAttribute("UserID"); model.PassWord = _Reader.GetAttribute("Password"); } } }//end of while return(model); } } else { throw new FileNotFoundException("Settings file to read does not exist where you said it would be!"); } }