public static void GetAllStudents() { using (var db = new StudentDB()) { students = db.StudentsDB.Include("Classes").ToList <Student>(); } }
public static Student FindStudent(String id, String pwd) { try { using (var db = new StudentDB()) { Student student = db.StudentsDB.SingleOrDefault(mystudent => mystudent.Id == id && mystudent.Pwd == pwd); return(student); } } catch { return(null); } }
public static bool AddStudnet(Student student) { try { using (var db = new StudentDB()) { db.StudentsDB.Add(student); db.SaveChanges(); } return(true); } catch (Exception e) { return(false); } }
public static bool UpdateStudnet(Student student) { try { using (var db = new StudentDB()) { db.StudentsDB.Attach(student); db.Entry(student).State = EntityState.Modified; db.SaveChanges(); } return(true); } catch { return(false); } }
public static bool DeletStudnet(Student student) { try { using (var db = new StudentDB()) { Student student1 = db.StudentsDB.Include("Classes").SingleOrDefault(mystudent => mystudent.Id == student.Id && mystudent.Pwd == student.Pwd); db.MyClassesDB.RemoveRange(student1.Classes); db.SaveChanges(); db.StudentsDB.Remove(student1); db.SaveChanges(); } return(true); } catch { return(false); } }