Database Connection

Database Connection

internal class PPMDac : DacBase

{
public PPMDac()
: base()

{

}
internal DataTable GetData(string commandQuery, params OracleParameter[] parameters)
{
try
{
using (OracleCommand oracleCommand = new OracleCommand(commandQuery))
{
oracleCommand.CommandType = CommandType.Text;
if (parameters != null)
{
foreach (OracleParameter oracleParameter in parameters)

{

oracleCommand.Parameters.Add(oracleParameter);

}

}
OracleDataAdapter dataAdapter = new OracleDataAdapter();



dataAdapter.SelectCommand = oracleCommand;
DataTable dataTable = new DataTable();
OpenConnection(oracleCommand);
dataAdapter.Fill(dataTable);
CloseConnection(oracleCommand);
return dataTable;
}

} catch (OracleException exception)
{
throw exception;
}

}
private void OpenConnection(OracleCommand command)
{
using (OracleConnection connection = new OracleConnection())
{
connection.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverName)(PORT=0000)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)));User Id=userId;Password=psw";
command.Connection = connection;

connection.Open();

}

}
private void CloseConnection(OracleCommand command)



{

command.Connection.Close();

command.Connection.Dispose();

command.Dispose();

}
public DataTable GetOpenProject()



{
return GetData(StringResource.ProjectSelect);



}

}