IDataClient GetDataClient(string ClientType)
{
if (ClientType == "SQL")
{
if (sqlClient != null)
{
return(sqlClient);
}
sqlClient = new SqlAdapter();
return(sqlClient);
}
else if (ClientType == "ORACLE")
{
if (oraClient != null)
{
return(oraClient);
}
oraClient = new OracleAdapter();
return(oraClient);
}
else if (ClientType == "SQLite")
{
if (sqliteClient != null)
{
return(sqliteClient);
}
sqliteClient = new SQLiteAdapter();
return(sqliteClient);
}
else if (ClientType == "OleDb")
{
if (oleDbClient != null)
{
return(oleDbClient);
}
oleDbClient = new OleDbAdapter();
return(oleDbClient);
}
else if (ClientType == "Postgre")
{
if (postgreClient != null)
{
return(postgreClient);
}
postgreClient = new PostgreAdapter();
return(postgreClient);
}
return(null);
}
// 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);
}
