public static void Add_New_Server(String serverName, String value, ComboBox combobox)
{
if (!Check_Server_Exist_Or_Not(serverName))
{
combobox.IsEnabled = true;
combobox.Items.Add(serverName);
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(file_path);
XmlNode root = xmlDoc.DocumentElement;
XmlElement xmlEle = xmlDoc.CreateElement("Server");
XmlAttribute newAttr1 = xmlDoc.CreateAttribute("displayName");
XmlAttribute newAttr2 = xmlDoc.CreateAttribute("value");
newAttr1.Value = serverName;
newAttr2.Value = value;
xmlEle.Attributes.Append(newAttr1);
xmlEle.Attributes.Append(newAttr2);
root.InsertAfter(xmlEle, root.SelectSingleNode("/Server"));
xmlDoc.Save(file_path);
MessageBox.Show("Successfully Added New Server");
return;
}
MessageBox.Show("Already Exist With This Name");
return;
}
public static void Add_New_Database(String displayName, String connectionString, String serverName, ComboBox combobox)
{
if (!Check_Database_Exist_Or_Not(serverName, displayName))
{
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(file_path);
String x = "//Servers//Server[@displayName='" + serverName + "']";
XmlNode root = xmlDoc.SelectSingleNode(x);
XmlElement xmlEle = xmlDoc.CreateElement("databasename");
XmlAttribute newAttr1 = xmlDoc.CreateAttribute("displayName");
XmlAttribute newAttr2 = xmlDoc.CreateAttribute("connectionString");
newAttr1.Value = displayName;
newAttr2.Value = connectionString;
xmlEle.Attributes.Append(newAttr1);
xmlEle.Attributes.Append(newAttr2);
root.InsertAfter(xmlEle, root.SelectSingleNode("/Server"));
xmlDoc.Save(file_path);
combobox.IsEnabled = true;
combobox.Items.Add(displayName);
MessageBox.Show("Database Added Successfully");
return;
}
MessageBox.Show("Sorry Already Exist Database with this name");
return;
}
public static List <String> List_of_All_Server()
{
List <String> serverList = new List <String>();
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument document = new XmlDocument();
document.Load(@file_path);
var nodes1 = document.SelectNodes("//Server");
foreach (XmlNode node in nodes1)
{
serverList.Add(node.Attributes[0].Value);
}
return(serverList);
}
public static bool Check_Server_Exist_Or_Not(String serverName)
{
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument document = new XmlDocument();
document.Load(@file_path);
var nodes1 = document.SelectNodes("//Server");
foreach (XmlNode node in nodes1)
{
if (node.Attributes[0].Value.Equals(serverName))
{
return(true);
}
}
return(false);
}
public static List <String> List_All_Database_For_SelectedServer(String ServerName)
{
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument doc = new XmlDocument();
doc.Load(file_path);
String x = "/Servers/Server[@displayName = '" + ServerName + "']";
x = x + "/databasename";
var node1 = doc.SelectNodes(x);
List <String> dblist = new List <String>();
foreach (XmlNode node in node1)
{
dblist.Add(node.Attributes[0].Value);
}
return(dblist);
}
public static void Delete_Database(String serverName, String databasename)
{
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument doc = new XmlDocument();
doc.Load(file_path);
String x = "/Servers/Server[@displayName = '" + serverName + "']";
x = x + "/databasename[@displayName = '" + databasename + "']";
XmlNode node = doc.SelectSingleNode(x);
if (node != null)
{
XmlNode parent = node.ParentNode;
parent.RemoveChild(node);
doc.Save(@file_path);
}
}
public static void Delete_Server(String serverName)
{
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument doc = new XmlDocument();
doc.Load(file_path);
String x = "/Servers/Server[@displayName = '" + serverName + "']";
XmlNode node = doc.SelectSingleNode(x);
if (node != null)
{
XmlNode parent = node.ParentNode;
parent.RemoveChild(node);
//string newXML = doc.OuterXml;
doc.Save(@file_path);
}
return;
}
public static string Get_server_value(String serverName)
{
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument doc = new XmlDocument();
doc.Load(file_path);
String x = "/Servers/Server[@displayName = '" + serverName + "']";
//x = x + "/databasename[@displayName = '" + databasename + "']";
XmlNode node = doc.SelectSingleNode(x);
if (node != null)
{
String connectionString = node.Attributes["value"].Value;
return(connectionString);
}
return("-1");
}
public static bool Check_Database_Exist_Or_Not(String serverName, String databasename)
{
String file_path = CommanOperations.Path_of_StoreDB_XML_file();
XmlDocument doc = new XmlDocument();
doc.Load(file_path);
String x = "/Servers/Server[@displayName = '" + serverName + "']";
x = x + "/databasename";
var nodes = doc.SelectNodes(x);
foreach (XmlNode node in nodes)
{
if (node.Attributes[0].Value.Equals(databasename))
{
return(true);
}
}
return(false);
}
