public IHttpActionResult Posttbl_ContactDetails(tbl_ContactDetails ContactDetails) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } List <tbl_ContactDetails> tbl_ContactDetails = db.tbl_ContactDetails.Where(c => c.Email == ContactDetails.Email).ToList(); if (tbl_ContactDetails.Any()) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Email already exist with other contact")); } tbl_ContactDetails = db.tbl_ContactDetails.Where(c => c.PhoneNumber == ContactDetails.PhoneNumber).ToList(); if (tbl_ContactDetails.Any()) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Phone Number is already exist with other contact")); } db.tbl_ContactDetails.Add(ContactDetails); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = ContactDetails.Id }, ContactDetails)); }
public IHttpActionResult Puttbl_ContactDetails(int id, tbl_ContactDetails tbl_ContactDetails) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_ContactDetails.Id) { return(BadRequest()); } db.Entry(tbl_ContactDetails).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_ContactDetailsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Gettbl_ContactDetails(int id) { tbl_ContactDetails tbl_ContactDetails = db.tbl_ContactDetails.Find(id); if (tbl_ContactDetails == null) { return(NotFound()); } return(Ok(tbl_ContactDetails)); }
public IHttpActionResult Deletetbl_ContactDetails(int id) { tbl_ContactDetails tbl_ContactDetails = db.tbl_ContactDetails.Find(id); if (tbl_ContactDetails == null) { return(NotFound()); } db.tbl_ContactDetails.Remove(tbl_ContactDetails); db.SaveChanges(); return(Ok(tbl_ContactDetails)); }