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