public static void Main() { Database.SetInitializer(new MigrateDatabaseToLatestVersion<UniversityDbContext, Configuration>()); var db = new UniversityDbContext(); var student = new Student { Name = "Pesho", FN = "M12345", Gender = Gender.Male }; db.Students.Add(student); //delete student Pesho //var studentsForDelete = db.Students.Where(s => s.Name == "Pesho").ToList(); //foreach (var item in studentsForDelete) //{ // db.Students.Remove(item); //} db.SaveChanges(); Console.WriteLine("Students count: {0}", db.Students.Count()); Console.WriteLine("Courses count: {0}", db.Courses.Count()); Console.WriteLine("Authors count: {0}", db.Authors.Count()); Console.WriteLine("Materials count: {0}", db.Materials.Count()); }
public void DeberiActualizar() { var mockSet = new Mock<DbSet<Student>>(); var mockContext = new Mock<UniversityContext>(); mockContext.Setup(m => m.Students).Returns(mockSet.Object); var existing = new Student { StudentId = 1, Nombre = "Carlos", Paterno = "Estrada", Materno = "Copa", Telefono = 2269587 }; var data = new Student { StudentId = 1, Nombre = "Carlos", Paterno = "Estrada", Materno = "Copa", Telefono = 2269587, }; var queryable = new List<Student> { data }.AsQueryable(); mockSet.As<IQueryable<Student>>().Setup(m => m.Provider).Returns(queryable.Provider); mockSet.As<IQueryable<Student>>().Setup(m => m.Expression).Returns(queryable.Expression); mockSet.As<IQueryable<Student>>().Setup(m => m.ElementType).Returns(queryable.ElementType); mockSet.As<IQueryable<Student>>().Setup(m => m.GetEnumerator()).Returns(queryable.GetEnumerator()); mockContext.Setup(m => m.SaveChanges()).Verifiable(); var service = new UniversityContextService(mockContext.Object); service.UpdateStudent(data); var mostrar = service.Show(); mockContext.Verify(); Assert.AreEqual(1, mostrar.Count); Assert.AreEqual("Carlos", mostrar[0].Nombre); Assert.AreEqual(2269587, mostrar[0].Telefono); }
private static void AddStudent(string fName, string lName, string number, Course course) { var db = new UniversityContext(); var student = new Student(); student.FirstName = fName; student.LastName = lName; student.Number = number; student.Courses.Add(course); db.Students.Add(student); db.SaveChanges(); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Student = await _context.Students.FirstOrDefaultAsync(m => m.ID == id); if (Student == null) { return(NotFound()); } return(Page()); }
public void UpdateStudent(Student student) { int? x = student.StudentId; if (!x.HasValue) { _context.Students.Add(new Student { StudentId = student.StudentId, Nombre = student.Nombre, Paterno = student.Paterno, Materno = student.Materno, Telefono = student.Telefono}); _context.SaveChanges(); } else { var entity = _context.Students.Where(s => s.StudentId == student.StudentId).Single(); entity.Telefono = student.Telefono; _context.SaveChanges(); } }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Student = await _context.Students.FindAsync(id); if (Student != null) { _context.Students.Remove(Student); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public void DeberiaEliminar() { var mockSet = new Mock<DbSet<Student>>(); var mockContext = new Mock<UniversityContext>(); mockContext.Setup(m => m.Students).Returns(mockSet.Object); var data = new Student { StudentId = 1, Nombre = "Carlos", Paterno = "Estrada", Materno = "Copa", Telefono = 2269587}; var queryable = new List<Student> { data }.AsQueryable(); mockSet.As<IQueryable<Student>>().Setup(m => m.Provider).Returns(queryable.Provider); mockSet.As<IQueryable<Student>>().Setup(m => m.Expression).Returns(queryable.Expression); mockSet.As<IQueryable<Student>>().Setup(m => m.ElementType).Returns(queryable.ElementType); mockSet.As<IQueryable<Student>>().Setup(m => m.GetEnumerator()).Returns(queryable.GetEnumerator()); mockSet.Setup(m => m.Remove(data)).Verifiable(); mockContext.Setup(m => m.SaveChanges()).Verifiable(); var service = new UniversityContextService(mockContext.Object); service.DeleteStudent("Carlos");//elimina por nombre mockContext.Verify(); }
static void Main(string[] args) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<UniversityContext, Configuration>()); var db = new UniversityContext(); var student = new Student { Name = "Pesho", Number = 11111 }; var studentTwo = new Student { Name = "Misho", Number = 22222 }; var studentThree = new Student { Name = "Gosho", Number = 33333 }; var course = new Course { Name = "Programming 101", Description = "Introduction to Programming", Materials = "Youtube videos" }; student.Homeworks.Add(new Homework { Student = student, Content = "Some content" }); course.Homeworks.Add(new Homework { Course = course, Content = "Some content" }); db.Students.Add(student); db.Students.Add(studentTwo); db.Students.Add(studentThree); db.Courses.Add(course); db.SaveChanges(); }
public void UpdateStudent(Student student) { context.Entry(student).State = EntityState.Modified; }
public void InsertStudent(Student student) { context.Students.Add(student); }
private void UpdateStudentCourses(string[] selectedCourses, Student studentToUpdate) { if (selectedCourses == null) { studentToUpdate.Enrollments = new List<Enrollment>(); return; } var selectedCoursesHS = new HashSet<string>(selectedCourses); var studentCourses = new HashSet<int> (studentToUpdate.Enrollments.Select(c => c.CourseID)); foreach (var enrollment in db.Enrollments) { if (selectedCoursesHS.Contains(enrollment.CourseID.ToString())) { if (!studentCourses.Contains(enrollment.CourseID)) { studentToUpdate.Enrollments.Add(enrollment); } } else { if (studentCourses.Contains(enrollment.CourseID)) { studentToUpdate.Enrollments.Remove(enrollment); } } } }
private void PopulateAssignedCourseData(Student student) { var allCourses = db.Courses; var studentCourses = new HashSet<int>(student.Enrollments.Select(c => c.CourseID)); var viewModel = new List<StudentEnrollmentCourses>(); foreach (var course in allCourses) { viewModel.Add(new StudentEnrollmentCourses { CourseID = course.CourseID, Title = course.Title, StudentEnrollment = studentCourses.Contains(course.CourseID) }); } ViewBag.Courses = viewModel; }