public void LoadSingleServer(BLL.Server oDB)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("select")
.AppendLine(" *")
.AppendLine(" from")
.AppendLine(" [server] a")
.AppendLine(" where")
.AppendFormat(" a.[serverid]='{0}'", oDB.ServerID);
DataTable oDT = base.ExecuteSQLToDatatable(sSQL.ToString());
if (oDT.Rows.Count > 0)
{
oDB.Name = oDT.Rows[0]["name"].ToString();
oDB.Description = DBHelper.NullToString(oDT.Rows[0]["description"]);
oDB.ChangeDateTime = oDT.Rows[0]["change_date_time"].ToString();
oDB.ChangeUID = oDT.Rows[0]["change_uid"].ToString();
}
else
{
oDB = null;
}
}
private void SetDB()
{
//What server are we scanning?
AGENT.DBServerAgent_Factory oServerAgent = new AGENT.DBServerAgent_Factory(m_ConnectionString);
string sServerName = oServerAgent.GetServerName();
//Does this server exist? If not, create it.
BLL.Server oServer = null;
DBL.DBServer_Factory oServerFactory = new DBL.DBServer_Factory();
m_ServerID = oServerFactory.GetServerID(sServerName);
if (m_ServerID == Guid.Empty)
{
//Create new server record.
oServer = new BLL.Server();
oServer.Name = sServerName;
oServer.Save();
m_ServerID = oServer.ServerID;
}
else
{
//load existing server
oServer = new BLL.Server(m_ServerID);
oServer.Load();
}
//What database are we scanning?
AGENT.DBDatabaseAgent_Factory oDatabaseAgent = new AGENT.DBDatabaseAgent_Factory(m_ConnectionString);
string sDatabaseName = oDatabaseAgent.GetDatabaseName();
//Does this database exist? If not, create it.
BLL.Database oDatabase = null;
DBL.DBDatabase_Factory oDatabaseFactory = new DBL.DBDatabase_Factory();
m_DBID = oDatabaseFactory.GetDatabaseID(m_ServerID, sDatabaseName);
if (m_DBID == Guid.Empty)
{
//Create new database record
oDatabase = new BLL.Database(oServer.ServerID);
oDatabase.Name = sDatabaseName;
oDatabase.Save();
m_DBID = oDatabase.DBID;
}
else
{
//Load existing database
oDatabase = new BLL.Database(m_ServerID, m_DBID);
oDatabase.Load();
}
}
public void UpdateSingleServer(BLL.Server oDB)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("update [server] set")
.AppendFormat(" name='{0}',", oDB.Name)
.AppendFormat(" description='{0}',", oDB.Description)
.AppendFormat(" Change_Date_Time='{0}',", oDB.ChangeDateTime)
.AppendFormat(" Change_UID='{0}'", oDB.ChangeUID)
.AppendLine(" where")
.AppendFormat(" serverid='{0}'", oDB.ServerID);
base.ExecuteNonQuery(sSQL.ToString());
}
public void InsertSingleServer(BLL.Server oDB)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("insert into [server] (")
.AppendLine(" serverid,")
.AppendLine(" name,")
.AppendLine(" description,")
.AppendLine(" Change_Date_Time,")
.AppendLine(" Change_UID) values (")
.AppendFormat("'{0}',", oDB.ServerID)
.AppendFormat("'{0}',", oDB.Name)
.AppendFormat("'{0}',", oDB.Description)
.AppendFormat("'{0}',", oDB.ChangeDateTime)
.AppendFormat("'{0}')", oDB.ChangeUID);
base.ExecuteNonQuery(sSQL.ToString());
}
