public bool UpdateStudent(Student s) { var sDB = GetStudent(s.Id); if (sDB == null) { throw new Exception("Student not found"); } var db = new AppEfDbContext(); sDB.Firstname = s.Firstname; sDB.Lastname = s.Lastname; sDB.Gpa = s.Gpa; sDB.Sat = s.Sat; sDB.IsFulltime = s.IsFulltime; sDB.MajorId = s.MajorId; var mid = db.Majors.Find(s.Major.Id); if (mid == null) { return(false); } else { db.Students.Update(sDB); db.SaveChanges(); return(true); } }
public bool UpdateStudent(Student s) { var db = new AppEfDbContext(); var sDb = GetStudent(s.Id); if (sDb == null) { throw new Exception("Student cannot be found"); } sDb.Firstname = s.Firstname; sDb.Lastname = s.Lastname; sDb.Gpa = s.Gpa; sDb.Sat = s.Sat; sDb.IsFulltime = s.IsFulltime; sDb.MajorId = s.MajorId; if (s.MajorId != null) { var major = db.Majors.Find(s.MajorId); if (major == null) { return(false); } } //db.Update<Student>(sDb); db.Students.Update(sDb); db.SaveChanges(); return(true); }
public bool RemoveStudent(Student s) { var db = new AppEfDbContext(); var rDB = GetStudent(s.Id); if (rDB == null) { throw new Exception("Student does not exist!"); } rDB.Firstname = s.Firstname; rDB.Lastname = s.Lastname; rDB.Gpa = s.Gpa; rDB.Sat = s.Sat; rDB.IsFulltime = s.IsFulltime; rDB.MajorId = s.MajorId; var major = db.Majors.Find(s.MajorId); if (major == null) { return(false); } db.Remove <Student>(rDB); db.SaveChanges(); return(true); }
public bool DeleteStudent(Student student) { var del = GetStudent(student.Id); var db = new AppEfDbContext(); if (del == null) { return(false); } db.Students.Remove(del); db.SaveChanges(); return(true); }
public bool DeleteStudent(Student dS) { var db = new AppEfDbContext(); var sDb = GetStudent(dS.Id); if (sDb == null) { return(false); } db.Students.Remove(sDb); db.SaveChanges(); return(true); }
public bool DeleteStudentById(int id) { var del = GetStudent(id); if (del == null) { return(false); } var db = new AppEfDbContext(); db.Students.Remove(del); db.SaveChanges(); return(true); }
public bool InsertStudent(Student student) { var db = new AppEfDbContext(); student.Id = 0; if (student.MajorId != null) { var major = db.Majors.Find(student.MajorId); if (major == null) { return(false); } } db.Students.Add(student); db.SaveChanges(); return(true); }