public ActionResult UnassignCourses(AssignTeacher assignTeacher)
{
var unAssigns = coueseTeacherDAL.AssingTeacherGetAll();
foreach (var item in unAssigns)
{
item.IsUnassign = true;
}
coueseTeacherDAL.Complete();
ViewBag.SMessage = "Unassign Courses Successfully!";
return(View());
}
public JsonResult GetCourseInfo(int departmentId)
{
//List<Blog> blogs = new List<Blog>();
var result = from e in courseTeacherDAL.CourseGetAll()
join d in courseTeacherDAL.AssingTeacherGetAll()
on e.CourseId equals d.CourseId into eGroup
from d in eGroup.DefaultIfEmpty()
select new
{
DepartmentId = e.DepartmentId,
DepartmentName = e.Department.DepartmentName,
CourseCode = e.CourseCode,
CourseName = e.CourseName,
Semester = e.Semester,
AssignTo = d == null ? "Not Assigned Yet" : d.Teacher.TeacherName
};
var dataList = result.Where(c => c.DepartmentId == departmentId).ToList();
var jsonData = dataList.Select(c => new { c.CourseCode, c.CourseName, c.Semester, c.AssignTo });
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTeacherInfoByTeacherId(int teacherTd)
{
//var dataList = courseTeacherDAL.TeacherGetAll().Where(c => c.TeacherId == teacherTd).ToList();
CoueseTeacherDAL courseTeacherDAL = new CoueseTeacherDAL();
var teacherGetAll = courseTeacherDAL.TeacherGetAll();
var AssignCourseCreditresult = courseTeacherDAL.AssingTeacherGetAll();
var gropbySum = AssignCourseCreditresult
.GroupBy(s => new { s.TeacherId })
.Select(g => new
{
TeacherId = g.Key.TeacherId,
AssignCourseCredit = g.Sum(x => x.AssignCourseCredit)
});
var result = from e in teacherGetAll
join d in gropbySum
on e.TeacherId equals d.TeacherId into eGroup
from d in eGroup.DefaultIfEmpty()
select new
{
TeacherId = e.TeacherId,
TeacherName = e.TeacherName,
CreditTeken = e.CreditTaken,
AssignCreditTeken = d == null ? 0 : d.AssignCourseCredit,
};
var newResult = result.Select(n => new
{
TeacherId = n.TeacherId,
TeacherName = n.TeacherName,
CreditTeken = n.CreditTeken,
AssignCredit = n.AssignCreditTeken,
RemainingCredit = n.CreditTeken - n.AssignCreditTeken,
});
var finalResult = newResult.Where(c => c.TeacherId == teacherTd).ToList();
var jsonData = finalResult.Select(c => new { c.CreditTeken, c.RemainingCredit });
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
