public void Update(VulnerabilityDal vulnerability)
{
using (var conn = Database.GetConnection())
{
conn.Execute("update Vulnerabilities set vulnerability=@name where id=@id;", new { id = vulnerability.Id, name = vulnerability.Name });
}
}
public int Insert(VulnerabilityDal vulnerability)
{
using (var conn = Database.GetConnection())
{
conn.Execute("insert into Vulnerabilities (vulnerability) values (@name);", new { name = vulnerability.Name });
var result = conn.Query <VulnerabilityDal>("select id, vulnerability AS name from Vulnerabilities where name=@name;", vulnerability.Name).FirstOrDefault();
return(result == null ? -1 : result.Id);
}
}
