// PUT: api/Student/5
public HttpResponseMessage Put(string id, [FromBody] Student value)
{
try
{
using (EClassEntities db = new EClassEntities())
{
Student s = db.Students.SingleOrDefault(b => b.StudentID == id);
if (s != null)
{
s.StudentID = id;
s.FullName = value.FullName;
s.Email = value.Email;
s.Address = value.Address;
s.ClassID = value.ClassID;
s.PhoneNumber = value.PhoneNumber;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage EditStudent(string id, [FromBody] Student student)
{
try
{
using (EClassEntities db = new EClassEntities())
{
var s = db.Students.SingleOrDefault(x => x.StudentID == id);
if (s != null)
{
s.FullName = student.FullName;
s.ClassID = student.ClassID;
s.Birthday = student.Birthday;
s.Address = student.Address;
s.Email = student.Email;
s.Gender = student.Gender;
db.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// GET: api/Student
//ádfasdfasdfádfa
//ádfasdfasdfasdfasdfa
//hello
//hi
public HttpResponseMessage Get()
{
EClassEntities db = new EClassEntities();
var result = from s in db.Students
select new { s.StudentID, s.FullName, s.Class.Period };
return(Request.CreateResponse(HttpStatusCode.OK, result.ToList()));
}
public HttpResponseMessage GetTest1()
{
using (EClassEntities db = new EClassEntities())
{
var list = from c in db.Students
select new { c.StudentID, c.FullName, c.Class.Period };
return(Request.CreateResponse(HttpStatusCode.OK, list.ToList()));
}
}
// GET: api/Students
public List <StudentDTO> Get()
{
using (EClassEntities db = new EClassEntities())
{
List <StudentDTO> students = new List <StudentDTO>();
foreach (Student s in db.Students)
{
students.Add(new StudentDTO(s.StudentID, s.FullName, s.Birthday));
}
return(students);
}
}
// GET: api/Student/5
public StudentDTO Get(string id)
{
using (EClassEntities db = new EClassEntities())
{
Student s = db.Students.SingleOrDefault(x => x.StudentID == id);
if (s != null)
{
return(new StudentDTO(s.StudentID, s.FullName, s.Birthday));
}
else
{
return(null);
}
}
}
// GET: api/Student/5
public Student Get(string id)
{
using (EClassEntities db = new EClassEntities())
{
Student s = db.Students.SingleOrDefault(x => x.StudentID == id);
if (s != null)
{
return(s);
}
else
{
return(null);
}
}
}
public HttpResponseMessage AddStudent([FromBody] Student student)
{
try
{
using (EClassEntities db = new EClassEntities())
{
db.Students.Add(student);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// DELETE: api/Student/5
public HttpResponseMessage Delete(string id)
{
try
{
using (EClassEntities db = new EClassEntities())
{
Student s = db.Students.SingleOrDefault(x => x.StudentID == id);
db.Students.Remove(s);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public List <StudentPeriodDTO> GetTest()
{
using (EClassEntities db = new EClassEntities())
{
var list = from c in db.Students
join d in db.Classes
on c.ClassID equals d.ClassID
select new StudentPeriodDTO
{
StudentID = c.StudentID,
FullName = c.FullName,
Birthday = c.Birthday,
Period = d.Period
};
return(list.ToList());
}
}
// PUT: api/Students/5
public List <Student> EditStudent(string id, [FromBody] Student student)
{
using (EClassEntities db = new EClassEntities())
{
Student s = db.Students.SingleOrDefault(x => x.StudentID == id);
if (s != null)
{
s.FullName = student.FullName;
s.ClassID = student.ClassID;
s.Birthday = student.Birthday;
s.Address = student.Address;
s.Email = student.Email;
s.Gender = student.Gender;
}
db.SaveChanges();
return(db.Students.ToList());
}
}
public List <Student> getStudentsByGender(string gender)
{
using (EClassEntities db = new EClassEntities())
{
List <Student> liststudent = new List <Student>();
if (gender == "all")
{
liststudent = db.Students.ToList();
}
else if (gender == "female")
{
liststudent = db.Students.Where(s => s.Gender == false).ToList();
}
else
{
liststudent = db.Students.Where(s => s.Gender == true).ToList();
}
return(liststudent);
}
}
public List <Student> LayStudentByGender(string gender)
{
List <Student> listStudent = null;
using (EClassEntities db = new EClassEntities())
{
if (gender.ToLower().Equals("all"))
{
listStudent = db.Students.ToList();
}
else if (gender.ToLower().Equals("female"))
{
listStudent = db.Students.Where(x => x.Gender.Value == false).ToList();
}
else if (gender.ToLower().Equals("male"))
{
listStudent = db.Students.Where(x => x.Gender.Value == true).ToList();
}
}
return(listStudent);
}
public List <Student> GetStudentsByGender(string gender)
{
List <Student> listStudent = new List <Student>();
using (EClassEntities db = new EClassEntities())
{
if (gender.ToLower() == "all")
{
listStudent = db.Students.ToList();
}
else if (gender.ToLower() == "female")
{
listStudent = db.Students.Where(s => s.Gender.Value == false).ToList();
}
else if (gender.ToLower() == "male")
{
listStudent = db.Students.Where(s => s.Gender.Value == true).ToList();
}
}
return(listStudent);
}
// GET: api/Student
public HttpResponseMessage Get()
{
using (EClassEntities db = new EClassEntities())
{
//var result = from s in db.Students
// select new { s.StudentID, s.FullName, s.Class.Period };
var result = db.Students;
return(Request.CreateResponse(HttpStatusCode.OK, result.ToList()));
//List<StudentPeriodDTO> listS = new List<StudentPeriodDTO>();
//foreach(var student in result)
//{
// StudentPeriodDTO s = new StudentPeriodDTO(student.StudentID, student.FullName, student.Period);
// listS.Add(s);
//}
//return listS;
}
}
