private void initDatabase(string connString, bool demo) { string prefix = String.Empty; if (demo) { prefix = "Demo Call Records - "; } else { prefix = "Mitel Call Records - "; } DBInstaller myInstaller = new DBInstaller(connString, MiConfig.GetProvider()); this.SetText(prefix + "Creating Database"); myInstaller.CreateDatabase(); this.SetText(prefix + "Adding Tables"); myInstaller.CreateTables(); this.SetText(prefix + "Adding default hardware formats"); myInstaller.InsertInputFormats(); if (demo) { this.SetText(prefix + "Adding Demo Data"); myInstaller.InsertDefaultData(); } }
private void bnDataClear_Click(object sender, EventArgs e) { DialogResult d = MessageBox.Show("Are you sure you want to clear the Mitel Call Records file?\nWarning: you cannot undo this operation. You may want to back up your call record file before proceeding", "Clear Mitel Call Records File", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (d == DialogResult.Yes) { String connectionString = MiConfig.GetConnectionString("MiDatabaseString"); DataProvider provider = MiConfig.GetProvider(); DBInstaller installer = new DBInstaller(connectionString, provider); this.Cursor = Cursors.WaitCursor; installer.EmptyCallData(); this.Cursor = Cursors.Default; } }
private void bnDemoData_Click(object sender, EventArgs e) { DialogResult d = MessageBox.Show("Are you sure you want to clear the call records file and insert demo call records?", "Demo Call Records", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (d == DialogResult.Yes) { String connectionString = MiConfig.GetConnectionString("MiDemoString"); DataProvider provider = MiConfig.GetProvider(); DBInstaller installer = new DBInstaller(connectionString, provider); this.Cursor = Cursors.WaitCursor; installer.InsertDefaultData(); installer.InsertInputFormats(); this.Cursor = Cursors.Default; } }
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 }