public int DeleteContact(int id)
        {
            using (CMContext contactDataContext = new CMContext())
            {
                using (var transaction = contactDataContext.Database.BeginTransaction())
                {
                    var contact = contactDataContext.Contact.Find(id);
                    contact.Active = false;
                    contactDataContext.Update(contact);
                    contactDataContext.SaveChanges();
                    transaction.Commit();

                    return(contact != null ? 1 : 0);
                }
            }
        }
        public void EditContact(int id, Contact editedContact)
        {
            using (CMContext contactDataContext = new CMContext())
            {
                using (var transaction = contactDataContext.Database.BeginTransaction())
                {
                    var contact = contactDataContext.Contact.SingleOrDefault(x => x.Id == id);

                    contact.Active        = editedContact.Active;
                    contact.ContactNumber = editedContact.ContactNumber;
                    contact.FirstName     = editedContact.FirstName;
                    contact.LastName      = editedContact.LastName;

                    contactDataContext.Update(contact);
                    contactDataContext.SaveChanges();
                    transaction.Commit();
                }
            }
        }