public IHttpActionResult GetPersonTableJquery(int id) { PersonTableJquery personTableJquery = db.PersonTableJquery.Find(id); if (personTableJquery == null) { return(NotFound()); } return(Ok(personTableJquery)); }
public IHttpActionResult DeletePersonTableJquery(int id) { PersonTableJquery personTableJquery = db.PersonTableJquery.Find(id); if (personTableJquery == null) { return(NotFound()); } db.PersonTableJquery.Remove(personTableJquery); db.SaveChanges(); return(Ok(personTableJquery)); }
public HttpResponseMessage PostPersonTable(PersonTableJquery personTable) { if (!ModelState.IsValid) { var errorS = ""; errorS = ValidatePerson(personTable); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, errorS)); } db.PersonTableJquery.Add(personTable); db.SaveChanges(); return(Request.CreateErrorResponse(HttpStatusCode.NoContent, "No Content")); }
// BEMÆRK: Alt nedenstående kode herfra bruges ikke i min medsendte GET GUI, men til ADMIN GUI // som jeg ikke har sendt med!!!! // Denne metode er min validering af brugerens input - skal matche værdierne i modellen // Bruges vedr POST og PUT private string ValidatePerson(PersonTableJquery personTable) { var errorS = ""; errorS += "You need to enter valid data at: \n\n"; if (string.IsNullOrEmpty(personTable.Navn) || ((personTable.Navn).Length > 20)) { errorS += "Name\n"; } if (string.IsNullOrEmpty(personTable.Efternavn) || ((personTable.Efternavn).Length > 20)) { errorS += "LastName\n"; } if (string.IsNullOrEmpty(personTable.Alder)) { errorS += "Age\n"; } if (!string.IsNullOrEmpty(personTable.Alder)) { try { int alder = Int32.Parse(personTable.Alder); if (alder < 18 || alder > 99) { errorS += "Age is not correct, need to be between 18 and 99\n"; } } catch (Exception) { errorS += "Age is not a number\n"; } } return(errorS); }
// PUT: api/PersonTablesAPI public HttpResponseMessage PutPersonTable(int id, PersonTableJquery personTable) { if (!ModelState.IsValid) { // Min validerings metode kales var errorS = ""; errorS = ValidatePerson(personTable); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, errorS)); } if (id != personTable.Id) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "The person does not exits!")); } db.Entry(personTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!PersonTableJqueryExists(id)) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "This is no ID in the table!")); } else { throw; } } 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) { // return No } return(Request.CreateErrorResponse(HttpStatusCode.NoContent, "No Content")); }