//public static string _dbtyp = ConfigurationManager.AppSettings["DatabaseType"].ToString(); public static DBFacType DBSettings() { DBFacType db = new DBFacType(); string dbname = string.Empty; string password = string.Empty; string userid = string.Empty; string server = string.Empty; string port = string.Empty; string maxpoolsize = string.Empty; string conntimeout = string.Empty; string cmdtimeout = string.Empty; string fName = string.Empty; fName = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "settings.INI"); CreateINIFile(fName); db.DBProvider = GetIni(fName, "ProviderName", DBFactory.CDatabaseProvider.PostgreSQL); db.DBType = GetIni(fName, "DatabaseType", DBFactory.CDatabaseType.PostgreSQL); dbname = GetIni(fName, "DatabaseName", String.Empty); password = GetIni(fName, "Password", String.Empty); userid = GetIni(fName, "UserId", String.Empty); server = GetIni(fName, "Server", String.Empty); port = GetIni(fName, "Port", String.Empty); maxpoolsize = GetIni(fName, "MaxPoolSize", "100"); conntimeout = GetIni(fName, "ConnectionTimeout", "60"); db.ConnStr = string.Format(db.DBType.ToUpper() == DBFactory.CDatabaseType.Oracle ? DBFactory.CConnectString.Oracle : db.DBType.ToUpper() == DBFactory.CDatabaseType.MySQL ? DBFactory.CConnectString.MySQL : db.DBType.ToUpper() == DBFactory.CDatabaseType.PostgreSQL ? DBFactory.CConnectString.PostgreSQL : DBFactory.CConnectString.SQLServer, server, port, dbname, userid, password, maxpoolsize, conntimeout, cmdtimeout); return(db); }
public static DBFacType GetDBSettingsMVC(IOptions <DatabaseSettings> appSettings) { DBFacType db = new DBFacType(); string dbname = string.Empty; string password = string.Empty; string userid = string.Empty; string server = string.Empty; string port = string.Empty; string maxpoolsize = string.Empty; string conntimeout = string.Empty; string cmdtimeout = string.Empty; string fName = string.Empty; /* * db.DBProvider = appSettings.Value.ProviderName; //Config.GetSection("DatabaseSettings").GetSection("ProviderName").Value; // ConfigurationManager.AppSettings[0].ToString();//"ProviderName" * db.DBType = appSettings.Value.DatabaseType; * dbname = appSettings.Value.DatabaseName; * // dbname = ConfigurationManager.AppSettings["DatabaseName"].ToString(); * password = appSettings.Value.Password; * //password = ConfigurationManager.AppSettings["Password"].ToString(); * // userid = ConfigurationManager.AppSettings["UserId"].ToString(); * userid = appSettings.Value.UserId; * * //server = ConfigurationManager.AppSettings["Server"].ToString(); * server = appSettings.Value.Server; * //port = ConfigurationManager.AppSettings["Port"].ToString(); * port = appSettings.Value.Port.ToString(); * * //maxpoolsize = ConfigurationManager.AppSettings["MaxPoolSize"].ToString(); * maxpoolsize = appSettings.Value.MaxPoolSize.ToString(); * //conntimeout = ConfigurationManager.AppSettings["ConnectionTimeout"].ToString(); * conntimeout = appSettings.Value.ConnectionTimeout.ToString(); * cmdtimeout = appSettings.Value.CommandTimeout.ToString(); * //cmdtimeout = ConfigurationManager.AppSettings["CommandTimeout"].ToString(); */ fName = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "settings.INI"); CreateINIFile(fName); db.DBProvider = GetIni(fName, "ProviderName", DBFactory.CDatabaseProvider.PostgreSQL); db.DBType = GetIni(fName, "DatabaseType", DBFactory.CDatabaseType.PostgreSQL); dbname = GetIni(fName, "DatabaseName", String.Empty); password = GetIni(fName, "Password", String.Empty); userid = GetIni(fName, "UserId", String.Empty); server = GetIni(fName, "Server", String.Empty); port = GetIni(fName, "Port", String.Empty); maxpoolsize = GetIni(fName, "MaxPoolSize", "100"); conntimeout = GetIni(fName, "ConnectionTimeout", "60"); db.ConnStr = string.Format(db.DBType.ToUpper() == DBFactory.CDatabaseType.Oracle ? DBFactory.CConnectString.Oracle : db.DBType.ToUpper() == DBFactory.CDatabaseType.MySQL ? DBFactory.CConnectString.MySQL : db.DBType.ToUpper() == DBFactory.CDatabaseType.PostgreSQL ? DBFactory.CConnectString.PostgreSQL : DBFactory.CConnectString.SQLServer, server, port, dbname, userid, password, maxpoolsize, conntimeout, cmdtimeout); return(db); }