public List <ViewCourseModel> GetAllCoursesWithSemesterAndStatus(int departmentId)
{
string query = "SELECT * FROM GetAllCoursesWithSemesterAndStatus WHERE Id = '" + departmentId + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <ViewCourseModel> courses = new List <ViewCourseModel>();
while (Reader.Read())
{
ViewCourseModel aCourse = new ViewCourseModel();
aCourse.DepartmentId = (int)Reader["Id"];
aCourse.CourseCode = Reader["CourseCode"].ToString();
aCourse.CourseName = Reader["CourseName"].ToString();
aCourse.Semester = Reader["Semester"].ToString();
aCourse.TeacherName = Reader["Name"].ToString();
aCourse.Status = Reader["Status"].ToString();
if (aCourse.Status == "")
{
aCourse.AssignedStatus = "Not Assigned Yet";
}
else
{
aCourse.AssignedStatus = aCourse.TeacherName;
}
courses.Add(aCourse);
}
Reader.Close();
Connection.Close();
return(courses);
}
public List <ViewCourseModel> GetAllAssignCourse()
{
SqlConnection connection = new SqlConnection(connectionstrings);
string query = "SELECT * FROM t_courses";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
List <ViewCourseModel> viewCourses = new List <ViewCourseModel>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ViewCourseModel course = new ViewCourseModel()
{
DepartmentId = (int)reader["DepartmentId"],
Code = reader["Code"].ToString(),
Name = reader["Name"].ToString(),
Semester = reader["Semester"].ToString(),
TeacherName = reader["TeacherName"].ToString()
};
viewCourses.Add(course);
}
reader.Close();
connection.Close();
return(viewCourses);
}
public IEnumerable <ViewCourseModel> GetCourseViewModels()
{
string query = "ProcedureViewCourseStatistics";
SqlCommand Command = new SqlCommand(query, Connection);
Command.CommandType = CommandType.StoredProcedure;
//Command.CommandText = query;
List <ViewCourseModel> courseViewModels = new List <ViewCourseModel>();
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
while (reader.Read())
{
ViewCourseModel course = new ViewCourseModel
{
DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()),
Name = reader["Name"].ToString(),
Code = reader["Code"].ToString(),
Semester = reader["Semester"].ToString(),
Teacher = reader["Teacher"].ToString()
};
courseViewModels.Add(course);
}
reader.Close();
Connection.Close();
return(courseViewModels);
}
public ActionResult View(Int32 id)
{
Provider provider = db.Providers.Find(userContext.ItemId);
if (provider == null)
{
return(HttpNotFound());
}
Course course = db.Courses.FirstOrDefault(x => x.CourseId == id);
if (course == null || course.ProviderId != userContext.ItemId)
{
return(HttpNotFound());
}
ViewCourseModel model = new ViewCourseModel(course);
return(View(model));
}
