public HttpResponseMessage Delete(String email) { try { using (knowhauEntities entities = new knowhauEntities()) { var entity = entities.ADMINs.FirstOrDefault(e => e.email == email); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "email = " + email.ToString() + " not found to delete")); } else { var entity2 = entities.BAs.FirstOrDefault(e => e.adminemail == entity.email); while (entity2 != null) { entities.BAs.Remove(entity2); entities.SaveChanges(); entity2 = entities.BAs.FirstOrDefault(e => e.adminemail == entity.email); } entities.ADMINs.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(String beaconID, string admin) { try { using (knowhauEntities entities = new knowhauEntities()) { var entity = entities.BEACONs.FirstOrDefault(e => e.beaconID == beaconID); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "beaconID = " + beaconID.ToString() + " not found to delete")); } else { var entity3 = entities.CONTENTs.FirstOrDefault(e => e.beaconID == entity.beaconID); var entity4 = entities.HISTORICs.FirstOrDefault(e => e.contentID == entity3.contentID); while (entity4 != null) { entities.HISTORICs.Remove(entity4); entities.SaveChanges(); entity4 = entities.HISTORICs.FirstOrDefault(e => e.contentID == entity3.contentID); } while (entity3 != null) { entities.CONTENTs.Remove(entity3); entities.SaveChanges(); entity3 = entities.CONTENTs.FirstOrDefault(e => e.beaconID == entity.beaconID); } var entity2 = entities.BAs.FirstOrDefault(e => e.beaconID == entity.beaconID); while (entity2 != null) { entities.BAs.Remove(entity2); entities.SaveChanges(); entity2 = entities.BAs.FirstOrDefault(e => e.beaconID == entity.beaconID); } entities.BEACONs.Remove(entity); entities.SaveChanges(); BA id = new BA(); //id=entities.BAs.FirstOrDefault(e => e.beaconID == beaconID); LOGWEBAPP web = new LOGWEBAPP(); web.date = DateTime.Now; web.eventtype = "D"; web.username = admin; entities.LOGWEBAPPs.Add(web); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int baID) { try { using (knowhauEntities entities = new knowhauEntities()) { var entity = entities.BAs.FirstOrDefault(e => e.baID == baID); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "baID = " + baID.ToString() + " not found to delete")); } else { entities.BAs.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put(String beaconID, [FromBody] BA BA) { try { using (knowhauEntities entities = new knowhauEntities()) { var entity = entities.BAs.FirstOrDefault(e => e.beaconID == beaconID); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Beacon with id " + beaconID.ToString() + " not found to update")); } else { entity.beaconID = BA.beaconID; entity.adminemail = BA.adminemail; entity.baID = BA.baID; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put(String email, [FromBody] SUPERADMIN SUPERADMIN) { try { using (knowhauEntities entities = new knowhauEntities()) { var entity = entities.SUPERADMINs.FirstOrDefault(e => e.email == email); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "SUPERADMIN with email " + email.ToString() + " not found to update")); } else { entity.email = SUPERADMIN.email; entity.name = SUPERADMIN.name; entity.password = SUPERADMIN.password; entity.username = SUPERADMIN.username; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
/* public HttpResponseMessage Post(USERM utilizador) * { * HttpResponseMessage result; * if (ModelState.IsValid) * { * using (knowhauEntities db = new knowhauEntities()) * { * db.USERMs.Add(utilizador); * db.SaveChanges(); * } * result = Request.CreateResponse(HttpStatusCode.Created, utilizador); * } * else * { * result = Request.CreateResponse(HttpStatusCode.BadRequest, "Server failed to save data"); * } * return result; * }*/ public HttpResponseMessage Put(String email, [FromBody] USERM utilizador) { try { using (knowhauEntities entities = new knowhauEntities()) { var entity = entities.USERMs.FirstOrDefault(e => e.email == email); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Utilizador with email " + email.ToString() + " not found to update")); } else { entity.birthdate = utilizador.birthdate; entity.email = utilizador.email; entity.genre = utilizador.genre; entity.name = utilizador.name; entity.password = utilizador.password; entity.username = utilizador.username; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put(String beaconID, [FromBody] BEACON BEACON) { try { using (knowhauEntities entities = new knowhauEntities()) { BEACON entity = new BEACON(); entity = entities.BEACONs.FirstOrDefault(e => e.beaconID == beaconID); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Beacon with id " + beaconID.ToString() + " not found to update")); } else { entity.beaconID = BEACON.beaconID; entity.majorvalue = BEACON.majorvalue; entity.minorvalue = BEACON.minorvalue; entity.model = BEACON.model; entity.name = BEACON.name; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put(int contentID, [FromBody] CONTENT CONTENT) { try { using (knowhauEntities entities = new knowhauEntities()) { CONTENT entity = new CONTENT(); entity = entities.CONTENTs.FirstOrDefault(e => e.contentID == contentID); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Content with id " + contentID.ToString() + " not found to update")); } else { entity.beaconID = CONTENT.beaconID; entity.contentID = CONTENT.contentID; entity.contentmsg = CONTENT.contentmsg; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Post([FromBody] BA ba) { try { using (knowhauEntities entities = new knowhauEntities()) { entities.BAs.Add(ba); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, ba); message.Headers.Location = new Uri(Request.RequestUri + ba.baID.ToString()); return(message); } } catch (DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Post([FromBody] BEACON beacon, String admin, String mensagem, int super) { try { HttpConfiguration config = GlobalConfiguration.Configuration; config.Formatters.JsonFormatter .SerializerSettings .ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore; using (knowhauEntities entities = new knowhauEntities()) { LOGWEBAPP web = new LOGWEBAPP(); web.date = DateTime.Now; web.eventtype = "I"; web.username = admin; if (super == 0) { BA id = new BA(); id.beaconID = beacon.beaconID; id.adminemail = admin; entities.BAs.Add(id); } CONTENT cont = new CONTENT(); cont.beaconID = beacon.beaconID; cont.contentmsg = mensagem; entities.BEACONs.Add(beacon); entities.CONTENTs.Add(cont); entities.LOGWEBAPPs.Add(web); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, beacon); message.Headers.Location = new Uri(Request.RequestUri + beacon.name.ToString()); return(message); } } catch (DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }