示例#1
0
 /// <summary>
 /// Adds new contact in database
 /// </summary>
 /// <param name="inputContact"></param>
 public void AddNewContact(Contact inputContact)
 {
     using (var ctx = new AppContacts())
     {
         ctx.Contacts.Add(inputContact);
         ctx.SaveChanges();
     }
 }
示例#2
0
        /// <summary>
        /// Deletes contact from database
        /// </summary>
        /// <param name="id"></param>
        public void DeleteContact(int id)
        {
            using (var ctx = new AppContacts())
            {
                var contact = ctx.Contacts
                              .Where(s => s.ContactId == id)
                              .FirstOrDefault();

                ctx.Contacts.Remove(contact);
                ctx.SaveChanges();
            }
        }
示例#3
0
        /// <summary>
        /// Updates contact information in database
        /// </summary>
        /// <param name="inputContact"></param>
        /// <returns>integer indicating whether the operation was successful</returns>
        public int UpdateContact(Contact inputContact)
        {
            using (var ctx = new AppContacts())
            {
                var existingContact = ctx.Contacts.Where(s => s.ContactId == inputContact.ContactId)
                                      .FirstOrDefault <Contact>();

                if (existingContact != null)
                {
                    existingContact.FirstName     = inputContact.FirstName;
                    existingContact.LastName      = inputContact.LastName;
                    existingContact.Email         = inputContact.Email;
                    existingContact.PhoneNumber   = inputContact.PhoneNumber;
                    existingContact.ContactStatus = inputContact.ContactStatus;

                    ctx.SaveChanges();
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
        }