public string[] GetCourses() { SqlDataReader coursesDataReader = null; SqlConnection connection = null; string[] coursesData = null; string coursesSql = ""; try { dbConnection = new DataBaseManager(); connection = dbConnection.GetDBConnection(); if (connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } coursesSql = "SELECT courseID, courseName FROM courses"; SqlCommand coursesResult = new SqlCommand(coursesSql, connection); coursesDataReader = coursesResult.ExecuteReader(); if (coursesDataReader == null) { connection.Close(); return(null); } if (coursesDataReader.HasRows) { int index = 0; while (coursesDataReader.Read()) { coursesData[index] = Convert.ToString(coursesDataReader.Read()); index++; } } } finally { if (connection.State == System.Data.ConnectionState.Open) { connection.Close(); } } return(coursesData); }
/// <summary> /// Rgisters the Student into the system /// </summary> /// <param name="firstName"> The first name of the student</param> /// <param name="lastName"> The last name of the student</param> /// <param name="userName"> The user name of the student</param> /// <param name="studentNumber"> The automatically generated student number</param> /// <param name="password"> The studen't password(encrypted)</param> /// <param name="course"> The course to be offered by the student</param> private bool registerStudet(Student student) { SqlConnection connection = null; dbConnection = new DataBaseManager(); bool registered = false; try { connection = dbConnection.GetDBConnection(); if (connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } string studentsSql = "INSERT INTO students(studentID,firstName,lastName,password,courseID) " + "VALUES('" + student.StudentNumber + "','" + student.FirstName + "','" + student.LastName + "','" + student.Password + "','" + student.CourseCode + "')"; //debug.Text = studentsSql; SqlCommand studentCommand = new SqlCommand(studentsSql, connection); if (studentCommand.ExecuteNonQuery() > 0) { registered = true; } else { registered = false; } } catch (Exception e) { registered = false; } finally { if (connection.State == System.Data.ConnectionState.Open) { connection.Close(); } } return(registered); }