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);
}
