private void DeleteTransactions(tblProjectInfo p, iatiactivity MatchedProject)
{
//Commitments
if (MatchedProject.IsPlannedDisbursmentIncluded)
{
var aimsCommitments = p.tblProjectFundingCommitments.Where(w => w.FundSourceId == MatchedProject.AimsFundSourceId).ToList();
foreach (var cc in aimsCommitments)
{
dbContext.tblProjectFundingCommitments.Remove(cc);
}
}
//PlannedDisbursements
if (MatchedProject.IsPlannedDisbursmentIncluded)
{
var planDisb = p.tblProjectFundingPlannedDisbursements.Where(w => w.FundSourceId == MatchedProject.AimsFundSourceId).ToList();
foreach (var cc in planDisb)
{
dbContext.tblProjectFundingPlannedDisbursements.Remove(cc);
}
}
//Disbursements
if (MatchedProject.IsDisbursmentIncluded)
{
var aimsDisbursements = p.tblProjectFundingActualDisbursements.Where(w => w.FundSourceId == MatchedProject.AimsFundSourceId).ToList();
foreach (var cc in aimsDisbursements)
{
dbContext.tblProjectFundingActualDisbursements.Remove(cc);
}
var aimsExp = p.tblProjectFundingExpenditures.Where(w => w.FundSourceId == MatchedProject.AimsFundSourceId).ToList();
foreach (var cc in aimsExp)
{
dbContext.tblProjectFundingExpenditures.Remove(cc);
}
}
}