public static DataTable GetWorkDays()
{
string query = "SELECT * FROM CREW_WORK_DAYS ";
DataTable dataTable = new DataTable();
using (OracleConnection connection = GetOracleConnetion.GetLiveConnection())
{
OracleCommand command = new OracleCommand(query, connection);
OracleDataAdapter dataAdapter = new OracleDataAdapter();
dataAdapter.SelectCommand = command;
connection.Open();
dataAdapter.Fill(dataTable);
connection.Close();
}
return(dataTable);
}
public static DataTable GetPersNr()
{
string query = "SELECT * FROM CREW_ENDING_CONTRACT_FULL";
DataTable dataTable = new DataTable();
using (OracleConnection connection = GetOracleConnetion.GetLiveConnection())
{
OracleCommand command = new OracleCommand(query, connection);
OracleDataAdapter dataAdapter = new OracleDataAdapter();
dataAdapter.SelectCommand = command;
connection.Open();
dataAdapter.Fill(dataTable);
connection.Close();
}
return(dataTable);
}