public void Update(ProductDomain editedItem)
{
var sql = Sql.Builder.Append("UPDATE Product ")
.Append(" SET Name = @0, CategoryId = @1 ", editedItem.Name, editedItem.ProductCategory.Id)
.Append(" WHERE ID = @0 ", editedItem.Id);
DataContext.Execute(sql);
}
public void Insert(ProductDomain newItem)
{
var sql = Sql.Builder.Append(" INSERT INTO Product (Name, CategoryId) ")
.Append(" VALUES (@0, @1) ", newItem.Name, newItem.ProductCategory.Id);
DataContext.Execute(sql);
}
