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