Exemple #1
0
        //PUT or Update the data

        public IHttpActionResult PutCustomer(StudentDisplay student)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest("This is invalid Model. Please recheck"));
            }

            using (var x = new WebAPI_PeopleEntities())
            {
                var checkExistingStudent = x.Students.Where(s => s.id == student.Id).FirstOrDefault <Student>();

                if (checkExistingStudent != null)
                {
                    checkExistingStudent.name    = student.Name;
                    checkExistingStudent.country = student.Country;
                    checkExistingStudent.phone   = student.Phone;
                    checkExistingStudent.tempadd = student.TempAdd;

                    x.SaveChanges();
                }
                else
                {
                    return(NotFound());
                }
            }

            return(Ok());
        }
Exemple #2
0
        //Delete a record in the database

        public IHttpActionResult Delete(int id)
        {
            if (id <= 0)
            {
                return(BadRequest("Please enter valid Customer Id"));
            }

            using (var x = new WebAPI_PeopleEntities())
            {
                var student = x.Students.Where(s => s.id == id).FirstOrDefault();

                x.Entry(student).State = System.Data.Entity.EntityState.Deleted;
                x.SaveChanges();
            }
            return(Ok());
        }
Exemple #3
0
        //Post The data
        public IHttpActionResult PostNewStudent(StudentDisplay student)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest("Invalid Data. Please Recheck!"));
            }

            using (var x = new WebAPI_PeopleEntities())
            {
                x.Students.Add(new Student()
                {
                    name    = student.Name,
                    email   = student.Email,
                    country = student.Country,
                    phone   = student.Phone,
                    tempadd = student.TempAdd
                });

                x.SaveChanges();
            }
            return(Ok());
        }
Exemple #4
0
        //GET -Retrieve data

        public IHttpActionResult GetAllStudent()
        {
            IList <StudentDisplay> students = null;

            using (var x = new WebAPI_PeopleEntities())
            {
                students = x.Students
                           .Select(c => new StudentDisplay()
                {
                    Id      = c.id,
                    Name    = c.name,
                    Email   = c.email,
                    Country = c.country,
                    Phone   = c.phone,
                    TempAdd = c.tempadd
                }).ToList <StudentDisplay>();
            }
            if (students.Count == 0)
            {
                return(NotFound());
            }
            return(Ok(students));
        }