public IActionResult EditStudentGroup(EditStudentGroup model)
{
USOSContext context = this.initContext();
AppUser student = _userManager.FindByNameAsync(model.userName).Result;
var select = context.StudentGroup.Where(x => x.appUser.UserName == model.userName).Select(x => new StudentGroup()
{
ID = x.ID, appUser = x.appUser, group = x.group
});
context.StudentGroup.RemoveRange(select);
foreach (int groupId in model.group)
{
Group group = context.Group.Find(groupId);
if (group != null)
{
StudentGroup newStudentGroup = new StudentGroup();
newStudentGroup.group = group;
newStudentGroup.appUser = student;
context.StudentGroup.Add(newStudentGroup);
context.Entry(newStudentGroup.group).State = EntityState.Unchanged;
context.Entry(newStudentGroup.appUser).State = EntityState.Unchanged;
}
}
context.SaveChanges();
return(RedirectToAction("Users", "Admin"));
}
public ActionResult EditMark(LessonStudentMarkView model)
{
USOSContext context = this.initContext();
LessonStudentMark studentmark = null;
Mark mark = context.Mark.Where(x => x.ID == model.MarkID).First();
AppUser user = context.Users.Where(x => x.UserName == model.Username).First();
Lesson lesson = context.Lesson.Where(x => x.ID == model.LessonID).First();
var query = context.LessonStudentMark.Where(x => x.Lesson.ID == model.LessonID && x.Username.UserName == model.Username).Include(x => x.Mark) ;
if (query.Count() != 0)
{
studentmark = query.First();
}
if (studentmark == null)
{
studentmark = new LessonStudentMark();
studentmark.Mark = mark;
studentmark.Lesson = lesson;
studentmark.Username = user;
context.LessonStudentMark.Add(studentmark);
context.Entry(studentmark.Lesson).State = EntityState.Unchanged;
context.Entry(studentmark.Username).State = EntityState.Unchanged;
}
else
{
studentmark.Mark = mark;
context.LessonStudentMark.Update(studentmark);
}
context.SaveChanges();
return RedirectToAction("MarkLecturer", "Mark");
}
public IActionResult EditLesson(CreateLessonView model)
{
USOSContext context = this.initContext();
Lesson editLesson = context.Lesson.Find(model.lessonID);
if (model.lectureID != null)
{
editLesson.lecture = context.Lecture.Find(Convert.ToInt32(model.lectureID));
}
if (model.lecturerID != null)
{
editLesson.lecturer = _userManager.FindByNameAsync(model.lecturerID).Result;
}
var select = context.LessonsGroup.Where(x => x.lesson.ID == model.lessonID).Select(x => new LessonsGroup(x));
context.LessonsGroup.RemoveRange(select);
if (model.group != null)
{
foreach (int g in model.group)
{
Group group = context.Group.Find(g);
LessonsGroup newLessonGroup = new LessonsGroup();
newLessonGroup.group = group;
newLessonGroup.lesson = editLesson;
context.LessonsGroup.Add(newLessonGroup);
}
}
context.Entry(editLesson.lecturer).State = EntityState.Unchanged;
context.SaveChanges();
return(RedirectToAction("Lessons", "Admin"));
}
public IActionResult CreateLesson(CreateLessonView lecture)
{
USOSContext context = this.initContext();
Lesson newLesson = new Lesson();
newLesson.lecture = context.Lecture.Find(Convert.ToInt32(lecture.lectureID));
newLesson.lecturer = _userManager.FindByNameAsync(lecture.lecturerID).Result;
context.Lesson.Add(newLesson);
context.Entry(newLesson.lecturer).State = EntityState.Unchanged;
foreach (int g in lecture.group)
{
Group group = context.Group.Find(g);
LessonsGroup newLessonGroup = new LessonsGroup();
newLessonGroup.group = group;
newLessonGroup.lesson = newLesson;
context.LessonsGroup.Add(newLessonGroup);
}
context.SaveChanges();
return(RedirectToAction("Lessons", "Admin"));
}