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)); }
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 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; } }
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); } }
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)); }
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); } }