public static IDataStorage Get() { switch (Properties.Settings.Default.databaseType) { case "MySql": return(new MySQLStorage(DBUtils.GetMySqlServerConnectionString("qdmsdata"))); case "SqlServer": return(new SqlServerStorage(DBUtils.GetSqlServerConnectionString("qdmsdata", useWindowsAuthentication: Properties.Settings.Default.sqlServerUseWindowsAuthentication))); default: return(new MySQLStorage(DBUtils.GetMySqlServerConnectionString("qdmsdata"))); } }
private static NameValueCollection GetQuartzSettingsSqlServer() { NameValueCollection properties = new NameValueCollection(); properties["quartz.scheduler.instanceName"] = "QdmsScheduler"; properties["quartz.scheduler.instanceId"] = "instance_one"; properties["quartz.jobStore.type"] = "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz"; properties["quartz.jobStore.driverDelegateType"] = "Quartz.Impl.AdoJobStore.SqlServerDelegate, Quartz"; properties["quartz.jobStore.useProperties"] = "true"; properties["quartz.jobStore.dataSource"] = "default"; properties["quartz.jobStore.tablePrefix"] = "QRTZ_"; //properties["quartz.jobStore.lockHandler.type"] = "Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz"; properties["quartz.dataSource.default.connectionString"] = DBUtils.GetSqlServerConnectionString( "qdmsQuartz", Settings.Default.sqlServerHost, Settings.Default.sqlServerUsername, EncryptionUtils.Unprotect(Settings.Default.sqlServerPassword), useWindowsAuthentication: Settings.Default.sqlServerUseWindowsAuthentication); properties["quartz.dataSource.default.provider"] = "SqlServer-20"; return(properties); }