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()); } }