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);
}
