/// <summary> /// Returns a student whose id matches the given id /// </summary> /// <param name="id"></param> /// <returns></returns> public Students GetStudent(int id) { using (var db = new BlazorDbContext(_dbContextOptions)) { return(db.Students.Where(a => a.Id == id).FirstOrDefault()); } }
/// <summary> /// returns a list of students /// </summary> /// <returns></returns> public List <Students> ReloadAllStudents() { using (var db = new BlazorDbContext(_dbContextOptions)) { return(db.Students.ToList()); } }
/// <summary> /// returns a list of students /// </summary> /// <returns></returns> public async Task <List <Students> > GetAllStudentsAsync() { using (var db = new BlazorDbContext(_dbContextOptions)) { return(await db.Students.ToListAsync()); } }
/// <summary> /// Creates a new Student Entity /// </summary> /// <param name="student"></param> public void CreateStudent(Students student) { using (var db = new BlazorDbContext(_dbContextOptions)) { db.Students.Add(student); db.SaveChanges(); } }
/// <summary> /// Deletes a student by Id /// </summary> /// <param name="id"></param> public void RemoveStudent(int id) { using (var db = new BlazorDbContext(_dbContextOptions)) { var student = db.Students.Where(a => a.Id == id).FirstOrDefault(); db.Remove(student); db.SaveChanges(); } }
/// <summary> /// Updates a selected student /// </summary> /// <param name="student"></param> public void UpdateStudent(Students student) { using (var db = new BlazorDbContext(_dbContextOptions)) { var dbStudent = db.Students.Where(a => a.Id == student.Id).FirstOrDefault(); dbStudent.FirstName = student.FirstName; dbStudent.LastName = student.LastName; dbStudent.Gender = student.Gender; dbStudent.DateOfBirth = student.DateOfBirth; db.SaveChanges(); } }