/// <summary>
/// get teacher credit from teacher table
/// </summary>
/// <param name="teacherId"></param>
/// <returns></returns>
public JsonResult GetCreditByTeacherId(int teacherId)
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
int creditToBeTaken = aCourseAssignManager.GetCreditByTeacherId(teacherId);
return(Json(creditToBeTaken, JsonRequestBehavior.AllowGet));
}
public CourseAssignController()
{
courseAssignManager = new CourseAssignManager();
teacherManager = new TeacherManager();
departmentManager = new DepartmentManager();
courseManager = new CourseManager();
}
public ActionResult AssignTeacher(CourseAssignToTeacherModel courseAssignToTeacherModel)
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
ViewBag.Departments = aCourseAssignManager.GetAllDepartments();
ViewBag.Teachers = aCourseAssignManager.GetAllTeachers();
ViewBag.CourseCodeList = aCourseAssignManager.GetAllCourseCodes();
//do the code to store in the database
if (aCourseAssignManager.IsCourseExist(courseAssignToTeacherModel.CourseId))
{
ViewBag.Message = ("Course is already assigned");
}
else
{
int stored = aCourseAssignManager.SaveCourseAssignToTeacher(courseAssignToTeacherModel);
if (stored == 1)
{
ViewBag.Message = ("Course Assign to Teacher done successfully");
}
else
{
ViewBag.Message = ("Course Assign to Teacher Error");
}
}
return(View());
/*
* 1. one course should be assigned to one teacher only-done
* 2. if teacher credit exceed, an dialog box with yes/no pop up and work accordingly
* 3. remaining credit returning false count--done
*/
}
public JsonResult GetCourseListByDeptId(int deptId)
{
List <CourseModel> courseList = new List <CourseModel>();
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
courseList = aCourseAssignManager.GetCourseListByDeptId(deptId);
return(Json(courseList, JsonRequestBehavior.AllowGet));
}
public TeacherController()
{
departmentManager = new DepartmentManager();
designationManager = new DesignationManager();
teacherManager = new TeacherManager();
courseManager = new CourseManager();
courseAssignManager = new CourseAssignManager();
}
public JsonResult GetCourseModelByCourseId(int courseId)
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
CourseModel aCourseModel = new CourseModel();
aCourseModel = aCourseAssignManager.GetCourseModelByCourseId(courseId);
return(Json(aCourseModel, JsonRequestBehavior.AllowGet));
}
public ActionResult AssignTeacher()
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
ViewBag.Departments = aCourseAssignManager.GetAllDepartments();
ViewBag.Teachers = aCourseAssignManager.GetAllTeachers();
ViewBag.CourseCodeList = aCourseAssignManager.GetAllCourseCodes();
return(View());
}
public CourseAssignController()
{
CourseAssignManager = new CourseAssignManager();
DepartmentManager = new DepartmentManager();
TeacherManager = new TeacherManager();
CourseManager = new CourseManager();
//Courses = new List<Course>();
//Teachers = new List<Teacher>();
}
/// <summary>
/// to get teacher list from Dept id
/// </summary>
/// <param name="deptId"></param>
/// <returns></returns>
public JsonResult GetTeacherByDeptId(int deptId)
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
List <TeacherModel> teachers = new List <TeacherModel>();
teachers = aCourseAssignManager.GetTeachersByDeptId(deptId);
//var teachers = db.Teachers.Where(m => m.DepartmentId == deptId).ToList();
//return Json(teachers, JsonRequestBehavior.AllowGet);
return(Json(teachers, JsonRequestBehavior.AllowGet));
}
/*[HttpGet]
* public ActionResult DeleteAssignedTeacher()
* {
* return View();
* }*/
//[HttpPost]
public ActionResult DeleteAssignedTeacher(int id)
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
int rowsEffected = aCourseAssignManager.DeleteAssignedCourseByCourseAssignId(id);//aCourseManager.DeleteCourse(courseId);
if (rowsEffected > 0)
{
return(RedirectToAction("ViewAllAssignedTeachers"));
}
else
{
return(null);
}
}
/// <summary>
/// check if teacherAssignedCredit is more than the credit is being taken
/// </summary>
/// <param name="teacherID"></param>
/// <param name="currentCreditTaking"></param>
/// <returns></returns>
public JsonResult CheckTakenCreditOverFlowsRemainingCredit(int teacherID, int currentCreditTaking)
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
int creditToBeTaken = aCourseAssignManager.GetCreditByTeacherId(teacherID);
int totalAssignedCredit = aCourseAssignManager.GetAssignedCreditByTeacherId(teacherID);
totalAssignedCredit = totalAssignedCredit + currentCreditTaking;
if (totalAssignedCredit > creditToBeTaken)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ViewAllAssignedTeachers(int?messageFromEdit)
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
List <CourseAssignToTeacherModel> CourseAssignToTeachers = new List <CourseAssignToTeacherModel>();
CourseAssignToTeachers = aCourseAssignManager.GetAllCourseAssignedTeachers();
//return View(CourseAssignToTeachers);
if (CourseAssignToTeachers.Count == 0)
{
string message = "No data in the database for AssignedTeacher";
ViewBag.MessageViewCourses = message;
}
else if (messageFromEdit > 0)
{
ViewBag.MessageViewCourses = "AssignedTeacher Updated Successfully";
}
ViewBag.CourseAssignToTeacherModelList = CourseAssignToTeachers;
return(View());
}
public JsonResult GetTeacherInfo(int teacherId)
{
List <CourseAssign> coursesIdList = CourseAssignManager.GetCoursesByTeacherId(teacherId);
decimal credit = 0;
foreach (CourseAssign course in coursesIdList)
{
credit += CourseManager.GetCourseById(course.CourseId).Credit;
}
decimal takenCredit = TeacherManager.GetTeacherById(teacherId).Credit;
decimal remainingCredit = takenCredit - credit;
var teacher = new Teacher();
teacher.Credit = takenCredit;
teacher.RemainingCredit = remainingCredit;
return(Json(teacher));
}
public ActionResult CourseAssign(CourseAssign courseAssign)
{
if (ModelState.IsValid)
{
ViewBag.Departments = GetAllDepartmentList();
ViewBag.Designation = GetAllDesignationList();
string result = new CourseAssignManager().InsertNewCourse(courseAssign);
ViewData["Message"] = result;
ModelState.Clear();
return(View());
}
else
{
ViewData["Message"] = "";
ViewBag.Departments = GetAllDepartmentList();
ViewBag.Courses = GetAllCourseList();
return(View());
}
}
/// <summary>
/// checks how much credits are remaining
/// </summary>
/// <param name="teacherId"></param>
/// <returns>total remaining credit </returns>
public JsonResult GetRemainingCreditByTeacherId(int teacherId)
{
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
int creditToBeTaken = aCourseAssignManager.GetCreditByTeacherId(teacherId);
int remainingCredit;
int totalAssignedCredit = aCourseAssignManager.GetAssignedCreditByTeacherId(teacherId);
if (totalAssignedCredit == 0)
{
remainingCredit = creditToBeTaken;
}
else if (totalAssignedCredit < creditToBeTaken)
{
remainingCredit = creditToBeTaken - totalAssignedCredit;
}
else
{
remainingCredit = creditToBeTaken - totalAssignedCredit;
}
return(Json(remainingCredit, JsonRequestBehavior.AllowGet));
}
public ActionResult Save(CourseAssign courseAssign)
{
ViewBag.DepartmentList = GetAllDepartmentForDropdown();
if (ModelState.IsValid)
{
string message = CourseAssignManager.Save(courseAssign);
ViewBag.Message = message;
if (message == "Course Is Successfully Assigned")
{
ModelState.Clear();
return(View());
}
else
{
return(View(courseAssign));
}
}
else
{
ViewBag.Message = "Please Fill All Field With Correct Format";
return(View(courseAssign));
}
}
public ActionResult EditAssignedTeacher(int id, int?message)
{
if (message != null)
{
if (message == 0)
{
ViewBag.Message = "Sorry! Course Assign Update Failed !!";
}
else if (message == 5)
{
ViewBag.Message = "Sorry! Course Code Exists !!";
}
else if (message == 6)
{
ViewBag.Message = "Sorry! Course Name Exists !!";
}
}
CourseAssignManager aCourseAssignManager = new CourseAssignManager();
ViewBag.Departments = aCourseAssignManager.GetAllDepartments();
ViewBag.Teachers = aCourseAssignManager.GetAllTeachers();
ViewBag.CourseCodeList = aCourseAssignManager.GetAllCourseCodes();
CourseAssignToTeacherModel aCourseAssignToTeacherModel = new CourseAssignToTeacherModel();
aCourseAssignToTeacherModel = aCourseAssignManager.GetAssignedCourseToTeacherModelById(id);
/*ViewBag.Departments = aCourseAssignManager.GetAllDepartments();
* ViewBag.Teachers = aCourseAssignManager.GetAllTeachers();
* ViewBag.CourseCodeList = aCourseAssignManager.GetAllCourseCodes();*/
return(View(aCourseAssignToTeacherModel));
}
private CourseAssignManager courseAssignManager; //---this line ---------for warid
public CourseController()
{
courseManager = new CourseManager();
departmentManager = new DepartmentManager();
courseAssignManager = new CourseAssignManager(); //----this line--------for warid
}
public ActionResult UnassignCourse(string unAssignCourse)
{
ViewData["Message"] = new CourseAssignManager().UnAssignCourses();
return(View());
}
public UnassignCourseController()
{
CourseAssignManager = new CourseAssignManager();
}
