private void view_id_Click(object sender, EventArgs e)
{
int enroll = 0;
if (ShowMenuPanel.Visible == false)
{
try
{
classRoom = new DataBaseModel();
int id;
id = Convert.ToInt32(Prompt.ShowDialog("Enter Course ID you Want to Show", "Search by ID"));
List <StdCourse> courses = new List <StdCourse>();
StdCourse course = classRoom.selectOneCourses(id);
courses.Add(course);
OpenView(new StdViewCourses(courses, LoggedInUser, enroll));
menu_trans.ShowSync(ShowMenuPanel);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
menu_trans.HideSync(ShowMenuPanel);
}
}
public List <StdCourse> selectStudentCourses(int stdID)
{
List <StdCourse> CourseList = new List <StdCourse>();
//try
{
conn = new OracleConnection(connectionPath);
conn.Open();
StdCourse course;
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECTSTUDENTCOURSES";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("id", OracleDbType.Int32).Value = stdID;
cmd.Parameters.Add("Cou", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader objReader = cmd.ExecuteReader();
while (objReader.Read())
{
int CouID = (int)objReader["COURSE_ID"];
string CouName = (string)objReader["C_NAME"];
string subject = (string)objReader["SUBJECT"];
int InsID = (int)objReader["USER_ID"];
string inst_name = objReader["USER_NAME"].ToString();
course = new StdCourse(CouID, CouName, subject, inst_name, InsID);
CourseList.Add(course);
}
conn.Close();
}
//catch (Exception)
{
//MessageBox.Show("errore in database when select all courses");
}
return(CourseList);
}
public List <StdCourse> selectAllCourses()
{
try
{
List <StdCourse> CourseList = new List <StdCourse>();
string callstr = "Select * FROM COURSE";
adapter = new OracleDataAdapter(callstr, connectionPath);
ds = new DataSet();
adapter.Fill(ds);
DataTable table = ds.Tables[0];
int x = table.Rows.Count;
int y = table.Rows.Count - 1;
DataRow row;
StdCourse course;
while (x > 0)
{
row = (DataRow)table.Rows[y];
int CouID = (int)row["COURSE_ID"];
string CouName = (string)row["C_NAME"];
string subject = (string)row["SUBJECT"];
int InsID = (int)row["USER_ID"];
string inst_name = (string)row["USER_NAME"];
course = new StdCourse(CouID, CouName, subject, inst_name, InsID);
CourseList.Add(course);
x--;
y--;
}
return(CourseList);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
}
public StdCourse selectOneCourses(int id)
{
StdCourse Stdcourse = new StdCourse();
try
{
conn = new OracleConnection(connectionPath);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECTONECOURSE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("cours_id", OracleDbType.Int32).Value = id;
cmd.Parameters.Add("cid", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader objReader = cmd.ExecuteReader();
while (objReader.Read())
{
int CouID = (int)objReader["COURSE_ID"];
string CouName = (string)objReader["C_NAME"];
string subject = (string)objReader["SUBJECT"];
int InsID = (int)objReader["USER_ID"];
string inst_name = (string)objReader["USER_NAME"];
Stdcourse.courseID = CouID;
Stdcourse.courseName = CouName;
Stdcourse.courseSub = subject;
Stdcourse.instID = InsID;
Stdcourse.instName = inst_name;
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("errore in database when select all courses");
}
return(Stdcourse);
}