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
}