public int Insert(RiskAssessment risk)
{
using (var db = new RiskAssessmentDbContext())
{
db.RiskAssessments.Add(risk);
db.SaveChanges();
return(risk.id);
}
}
public int Insert(Threat threat)
{
using (var db = new RiskAssessmentDbContext())
{
db.Threats.Add(threat);
db.SaveChanges();
return(threat.Id);
}
}
public void Delete(int id)
{
using (var db = new RiskAssessmentDbContext())
{
Threat t = Read(id).FirstOrDefault();
if (t != null)
{
db.Threats.Remove(t);
db.SaveChanges();
}
else
{
throw new Exception("No Threat has the ID: " + id);
}
}
}
public void Update(RiskAssessment riskAssessment)
{
using (var db = new RiskAssessmentDbContext())
{
RiskAssessment r = Read(riskAssessment.id).FirstOrDefault();
if (r != null)
{
r.Title = riskAssessment.Title;
r.Latitude = riskAssessment.Latitude;
r.Longitude = riskAssessment.Longitude;
r.Threats = riskAssessment.Threats;
db.RiskAssessments.Update(r);
db.SaveChanges();
}
else
{
throw new Exception("No Risk has the ID: " + riskAssessment.id);
}
}
}