public ActionResult Create([Bind(Include = "TeacherID,FirstName,MiddleName,LastName,AcadDegree")] Teacher teacher) { if (ModelState.IsValid) { db.Teachers.Add(teacher); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(teacher)); }
public ActionResult Create([Bind(Include = "GroupID,CourseNumber")] Group group) { if (ModelState.IsValid) { db.Groups.Add(group); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(group)); }
public ActionResult Create([Bind(Include = "RecordBookNumberID,GroupID,FirstName,MiddleName,LastName")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.GroupID = new SelectList(db.Groups, "GroupID", "GroupID", student.GroupID); return(View(student)); }
public void AddMarkColumn(ref TotalJournalContext db, string type, string groupId, int?subjectId) { //получаем максимальный номер лабы по предмету //получаем максимальный ИД в таблице // в цикле по студентам каждому студенту присваиваем ноль по лабе с данным номером Subject subject = db.Subjects.Find(subjectId); List <Group> groups = subject.Groups.ToList(); Group group = db.Groups.Find(groupId); #region int MaxLabNumber = 0, MaxLabID = 0, MaxLabMaxPointID = 0; if (db.LabMaxPoints.Where(m => m.Subject.SubjectID == subjectId).Count() != 0) { //максимальный номер лабы по предмету MaxLabNumber = db.LabMaxPoints .Where(m => m.Subject.SubjectID == subjectId).Max(m => m.LabNumber); } if (db.Marks.Count() != 0) { MaxLabID = db.Marks.Max(m => m.MarkID); } if (db.LabMaxPoints.Count() != 0) { MaxLabMaxPointID = db.LabMaxPoints.Max(m => m.LabMaxPointID); } db.LabMaxPoints.Add(new LabMaxPoint() { LabMaxPointID = MaxLabMaxPointID + 1, LabNumber = MaxLabNumber + 1, MaxPoint = 0, SubjectID = (int)subjectId }); #endregion foreach (var grp in groups) { foreach (var student in grp.Students) { MaxLabID++; subject.Marks.Add(new Mark() { MarkID = MaxLabID, LabNumber = (MaxLabNumber + 1), RecordBookNumberID = student.RecordBookNumberID, DateOfProgram = DateTime.Now, DateOfReport = DateTime.Now, SubjectID = Convert.ToInt32(subjectId), TheMark = 0 }); } } db.SaveChanges(); }
public ActionResult Create([Bind(Include = "SubjectCP_ID,TeacherID,SubjectCPName,Term")] SubjectCP subjectCP) { if (ModelState.IsValid) { db.SubjectCPs.Add(subjectCP); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TeacherID = new SelectList(db.Teachers, "TeacherID", "FirstName", subjectCP.TeacherID); return(View(subjectCP)); }
public ActionResult AddMarkColumn(string groupId, int?subjectId) { //получаем максимальный номер лабы по предмету //получаем максимальный ИД в таблице // в цикле по студентам каждому студенту присваиваем ноль по лабе с данным номером Subject subject = db.Subjects.Find(subjectId); List <Group> groups = subject.Groups.ToList(); Group group = db.Groups.Find(groupId); // если в текущей группе нету студентов if (group.Students.Count == 0) { ViewBag.ErrorText = "Сначала добавьте студентов в группу!"; return(View("Error")); } #region int MaxLabNumber = 0, MaxLabID = 0, MaxLabMaxPointID = 0; if (db.LabMaxPoints.Where(m => m.Subject.SubjectID == subjectId).Count() != 0) { //максимальный номер лабы по предмету MaxLabNumber = db.LabMaxPoints .Where(m => m.Subject.SubjectID == subjectId).Max(m => m.LabNumber); } if (db.Marks.Count() != 0) { MaxLabID = db.Marks.Max(m => m.MarkID); } if (db.LabMaxPoints.Count() != 0) { MaxLabMaxPointID = db.LabMaxPoints.Max(m => m.LabMaxPointID); } db.LabMaxPoints.Add(new LabMaxPoint() { LabMaxPointID = MaxLabMaxPointID + 1, LabNumber = MaxLabNumber + 1, MaxPoint = 0, SubjectID = (int)subjectId }); #endregion foreach (var grp in groups) { foreach (var student in grp.Students) { MaxLabID++; subject.Marks.Add(new Mark() { MarkID = MaxLabID, LabNumber = (MaxLabNumber + 1), RecordBookNumberID = student.RecordBookNumberID, DateOfProgram = DateTime.Now, DateOfReport = DateTime.Now, SubjectID = Convert.ToInt32(subjectId), TheMark = 0 }); } } db.SaveChanges(); return(RedirectToAction(getUrl("ShowMarks", groupId, subjectId))); }