Esempio n. 1
0
        public void AddPerson(Person person)
        {
            var db = new PhBContext();

            db.People.Add(person);
            db.SaveChanges();
        }
Esempio n. 2
0
        public Person GetPerson(int id)
        {
            var db = new PhBContext();
            var q  = db.People.Include("Category").Single(p => p.PersonId == id);

            return(q);
        }
Esempio n. 3
0
        public Category GetCategory(int categoryId)
        {
            var db = new PhBContext();
            var q  = db.Categories.Single(p => p.CategoryId == categoryId);

            return(q);
        }
Esempio n. 4
0
        public void AddCategory(Category category)
        {
            var db = new PhBContext();

            db.Categories.Add(category);
            db.SaveChanges();
        }
Esempio n. 5
0
        public void UpdatePerson(int id, Person person)
        {
            var db      = new PhBContext();
            var operson = db.People.Single(p => p.PersonId == id);

            operson.Name        = person.Name;
            operson.PhoneNumber = person.PhoneNumber;
            db.SaveChanges();
        }
Esempio n. 6
0
        public void UpdateCategory(int id, Category category)
        {
            var db        = new PhBContext();
            var ocategory = db.Categories.Single(c => c.CategoryId == id);

            ocategory.Name = category.Name;

            db.SaveChanges();
        }
Esempio n. 7
0
        public void DeletePerson(int personId)
        {
            var db     = new PhBContext();
            var person = db.People.SingleOrDefault(p => p.PersonId == personId);

            if (person != null)
            {
                db.People.Remove(person);
                db.SaveChanges();
            }
        }
Esempio n. 8
0
        public void DeleteCategory(int categoryId)
        {
            var db       = new PhBContext();
            var category = db.Categories.SingleOrDefault(c => c.CategoryId == categoryId);

            if (category != null)
            {
                db.Categories.Remove(category);
                db.SaveChanges();
            }
        }
Esempio n. 9
0
        public IEnumerable <Person> GetPeople()
        {
            var db = new PhBContext();

            return(db.People);
        }
Esempio n. 10
0
        public IEnumerable <Category> GetCategories()
        {
            var db = new PhBContext();

            return(db.Categories.Include("People"));
        }
Esempio n. 11
0
        public void DeleteDb()
        {
            var db = new PhBContext();

            db.Database.Delete();
        }