public DataWarehouse(string targetPlatform, OleDBConnection prodStagingDatabase, OleDBConnection prodDataVaultDatabase, OleDBConnection prodMartDatabase, OleDBConnection devStagingDatabase, OleDBConnection devDataVaultDatabase, OleDBConnection devMartDatabase)
{
_targetPlatform = targetPlatform;
ProdStagingDatabase = prodStagingDatabase;
ProdDataVaultDatabase = prodDataVaultDatabase;
ProdMartDatabase = prodMartDatabase;
DevStagingDatabase = devStagingDatabase;
DevDataVaultDatabase = devDataVaultDatabase;
DevMartDatabase = devMartDatabase;
}
// This function retrieves all data from tblPersonnel table
public static dsPersonnel GetPersonnel(string Database, string strSearch)
{
dsPersonnel DS;
OleDbConnection SqlConn;
OleDbAdapter sqlDA;
//Opens OleDbConnection
sqlConn = new OleDBConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + Database);
//Employee Search (procured from video, add in later?
if (strSearch == null || strSearch == "")
{
sqlDA = new OleDbDataAdapter("Select * from tblPersonnel", sqlConn);
}
else
{
sqlDA = new OleDbAdapter("Select '' from tblPersonnel where LastName = '" + strSearch + "'", sqlConn);
}
//Sets Value of DS
DS = new dsPersonnel();
//Fills Table with Data
sqlDA_Fill(DS.tblPersonnel);
//Return value
return(DS);
}
public static void RegisterOleDBConnection(SsisEmitterContext context, OleDBConnection oleDBConnection, IDTSComponentMetaData100 component)
{
oleDBConnection.Initialize(context);
component.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(oleDBConnection.ConnectionManager);
component.RuntimeConnectionCollection[0].ConnectionManagerID = oleDBConnection.ConnectionManager.ID;
}
public OleDBConnectionViewModel(Connection connection) : base(connection)
{
_oleDBConnection = (OleDBConnection)connection;
}
