// GET: api/Songs/{id} public SongsModel GetSongById(string id) { SongsModel selSong = null; //grabs song based on passed id using (var ctx = new Assignment2Entities()) { selSong = ctx.songs .Where(s => (s.id).ToString() == id) .Select(s => new SongsModel() { sId = s.id, sName = s.songName, aName = s.artistName, year = s.yearPublished, }).FirstOrDefault <SongsModel>(); } //return null if no song found if (selSong == null) { return(null); } return(selSong); }
// DELETE: api/Songs/{id} public string DeleteSong(string id) { song selSong = null; using (var ctx = new Assignment2Entities()) { //grabs song based on id selSong = ctx.songs .Where(s => (s.id).ToString() == id) .FirstOrDefault(); //returns error if song not found if (selSong == null) { return("Not a valid song"); } else { //deletes song ctx.songs.Remove(selSong); ctx.SaveChanges(); return("Success"); } } }
// GET: api/Songs public List <ReviewsModel> GetAllReviews() { List <ReviewsModel> reviewList = null; using (var ctx = new Assignment2Entities()) { //grabs all reviews reviewList = ctx.reviews .Select(r => new ReviewsModel() { rId = r.reviewId, sId = r.songId, sRating = r.rating, textReview = r.review1 }).ToList <ReviewsModel>(); } //return null if no review found if (reviewList.Count == 0) { return(null); } return(reviewList); }
// DELETE: api/Reviews/5 public string DeleteReview(string id) { review selRev = null; using (var ctx = new Assignment2Entities()) { //finds review selRev = ctx.reviews .Where(s => (s.reviewId).ToString() == id) .FirstOrDefault(); //return error if review not found if (selRev == null) { return("Not a valid song"); } else { //deletes review ctx.reviews.Remove(selRev); ctx.SaveChanges(); return("Success"); } } }
public CStudent GetStudent(int studentId) { Assignment2Entities db = new Assignment2Entities(); Student student = db.Students.Where(x => x.StudentId == studentId).FirstOrDefault(); List <Enroll> enrollments = student.Enrolls.ToList(); List <CCourse> cCourses = new List <CCourse>(); CourseWebService courseWebService = new CourseWebService(); foreach (Enroll e in enrollments) { cCourses.Add(courseWebService.ConvertToCCourse(e.Course)); } CStudent classStudent = new CStudent(); db.Dispose(); classStudent = ConvertToCStudent(student); classStudent.Courses = cCourses; return(classStudent); }
// GET: api/Reviews/{id} public ReviewsModel GetReviewById(string id) { ReviewsModel selReview = null; using (var ctx = new Assignment2Entities()) { //grabs selected review selReview = ctx.reviews .Where(r => (r.reviewId).ToString() == id) .Select(r => new ReviewsModel() { rId = r.reviewId, sId = r.songId, sRating = r.rating, textReview = r.review1 }).FirstOrDefault <ReviewsModel>(); } //return null if not found if (selReview == null) { return(null); } return(selReview); }
// GET: api/Songs public List <SongsModel> GetAllSongs() { List <SongsModel> songsList = null; //grabs all songs using (var ctx = new Assignment2Entities()) { songsList = ctx.songs .Select(s => new SongsModel() { sId = s.id, sName = s.songName, aName = s.artistName, year = s.yearPublished, }).ToList <SongsModel>(); } //returns null if no songs if (songsList.Count == 0) { return(null); } return(songsList); }
public CCourse GetCourse(int courseId) { Assignment2Entities db = new Assignment2Entities(); Course course = db.Courses.Where(x => x.CourseId == courseId).FirstOrDefault(); List <Enroll> enrolls = course.Enrolls.ToList(); List <CStudent> classStudents = new List <CStudent>(); StudentWebService studentWebService = new StudentWebService(); foreach (Enroll e in enrolls) { classStudents.Add(studentWebService.ConvertToCStudent(e.Student)); } CCourse cCourse = new CCourse(); db.Dispose(); cCourse = ConvertToCCourse(course); cCourse.Students = classStudents; return(cCourse); }
public Boolean AddCourse(CCourse cCourse) { Assignment2Entities db = new Assignment2Entities(); Course course = new Course(); course = ConvertToCourse(cCourse); db.Courses.Add(course); db.SaveChanges(); db.Dispose(); return(true); }
// POST: api/Reviews public string PostReview(review revPost) { using (var ctx = new Assignment2Entities()) { if (!ModelState.IsValid) { return("Post Failed"); } //inserts review ctx.reviews.Add(revPost); ctx.SaveChanges(); return("Success"); } }
public Boolean AddStudent(CStudent classStudent) { Assignment2Entities db = new Assignment2Entities(); Student student = new Student(); student = ConvertToStudent(classStudent); db.Students.Add(student); db.SaveChanges(); db.Dispose(); return(true); }
public Boolean SaveCourse(CCourse cCourse) { Assignment2Entities db = new Assignment2Entities(); Course course = db.Courses.Where(x => x.CourseId == cCourse.CourseId).FirstOrDefault(); Course studentTemp = ConvertToCourse(cCourse); db.Entry(course).CurrentValues.SetValues(studentTemp); db.SaveChanges(); db.Dispose(); return(true); }
public Boolean SaveStudent(CStudent classStudent) { Assignment2Entities db = new Assignment2Entities(); Student student = db.Students.Where(x => x.StudentId == classStudent.StudentId).FirstOrDefault(); Student studentTemp = ConvertToStudent(classStudent); db.Entry(student).CurrentValues.SetValues(studentTemp); db.SaveChanges(); db.Dispose(); return(true); }
public Boolean DeleteStudent(int studentId) { Assignment2Entities db = new Assignment2Entities(); Student student = db.Students.Where(x => x.StudentId == studentId).FirstOrDefault(); List <Enroll> enrollments = student.Enrolls.ToList(); db.Enrolls.RemoveRange(enrollments); db.Students.Remove(student); db.SaveChanges(); db.Dispose(); return(true); }
// POST: api/Songs public string PostSong(song songPost) { using (var ctx = new Assignment2Entities()) { if (!ModelState.IsValid) { return("Post Failed"); } //inserts song into db ctx.songs.Add(songPost); ctx.SaveChanges(); return("Success"); } }
// PUT: api/Reviews/5 public string PutReview(review revPut) { using (var ctx = new Assignment2Entities()) { if (!ModelState.IsValid) { return("Put Failed"); } //edits review ctx.Entry(revPut).State = EntityState.Modified; ctx.SaveChanges(); return("Success"); } }
public Boolean DeleteCourse(int studentId) { Assignment2Entities db = new Assignment2Entities(); Course course = db.Courses.Where(x => x.CourseId == studentId).FirstOrDefault(); List <Enroll> enrolls = course.Enrolls.ToList(); db.Enrolls.RemoveRange(enrolls); db.Courses.Remove(course); db.SaveChanges(); db.Dispose(); return(true); }
public List <CCourse> GetAllCourses() { Assignment2Entities db = new Assignment2Entities(); List <Course> courses = db.Courses.ToList(); List <CCourse> cCourses = new List <CCourse>(); db.Dispose(); foreach (Course c in courses) { cCourses.Add(ConvertToCCourse(c)); } return(cCourses); }
public List <CStudent> GetAllStudents() { Assignment2Entities db = new Assignment2Entities(); List <Student> students = db.Students.ToList(); List <CStudent> classStudents = new List <CStudent>(); db.Dispose(); foreach (Student s in students) { classStudents.Add(ConvertToCStudent(s)); } return(classStudents); }
public List <CStudent> SearchStudents(String studentName) { Assignment2Entities db = new Assignment2Entities(); List <Student> students = (from m in db.Students where m.StudentName.Contains(studentName) select m).ToList(); List <CStudent> classStudents = new List <CStudent>(); db.Dispose(); foreach (Student s in students) { classStudents.Add(ConvertToCStudent(s)); } return(classStudents); }
public List <CCourse> SearchCourses(String coursename) { Assignment2Entities db = new Assignment2Entities(); List <Course> courses = (from m in db.Courses where m.CourseName.Contains(coursename) select m).ToList(); List <CCourse> cCourses = new List <CCourse>(); db.Dispose(); foreach (Course c in courses) { cCourses.Add(ConvertToCCourse(c)); } return(cCourses); }
public Boolean Enroll(int studentId, int courseId) { Assignment2Entities db = new Assignment2Entities(); Enroll enroll = db.Enrolls.Where(x => x.StudentId == studentId && x.CourseId == courseId).FirstOrDefault(); if (enroll != null) { return(false); } Enroll enrollment = new Enroll(); enrollment.StudentId = studentId; enrollment.CourseId = courseId; db.Enrolls.Add(enrollment); db.SaveChanges(); db.Dispose(); return(true); }