public List <ViewCourseStatics> GetAll(int id)
{
string query = "Select * from ViewCourseStatics where Id=" + id + "";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <ViewCourseStatics> listOfTeachers = new List <ViewCourseStatics>();
while (reader.Read())
{
ViewCourseStatics viewCourseStatics = new ViewCourseStatics();
viewCourseStatics.Id = (int)reader["Id"];
viewCourseStatics.CourseCode = reader["CourseCode"].ToString();
viewCourseStatics.CourseName = reader["CourseName"].ToString();
viewCourseStatics.Semester = reader["Semester"].ToString();
viewCourseStatics.AssignTo = reader["AssignTo"].ToString();
listOfTeachers.Add(viewCourseStatics);
}
reader.Close();
connection.Close();
return(listOfTeachers);
}
public dynamic GetViewCourseStaticsList(int viewCourseStatics)
{
Query = "SELECT CourseCode, CourseName, C.DepartmentId, Semester, case WHEN CA.Status = 'Assign' " +
"THEN TeacherName ELSE 'Not Assigned Yet' END AS AssignedTo FROM Course C " +
"LEFT OUTER JOIN CourseAssign CA ON C.Id = CA.CourseId LEFT OUTER JOIN Teacher T ON CA.TeacherId = T.Id ";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <ViewCourseStatics> aCourseStaticses = new List <ViewCourseStatics>();
while (Reader.Read())
{
ViewCourseStatics aCourseStatics = new ViewCourseStatics();
aCourseStatics.Code = Reader["CourseCode"].ToString();
aCourseStatics.Name = Reader["CourseName"].ToString();
aCourseStatics.Semester = Reader["Semester"].ToString();
aCourseStatics.AssignedTo = Reader["AssignedTo"].ToString();
aCourseStatics.DepartmentId = (int)Reader["DepartmentId"];
aCourseStaticses.Add(aCourseStatics);
}
Connection.Close();
return(aCourseStaticses);
}
