public List<Student> getStudents(int groupId) { using (var db = new StorageContext()) return db.Students.Where( student => student.Group.GroupId == groupId) .ToList(); }
public void createStudent(string firstName, string lastName, string indexNo, int groupId) { using (var db = new StorageContext()) { var group = db.Groups.Find(groupId); var student = new Student { FirstName = firstName, LastName = lastName, IndexNo = indexNo, Group = group }; db.Students.Add(student); db.SaveChanges(); } }
public void deleteStudent(Student st) { using (var db = new StorageContext()) { var original = db.Students.Find(st.StudentId); if (original != null) { db.Students.Remove(original); db.SaveChanges(); } } }
public void updateStudent(Student st) { using (var db = new StorageContext()) { var original = db.Students.Find(st.StudentId); if (original != null) { original.FirstName = st.FirstName; original.LastName = st.LastName; int groupId = original.Group.GroupId; original.IndexNo = st.IndexNo; try { db.SaveChanges(); } catch (DbEntityValidationException ex) { Console.WriteLine(ex.EntityValidationErrors.ElementAt(0).ValidationErrors.ElementAt(0).ErrorMessage); } } } }
public List<Group> getGroups() { using (var db = new StorageContext()) return db.Groups.ToList(); }