public static int DeleteReport(Report report)
{
using (DbEntities db = new DbEntities())
{
db.Attach(report);
db.Reports.DeleteObject(report);
db.ObjectStateManager.ChangeObjectState(report, System.Data.EntityState.Deleted);
//remove transfer with this report
var transfers = db.Transfers.Where(t => t.ReportFromId.Equals(report.Id) || t.ReportToId.Equals(report.Id)).ToList();
transfers.ForEach(t => db.DeleteObject(t));
return db.SaveChanges();
}
}
public static int UpsertColumn(Column column)
{
using (DbEntities db = new DbEntities())
{
if (column.EntityKey == null)
{
//new column so insert
db.Columns.AddObject(column);
//db.ObjectStateManager.ChangeObjectState(newReport, System.Data.EntityState.Added);
}
else
{
//update report
db.Attach(column);
db.ObjectStateManager.ChangeObjectState(column, System.Data.EntityState.Modified);
}
return db.SaveChanges();
}
}
public static int UpsertTransfer(List<Transfer> transfers)
{
using (DbEntities db = new DbEntities())
{
foreach (Transfer transfer in transfers)
{
if (transfer.EntityKey == null)
{
db.Transfers.AddObject(transfer);
}
else
{
db.Attach(transfer);
db.ObjectStateManager.ChangeObjectState(transfer, System.Data.EntityState.Modified);
}
}
return db.SaveChanges();
}
}
public static int UpsertReport(Report report)
{
using (DbEntities db = new DbEntities())
{
if (report.EntityKey == null)
{
//new report so insert
db.Reports.AddObject(report);
//db.ObjectStateManager.ChangeObjectState(newReport, System.Data.EntityState.Added);
}
else
{
//update report
db.Attach(report);
db.ObjectStateManager.ChangeObjectState(report, System.Data.EntityState.Modified);
}
return db.SaveChanges();
}
}