public void UpdateCategory(ProductCategoryDomain editedItem) { var sql = Sql.Builder.Append("UPDATE ProductCategory ") .Append(" SET Name = @0, TypeId = @1 ", editedItem.Name, EnumHelper.EnumTextToInt(editedItem.ProductType, typeof(Enums.ProductType))) .Append(" WHERE ID = @0 ", editedItem.Id); DataContext.Execute(sql); }
public void InsertCategory(ProductCategoryDomain newItem) { var sql = Sql.Builder.Append(" INSERT INTO ProductCategory (Name, TypeId) ") .Append(" VALUES (@0, @1) ", newItem.Name, EnumHelper.EnumTextToInt(newItem.ProductType, typeof(Enums.ProductType))); DataContext.Execute(sql); }