Exemplo n.º 1
0
        public void getFacultySchedule(string getp)
        {
            db = new DatabaseLayer.DBConnection();
            string query = "SELECT CourseName FROM OfferedCourses_Spring_17 WHERE CourseTeacher='" + getp + "';";

            db.GetQuery(query);
            if (db.dr.HasRows)
            {
                while (db.dr.Read())
                {
                    if (db.dr[0].ToString() != null)
                    {
                        try
                        {
                            string sl = db.dr.GetString(0);
                            courseList.Add(new Courses(sl));
                        }
                        catch (Exception ex)
                        {
                            continue;
                        }
                    }
                }
                db.dr.Dispose();
            }

            //}
            db.con.Dispose();
            this.GetCourseList("Spring_17");
        }
Exemplo n.º 2
0
 public void GetCourseList(string s)
 {
     db = new DatabaseLayer.DBConnection();
     for (int i = 0; i < courseList.Count; i++)
     {
         string query = "SELECT * FROM OfferedCourses_" + s + " WHERE CourseName='" + courseList[i].courseName + "';";
         db.GetQuery(query);
         if (db.dr.HasRows)
         {
             while (db.dr.Read())
             {
                 courseList[i].SetValue(db.dr.GetString(0), db.dr.GetString(2),
                                        db.dr.GetString(3), db.dr.GetString(5), db.dr.GetString(5), db.dr.GetString(6));
             }
             db.dr.Dispose();
         }
     }
     db.con.Dispose();
 }