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