public async Task <IActionResult> UpdateAssignedSubject(TEnrolledSubjectVm td)
{
//for the class
var Subject = _context.Subject.AsNoTracking().ToList();
ViewBag.Subject = new SelectList(Subject, "SubjectId", "SubjectTitle");
//for the class
var Class = _context.Class.AsNoTracking().ToList();
ViewBag.Class = new SelectList(Class, "ClassId", "ClassName");
//for thr teacher
var Teacher = _context.Teacher.AsNoTracking().ToList();
ViewBag.Teacher = new SelectList(Teacher, "TeacherId", "TeacherName");
//var check = await _context.TEnrolledSubject.AsNoTracking().Where(s => s.ClassId == td.clsidVM && s.SectionId == td.secidVM && s.SubjectId == td.sbjctidVM).FirstOrDefaultAsync();
//if (check != null)
//{
// ViewBag.MSG = "Already assigned";
// return View();
//}
TEnrolledSubject enrolledSubject = new TEnrolledSubject()
{
ClassId = td.clsidVM,
SectionId = td.secidVM,
Year = td.tcrsbjctyearVM,
TEnrolledSubjectId = td.tcrsbjctserialnoVM,
SubjectId = td.sbjctidVM,
TeacherId = td.tcridVM
};
_context.TEnrolledSubject.Update(enrolledSubject);
await _context.SaveChangesAsync();
return(RedirectToAction("ListAssignedSubject"));
}
public async Task <IActionResult> UpdateAssignedSubject(int id)
{
//for the class
var Subject = _context.Subject.AsNoTracking().ToList();
ViewBag.Subject = new SelectList(Subject, "SubjectId", "SubjectTitle");
//for the class
var Class = _context.Class.AsNoTracking().ToList();
ViewBag.Class = new SelectList(Class, "ClassId", "ClassName");
//for thr teacher
var Teacher = _context.Teacher.AsNoTracking().ToList();
ViewBag.Teacher = new SelectList(Teacher, "TeacherId", "TeacherName");
//GEt the specific data
TEnrolledSubject data = await _context.TEnrolledSubject.AsNoTracking().Where(s => s.TEnrolledSubjectId == id).FirstOrDefaultAsync();
if (data == null)
{
return(RedirectToAction("Error"));
}
TEnrolledSubjectVm tdata = new TEnrolledSubjectVm()
{
tcrsbjctserialnoVM = data.TEnrolledSubjectId,
clsidVM = data.ClassId,
secidVM = data.SectionId,
sbjctidVM = data.SubjectId,
tcridVM = data.TeacherId,
tcrsbjctyearVM = data.Year
};
var d = _context.SectionCapacity.AsNoTracking().Where(s => s.ClassId == tdata.clsidVM).ToList();
var e = _context.Section.AsNoTracking().ToList();
var query = from a in d
join b in e on a.SectionId equals b.SectionId
select new
{
SectionId = b.SectionId,
SectionName = b.SectionName
};
var slist = new SelectList(query, "SectionId", "SectionName");
ViewBag.Section = slist;
return(View(tdata));
}
public async Task <IActionResult> SubjectAssignToTeacher(TEnrolledSubjectVm tb)
{
//for the class
var Subject = _context.Subject.AsNoTracking().ToList();
ViewBag.Subject = new SelectList(Subject, "SubjectId", "SubjectTitle");
//for the class
var Class = _context.Class.AsNoTracking().ToList();
ViewBag.Class = new SelectList(Class, "ClassId", "ClassName");
//for thr teacher
var Teacher = _context.Teacher.AsNoTracking().ToList();
ViewBag.Teacher = new SelectList(Teacher, "TeacherId", "TeacherName");
var check = await _context.TEnrolledSubject.AsNoTracking().Where(s => s.ClassId == tb.clsidVM && s.SectionId == tb.secidVM && s.SubjectId == tb.sbjctidVM).FirstOrDefaultAsync();
if (check != null)
{
ViewBag.MSG = "Already assigned";
return(View());
}
if (ModelState.IsValid)
{
TEnrolledSubject enrolledSubject = new TEnrolledSubject()
{
ClassId = tb.clsidVM,
SectionId = tb.secidVM,
Year = DateTime.Now.Year,
TEnrolledSubjectId = 0,
SubjectId = tb.sbjctidVM,
TeacherId = tb.tcridVM
};
_context.TEnrolledSubject.Add(enrolledSubject);
await _context.SaveChangesAsync();
return(RedirectToAction("ListAssignedSubject"));
}
return(View());
}
