private string m_FolderNameActVersion; //Nombre de la carpeta de la versión actual
/// <summary>
/// Class constructor
/// </summary>
/// <param name="DBConnection">Reference to SQL connection</param>
/// <remarks></remarks>
public CDBScripts(RoutinesLibrary.Data.DataBase.SQLCompact.SQLCompactConnection DBConnection)
{
//Guardamos la conexión con la base de datos
m_DBConnection = DBConnection;
//Path de la carpeta de los scripts de DB
m_DBScriptsFolderPath = Path.Combine((new Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase()).Info.DirectoryPath, DB_SCRIPTS_FOLDER_PATH);
//Nombre de la carpeta de la versión actual. Tiene el formato XXYYZZWW
string[] aSwVersion = (new Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase()).Info.Version.ToString().Split('.');
m_FolderNameActVersion = "";
foreach (string numSwVersion in aSwVersion)
{
if (numSwVersion.Length == 1)
{
m_FolderNameActVersion += "0";
}
m_FolderNameActVersion += numSwVersion;
}
}
/// <summary>
/// Class constructor. Created the DB if not exists or update it
/// </summary>
public CLocalData()
{
//Create connection with the Data Base and execute the necesary sql sentences
string sDBPathFilename = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.CommonProgramFiles),
"JBC\\JBC Host Controller Service", System.Convert.ToString(
My.Settings.Default.SQLCeDB));
m_DBConnection = new RoutinesLibrary.Data.DataBase.SQLCompact.SQLCompactConnection(sDBPathFilename);
CDBScripts DBScripts = new CDBScripts(m_DBConnection);
if (!System.IO.File.Exists(sDBPathFilename))
{
DBScripts.CreateDataBase();
}
else
{
DBScripts.UpdateDataBase(GetHostControllerSwVersion());
}
}
