public IHttpActionResult GetAllStudents()
{
IList <StudentViewModel> students = null;
using (var ctx = new SchoolMgmtEntities())
{
students = ctx.Students.Include("StudentAddress").Select(s => new StudentViewModel()
{
Id = s.StudentID,
FirstName = s.FirstName,
LastName = s.LastName
//,
//Address = s.StudentAddress == null || includeAddress == false ? null : new AddressViewModel()
//{
// StudentId = s.StudentAddress.StudentID,
// Address1 = s.StudentAddress.Address1,
// Address2 = s.StudentAddress.Address2,
// City = s.StudentAddress.City,
// State = s.StudentAddress.State
//}
}).ToList <StudentViewModel>();
}
if (students == null)
{
return(NotFound());
}
return(Ok(students));
}
public IHttpActionResult Put(StudentViewModel student)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new SchoolMgmtEntities())
{
var existingStudent = ctx.Students.Where(s => s.StudentID == student.Id)
.FirstOrDefault <Student>();
if (existingStudent != null)
{
existingStudent.FirstName = student.FirstName;
existingStudent.LastName = student.LastName;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult Delete(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid student id"));
}
using (var ctx = new SchoolMgmtEntities())
{
var student = ctx.Students
.Where(s => s.StudentID == id)
.FirstOrDefault();
ctx.Entry(student).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewStudent(StudentViewModel student)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SchoolMgmtEntities())
{
ctx.Students.Add(new Student()
{
StudentID = student.Id,
FirstName = student.FirstName,
LastName = student.LastName
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetAllStudents(string name)
{
IList <StudentViewModel> students = null;
using (var ctx = new SchoolMgmtEntities())
{
students = ctx.Students.Include("StudentAddress")
.Where(s => s.FirstName.ToLower() == name.ToLower())
.Select(s => new StudentViewModel()
{
Id = s.StudentID,
FirstName = s.FirstName,
LastName = s.LastName
}).ToList <StudentViewModel>();
}
if (students.Count == 0)
{
return(NotFound());
}
return(Ok(students));
}
public IHttpActionResult GetStudentById(int id)
{
StudentViewModel student = null;
using (var ctx = new SchoolMgmtEntities())
{
student = ctx.Students.Include("StudentAddress")
.Where(s => s.StudentID == id)
.Select(s => new StudentViewModel()
{
Id = s.StudentID,
FirstName = s.FirstName,
LastName = s.LastName
}).FirstOrDefault <StudentViewModel>();
}
if (student == null)
{
return(NotFound());
}
return(Ok(student));
}
public IHttpActionResult GetAllStudentsInSameStandard(int standardId)
{
IList <StudentViewModel> students = null;
using (var ctx = new SchoolMgmtEntities())
{
students = ctx.Students.Include("StudentAddress").Include("Standard").Where(s => s.StandardID == standardId)
.Select(s => new StudentViewModel()
{
Id = s.StudentID,
FirstName = s.FirstName,
LastName = s.LastName
//,
//Address = s.StudentAddress == null ? null : new AddressViewModel()
//{
// StudentId = s.StudentAddress.StudentID,
// Address1 = s.StudentAddress.Address1,
// Address2 = s.StudentAddress.Address2,
// City = s.StudentAddress.City,
// State = s.StudentAddress.State
//}
,
Standard = new StandardViewModel()
{
StandardId = s.Standard.StandardID,
Name = s.Standard.StandardName
}
}).ToList <StudentViewModel>();
}
if (students.Count == 0)
{
return(NotFound());
}
return(Ok(students));
}
