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