public IActionResult AddNewStudentEntry(ViewModel viewmodel)
{
Dictionary <int, List <string> > answers = new Dictionary <int, List <string> >();
var coll = Request.Form.ToList();
foreach (var str in coll)
{
if (int.TryParse(str.Key, out int id))
{
if (answers.ContainsKey(id))
{
answers[1].Add(str.Value);
}
else
{
answers.Add(id, new List <string> {
str.Value
});
}
}
}
viewmodel.OneStudent.Answers = answers;
_context.Students.Add(viewmodel.OneStudent);
_context.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
static void Main(string[] args)
{
using (var db = new StudentsDB())
{
//db.Database.Log = str => Console.WriteLine("EF>> {0}", str);
var students_count = db.Students.Count();
Console.WriteLine("Students in DB: {0}", students_count);
}
using (var db = new StudentsDB())
if (!db.Groups.Any())
{
var student_n = 1;
for (var group_n = 1; group_n <= 10; group_n++)
{
var group = new StudentsGroup
{
Name = $"Group {group_n}"
};
for (var i = 0; i < 10; i++)
{
var student = new Student
{
Name = $"Student {student_n}",
Surname = $"Surname {student_n}",
Patronymic = $"Patronymic {student_n}",
};
group.Students.Add(student);
student_n++;
//db.Students.Add(student); // в этом нет необходимости!
}
db.Groups.Add(group);
}
db.Database.Log = str => Console.WriteLine("EF>> {0}", str);
db.SaveChanges();
}
using (var db = new StudentsDB())
{
db.Database.Log = str => Console.WriteLine("EF>> {0}", str);
var students_group_id_7 = db.Students
//.Include(student => student.Group)
.Where(student => student.Group.Id == 7).ToArray();
Console.ReadLine();
Console.WriteLine(students_group_id_7[0].Group.Name);
}
Console.ReadLine();
}
static void Main(string[] args)
{
using (var db = new StudentsDB())
{
//db.Database.Log = str => Console.WriteLine("EF>> {0}", str);
var students_count = db.Students.Count();
Console.WriteLine("Количество студентов в БД {0}", students_count);
}
using (var db = new StudentsDB())
if (db.Groups.Count() == 0)
{
var students_n = 1;
for (var i = 1; i <= 10; i++)
{
var group = new Group
{
Name = $"Группа {i}",
Students = new List <Student>()
};
for (var j = 0; j < 10; j++)
{
var student = new Student
{
Name = $"Имя {students_n}",
SurName = $"Фамилия {students_n}",
Patronymic = $"Отчество {students_n}",
Birthday = DateTime.Now.Subtract(TimeSpan.FromDays(365 / 4 * (students_n + 10)))
};
students_n++;
group.Students.Add(student);
}
db.Groups.Add(group);
}
db.SaveChanges();
}
//using (var db = new StudentsDB())
//{
// var students_count = db.Students.Count();
// Console.WriteLine("Количество студентов в БД {0}", students_count);
//}
using (var db = new StudentsDB())
if (db.Courses.Count() == 0)
{
var rnd = new Random();
for (var i = 1; i <= 10; i++)
{
var course = new Course
{
Name = $"Курс {i}",
Students = new List <Student>()
};
for (var j = 0; j < 10; j++)
{
var student_id = rnd.Next(1, 101);
if (course.Students.Any(s => s.Id == student_id))
{
continue;
}
var student = db.Students.First(s => s.Id == student_id);
course.Students.Add(student);
}
db.Courses.Add(course);
}
db.SaveChanges();
}
using (var db = new StudentsDB())
{
var empty_courses = db.Courses.Where(course => course.Students.Count() == 0);
foreach (var course in empty_courses)
{
Console.WriteLine(course.Name);
}
var empty_students = db.Students.Where(student => student.Courses.Count() == 0);
foreach (var student in empty_students)
{
Console.WriteLine("[{0}] {1} {2} {3} {4}",
student.Id,
student.SurName,
student.Name,
student.Patronymic,
student.Birthday);
}
Console.WriteLine("Студентов без курсов {0}", empty_students.Count());
var course_info = db.Courses.Select(course => new
{
CourseName = course.Name,
StudentsCount = course.Students.Count(),
StudentNames = course.Students.Select(student => student.Name)
});
foreach (var info in course_info)
{
Console.WriteLine("{0}({1}) - {2}",
info.CourseName, info.StudentsCount, string.Join(",", info.StudentNames));
}
}
Console.WriteLine("Конец...");
Console.ReadLine();
}
