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));
}
