/// <summary>
/// Fetches the program record in descending order and returns OracleDataAdapter
/// </summary>
/// <returns></returns>
public OracleDataAdapter GetPrograms()
{
OracleConnection conn = ConnectToDB.Connect();
conn.Open();
OracleDataAdapter data = new OracleDataAdapter("select * from ASE.program order by program_id desc", conn);
return(data);
}
/// <summary>
/// Returns Oracle Adapter
/// </summary>
/// <returns></returns>
public OracleDataAdapter GetBugs()
{
OracleDataAdapter data = null;
try
{
OracleConnection conn = ConnectToDB.Connect();
conn.Open();
data = new OracleDataAdapter("select b.bug_id, p.program_name, b.class_name, b.method_name from ASE.bug b, ASE.program p where p.program_id=b.program_id", conn);
conn.Close();
}
catch (Exception ex)
{
}
return(data);
}
/// <summary>
/// Fetches All record from bug table and returns the resultset table
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable GetBugs(int id)
{
OracleConnection conn = ConnectToDB.Connect();
conn.Open();
OracleCommand command = conn.CreateCommand();
command.CommandText = "select b.id, b.bug_id, u.fname, b.attemped_date, b.status from ASE.bug_history b, ASE.user_table u where u.user_id=b.user_id and bug_id=:id";
command.Parameters.Add(":id", id);
DataTable dr = new DataTable();
dr.Load(command.ExecuteReader());
conn.Close();
return(dr);
}
