public int UpdateStudent(Student student, List <Course> courses)
{
using (var db = new MiniDbContext())
{
var oldStudent = db.Students
.Include("Courses")
.Include("Address")
.SingleOrDefault(s => s.StudentId == student.StudentId);
foreach (var item in oldStudent.Courses.ToList())
{
oldStudent.Courses.Remove(item);
}
db.Entry(oldStudent).CurrentValues.SetValues(student);
db.Entry(oldStudent.Address).CurrentValues.SetValues(student.Address);
foreach (var item in courses)
{
oldStudent.Courses.Add(item);
}
return(db.SaveChanges());
}
}
public List <Course> GetCourses()
{
using (var db = new MiniDbContext())
{
return(db.Courses.Select(c => c).ToList());
}
}
public List <Student> GetStudents()
{
using (var db = new MiniDbContext())
{
return(db.Students
.Include("Courses")
.Include("Address").ToList());
}
}
public Student GetStudent(int StudentId)
{
using (var db = new MiniDbContext())
{
return(db.Students
.Include("Courses")
.Include("Address")
.Where(s => s.StudentId == StudentId)
.FirstOrDefault() as Student);
}
}
public int DeleteStudent(int StudentId)
{
using (var db = new MiniDbContext())
{
Student student = db.Students.Where(s => s.StudentId == StudentId)
.Include("Address")
.SingleOrDefault();
db.Students.Remove(student);
//db.Entry(student).State = EntityState.Deleted;
return(db.SaveChanges());
}
}
public int AddStudent(Student student, List <Course> courses)
{
using (var db = new MiniDbContext())
{
student.Courses = courses;
db.Students.Add(student);
//Ne dodaje child tabeli objekte, vec ih samo vezuje za parenta.
foreach (Course course in courses)
{
db.Entry(course).State = EntityState.Unchanged;
}
return(db.SaveChanges());
}
}
public List <Student> GetStudentsSorted(string sortbytype)
{
using (var db = new MiniDbContext())
{
try
{
switch (sortbytype)
{
case ("First Name - Ascending"):
return(db.Students
.Include("Courses")
.Include("Address")
.OrderBy(s => s.sFirstName).ToList());
case ("First Name - Descending"):
return(db.Students
.Include("Courses")
.Include("Address")
.OrderByDescending(s => s.sFirstName).ToList());
case ("Last Name - Ascending"):
return(db.Students
.Include("Courses")
.Include("Address")
.OrderBy(s => s.sLastName).ToList());
case ("Last Name - Descending"):
return(db.Students
.Include("Courses")
.Include("Address")
.OrderByDescending(s => s.sLastName).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
return(null);
}
}
public List <Course> SortStudentsWithCourses(List <Course> courses)
{
var Courses = new List <Course>();
using (var db = new MiniDbContext())
{
Courses = db.Courses
.Include("Students").ToList();
}
var SortedCourses = new List <Course>();
foreach (var course in courses)
{
foreach (var coursedb in Courses)
{
if (course.CourseId == coursedb.CourseId)
{
SortedCourses.Add(coursedb);
}
}
}
return(SortedCourses);
}
public DataProvider(MiniDbContext dbContext)
{
this.dbContext = dbContext;
}
public SourceService(MiniDbContext _dbContext)
{
dbContext = _dbContext;
}
public SourcesController(MiniDbContext context)
{
_context = context;
}
