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