public bool Insertwebspherenodesandservers(VitalSignsWebSphereDLL.VitalSignsWebSphereDLL.Cell cells, int id)
{
try
{
return(VSWebDAL.SecurityDAL.webspehereimportDAL.Ins.Insertwebspherenodesandservers(cells, id));
}
catch (Exception ex)
{
throw ex;
}
//return VSWebDAL.SecurityDAL.ServersDAL.Ins.UpdateData(ServerObject);
}
public bool InsertwebsphereSametimenodesandservers(VitalSignsWebSphereDLL.VitalSignsWebSphereDLL.Cell cells, int id, int Sid)
{
try
{
return(VSWebDAL.ConfiguratorDAL.IBMConnectionsServersDAL.Ins.InsertwebsphereSametimenodesandservers(cells, id, Sid));
}
catch (Exception ex)
{
throw ex;
}
//return VSWebDAL.SecurityDAL.ServersDAL.Ins.UpdateData(ServerObject);
}
public bool InsertwebsphereSametimenodesandservers(VitalSignsWebSphereDLL.VitalSignsWebSphereDLL.Cell cell, int id, int Sid)
{
bool returnval = false;
bool insertServerDtls = false;
string sql;
DataTable dt = new DataTable();
try
{
sql = "select * from WebsphereCell where CellName='" + cell.Name.ToString() + "' and IBMConnectionSID='" + Sid + "'";
dt = objAdaptor.FetchData(sql);
if (dt.Rows.Count == 0)
{
sql = "Update WebsphereCell set CellName ='" + cell.Name.ToString() + "' where CellID='" + id + "' ";
returnval = objAdaptor.ExecuteNonQuery(sql);
}
sql = "select CellID from WebsphereCell where CellName='" + cell.Name.ToString() + "'";
dt = objAdaptor.FetchData(sql);
int cellid = Convert.ToInt32(dt.Rows[0]["CellID"].ToString());
foreach (VitalSignsWebSphereDLL.VitalSignsWebSphereDLL.Node node in cell.Nodes.Node)
{
sql = "select * from WebsphereNode where CellID='" + cellid + "' and NodeName='" + node.Name.ToString() + "'";
dt = objAdaptor.FetchData(sql);
if (dt.Rows.Count == 0)
{
sql = "INSERT INTO WebsphereNode (NodeName, CellId, HostName) VALUES ('" + node.Name.ToString() + "',(SELECT MAX(CellID) FROM WebsphereCell where CellName='" + cell.Name.ToString() + "'),'" + node.HostName.ToString() + "');\n";
//INSERT
returnval = objAdaptor.ExecuteNonQuery(sql);
}
sql = "select NodeID from WebsphereNode where NodeName='" + node.Name.ToString() + "'";
dt = objAdaptor.FetchData(sql);
int nodeid = Convert.ToInt32(dt.Rows[0]["NodeID"].ToString());
foreach (string serverName in node.Servers.Server)
{
string servername1 = serverName;
string nodename1 = node.Name.ToString();
string cellname = cell.Name.ToString();
string inserservername = servername1 + " [" + cellname + '~' + nodename1 + "]";
sql = "select * from WebsphereServer where CellID='" + cellid + "' and NodeID='" + nodeid + "' and ServerName='" + inserservername + "'";
dt = objAdaptor.FetchData(sql);
if (dt.Rows.Count == 0)
{
sql = "INSERT INTO Servers (ServerName, ServerTypeId, Description, LocationId, IPAddress) VALUES ('" + inserservername + "', '22', 'WebSphere', (SELECT MIN(ID) From Locations),'');\n";
returnval = objAdaptor.ExecuteNonQuery(sql);
sql = "INSERT INTO WebsphereServer (ServerName, CellId, NodeId, ServerId) VALUES ('" + inserservername + "',(SELECT MAX(CellID) FROM WebsphereCell where CellName='" + cell.Name.ToString() + "')," +
"(SELECT MAX(NodeId) FROM WebsphereNode where NodeName='" + node.Name.ToString() + "'), (SELECT MAX(ID) FROM Servers WHERE ServerName='" + inserservername + "'));\n";
returnval = objAdaptor.ExecuteNonQuery(sql);
}
}
}
}
finally
{
}
return(returnval);
}
public bool Insertwebspherenodesandservers(VitalSignsWebSphereDLL.VitalSignsWebSphereDLL.Cell cell, int id)
{
bool returnval = false;
bool insertServerDtls = false;
string sql;
DataTable dt = new DataTable();
try
{
sql = "select * from WebsphereCell where CellName='" + cell.Name.ToString() + "'";
dt = objAdaptor.FetchData(sql);
if (dt.Rows.Count == 0)
{
sql = "Update WebsphereCell set CellName ='" + cell.Name.ToString() + "' where CellID='" + id + "' ";
//sql += "INSERT INTO WebsphereCell (CellName) VALUES ('" + cell.Name.ToString() + "');\n";
returnval = objAdaptor.ExecuteNonQuery(sql);
}
sql = "select CellID from WebsphereCell where CellName='" + cell.Name.ToString() + "'";
dt = objAdaptor.FetchData(sql);
int cellid = id;
foreach (VitalSignsWebSphereDLL.VitalSignsWebSphereDLL.Node node in cell.Nodes.Node)
{
sql = "select * from WebsphereNode where CellID='" + cellid + "' and NodeName='" + node.Name.ToString() + "'";
dt = objAdaptor.FetchData(sql);
if (dt.Rows.Count == 0)
{
//sql = "INSERT INTO WebsphereNode (NodeName, CellId, HostName) VALUES ('" + node.Name.ToString() + "',(SELECT MAX(CellID) FROM WebsphereCell where CellName='" + cell.Name.ToString() + "'),'" + node.HostName.ToString() + "');\n";
//INSERT
sql = "INSERT INTO WebsphereNode (NodeName, CellId, HostName) VALUES ('" + node.Name.ToString() + "','" + cellid + "','" + node.HostName.ToString() + "');\n";
returnval = objAdaptor.ExecuteNonQuery(sql);
}
sql = "select NodeID from WebsphereNode where NodeName='" + node.Name.ToString() + "' and CellID='" + cellid + "'";
dt = objAdaptor.FetchData(sql);
int nodeid = Convert.ToInt32(dt.Rows[0]["NodeID"].ToString());
foreach (string serverName in node.Servers.Server)
{
string servername1 = serverName;
string nodename1 = node.Name.ToString();
string cellname = cell.Name.ToString();
string inserservername = servername1 + " [" + cellname + '~' + nodename1 + "]";
//1/20/16 WS Commented out due to duplicates being able to be made using RMI and SOAP. It will now jsut compare ServerName to stop this issue.
//The server name has cell, node and server name in it so it should prevent all duplications
//sql = "select * from WebsphereServer where CellID='" + cellid + "' and NodeID='" + nodeid + "' and ServerName='" + inserservername + "'";
sql = "select * from WebsphereServer where ServerName='" + inserservername + "'";
dt = objAdaptor.FetchData(sql);
if (dt.Rows.Count == 0)
{
sql = "INSERT INTO Servers (ServerName, ServerTypeId, Description, LocationId, IPAddress, ProfileName, BusinessHoursID) VALUES ('" + inserservername + "', '22', 'WebSphere', (SELECT MIN(ID) From Locations),'', '0', '0');\n";
returnval = objAdaptor.ExecuteNonQuery(sql);
//sql = "INSERT INTO WebsphereServer (ServerName, CellId, NodeId, ServerId) VALUES ('" + inserservername + "',(SELECT MAX(CellID) FROM WebsphereCell where CellName='" + cell.Name.ToString() + "')," +
//"(SELECT MAX(NodeId) FROM WebsphereNode where NodeName='" + node.Name.ToString() + "'), (SELECT MAX(ID) FROM Servers WHERE ServerName='" + inserservername + "'));\n";
sql = "INSERT INTO WebsphereServer (ServerName, CellId, NodeId, ServerId) VALUES ('" + inserservername + "','" + cellid + "'," +
"'" + nodeid + "', (SELECT MAX(ID) FROM Servers WHERE ServerName='" + inserservername + "'));\n";
returnval = objAdaptor.ExecuteNonQuery(sql);
}
}
}
}
finally
{
}
return(returnval);
}
