public void Add(Department entity)
{
using (var contosoDbContent = new ContosoDbContext())
{
contosoDbContent.Departments.Add(entity);
contosoDbContent.SaveChanges();
}
}
public void Create(Course course)
{
using (var _db = new ContosoDbContext())
{
_db.Courses.Add(course);
_db.SaveChanges();
}
}
public void Add(Person entity)
{
using (var contosoDbContent = new ContosoDbContext())
{
contosoDbContent.Persons.Add(entity);
contosoDbContent.SaveChanges();
}
}
public void Add(Course entity)
{
using (var contosoDbContent = new ContosoDbContext())
{
contosoDbContent.Courses.Add(entity);
contosoDbContent.SaveChanges();
}
}
public void Update(Department entity)
{
using (var contosoDbContent = new ContosoDbContext())
{
contosoDbContent.Departments.Attach(entity);
contosoDbContent.Entry(entity).State = EntityState.Modified;
contosoDbContent.SaveChanges();
}
}
public void Delete(Department entity)
{
using (var contosoDbContent = new ContosoDbContext())
{
Department department = contosoDbContent.Departments.Where(d => d.Id == entity.Id).FirstOrDefault();
if (department != null)
{
contosoDbContent.Departments.Remove(department);
contosoDbContent.SaveChanges();
}
}
}
public void Delete(Person entity)
{
using (var contosoDbContent = new ContosoDbContext())
{
Person person = contosoDbContent.Persons.Where(p => p.Id == entity.Id).FirstOrDefault();
if (person != null)
{
contosoDbContent.Persons.Remove(person);
contosoDbContent.SaveChanges();
}
}
}
public void Delete(Course entity)
{
using (var contosoDbContent = new ContosoDbContext())
{
Course course = contosoDbContent.Courses.Where(c => c.Id == entity.Id).FirstOrDefault();
if (course != null)
{
contosoDbContent.Courses.Remove(course);
contosoDbContent.SaveChanges();
}
}
}
public void SaveChanges()
{
try
{
_db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
public void Create(Department department)
{
db.Departments.Add(department);
db.SaveChanges();
}
public void Create(Person person)
{
db.People.Add(person);
db.SaveChanges();
}
public void SaveChanges()
{
_context.SaveChanges();
}
public void Create(Course course)
{
db.Courses.Add(course);
db.SaveChanges();
}
public void SaveChanges()
{
_db.SaveChanges();
}