public IQueryable<SchoolModel> Get() { var responseMsg = this.PerformOperationAndHandleExceptions(() => { var db = new SchoolContext(); var result = db.Schools.Select(s => new SchoolModel() { Id = s.Id, Location = s.Location, Name = s.Name }); return result; }); return responseMsg; }
public SchoolModel GetById(int id) { var responseMsg = this.PerformOperationAndHandleExceptions(() => { var result = new SchoolModel(); var db = new SchoolContext(); var school = db.Schools.Find(id); if (school != null) { result.Id = school.Id; result.Location = school.Location; result.Name = school.Name; } return result; }); return responseMsg; }
public IQueryable<StudentModel> Get() { var responseMsg = this.PerformOperationAndHandleExceptions(() => { var db = new SchoolContext(); var result = db.Students.Select(s => new StudentModel() { Id = s.Id, FirstName = s.FirstName, LastName = s.LastName, Age = s.Age, Grade = s.Grade }); return result; }); return responseMsg; }
public HttpResponseMessage Post(SchoolModel school) { var responseMsg = this.PerformOperationAndHandleExceptions(() => { var newcSchool = new School() { Location = school.Location, Name = school.Name }; var db = new SchoolContext(); db.Schools.Add(newcSchool); db.SaveChanges(); school.Id = newcSchool.Id; var response = this.Request.CreateResponse(HttpStatusCode.Created, school); return response; }); return responseMsg; }
public IQueryable<StudentModel> GetById(string subject, double value) { var responseMsg = this.PerformOperationAndHandleExceptions(() => { var db = new SchoolContext(); var result = db.Students .Where(s => s.Marks.Any(m => m.Subject == subject && Equals(m.Value, value))) .Select(s => new StudentModel() { Id = s.Id, FirstName = s.FirstName, LastName = s.LastName, Age = s.Age, Grade = s.Grade }); return result; }); return responseMsg; }
public StudentModel GetById(int id) { var responseMsg = this.PerformOperationAndHandleExceptions(() => { var result = new StudentModel(); var db = new SchoolContext(); var s = db.Students.Find(id); if (s != null) { result.Id = s.Id; result.FirstName = s.FirstName; result.LastName = s.LastName; result.Age = s.Age; result.Grade = s.Grade; } return result; }); return responseMsg; }
public HttpResponseMessage Post(StudentModel student) { var responseMsg = this.PerformOperationAndHandleExceptions(() => { var newStudent = new Student() { FirstName = student.FirstName, LastName = student.LastName, Age = student.Age, Grade = student.Grade, School = null, SchoolId = null }; var db = new SchoolContext(); db.Students.Add(newStudent); db.SaveChanges(); student.Id = newStudent.Id; var response = this.Request.CreateResponse(HttpStatusCode.Created, student); return response; }); return responseMsg; }