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