public async Task <IActionResult> SubjectList(int Page = 1)
{
var s = await _context.Subject.ToListAsync();
if (s.Count == 0)
{
return(RedirectToAction("Error"));
}
List <SubjectVm> sv = new List <SubjectVm>();
int c = 1;
foreach (var item in s)
{
SubjectVm vm = new SubjectVm()
{
Sl = c,
SubjectId = item.SubjectId,
SubjectTitle = item.SubjectTitle
};
sv.Add(vm);
c++;
}
var List = await sv.ToPagedListAsync(Page, 5);
return(View(List));
}
public SubjectVm GetSubject(Expression <Func <Subject, bool> > filterPredicate)
{
if (filterPredicate == null)
{
throw new ArgumentNullException($"Predicate is null");
}
Subject subjectEntity = _dbContext.Subjects
.Include(s => s.Teacher)
.Include(s => s.SubjectGroups)
.ThenInclude(sg => sg.Group)
.FirstOrDefault(filterPredicate);
SubjectVm subjectVm = Mapper.Map <SubjectVm>(subjectEntity);
return(subjectVm);
}
public async Task <IActionResult> UpdateSubject(SubjectVm sb)
{
if (ModelState.IsValid)
{
Subject s = new Subject()
{
SubjectId = sb.SubjectId,
SubjectTitle = sb.SubjectTitle
};
_context.Subject.Update(s);
await _context.SaveChangesAsync();
return(RedirectToAction("SubjectList"));
}
return(View());
}
public async Task <IActionResult> UpdateSubject(int id)
{
Subject s = await _context.Subject.AsNoTracking().Where(sb => sb.SubjectId == id).FirstOrDefaultAsync();
if (s == null)
{
return(RedirectToAction("Error"));
}
SubjectVm vm = new SubjectVm()
{
SubjectId = s.SubjectId,
SubjectTitle = s.SubjectTitle
};
return(View(vm));
}
async public Task <ActionResult> AddSubjectDetail()
{
var classlist = await db.Classes.ToListAsync();
var subjectlist = await db.Subjects.ToListAsync();
var teacherlist = await db.Teachers.ToListAsync();
var data = new SubjectVm
{
Classes = classlist,
Subjects = subjectlist,
Teachers = teacherlist
};
return(View(data));
}
async public Task <ActionResult> AddSubjectDetail(SubjectVm Subj)
{
if (Subj.subjectDetails.Id == 0)
{
db.SubjectDetails.Add(Subj.subjectDetails);
await db.SaveChangesAsync();
}
else
{
var record = await db.SubjectDetails.Include("Class").Include("Subject").Include("Teacher").SingleOrDefaultAsync(m => m.Id == Subj.subjectDetails.Id);
record.SubjectId = Subj.subjectDetails.SubjectId;
record.ClassId = Subj.subjectDetails.ClassId;
record.TeacherId = Subj.subjectDetails.TeacherId;
await db.SaveChangesAsync();
}
return(RedirectToAction("SubjectDetail"));
}
async public Task <ActionResult> EditSubjectDetail(int id)
{
var sd = await db.SubjectDetails.Include(m => m.Subject).Include(m => m.Class).Include(m => m.Teacher).SingleOrDefaultAsync(m => m.Id == id);
var classlist = await db.Classes.ToListAsync();
var subjectlist = await db.Subjects.ToListAsync();
var teacherlist = await db.Teachers.ToListAsync();
var data = new SubjectVm
{
subjectDetails = sd,
Classes = classlist,
Subjects = subjectlist,
Teachers = teacherlist
};
return(View("AddSubjectDetail", data));
}
public async Task <ApiResult <SubjectVm> > GetSubjectById(int id)
{
var subject = await _context.Subjects.FindAsync(id);
if (subject == null)
{
return(new ApiErrorResult <SubjectVm>("Không tìm thấy "));
}
var data = new SubjectVm()
{
Id_Subject = subject.Id_Subject,
Name = subject.Name,
NumberOfCredits = subject.NumberOfCredits,
Lesson = subject.Lesson,
Description = subject.Description,
DateCreate = subject.DateCreate,
DateUpdate = subject.DateUpdate,
};
return(new ApiSuccessResult <SubjectVm>(data));
}
public async Task <IActionResult> AddSubject(SubjectVm sb)
{
if (ModelState.IsValid)
{
Subject s = new Subject()
{
SubjectId = sb.SubjectId,
SubjectTitle = sb.SubjectTitle
};
await _context.Subject.AddAsync(s);
await _context.SaveChangesAsync();
ModelState.Clear();
return(RedirectToAction("SubjectList"));
}
else
{
return(View());
}
}
