public IHttpActionResult PutApplicant(int id, Applicant applicant)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != applicant.applicationNo)
            {
                return(BadRequest());
            }

            db.Entry(applicant).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!ApplicantExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
示例#2
0
        public IHttpActionResult PutJob(int id, Job job)
        {
            if (id != job.jobId)
            {
                return(BadRequest());
            }

            db.Entry(job).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!JobExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public bool DeleteUser(int id)
        {
            try
            {
                //establishing database connection
                using (ORSDatabaseEntities db = new ORSDatabaseEntities())
                {
                    //deletes the user with specific id
                    User user    = db.Users.Where(f => f.userId == id).FirstOrDefault();
                    User objUser = new User()
                    {
                        userId   = user.userId,
                        password = user.password,
                        email    = user.email,
                        userName = user.userName,
                        phone    = user.phone,
                        gender   = user.gender,
                        roleId   = user.roleId
                    };
                    if (objUser != null)
                    {
                        //db.Users.Remove(user);
                        ////updates the changes in the database
                        //db.SaveChanges();

                        db.Entry(objUser).State = System.Data.Entity.EntityState.Deleted;
                        db.SaveChanges();

                        return(true);
                    }

                    else
                    {
                        //throws user defined exception
                        throw new UserException("User does not exist");
                    }
                }
            }
            catch (Exception ex)
            {
                //throws user defined exception
                throw new UserException(ex.Message);
            }
        }