public IHttpActionResult PutContact(int id, Contact contact) { if (id != contact.Id) { return(BadRequest()); } db.Entry(contact).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ContactExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public void InsertContact(Contact contact) { int?nextID = 0; contact.contactid = nextID.GetValueOrDefault() + 1; db.Contacts.Add(contact); db.SaveChanges(); }
public ActionResult Create(Contact contact) { if (ModelState.IsValid) { db.Contacts.Add(contact); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(contact)); }
public Contact Add(Contact item) { if (item == null) { throw new ArgumentNullException("item"); } ContactDB.Contacts.Add(item); ContactDB.SaveChanges(); return(item); }
public HttpResponseMessage SaveContact(tblContact a_contact) { int result = 0; try { dbContext.tblContacts.Add(a_contact); dbContext.SaveChanges(); result = 1; } catch (Exception e) { result = 0; } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
// POST api/Contacts public HttpResponseMessage PostContact([FromBody] Contact contact) { if (ModelState.IsValid) { try { using (ContactDBEntities entities = new ContactDBEntities()) { entities.Contacts.Add(contact); entities.SaveChanges(); } HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, contact); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = contact.Id })); return(response); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public void UpdateContact(ContactModel contact) { using (ContactDBEntities db = new ContactDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { ContactView CT = db.ContactViews.Find(contact.ContactID); CT.FirstName = contact.FirstName; CT.LastName = contact.LastName; CT.Phone = contact.Phone; CT.Email = contact.Email; CT.Street = contact.Street; CT.City = contact.City; CT.State = contact.State; CT.PostalCode = contact.PostalCode; CT.DisplayName = contact.DisplayName; db.SaveChanges(); dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public void AddContact(ContactModel contact) { using (ContactDBEntities db = new ContactDBEntities()) { ContactView CT = new ContactView(); CT.FirstName = contact.FirstName; CT.LastName = contact.LastName; CT.Phone = contact.Phone; CT.Email = contact.Email; CT.Street = contact.Street; CT.City = contact.City; CT.State = contact.State; CT.PostalCode = contact.PostalCode; db.ContactViews.Add(CT); db.SaveChanges(); } }
/// <summary> /// Save method. /// </summary> public void Save() { try { _context.SaveChanges(); } catch (DbEntityValidationException e) { var outputLines = new List <string>(); foreach (var eve in e.EntityValidationErrors) { outputLines.Add(string.Format("{0}: Entity of type \"{1}\" in state \"{2}\" has the following validation errors:", DateTime.Now, eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { outputLines.Add(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } System.IO.File.AppendAllLines(@"C:\errors.txt", outputLines); throw e; } }
// DELETE api/Contacts/5 public HttpResponseMessage DeleteContact(int id) { Contact contact = db.Contacts.Find(id); if (contact == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } db.Contacts.Remove(contact); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } return(Request.CreateResponse(HttpStatusCode.OK, contact)); }
// PUT api/Contacts/5 public HttpResponseMessage PutContact(int id, Contact contact) { if (ModelState.IsValid && id == contact.Id) { try { using (ContactDBEntities entities = new ContactDBEntities()) { var contactEntity = entities.Contacts.FirstOrDefault(e => e.Id == id); if (contactEntity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id= " + id.ToString() + " not found")); } else { contactEntity.FirstName = contact.FirstName; contactEntity.LastName = contact.LastName; contactEntity.Email = contact.Email; contactEntity.PhoneNumber = contact.PhoneNumber; contactEntity.Status = contact.Status; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, contactEntity)); } } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public void DeleteUser(int contactID) { using (ContactDBEntities db = new ContactDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var CT = db.ContactViews.Where(o => o.ContactID == contactID); if (CT.Any()) { db.ContactViews.Remove(CT.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public void Commit() { _db.SaveChanges(); _transaction.Complete(); }