public ActionResult Create(contactDb contactdb) { if (ModelState.IsValid) { contactdb.ID = db.contactDbs.ToList()[db.contactDbs.ToList().Count - 1].ID + 1; db.contactDbs.Add(contactdb); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(contactdb)); }
public void Update(Contact contact) { using (ContactDbEntities db = new ContactDbEntities()) { db.Contacts.Attach(contact); db.Entry(contact).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public Contact Insert(Contact contact) { using (ContactDbEntities db = new ContactDbEntities()) { db.Contacts.Add(contact); db.SaveChanges(); return(contact); } }
public void Delete(Contact contact) { using (ContactDbEntities db = new ContactDbEntities()) { db.Contacts.Attach(contact); db.Contacts.Remove(contact); db.SaveChanges(); } }
public void DeleteContactDAL(int id) { using (var ctx = new ContactDbEntities()) { var contact = ctx.Contacts .Where(s => s.Id == id) .FirstOrDefault(); ctx.Entry(contact).State = System.Data.EntityState.Deleted; ctx.SaveChanges(); } }
public void AddNewContactDAL(ContactViewModel contact) { using (var ctx = new ContactDbEntities()) { ctx.Contacts.Add(new Contact() { Id = contact.Id, First_Name = contact.FirstName, Last_Name = contact.LastName, Email = contact.Email, Phone_Number = contact.PhoneNumber, Status = contact.Status }); ctx.SaveChanges(); } }
public bool UpdateContactDAL(ContactViewModel contact) { using (var ctx = new ContactDbEntities()) { var existingContact = ctx.Contacts.Where(s => s.Id == contact.Id) .FirstOrDefault <Contact>(); if (existingContact != null) { existingContact.First_Name = contact.FirstName; existingContact.Last_Name = contact.LastName; existingContact.Email = contact.Email; existingContact.Phone_Number = contact.PhoneNumber; existingContact.Status = contact.Status; ctx.SaveChanges(); return(true); } else { return(false); } } }