public void Update(RobotTemplate template)
{
var descriptionString = GenxyConverter.Serialize(template.ToDictionary());
Db.Query().CommandText("update robottemplates set name=@name,description=@description where id=@id")
.SetParameter("@id", template.ID)
.SetParameter("@name", template.Name)
.SetParameter("@description", descriptionString)
.ExecuteNonQuery().ThrowIfEqual(0, ErrorCodes.SQLUpdateError);
}
public void Insert(RobotTemplate template)
{
var descriptionString = GenxyConverter.Serialize(template.ToDictionary());
var id = Db.Query().CommandText("insert robottemplates (name,description) values (@name,@description); select cast(scope_identity() as integer)")
.SetParameter("@name", template.Name)
.SetParameter("@description", descriptionString)
.ExecuteScalar <int>().ThrowIfEqual(0, ErrorCodes.SQLInsertError);
template.ID = id;
}
