// GET: api/Students
//working as intended
public IQueryable <Student> GetStudents()
{
var User_Id = IdService.getUserId(db, User);
var result = db.Students.Where((s) => s.User_Id == User_Id);
return(result);
}
// GET: api/Classrooms
//working as intended
public IQueryable <Classroom> GetClassrooms()
{
var User_Id = IdService.getUserId(db, User);
var result = from c in db.Classrooms
where c.User_Id == User_Id
select c;
return(result);
}
public async Task <IHttpActionResult> GetStudent(int id)
{
var User_Id = IdService.getUserId(db, User);
Student student = await db.Students.Where((s) => s.User_Id == User_Id && s.Stu_Id == id).FirstOrDefaultAsync();
if (student == null)
{
return(NotFound());
}
return(Ok(student));
}
public async Task <IHttpActionResult> GetClassroom(int id)
{
var User_Id = IdService.getUserId(db, User);
Classroom classroom = await db.Classrooms.Where((c) => c.User_Id == User_Id && c.Cls_Id == id).FirstOrDefaultAsync();
if (classroom == null)
{
return(NotFound());
}
return(Ok(classroom));
}
public async Task <IHttpActionResult> PostStudent(Student student)
{
student.User_Id = IdService.getUserId(db, User);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Students.Add(student);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = student.Stu_Id }, student));
}
public async Task <IHttpActionResult> PostClassroom(Classroom classroom)
{
classroom.User_Id = IdService.getUserId(db, User); //sets the user id for the new classroom
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Classrooms.Add(classroom);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = classroom.Cls_Id }, classroom));
}
public async Task <IHttpActionResult> PutStudent(int id, [FromBody] Student student)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//if the requested student does not belong to the current user
if (db.Students.AsNoTracking().Where((s) => s.Stu_Id == id).FirstOrDefault().User_Id != IdService.getUserId(db, User))
{
return(BadRequest("invalid student id for the logged in user"));
}
if (id != student.Stu_Id)
{
return(BadRequest());
}
db.Entry(student).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.OK));
}
public async Task <IHttpActionResult> DeleteStudent(int id)
{
Student student = await db.Students.FindAsync(id);
if (student == null)
{
return(NotFound());
}
//if the requested student does not belong to the current user
if (db.Students.AsNoTracking().Where((e) => e.Stu_Id == id).FirstOrDefault().User_Id != IdService.getUserId(db, User))
{
return(BadRequest("invalid student id for the logged in user"));
}
db.Students.Remove(student);
await db.SaveChangesAsync();
return(Ok(student));
}
public async Task <IHttpActionResult> DeleteClassroom(int id)
{
Classroom classroom = await db.Classrooms.FindAsync(id);
if (classroom == null)
{
return(NotFound());
}
//if the requested room does not belong to the current user
if (db.Classrooms.AsNoTracking().Where((e) => e.Cls_Id == id).FirstOrDefault().User_Id != IdService.getUserId(db, User))
{
return(BadRequest("invalid class id for the logged in user"));
}
db.Classrooms.Remove(classroom);
await db.SaveChangesAsync();
return(Ok(classroom));
}
