/// <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); }