public ServerNode(ServerInfo dbs)
{
NodeType = NodeType.Server;
Server = dbs;
this.IsConnected = false;
this.Text = dbs.ToString();
this.ImageIndex = DataConvert.GetInt32(IconType.Server);
this.SelectedImageIndex = DataConvert.GetInt32(IconType.Server);
}
private static bool IsExistServerNode(XmlDocument xmldoc, ServerInfo server)
{
XmlNode objRootNode = xmldoc.SelectSingleNode(Constants.NODE_ROOT + Constants.CHAR_SLASH + Constants.NODE_SERVERS);
foreach (XmlNode xn in objRootNode.ChildNodes)
{
if (xn.ChildNodes[0].InnerText == server.DatabaseType &&
xn.ChildNodes[1].InnerText == server.ServerName &&
xn.ChildNodes[2].InnerText == server.ConnectionString &&
xn.ChildNodes[3].InnerText == server.DatabaseName)
{
return true;
}
}
return false;
}
//private static void EditAccountNode(XmlDocument xmldoc, string email, ServerInfo server)
//{
// XmlNode objRootNode = xmldoc.SelectSingleNode(DatabaseConstants.NODE_ROOT + DatabaseConstants.CHAR_SLASH + DatabaseConstants.NODE_SERVERS);
// foreach (XmlNode xn in objRootNode.ChildNodes)
// {
// if (xn.ChildNodes[0].InnerText == email)
// {
// xn.ChildNodes[0].InnerText = user.Email;
// xn.ChildNodes[1].InnerText = user.Password;
// xn.ChildNodes[2].InnerText = user.UserName;
// xn.ChildNodes[3].InnerText = user.UserId;
// break;
// }
// }
//}
private static void DeleteServerNode(XmlDocument xmldoc, ServerInfo server)
{
XmlNode objRootNode = xmldoc.SelectSingleNode(Constants.NODE_ROOT + Constants.CHAR_SLASH + Constants.NODE_SERVERS);
foreach (XmlNode xn in objRootNode.ChildNodes)
{
if (xn.ChildNodes[0].InnerText == server.DatabaseType &&
xn.ChildNodes[1].InnerText == server.ServerName &&
xn.ChildNodes[2].InnerText == server.ConnectionString &&
xn.ChildNodes[3].InnerText == server.DatabaseName)
{
objRootNode.RemoveChild(xn);
break;
}
}
}
private static void InsertAccounNode(XmlDocument xmldoc, ServerInfo server)
{
XmlNode objRootNode = xmldoc.SelectSingleNode(Constants.NODE_ROOT + Constants.CHAR_SLASH + Constants.NODE_SERVERS);
XmlElement objChildNode = xmldoc.CreateElement(Constants.NODE_DBSERVER);
objRootNode.AppendChild(objChildNode);
XmlElement emtType = xmldoc.CreateElement(Constants.DB_DATABASETYPE);
emtType.InnerText = server.DatabaseType;
XmlElement emtServerName = xmldoc.CreateElement(Constants.DB_SERVERNAME);
emtServerName.InnerText = server.ServerName;
XmlElement emtConnectionString = xmldoc.CreateElement(Constants.DB_CONNECTIONSTRING);
emtConnectionString.InnerText = server.ConnectionString;
XmlElement emtDatabaseName = xmldoc.CreateElement(Constants.DB_DATABASENAME);
emtDatabaseName.InnerText = server.DatabaseName;
objChildNode.AppendChild(emtType);
objChildNode.AppendChild(emtServerName);
objChildNode.AppendChild(emtConnectionString);
objChildNode.AppendChild(emtDatabaseName);
}
public static string DeleteServer(ServerInfo server)
{
try
{
XmlDocument objXmlDoc = GetCGConfigFile();
if (objXmlDoc == null)
return "Config file doesn't exist!";
DeleteServerNode(objXmlDoc, server);
string configFile = Path.Combine(Application.StartupPath, Constants.FILE_CGCONFIG);
objXmlDoc.Save(configFile);
return "Ok";
}
catch
{
return "Fail";
}
}
public static string EditServer(ServerInfo server)
{
try
{
XmlDocument objXmlDoc = GetCGConfigFile();
if (objXmlDoc == null)
return "Config file doesn't exist!";
if (IsExistServerNode(objXmlDoc, server))
return "The server has already existed!";
else
InsertAccounNode(objXmlDoc, server);
string configFile = Path.Combine(Application.StartupPath, Constants.FILE_CGCONFIG);
objXmlDoc.Save(configFile);
return Constants.STATUS_SUCCESS;
}
catch
{
return Constants.STATUS_FAIL;
}
}
public static Collection<ServerInfo> GetServers()
{
try
{
XmlDocument objXmlDoc = GetCGConfigFile();
if (objXmlDoc == null)
return null;
DataView dv = GetData(objXmlDoc, Constants.NODE_ROOT + Constants.CHAR_SLASH + Constants.NODE_SERVERS);
Collection<ServerInfo> servers = new Collection<ServerInfo>();
for (int ix = 0; ix < dv.Table.Rows.Count; ix++)
{
ServerInfo server = new ServerInfo();
server.DatabaseType = dv.Table.Rows[ix][0].ToString();
server.ServerName = dv.Table.Rows[ix][1].ToString();
server.ConnectionString = dv.Table.Rows[ix][2].ToString();
server.DatabaseName = dv.Table.Rows[ix][3].ToString();
servers.Add(server);
}
return servers;
}
catch
{
return null;
}
}
private void OnDeleteClick(object o, EventArgs e)
{
if (MessageBox.Show("Are you sure?","Confirm",MessageBoxButtons.OKCancel,MessageBoxIcon.Asterisk,MessageBoxDefaultButton.Button2)== DialogResult.OK)
{
ServerNode sn = (ServerNode)this.SelectedNode;
ServerInfo dbServer = new ServerInfo();
dbServer = sn.Server;
if (dbServer != null)
{
string ret = ConfigCtrl.DeleteServer(dbServer);
if (ret != CGConstants.STATUS_SUCCESS)
{
MessageBox.Show(ret, CGConstants.MSG_ERROR, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
BaseNode bn = (BaseNode)sn.Parent;
bn.Nodes.Remove(sn);
}
}
}
public DlgAddSqlServer()
{
NewSqlServer = new ServerInfo();
InitializeComponent();
}
public static Collection<DatabaseInfo> GetDataBases(ServerInfo server)
{
return GetDataBases(server.ConnectionString, server.ServerName, server.DatabaseName);
}