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