public DataLayer(ConnectionTypeConstants contype)
{
Debug.Print("DataLayer Initializing...");
WebPermission wp = new WebPermission();
wp.Demand();
switch (Configuration.DatabaseType.ToUpper().Trim())
{
case "":
case "MYSQL":
qAdapter = new MySQLQueryAdapter();
break;
case "SQL":
case "SQL SERVER":
qAdapter = new SQLServerQueryAdapter();
break;
}
Debug.Assert(qAdapter != null);
// if (Configuration.PurgeLogOnStartup)
// {
String dbgfile = getDebugOutputFilepath();
if (File.Exists(dbgfile))
File.Delete(dbgfile);
//}
WriteDebugMessage("--DataLayer Initializing-" + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + "--");
DatabaseName = Configuration.DatabaseName;
try
{
CurrentConString = buildConnectionString(contype);
}
catch (frmPasswordPrompt.CredentialsNotGivenException exx)
{
throw;
}
Debug.Print("Using ConnectionString:" + CurrentConString);
//initialize our Type Manager.
String[] lookfolders = new String[] { JobClockConfig.GetExportLibFolder()};
mtypemanager = new MultiTypeManager(lookfolders,
new Type[] { typeof(BaseDataExporter) }, null,
new Nullcallback(), null,
new Assembly[] { Assembly.GetCallingAssembly() });
}
public String buildConnectionString(ConnectionTypeConstants contype)
{
String sbuild="";
String usecredentials="";
switch (contype)
{
case ConnectionTypeConstants.Connection_Admin:
sbuild= Configuration.AdminConnectionString;
usecredentials = Configuration.AdminCredentials;
break;
case ConnectionTypeConstants.Connection_Client:
sbuild=Configuration.ClientConnectionString;
usecredentials = Configuration.ClientCredentials;
break;
case ConnectionTypeConstants.Connection_Monitor:
sbuild = Configuration.MonitorConnectionString;
usecredentials = Configuration.MonitorCredentials;
break;
}
if (usecredentials.ToUpper() == "!PROMPT!")
{
String prompteduser, promptedpassword;
frmPasswordPrompt.DoShowPrompt(out prompteduser, out promptedpassword);
usecredentials = prompteduser + "," + promptedpassword;
}
if (!(usecredentials.ToUpper() == "NONE"))
{
//don't do this if the credentials are "NONE".
String[] ss = usecredentials.Split(',');
if (ss.Length >= 2)
sbuild += String.Format("; User ID={0};Password={1}", ss[0].Trim(), ss[1].Trim());
else
sbuild += String.Format("; User ID={0}", ss[0].Trim());
}
WriteDebugMessage("BuildConnectionString returning \"" + sbuild + "\"");
return sbuild;
}
