public async Task <IActionResult> Create([Bind("GradeId,FirstYear,Letter")] Grades grades) { if (ModelState.IsValid) { _context.Add(grades); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(grades)); }
public async Task <IActionResult> Create([Bind("GroupTypeId,GroupTypeName")] GroupTypes groupTypes) { if (ModelState.IsValid) { _context.Add(groupTypes); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(groupTypes)); }
public async Task <IActionResult> Create([Bind("AdminId,Login,Password")] Admins admins) { if (ModelState.IsValid) { _context.Add(admins); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(admins)); }
public async Task <IActionResult> Create([Bind("SkippingClassId,SkippingDate,PupilId")] SkippingClasses skippingClasses) { if (ModelState.IsValid) { _context.Add(skippingClasses); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["PupilId"] = new SelectList(_context.Pupils, "PupilId", "FirstName", skippingClasses.PupilId); return(View(skippingClasses)); }
public async Task <IActionResult> Create([Bind("GroupTypeSubjectId,GroupTypeId,SubjectId")] GroupTypeSubject groupTypeSubject) { if (ModelState.IsValid) { _context.Add(groupTypeSubject); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["GroupTypeId"] = new SelectList(_context.GroupTypes, "GroupTypeId", "GroupTypeName", groupTypeSubject.GroupTypeId); ViewData["SubjectId"] = new SelectList(_context.Subjects, "SubjectId", "SubjectName", groupTypeSubject.SubjectId); return(View(groupTypeSubject)); }
public async Task <IActionResult> Create([Bind("GroupPupilId,GroupId,PupilId")] GroupPupil groupPupil) { if (ModelState.IsValid) { _context.Add(groupPupil); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["GroupId"] = new SelectList(_context.Groups.Where(g => g.GroupTypeId != null), "GroupId", "GroupId", groupPupil.GroupId); ViewData["PupilId"] = new SelectList(_context.Pupils, "PupilId", "FirstName", groupPupil.PupilId); return(View(groupPupil)); }
public async Task <IActionResult> Create([Bind("TeacherSubjectId,TeacherId,SubjectId,HoursNumber")] TeacherSubject teacherSubject) { if (ModelState.IsValid) { _context.Add(teacherSubject); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["SubjectId"] = new SelectList(_context.Subjects, "SubjectId", "SubjectName", teacherSubject.SubjectId); ViewData["TeacherId"] = new SelectList(_context.TeachersInfo, "TeacherId", "TeacherFullName", teacherSubject.TeacherId); return(View(teacherSubject)); }
public async Task <IActionResult> Create([Bind("TeacherSubjectGroupId,TeacherSubjectId,GroupId")] TeacherSubjectGroup teacherSubjectGroup) { if (ModelState.IsValid) { _context.Add(teacherSubjectGroup); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["GroupId"] = new SelectList(_context.Groups.Include(t => t.Grade), "GroupId", "GroupName", teacherSubjectGroup.GroupId); ViewData["TeacherSubjectId"] = new SelectList(_context.TeacherSubject .Include(t => t.Teacher) .Include(t => t.Subject), "TeacherSubjectId", "TeacherSubjectName", teacherSubjectGroup.TeacherSubjectId); return(View(teacherSubjectGroup)); }
public async Task <IActionResult> Create([Bind("PupilId,FirstName,SurName,Patronymic,Dob,GradeId,Login,Password")] Pupils pupils) { if (ModelState.IsValid) { _context.Add(pupils); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["GradeId"] = new SelectList(_context.Grades, "GradeId", "Letter", pupils.GradeId); return(View(pupils)); #region SQL /* * * INSERT INTO pupils(FirstName,SurName,Patronymic,Dob,GradeId,Login,Password) * VALUES(@FirstName,@SurName,@Patronymic,@Dob,@GradeId,@Login,@Password) * */ #endregion }
public async Task <IActionResult> Create([Bind("HomeworkId,PassDate,TeacherSubjectGroupId,Homework")] Homeworks homeworks) { if (ModelState.IsValid) { _context.Add(homeworks); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["TeacherSubjectGroupId"] = new SelectList(_context.TeacherSubjectGroup .Include(t => t.TeacherSubject) .Include(t => t.TeacherSubject.Subject) .Include(t => t.TeacherSubject.Teacher) .Include(t => t.Group) .Include(t => t.Group.GroupType) .Include(t => t.Group.Grade), "TeacherSubjectGroupId", "TeacherSubjectGroupName", homeworks.TeacherSubjectGroupId); return(View(homeworks)); }
public async Task <IActionResult> Create([Bind("TimetableId,WeekDayNumber,LessonNumber,Oddness,TeacherSubjectGroupId")] Timetables timetables) { if (ModelState.IsValid) { _context.Add(timetables); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["TeacherSubjectGroupId"] = new SelectList(_context.TeacherSubjectGroup .Include(t => t.TeacherSubject) .Include(t => t.TeacherSubject.Subject) .Include(t => t.TeacherSubject.Teacher) .Include(t => t.Group) .Include(t => t.Group.GroupType) .Include(t => t.Group.Grade), "TeacherSubjectGroupId", "TeacherSubjectGroupName", timetables.TeacherSubjectGroupId); return(View(timetables)); }