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