public void Update(AgencyDal agency)
{
using (var conn = Database.GetConnection())
{
conn.Execute("update law_enforcement set agency=@name where id=@id;", new { id = agency.Id, name = agency.Agency });
}
}
public int Insert(AgencyDal agency)
{
using (var conn = Database.GetConnection())
{
conn.Execute("insert into law_enforcement (agency) values (@name);", new { name = agency.Agency });
var result = conn.Query <AgencyDal>("select id, agency from law_enforcement where agency=@name;", new { Name = agency.Agency }).FirstOrDefault();
return(result == null ? -1 : result.Id);
}
}
protected override void DataPortal_Update()
{
var dal = new Dal.LawEnforcement();
using (BypassPropertyChecks)
{
var data = new Dal.AgencyDal {
Id = Id, Agency = Agency
};
dal.Update(data);
}
}
protected override void DataPortal_Insert()
{
var dal = new Dal.LawEnforcement();
using (BypassPropertyChecks)
{
var data = new Dal.AgencyDal {
Agency = Agency
};
var newId = dal.Insert(data);
Id = newId;
}
}