public void Add(Report report)
{
using (var dbContext = new CustomDBContext(connectionString))
{
dbContext.Reports.Add(report);
dbContext.SaveChanges();
}
}
public void Edit(Report report)
{
using (var dbContext = new CustomDBContext(connectionString))
{
var transaction = dbContext.Database.BeginTransaction();
//Remove
RemoveNonexistentActivities(report, dbContext);
RemoveNonexistentFuturePlans(report, dbContext);
//Edit and add
var originalReport = dbContext.Reports.Find(report.Id);
dbContext.Entry(originalReport).CurrentValues.SetValues(report);
AddNewAndEditOldActivities(report, dbContext);
AddNewAndEditOldFuturePlans(report, dbContext);
transaction.Commit();
dbContext.SaveChanges();
}
}
