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