public bool Set_NewConnectionItem(string Key, string Server, string UserID, string Password, string activeDB, enum_DatabaseType activeDBType) { if (!ActiveSqlConnectionCollection.ContainsKey(Key)) { class_Data_SqlConnectionItemEntry newEntry = new class_Data_SqlConnectionItemEntry(); newEntry.Server = Server; newEntry.UserID = UserID; newEntry.Password = Password; newEntry.ActiveDataBase = activeDB; newEntry.ConnectionString = newEntry.ConnectionString.Replace("{server}", Server); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{uid}", UserID); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{pwd}", Password); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{db}", activeDB); newEntry.ActiveConnectionType = activeDBType; if (activeDBType == enum_DatabaseType.SqlServer) { newEntry.ActiveConnection = new class_data_SqlServerConnectionItem(); newEntry.ActiveConnection.activeDatabaseType = activeDBType; ((class_data_SqlServerConnectionItem)newEntry.ActiveConnection).ActiveConnection = new SqlConnection(newEntry.ConnectionString); try { ((class_data_SqlServerConnectionItem)newEntry.ActiveConnection).ActiveConnection.Open(); ActiveSqlConnectionCollection.Add(Key, newEntry); return(true); } catch { return(false); } } else if (activeDBType == enum_DatabaseType.MySql) { newEntry.ActiveConnection = new class_data_MySqlConnectionItem(); newEntry.ActiveConnection.activeDatabaseType = activeDBType; ((class_data_MySqlConnectionItem)newEntry.ActiveConnection).ActiveConnection = new MySqlConnection(newEntry.ConnectionString); try { ((class_data_MySqlConnectionItem)newEntry.ActiveConnection).ActiveConnection.Open(); ActiveSqlConnectionCollection.Add(Key, newEntry); return(true); } catch { return(false); } } else { return(false); } } else { return(false); } }
public class_data_MySqlSPEntry(enum_DatabaseType activeDBType) : base(activeDBType) { this.ActiveDBType = activeDBType; }
public static class_data_MySqlSPEntry CreateInstance(string SPName, MySqlDbType SPType, string EntryType, enum_DatabaseType activeDBType) { class_data_MySqlSPEntry newEntry = new class_data_MySqlSPEntry(activeDBType); newEntry.SPName = SPName; newEntry.SPType = SPType; newEntry.EntryType = EntryType; return(newEntry); }
public class_Data_SqlSPEntry(enum_DatabaseType activeDBType) { this.ActiveDBType = activeDBType; }