public override void Add_Item(Instructor item) { using (ElectiveContext db = new ElectiveContext()) { db.Instructors.Add(item); db.SaveChanges(); } }
public override void Delete_Item(int item) { using (ElectiveContext db = new ElectiveContext()) { //db.Instructors.Remove(item); //db.SaveChanges(); } }
public override void Delete_Item(int item) { using (ElectiveContext db = new ElectiveContext()) { db.Students.Remove(db.Students.FirstOrDefault(e => e.Id == item)); db.SaveChanges(); } }
public override void Add_Item(Subject item) { using (ElectiveContext db = new ElectiveContext()) { db.Subjects.Add(item); db.SaveChanges(); } }
public override void Add_Item(Student item) { using (ElectiveContext db = new ElectiveContext()) { var id = db.Students.Max(p => p.Id); item.Id = ++id; db.Students.Add(item); db.SaveChanges(); } }
public override List <Instructor> Get_Data() { List <Instructor> answer = new List <Instructor>(); using (ElectiveContext db = new ElectiveContext()) { foreach (Instructor item in db.Instructors) { answer.Add(item); } } return(answer); }
public override List <Student> Get_Data() { List <Student> answer = new List <Student>(); using (ElectiveContext db = new ElectiveContext()) { foreach (Student item in db.Students) { answer.Add(item); } } return(answer); }
public static int saveScoreListToDb(List <CourseScore> score) { ElectiveContext db = new ElectiveContext(); foreach (var item in score) { if (!db.CourseScores.Exists(c => c.Equals(item))) { db.CourseScores.Add(item); } } return(5); }