コード例 #1
0
        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));
        }
コード例 #3
0
 public IHttpActionResult AddDetails(JobSeeker newSeeker)
 {
     try
     {
         if (ModelState.IsValid)
         {
             JobSeeker objSeeker = entities.JobSeekers.Where(x => x.userId == newSeeker.userId).FirstOrDefault();
             if (objSeeker == null)
             {
                 entities.JobSeekers.Add(newSeeker);
                 entities.SaveChanges();
                 return(Ok(newSeeker));
             }
             else
             {
                 objSeeker.address       = newSeeker.address;
                 objSeeker.experience    = newSeeker.experience;
                 objSeeker.qualification = newSeeker.qualification;
                 objSeeker.profession    = newSeeker.profession;
                 objSeeker.skillSet      = newSeeker.skillSet;
                 objSeeker.resume        = newSeeker.resume;
                 entities.SaveChanges();
                 return(Ok(objSeeker));
             }
         }
         else
         {
             return(BadRequest(ModelState));
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #4
0
        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);
            }
        }
コード例 #5
0
        public IHttpActionResult SignUp(User objUser)
        {
            //checking if user's email already exists
            User obj = db.Users.Where(u => u.email == objUser.email).FirstOrDefault();

            if (obj != null)
            {
                //returning 409 status code , along with a error message
                return(Content(HttpStatusCode.Conflict, "User Already Exists"));
            }
            else
            {
                //adding new user
                db.Users.Add(new User()
                {
                    userName = objUser.userName,
                    password = objUser.password,
                    email    = objUser.email,
                    gender   = objUser.gender,
                    roleId   = objUser.roleId,
                    phone    = objUser.phone
                });
            }
            try
            {
                //saving changes to collection (which then save changes to Database)
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                //if user already exists
                if (UserExists(objUser.userId, objUser.email))
                {
                    return(Content(HttpStatusCode.Conflict, "User Already Exists"));
                }
                else
                {
                    throw;
                }
            }
            //success
            return(CreatedAtRoute("DefaultApi", new { id = objUser.userId }, objUser));
        }
コード例 #6
0
        public bool PutUser(int?id, User user)
        {
            try
            {
                //establishing database connection
                using (ORSDatabaseEntities db = new ORSDatabaseEntities())
                {
                    //First user with the same id that was passed is fetched and updated as per data passed by the client
                    User item = db.Users.Where(f => f.userId == id).FirstOrDefault();

                    //if the user exists
                    if (item != null)
                    {
                        // updates values into the user
                        item.password = user.password;
                        item.userName = user.userName;
                        item.email    = user.email;
                        item.phone    = user.phone;
                        item.gender   = user.gender;

                        //saving updated values in the user
                        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);
            }
        }