public void AddPerson(Person person) { var db = new PhBContext(); db.People.Add(person); db.SaveChanges(); }
public void AddCategory(Category category) { var db = new PhBContext(); db.Categories.Add(category); db.SaveChanges(); }
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(); }
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(); }
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(); } }
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(); } }