Beispiel #1
0
 public void Delete(int id)
 {
     using (var context = new Model.DTO.PhonebookEntities())
     {
         try
         {
             var q = context.Person.First(p => p.ID == id) as Model.DTO.Person;
             if (q != null)
             {
                 context.Person.Remove(q);
                 context.SaveChanges();
             }
         }
         catch (Exception)
         {
             throw;
         }
         finally
         {
             if (context != null)
             {
                 context.Dispose();
             }
         }
     }
 }
Beispiel #2
0
 public void Insert(string title, string phoneNumber, string mobile)
 {
     using (var context = new Model.DTO.PhonebookEntities())
     {
         try
         {
             Model.DTO.Person ref_Person = new DTO.Person();
             ref_Person.Title       = title;
             ref_Person.PhoneNumber = phoneNumber;
             ref_Person.Mobile      = mobile;
             context.Person.Add(ref_Person);
             context.SaveChanges();
         }
         catch (Exception)
         {
             throw;
         }
         finally
         {
             if (context != null)
             {
                 context.Dispose();
             }
         }
     }
 }
Beispiel #3
0
        public void Edit(int id, string title, string phoneNumber, string mobile)
        {
            using (var context = new Model.DTO.PhonebookEntities())
            {
                try
                {
                    var q = context.Person.First(p => p.ID == id) as Model.DTO.Person;
                    if (q != null)
                    {
                        q.Title       = title;
                        q.PhoneNumber = phoneNumber;
                        q.Mobile      = mobile;

                        context.Entry(q).CurrentValues.SetValues(context.Person);
                        context.SaveChanges();
                    }
                }
                catch (Exception)
                {
                    throw;
                }
                finally
                {
                    if (context != null)
                    {
                        context.Dispose();
                    }
                }
            }
        }
Beispiel #4
0
 public List <Model.DTO.Person> SelectAll()
 {
     using (var context = new Model.DTO.PhonebookEntities())
     {
         try
         {
             var q = context.Person.ToList();
             return(q);
         }
         catch (Exception)
         {
             throw;
         }
         finally
         {
             if (context != null)
             {
                 context.Dispose();
             }
         }
     }
 }