/// <summary>
/// Reads the providers state from the providers saved files.
/// </summary>
/// <param name="folder">The folder which contains all of your files and only your files.</param>
public override void Open(string folder)
{
Clear();
string databaseFile = Path.Combine(folder, "provider_database.settings");
string settingsFile = Path.Combine(folder, "provider_database_settings.xml");
//string zipFile = System.IO.Path.Combine(folder, "provider_database_data.zip");
//if (System.IO.File.Exists(zipFile))
//{
// Slyce.Common.Utility.UnzipFile(zipFile, tempFolder);
// //provider.Open(tempFolder);
//}
//else if (System.IO.File.Exists(databaseFile))
//{
// System.IO.File.Copy(databaseFile, System.IO.Path.Combine(tempFolder, System.IO.Path.GetFileName(dbFile)));
// //provider.Open(tempFolder);
//}
if (File.Exists(databaseFile))
{
TheBllDatabase = new BLL.Database(databaseFile);
}
if (File.Exists(settingsFile))
{
GetXmlSettings(settingsFile);
}
IsLoaded = true;
if (Screens != null && Screens.Length >= 2)
{
((Controls.ContentItems.SetupDatabase)Screens[0]).Populate();
((Controls.ContentItems.EditModel)Screens[1]).Populate();
}
}
public void LoadSingleDatabase(BLL.Database oDB)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("select")
.AppendLine(" *")
.AppendLine(" from")
.AppendLine(" [database] a")
.AppendLine(" where")
.AppendFormat(" a.[DBID]='{0}'", oDB.DBID);
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.ServerID = (Guid)oDT.Rows[0]["serverid"];
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 UpdateSingleDatabase(BLL.Database oDB)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("update [database] 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(" DBID='{0}'", oDB.DBID);
base.ExecuteNonQuery(sSQL.ToString());
}
public void InsertSingleDatabase(BLL.Database oDB)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("insert into [database] (")
.AppendLine(" serverid,")
.AppendLine(" DBID,")
.AppendLine(" name,")
.AppendLine(" description,")
.AppendLine(" Change_Date_Time,")
.AppendLine(" Change_UID) values (")
.AppendFormat("'{0}',", oDB.ServerID)
.AppendFormat("'{0}',", oDB.DBID)
.AppendFormat("'{0}',", oDB.Name)
.AppendFormat("'{0}',", oDB.Description)
.AppendFormat("'{0}',", oDB.ChangeDateTime)
.AppendFormat("'{0}')", oDB.ChangeUID);
base.ExecuteNonQuery(sSQL.ToString());
}
/// <summary>
/// Clears stored information and removes the provider screens.
/// </summary>
public override void Clear()
{
if (TheBllDatabase != null)
{
TheBllDatabase = null;
}
TheBllDatabase = new BLL.Database();
TablePrefixes.Clear();
ViewPrefixes.Clear();
StoredProcedurePrefixes.Clear();
foreach (ContentItem contentIten in Screens)
{
contentIten.Clear();
}
if (Screens != null && Screens.Length >= 2)
{
Screens[0] = null;
Screens[1] = null;
Screens = null;
}
}
