public async Task <IActionResult> SuccessfulLessonAdding(int chosenClassroom, int slot)
{
var classes = from c in _context.Class
where c.Id == (int)TempData["class"]
select c;
var _class = await classes.SingleOrDefaultAsync();
var subjects = from s in _context.Subject
where s.Id == (int)TempData["subject"]
select s;
var subject = await subjects.SingleOrDefaultAsync();
var teachers = from t in _context.Teacher
where t.Id == (int)TempData["teacher"]
select t;
var teacher = await teachers.SingleOrDefaultAsync();
var classrooms = from c in _context.Classroom
where c.Id == chosenClassroom
select c;
var classroom = await classrooms.SingleOrDefaultAsync();
if (_class == null || subject == null || teacher == null || classroom == null)
{
return(RedirectToAction("ConcurrencyError", new { errorMessage = "The value you tried to select had been deleted by another user before." }));
}
_context.Add(new Lesson {
Classroom = classroom,
Class = _class,
Subject = subject,
Slot = slot,
Teacher = teacher,
});
await _context.SaveChangesAsync();
return(View());
}
public async Task <IActionResult> Index(Edit edit)
{
if (edit.ClassroomToAdd != null)
{
try {
_context.Classroom.Add(new Classroom {
Number = edit.ClassroomToAdd,
});
await _context.SaveChangesAsync();
}
catch (DbUpdateException) {
return(RedirectToAction("Failure", new { errorMessage = "The value you have tried to add is not unique or the length is too big." }));
}
}
else if (edit.ClassroomToDelete != null)
{
var _classrooms = from c in _context.Classroom
where c.Id == edit.ClassroomToDelete
select c;
var classroom = await _classrooms.SingleOrDefaultAsync();
if (classroom == null)
{
return(RedirectToAction("Failure", new { errorMessage = "The value you tried to delete had been deleted by another user before." }));
}
var associatedLessons = from l in _context.Lesson
where l.Classroom.Id == classroom.Id
select l;
if (await associatedLessons.CountAsync() > 0)
{
return(RedirectToAction("Failure", new { ErrorMessage = "The value you have tried to delete has some lessons associated." }));
}
_context.Classroom.Remove(classroom);
await _context.SaveChangesAsync();
}
else if (edit.ClassToAdd != null)
{
try {
_context.Class.Add(new Class {
Name = edit.ClassToAdd,
});
await _context.SaveChangesAsync();
}
catch (DbUpdateException) {
return(RedirectToAction("Failure", new { errorMessage = "The value you have tried to add is not unique or the length is too big." }));
}
}
else if (edit.ClassToDelete != null)
{
var _classes = from c in _context.Class
where c.Id == edit.ClassToDelete
select c;
var _class = await _classes.SingleOrDefaultAsync();
if (_class == null)
{
return(RedirectToAction("Failure", new { errorMessage = "The value you tried to delete had been deleted by another user before." }));
}
var associatedLessons = from l in _context.Lesson
where l.Class.Id == _class.Id
select l;
if (await associatedLessons.CountAsync() > 0)
{
return(RedirectToAction("Failure", new { errorMessage = "The value you have tried to delete has some lessons associated." }));
}
_context.Class.Remove(_class);
await _context.SaveChangesAsync();
}
else if (edit.SubjectToAdd != null)
{
try {
_context.Subject.Add(new Subject {
Name = edit.SubjectToAdd,
});
await _context.SaveChangesAsync();
}
catch (DbUpdateException) {
return(RedirectToAction("Failure", new { errorMessage = "The value you have tried to add is not unique or the length is too big." }));
}
}
else if (edit.SubjectToDelete != null)
{
var _subjects = from s in _context.Subject
where s.Id == edit.SubjectToDelete
select s;
var subject = await _subjects.SingleOrDefaultAsync();
if (subject == null)
{
return(RedirectToAction("Failure", new { errorMessage = "The value you tried to delete had been deleted by another user before." }));
}
var associatedLessons = from l in _context.Lesson
where l.Subject.Id == subject.Id
select l;
if (await associatedLessons.CountAsync() > 0)
{
return(RedirectToAction("Failure", new { errorMessage = "The value you have tried to delete has some lessons associated." }));
}
_context.Subject.Remove(subject);
await _context.SaveChangesAsync();
}
else if (edit.TeacherToAdd != null)
{
try {
_context.Teacher.Add(new Teacher {
Surname = edit.TeacherToAdd,
});
await _context.SaveChangesAsync();
}
catch (DbUpdateException) {
return(RedirectToAction("Failure", new { errorMessage = "The value you have tried to add is not unique or the length is too big." }));
}
}
else if (edit.TeacherToDelete != null)
{
var _teachers = from t in _context.Teacher
where t.Id == edit.TeacherToDelete
select t;
var teacher = await _teachers.SingleOrDefaultAsync();
if (teacher == null)
{
return(RedirectToAction("Failure", new { errorMessage = "The value you tried to delete had been deleted by another user before." }));
}
var associatedLessons = from l in _context.Lesson
where l.Teacher.Id == teacher.Id
select l;
if (await associatedLessons.CountAsync() > 0)
{
return(RedirectToAction("Failure", new { errorMessage = "The value you have tried to delete has some lessons associated. " }));
}
_context.Teacher.Remove(teacher);
await _context.SaveChangesAsync();
}
var classes = await _context.Class.OrderBy(c => c.Name).ToListAsync();
var classrooms = await _context.Classroom.OrderBy(c => c.Number).ToListAsync();
var teachers = await _context.Teacher.OrderBy(t => t.Surname).ToListAsync();
var subjects = await _context.Subject.OrderBy(s => s.Name).ToListAsync();
ViewData["classes"] = classes;
ViewData["classrooms"] = classrooms;
ViewData["teachers"] = teachers;
ViewData["subjects"] = subjects;
return(View(edit));
}