private void deleteTransientUserReport(UserReport userReport, ReportProjectDBEntities entities)
{
// delete the summarize fields
var sumFields = (from ursf in entities.UserReportSummarizeField
where ursf.UserReportID == userReport.UserReportID
select ursf).ToList();
foreach (UserReportSummarizeField sumField in sumFields)
{
entities.DeleteObject(sumField);
}
// delete the fields
//TODO: NOt necessary, must be a cascade delete in the database
// delete the parameters
var userReportParms = (from urp in entities.UserReportParameter
where urp.UserReportID == userReport.UserReportID
select urp).ToList();
foreach (UserReportParameter userReportParameter in userReportParms)
{
entities.DeleteObject(userReportParameter);
}
// delete the user report
entities.DeleteObject(userReport);
entities.SaveChanges();
}
public void SetReportTypeCheckpoints(List <Rpt> reportTypes, string checkpointID)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
var removeReport_ICESecurityCheckpoint = from rptj in entities.Report_ICESecurityCheckpoint
where rptj.CheckpointID.Trim() == checkpointID.Trim()
select rptj;
foreach (Report_ICESecurityCheckpoint Report_ICESecurityCheckpoint in removeReport_ICESecurityCheckpoint)
{
entities.DeleteObject(Report_ICESecurityCheckpoint);
}
entities.SaveChanges();
foreach (Rpt rpt in reportTypes)
{
entities.AddToReport_ICESecurityCheckpoint(new Report_ICESecurityCheckpoint {
CheckpointID = checkpointID, ReportID = rpt.ID
});
}
entities.SaveChanges();
}