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 GetQuartzSettingsMySql()
{
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.MySQLDelegate, Quartz";
properties["quartz.jobStore.useProperties"] = "true";
properties["quartz.jobStore.dataSource"] = "default";
properties["quartz.jobStore.tablePrefix"] = "QRTZ_";
properties["quartz.dataSource.default.connectionString"] = DBUtils.GetMySqlServerConnectionString("qdmsQuartz");
properties["quartz.dataSource.default.provider"] = "MySql-65";
return(properties);
}
