public IHttpActionResult DeleteSolutionOffers(DeleteSoltuionOfferModel offer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } SolutionOffer _offer = null; string measureId = offer.Measure_id; string solutionId = offer.Solution_id; using (SoilCareEntities db = new SoilCareEntities()) { _offer = db.SolutionOffers.Where(s => s.Measure_id.Equals(measureId) && s.Solution_id.Equals(solutionId)) .FirstOrDefault <SolutionOffer>(); if (_offer == null) { db.Dispose(); return(NotFound()); } _offer.Status = "Deleted"; try { db.SaveChanges(); } catch (DbUpdateException) { throw; } } return(Ok()); }
public IHttpActionResult PutSolutionOffer(string id, SolutionOfferModel offer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } SolutionOffer _offer = null; using (SoilCareEntities db = new SoilCareEntities()) { _offer = db.SolutionOffers.Find(new string[] { id, offer.Solution_id }); if (_offer == null) { return(NotFound()); } AutoMapper.Mapper.Map <SolutionOfferModel, SolutionOffer>(offer, _offer); _offer.Status = "Modified"; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { throw; } } return(Ok()); }
public IHttpActionResult PutUser(string id, AddUserModel user) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } User _user = null; using (SoilCareEntities db = new SoilCareEntities()) { _user = db.Users.Find(id); if (_user == null) { return(NotFound()); } // Map model to entity Mapper.Map <AddUserModel, User>(user, _user); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { throw; } } return(Ok()); }
public IHttpActionResult PostSolutionsToMeasure(AddSolutionOfferModel offer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } string measureId = offer.Measure_id; using (SoilCareEntities db = new SoilCareEntities()) { foreach (string solutionId in offer.Solution_id) { db.SolutionOffers.Add(new SolutionOffer { Measure_id = measureId, Solution_id = solutionId, Status = "Unchanged", }); } try { db.SaveChanges(); } catch (DbUpdateException) { throw; } } return(CreatedAtRoute("DefaultApi", new { id = measureId }, offer)); }
public IHttpActionResult PostPlant(AddMeasureModel measure) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Measure _measure = Mapper.Map <AddMeasureModel, Measure>(measure); _measure.Measure_id = Guid.NewGuid().ToString("N"); using (SoilCareEntities db = new SoilCareEntities()) { db.Measures.Add(_measure); try { db.SaveChanges(); } catch (DbUpdateException) { if (MeasureExists(db, _measure.Measure_id)) { return(Conflict()); } throw; } } return(CreatedAtRoute("DefaultApi", new { id = _measure.Measure_id }, _measure)); }
// POST telephone first: api/Users public User PostUserByTelephone(string telephone) { User _user = new User(); _user.User_id = Guid.NewGuid().ToString("N"); _user.Created_at = DateTime.Now; _user.User_telephone = telephone; using (SoilCareEntities db = new SoilCareEntities()) { db.Users.Add(_user); try { db.SaveChanges(); } catch (DbUpdateException) { if (UserExists(db, _user.User_id)) { return(null); } throw; } } return(_user); }
public IHttpActionResult PostSolution([FromBody] AddSolutionModel solution) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Solution _solution; using (SoilCareEntities db = new SoilCareEntities()) { string initSolutionId = Guid.NewGuid().ToString("N"); _solution = new Solution(); _solution = Mapper.Map <AddSolutionModel, Solution>(solution); _solution.Solution_id = initSolutionId; _solution.Owner = "User"; db.Solutions.Add(_solution); try { db.SaveChanges(); } catch (DbUpdateException) { if (SolutionExists(db, _solution.Solution_id)) { return(Conflict()); } throw; } } return(CreatedAtRoute("DefaultApi", new { id = _solution.Solution_id }, _solution)); }
public IHttpActionResult PutLand(string id, AddLandModel land) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Land _land = null; using (SoilCareEntities db = new SoilCareEntities()) { _land = db.Lands.Find(id); if (_land == null) { return(NotFound()); } // Map model to entity _land.Land_name = land.Land_name; _land.Land_image = land.Land_image; _land.Land_address = land.Land_address; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { throw; } } return(Ok()); }
public IHttpActionResult PostLand(AddLandModel land) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Land _land = Mapper.Map <AddLandModel, Land>(land); _land.Land_id = Guid.NewGuid().ToString("N"); _land.Created_at = DateTime.Now; _land.Status = "Active"; using (SoilCareEntities db = new SoilCareEntities()) { db.Lands.Add(_land); try { db.SaveChanges(); } catch (DbUpdateException) { if (LandExists(db, _land.Land_id)) { return(Conflict()); } throw; } } return(CreatedAtRoute("DefaultApi", new { id = _land.Land_id }, _land)); }
public IHttpActionResult PostPlant(AddPlantModel plant) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } string initId = Guid.NewGuid().ToString("N"); Plant _plant = Mapper.Map <AddPlantModel, Plant>(plant); _plant.Plant_id = initId; _plant.Status = "Pending"; using (SoilCareEntities db = new SoilCareEntities()) { db.Plants.Add(_plant); try { db.SaveChanges(); } catch (DbUpdateException) { if (PlantExists(db, _plant.Plant_id)) { return(Conflict()); } throw; } } return(CreatedAtRoute("DefaultApi", new { id = _plant.Plant_id }, _plant)); }
// Delete: api/Lands/landId public IHttpActionResult DeleteLand(string id) { Land _land = null; using (SoilCareEntities db = new SoilCareEntities()) { _land = db.Lands.Find(id); if (_land == null) { db.Dispose(); return(NotFound()); } _land.Status = "Deleted"; try { db.SaveChanges(); } catch (DbUpdateException) { throw; } } return(Ok()); }