public static List <classesById> getClassesById(int studentID) { using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("pSelClassesByStudentID", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@StudentId", studentID); try { List <classesById> classes = new List <classesById>(); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { classesById row = new classesById(); row.studentName = reader["StudentName"].ToString(); row.studentEmail = reader["StudentEmail"].ToString(); row.classId = (int)reader["ClassId"]; row.className = reader["ClassName"].ToString(); row.classDate = (DateTime)reader["ClassDate"]; row.classDescription = reader["ClassDescription"].ToString(); classes.Add(row); } return(classes); } catch (SqlException e) { string error = "An exception occurred:" + e.Message; return(null); } } }
public static List <classesById> getClassData() { using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Select * from vClasses", conn); try { List <classesById> classes = new List <classesById>(); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { classesById row = new classesById(); row.classId = (int)reader["ClassId"]; row.className = reader["ClassName"].ToString(); row.classDate = (DateTime)reader["ClassDate"]; row.classDescription = reader["ClassDescription"].ToString(); classes.Add(row); } return(classes); } catch (SqlException e) { string error = "An exception occurred:" + e.Message; return(null); } } }