public ActionResult Create([Bind(Include = "TeacherCourseAssignId,DepartmentId,TeacherId,CourseId")] TeacherCourseAssign teachercourseassign)
{
if (ModelState.IsValid)
{
//var creditTaken = db.Teachers.Where(t => t.TeacherId == teachercourseassign.TeacherId).Select(t => t.Credit).DefaultIfEmpty(0).Sum();
//var assignedCredit = db.TeacherCourseAssigns.Where(t => t.TeacherId == teachercourseassign.TeacherId).Include(c => c.Course).Where(c => c.CourseId == c.Course.CourseId).Select(c => c.Course.Credit).DefaultIfEmpty(0).Sum();
//var selectedCourse = db.Courses.FirstOrDefault(x => x.CourseId == teachercourseassign.CourseId);
//var selectedSubjectCreditt = selectedCourse.Credit;
//var remainingCredit = creditTaken - assignedCredit;
//if (selectedSubjectCreditt > remainingCredit)
//{
// UpdateTeacherCredit(creditTaken + (selectedSubjectCreditt - remainingCredit), teachercourseassign.TeacherId);
//}
UpdateCourseStatus(1, teachercourseassign.CourseId);
db.TeacherCourseAssigns.Add(teachercourseassign);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", teachercourseassign.CourseId);
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", teachercourseassign.DepartmentId);
ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "Name", teachercourseassign.TeacherId);
return(View(teachercourseassign));
}
public ActionResult DeleteConfirmed(int id)
{
TeacherCourseAssign teachercourseassign = db.TeacherCourseAssigns.Find(id);
db.TeacherCourseAssigns.Remove(teachercourseassign);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "TeacherCourseAssignId,DepartmentId,TeacherId,CourseId")] TeacherCourseAssign teachercourseassign)
{
if (ModelState.IsValid)
{
db.Entry(teachercourseassign).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", teachercourseassign.CourseId);
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", teachercourseassign.DepartmentId);
ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "Name", teachercourseassign.TeacherId);
return(View(teachercourseassign));
}
// GET: /TeacherCourseAssign/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TeacherCourseAssign teachercourseassign = db.TeacherCourseAssigns.Find(id);
if (teachercourseassign == null)
{
return(HttpNotFound());
}
return(View(teachercourseassign));
}
public bool AssignCourse(TeacherCourseAssign teacherCourseAssign)
{
using (_projectDbContext = new ProjectDbContext())
{
_projectDbContext.TeacherCourseAssigns.Add(teacherCourseAssign);
_projectDbContext.SaveChanges();
int id = teacherCourseAssign.Id;
if (id > 0)
{
return(true);
}
return(false);
}
}
// GET: /TeacherCourseAssign/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TeacherCourseAssign teachercourseassign = db.TeacherCourseAssigns.Find(id);
if (teachercourseassign == null)
{
return(HttpNotFound());
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", teachercourseassign.CourseId);
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", teachercourseassign.DepartmentId);
ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "Name", teachercourseassign.TeacherId);
return(View(teachercourseassign));
}
public ActionResult AssignCourse(TeacherCourseAssign teacherCourseAssign)
{
FillDepartmentDropdown();
if (ModelState.IsValid)
{
if (_courseManager.IsCourseAssigned(teacherCourseAssign.CourseId))
{
FlashMessage.Danger("Course already been assigned");
return(RedirectToAction("AssignCourse"));
}
if (_courseManager.AssignCourse(teacherCourseAssign))
{
FlashMessage.Confirmation("Course assigned successfully");
return(RedirectToAction("AssignCourse"));
}
}
FlashMessage.Danger("Some error occured; please check all the inputs ");
return(View(teacherCourseAssign));
}
public bool AssignCourse(TeacherCourseAssign teacherCourseAssign)
{
return(_courseGateway.AssignCourse(teacherCourseAssign));
}
