public ActionResult EditNews(NewsView model) { USOSContext context = this.initContext(); if (!ModelState.IsValid) { return(View(model)); } using (context) { int id = model.ID; News Obj = context.News.Find(id); if (context.News.Where(x => x.ID != id).Any(x => x.Text == model.Text)) { ModelState.AddModelError("", "Aktualność już istnieje"); } Obj.Text = model.Text; Obj.Header = model.Header; Obj.Date = DateTime.Now; context.SaveChanges(); } return(RedirectToAction("News")); }
public ActionResult CreateNews(NewsView model) { USOSContext context = this.initContext(); if (!ModelState.IsValid) { ViewBag.Message = "Dodano"; return(View(model)); } using (context) { News Obj = new News(); if (context.News.Any(x => x.ID == model.ID)) { ModelState.AddModelError("", "Ta nazwa juĹĽ istnieje"); return(View(model)); } Obj.Text = model.Text; Obj.Header = model.Header; Obj.Date = DateTime.Now; ViewBag.Message = "Dodano"; context.News.Add(Obj); context.SaveChanges(); } return(RedirectToAction("News")); }
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() { USOSContext context = this.initContext(); CreateLessonView lesson = new CreateLessonView(); lesson.lectures = context.Lecture.Select(x => new SelectListItem() { Value = Convert.ToString(x.ID), Text = x.Name }).ToList(); lesson.groups = context.Group.Select(x => new SelectListItem() { Value = Convert.ToString(x.ID), Text = x.Name }).ToList(); IList <AppUser> lecturers = _userManager.GetUsersInRoleAsync("Lecturer").Result; List <SelectListItem> list = new List <SelectListItem>(); foreach (AppUser user in lecturers) { list.Add(new SelectListItem() { Value = user.UserName, Text = user.UserName }); } lesson.lecturers = list; return(PartialView("CreateLesson", lesson)); }
public IActionResult MarkWorker() { USOSContext context = this.initContext(); List<Lesson> lessons = context.Lesson.Include(x => x.lecture).ToList(); List<LessonStudentMarkView> lessonsStudentMarkView = new List<LessonStudentMarkView>(); foreach (Lesson lesson in lessons) { List<LessonsGroup> lessonsGroup = context.LessonsGroup.Where(x => x.lesson.ID == lesson.ID).Include(x => x.group).Include(x => x.lesson).Include(x => x.lesson.lecture).ToList();//.Select(x => new LessonsGroup(x)).ToList(); foreach (LessonsGroup lg in lessonsGroup) { List<StudentGroup> studentgroups = context.StudentGroup.Include(x => x.appUser).Include(x => x.group).Where(x => x.group.ID == lg.group.ID).ToList(); foreach (StudentGroup studentgroup in studentgroups) { LessonStudentMarkView view = new LessonStudentMarkView(); if (context.LessonStudentMark.Where(x => x.Lesson.ID == lg.lesson.ID && x.Username.UserName == studentgroup.appUser.UserName).Include(x => x.Mark).Count() != 0) { LessonStudentMark lessonstudentmark = context.LessonStudentMark.Where(x => x.Lesson.ID == lg.lesson.ID && x.Username.UserName == studentgroup.appUser.UserName).Include(x => x.Mark).First(); view.Mark = lessonstudentmark.Mark.Value; } view.LessonID = lesson.ID; view.Username = studentgroup.appUser.UserName; view.Lesson = lg.lesson.lecture.Name; lessonsStudentMarkView.Add(view); } } } return View(lessonsStudentMarkView); }
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 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 News() { USOSContext context = this.initContext(); List <NewsView> News; News = context.News.ToArray().OrderBy(x => x.ID).Select(x => new NewsView(x)).ToList(); return(View(News)); }
public IActionResult CreateLecture() { USOSContext context = this.initContext(); Lecture lecture = new Lecture(); return(PartialView("CreateLecture", lecture)); }
public USOSContext initContext() { DbContextOptionsBuilder<USOSContext> options = new DbContextOptionsBuilder<USOSContext>(); options.UseSqlServer(configuration.GetConnectionString("MyConnStr")); var context = new USOSContext(options.Options); return context; }
public IActionResult CreateGroup() { USOSContext context = this.initContext(); Group group = new Group(); return(PartialView("CreateGroup", group)); }
public IActionResult EditLecture(Lecture model) { USOSContext context = this.initContext(); context.Lecture.Update(model); context.SaveChanges(); return(RedirectToAction("Lectures", "Admin")); }
public IActionResult EditLecture(int ID) { USOSContext context = this.initContext(); Lecture lecture = context.Lecture.Find(ID); return(PartialView("EditLecture", lecture)); }
public IActionResult EditGroup(int ID) { USOSContext context = this.initContext(); Group group = context.Group.Find(ID); return(PartialView("EditGroup", group)); }
public IActionResult EditGroup(Group model) { USOSContext context = this.initContext(); context.Group.Update(model); context.SaveChanges(); return(RedirectToAction("Groups", "Admin")); }
public IActionResult Lectures() { USOSContext context = this.initContext(); List <Lecture> lectures; lectures = context.Lecture.ToArray().OrderBy(x => x.ID).Select(x => new Lecture() { ID = x.ID, Name = x.Name }).ToList(); return(View(lectures)); }
public IActionResult Groups() { USOSContext context = this.initContext(); List <Group> groups; groups = context.Group.ToArray().OrderBy(x => x.ID).Select(x => new Group() { ID = x.ID, Name = x.Name }).ToList(); return(View(groups)); }
public ActionResult EditMark(int lessonId, string username) { USOSContext context = this.initContext(); LessonStudentMarkView edit = new LessonStudentMarkView(); edit.LessonID = lessonId; edit.Username = username; edit.Marks = context.Mark.Select(x => new SelectListItem() { Value = Convert.ToString(x.ID), Text = x.Name }).ToList(); return PartialView("EditMark",edit); }
public ActionResult DeleteNews(int id) { USOSContext context = this.initContext(); using (context) { News Obj = context.News.Find(id); context.News.Remove(Obj); context.SaveChanges(); } return(RedirectToAction("News")); }
public async Task <IActionResult> DeleteGroup(int ID) { USOSContext context = this.initContext(); Group group = context.Group.Find(ID); if (group != null) { context.Group.Remove(group); context.SaveChanges(); } return(RedirectToAction("Groups", "Admin")); }
public IActionResult EditStudentGroup(string userName) { AppUser editUser = _userManager.FindByNameAsync(userName).Result; USOSContext context = this.initContext(); EditStudentGroup model = new EditStudentGroup(); model.userName = editUser.UserName; model.groups = context.Group.Select(x => new SelectListItem() { Value = Convert.ToString(x.ID), Text = x.Name }).ToList(); return(PartialView("EditStudentGroup", model)); }
public async Task <IActionResult> DeleteLecture(int ID) { USOSContext context = this.initContext(); Lecture lecture = context.Lecture.Find(ID); if (lecture != null) { context.Lecture.RemoveRange(lecture); context.Lecture.Remove(lecture); context.SaveChanges(); } return(RedirectToAction("Lectures", "Admin")); }
public IActionResult CreateGroup(Group model) { USOSContext context = this.initContext(); Group newGroup = new Group(); Group result = context.Group.Find(model.ID); if (result == null) { newGroup.Name = model.Name; context.Group.Add(newGroup); context.SaveChanges(); } return(RedirectToAction("Groups", "Admin")); }
public IActionResult CreateLecture(Lecture model) { USOSContext context = this.initContext(); Lecture newLecture = new Lecture(); Lecture result = context.Lecture.Find(model.ID); if (result == null) { newLecture.Name = model.Name; context.Lecture.Add(newLecture); context.SaveChanges(); } return(RedirectToAction("Lectures", "Admin")); }
public IActionResult EditLesson(int ID) { USOSContext context = this.initContext(); CreateLessonView lesson = new CreateLessonView(); Lesson editLesson = context.Lesson.Where(x => x.ID == ID).Include(x => x.lecture).Include(x => x.lecturer).First(); lesson.lectures = context.Lecture.Select(x => new SelectListItem() { Value = Convert.ToString(x.ID), Text = x.Name }).ToList(); lesson.groups = context.Group.Select(x => new SelectListItem() { Value = Convert.ToString(x.ID), Text = x.Name }).ToList(); IList <AppUser> lecturers = _userManager.GetUsersInRoleAsync("Lecturer").Result; List <SelectListItem> list = new List <SelectListItem>(); foreach (AppUser user in lecturers) { SelectListItem item = new SelectListItem() { Value = user.UserName, Text = user.UserName }; list.Add(item); } foreach (SelectListItem g in lesson.groups) { var select = context.LessonsGroup.Where(x => x.lesson.ID == ID && x.group.ID == Convert.ToInt32(g.Value)).Include(x => x.lesson).Include(x => x.group).Select(x => new LessonsGroup(x)); if (select.Count() > 0) { g.Selected = true; } } lesson.lecturers = list; lesson.lectureID = editLesson.lecture.ID; lesson.lecturerID = editLesson.lecturer.UserName; lesson.lessonID = ID; return(PartialView("EditLesson", lesson)); }
public ActionResult EditNews(int id) { NewsView model; USOSContext context = this.initContext(); using (context) { News Obj = context.News.Find(id); if (Obj == null) { return(Content("Strona nie istnieje")); } model = new NewsView(Obj); } return(PartialView(model)); }
public IActionResult Users() { if (!User.IsInRole("Admin")) { return(RedirectToAction("Index", "Home")); } USOSContext context = this.initContext(); var userRoles = new List <AdminUsersView>(); var userStore = new UserStore <AppUser>(context); foreach (var user in userStore.Users) { var r = new AdminUsersView { Email = user.Email, PhoneNumber = user.PhoneNumber, UserName = user.UserName, Role = new List <string>() }; if (_userManager.IsInRoleAsync(user, "Student").Result) { var list = context.StudentGroup.Where(x => x.appUser == user).Include(x => x.group).ToList(); foreach (StudentGroup s in list) { r.groups += s.group.Name + " "; } } var roles = _userManager.GetRolesAsync(user).Result; string roleStr = ""; foreach (var role in roles) { r.Role.Add(role); } userRoles.Add(r); } return(View(userRoles)); }
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")); }
public IActionResult Lessons() { USOSContext context = this.initContext(); List <LessonsView> lessonsView = new List <LessonsView>(); List <Lesson> lessons = context.Lesson.Select(x => new Lesson() { ID = x.ID, lecture = x.lecture, lecturer = x.lecturer }).ToList(); foreach (Lesson lesson in lessons) { LessonsView view = new LessonsView(); view.ID = lesson.ID; view.LectureID = lesson.lecture.ID; view.LectureName = lesson.lecture.Name; view.LecturerName = lesson.lecturer.UserName; List <LessonsGroup> lessonsGroup = context.LessonsGroup.Where(x => x.lesson.ID == lesson.ID).Include(x => x.group).Include(x => x.lesson).ToList();//.Select(x => new LessonsGroup(x)).ToList(); foreach (LessonsGroup lg in lessonsGroup) { if (view.GroupName == null) { view.GroupName += lg.group.Name; view.GroupID = Convert.ToString(lg.group.ID); } else { view.GroupName += "," + lg.group.Name; view.GroupID = "," + Convert.ToString(lg.group.ID); } } lessonsView.Add(view); } return(View(lessonsView)); }
public UsosSemesterService(USOSContext context) { _context = context; }