public List <TeacherCourses> GetTeacherCourses(int userID)
{
List <TeacherCourses> courses = new List <TeacherCourses>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("UserTeacherDashboard", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", userID);
cn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var course = new TeacherCourses();
course.CourseID = (int)dr["CourseID"];
course.CourseName = dr["CourseName"].ToString();
course.IsArchived = (bool)dr["IsArchived"];
courses.Add(course);
}
}
}
return(courses);
}
public bool Exists(TeacherCourses course, int?id = null)
{
var result = _context.TeacherCourses.Where(x => x.UserId == course.UserId &&
x.CourseId == course.CourseId && x.CourseTypeId == course.CourseTypeId);
if (id.HasValue)
{
result = result.Where(x => x.Id != id.Value);
}
return(result.Any());
}
public static TeacherModel GetTeacherDashboardInfo(int userId)
{
TeacherRepo teacherRepo = new TeacherRepo();
TeacherModel teacherModel = new TeacherModel();
teacherModel.CourseList = new List <TeacherCourses>();
//TeacherCourses teacherCourses = new TeacherCourses();
teacherModel.CurrentCourses = teacherRepo.GetClassesByTeacherId(userId).Count(x => x.IsArchived = true);
teacherModel.ArchivedCourses = teacherRepo.GetClassesByTeacherId(userId).Count(x => x.IsArchived = false);
teacherModel.UserId = userId;
foreach (var x in teacherRepo.GetClassesByTeacherId(userId))
{
TeacherCourses tempTC = new TeacherCourses();
tempTC.CourseName = x.CourseName;
tempTC.NumOfStudentsInCourse = teacherRepo.GetCurrentStudentCountInCourse(x.CourseId);
tempTC.CourseId = x.CourseId;
teacherModel.CourseList.Add(tempTC);
}
return(teacherModel);
}
public IEnumerable <TeacherCourses> FindTeacher(int id)
{
MySqlConnection Conn = School.AccessDatabase();
Conn.Open();
MySqlCommand cmd = Conn.CreateCommand();
//SQL query to select a row from the table with specified id.
cmd.CommandText = "SELECT teacherfname, teacherlname, classcode, classname " +
"FROM `classes` INNER JOIN `teachers` ON classes.teacherid = teachers.teacherid " +
"WHERE teachers.teacherid =" + id;
//"Select * from teachers where teacherid = " + id;
MySqlDataReader ResultSet = cmd.ExecuteReader();
List <TeacherCourses> Courses = new List <TeacherCourses> {
};
while (ResultSet.Read())
{
string teacherfname = ResultSet["teacherfname"].ToString();
string teacherlname = ResultSet["teacherlname"].ToString();
string classcode = ResultSet["classcode"].ToString();
string classname = ResultSet["classname"].ToString();
TeacherCourses TCourses = new TeacherCourses();
TCourses.teacherfname = teacherfname;
TCourses.teacherlname = teacherlname;
TCourses.classcode = classcode;
TCourses.classname = classname;
Courses.Add(TCourses);
}
Conn.Close();
return(Courses);
}
public void Update(TeacherCourses course)
{
_context.Update(course);
_context.SaveChanges();
}
public void Add(TeacherCourses course)
{
_context.Add(course);
_context.SaveChanges();
}
