public SavedSearchManager(string connectionString, DataProvider provider) { _connectionString = connectionString; _provider = provider; DBControl control = new DBControl(connectionString, provider); if (!control.CheckDataAccess()) { control.CreateTables(); } }
public ContactManager(string connectionString, DataProvider provider) { _connectionString = connectionString; _provider = provider; _lastid = ""; DBControl control = new DBControl(connectionString, provider); if (!control.CheckDataAccess()) { control.CreateTables(); } }
/* Initialise the class variables and set the log file connection string */ public MiManager(string connString, DataProvider provider, string dataLogFilePath) { _connectionString = connString; _provider = provider; _dataLogFilePath = dataLogFilePath; LogManager.SetConnectionString(connString, _provider); //When the MiManager is created it does a check on the DB to make sure all the required tables are there DBControl control = new DBControl(connString, provider); if (!control.CheckDataAccess()) { control.CreateTables(); } }
private void BuildDemoFile() { ConnStringer stringer = new ConnStringer(); string myDocs = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); this.SetText("Creating the Demo Call Records Database"); string demoPath = myDocs + "\\MiSMDR\\Demo_Call_Records.db"; string connString = stringer.buildLiteConnectionString(demoPath, "3", "True", "False", "", "", false); MiConfig.SetConnectionString("MiDemoString", connString); //initialise and put demo data in the database if there is none already DBControl control = new DBControl(MiConfig.GetConnectionString("MiDemoString"), MiConfig.GetProvider()); if (!control.CheckDataAccess()) { initDatabase(connString, true); } }
private void BuildMitelFile() { ConnStringer stringer = new ConnStringer(); string myDocs = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); this.SetText("Creating the Mitel Call Records Database"); string dataPath = myDocs + "\\MiSMDR\\Mitel_Call_Records.db"; string connString = stringer.buildLiteConnectionString(dataPath, "3", "False", "False", "", "", false); MiConfig.SetConnectionString("MiDatabaseString", connString); //we only need to intialise the database if it doesnt have any content DBControl control = new DBControl(MiConfig.GetConnectionString("MiDatabaseString"), MiConfig.GetProvider()); if (!control.CheckDataAccess()) { initDatabase(connString, false); } }
private void afterLoad() { string myDocs = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); //first thing is to see if the config is new if (MiConfig.GetProvider() != DataProvider.Sqlite) { this.SetText("Updating configuration file"); MiConfig.buildDefaultConfigFile(_configPath); //rebuild it just in case MiConfig.SetProvider(DataProvider.Sqlite); } if (MiConfig.GetProvider() != DataProvider.Sqlite) { //CHECK AGAIN - this is to make sure the config file is in a writable location this.SetText("Unable to create a config file. Please contact the MiSMDR support team at [email protected]"); } if ((MiConfig.GetConnectionString("MiDatabaseString") == "notinstalled") || (MiConfig.GetConnectionString("MiDemoString") == "notinstalled")) { CheckMiSMDRFolder(); //now we need to check the demo file location if (MiConfig.GetConnectionString("MiDemoString") == "notinstalled") { BuildDemoFile(); } if (MiConfig.GetConnectionString("MiDatabaseString") == "notinstalled") { BuildMitelFile(); } } if (MiConfig.GetLogPath() == "notinstalled") { this.SetText("Checking Mitel Data log file"); string dataLogPath = myDocs + "\\MiSMDR\\MitelData_Log.txt"; MiConfig.SetLogPath(dataLogPath); } DBControl demoChecker = new DBControl(MiConfig.GetConnectionString("MiDemoString"), MiConfig.GetProvider()); DBControl liveChecker = new DBControl(MiConfig.GetConnectionString("MiDatabaseString"), MiConfig.GetProvider()); this.SetText("Configuration looks ok"); this.SetText("Checking Database access"); if (!demoChecker.CheckDataAccess()) { this.SetText("Demo Database looks ok"); CheckMiSMDRFolder(); //check the folder exists BuildDemoFile(); } if (!liveChecker.CheckDataAccess()) { this.SetText("Mitel Database looks ok"); CheckMiSMDRFolder(); BuildMitelFile(); } //Load MiSMDR main CheckProgressBar(); HideSplash(); MiSMDR.MiForm.customStart(_popup, _trialStatus); CloseSplash(); //after the MiForm is closed then kill the App }