private void UpdateIssue(Issue issue, AudiReportContext context)
{
// Find Issue by Id
Issue issueModel = context.Issues.Include("Recommendations").Where(i => i.IssueId == issue.IssueId).FirstOrDefaultAsync().Result;
// Update Data
issueModel.Title = issue.Title;
issueModel.Description = issue.Description;
Context.Entry(issueModel).State = EntityState.Modified;
Context.SaveChanges();
}
private void DeleteIssue(int issueId, AudiReportContext context)
{
var issue = context.Issues.Where(x => x.IssueId == issueId).FirstOrDefault();
context.Issues.Attach(issue);
context.Issues.Remove(issue);
context.SaveChanges();
}
public void UpdateOnlyAudit(int auditId, string docId)
{
using (Context = new AudiReportContext())
{
var audit = Context.Audits.Where(x => x.AuditId == auditId).FirstOrDefault();
audit.GoogleDocId = docId;
Context.Entry(audit).State = EntityState.Modified;
Context.SaveChanges();
}
}
public void UpdateAudit(Audit audit)
{
Audit model = FindAuditById(audit.AuditId);
using (Context = new AudiReportContext())
{
model.Title = audit.Title;
Context.Entry(model).State = EntityState.Modified;
Context.SaveChanges();
// Update or add Issues
AddOrUpdateIssue(model.AuditId, audit, Context);
// Update or add Recommendations
foreach (Issue issue in audit.Issues)
{
if (issue.Recommendations != null)
{
AddOrUpdateRecommendation(issue.Recommendations, issue.IssueId, Context);
}
}
}
}
private void CreateIssue(Issue issue, AudiReportContext context)
{
context.Issues.Add(issue);
context.SaveChanges();
}
private void CreateRecommendation(Recommendation recommendation, AudiReportContext context)
{
context.Recommendations.Add(recommendation);
context.SaveChanges();
}