Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Pau 14 posts 75 karma points
    May 11, 2015 @ 12:49
    Pau
    0

    Problems with petapoco

    Hi guys, i'm starting with petapoco to save my categories, buy im having a problem with the autoincrement,

    I followed this example: http://www.nibble.be/?p=440, but i dont create nodes with the categories, i show them in a table, loading them from the DB, and everyone have Id = 0

    This is my model:

    [TableName("categories")]
        [PrimaryKey("CategoryId", autoIncrement = true)]
        public class Category
        {
            public Category() { }
            [PrimaryKeyColumn(AutoIncrement = true)]
            public int CategoryId { get; set; }
            public string Name { get; set; }
            public string Father { get; set; }
            public override string ToString()
            {
                return "Category: "+ Name ;
            }
       

    This is my RegisterEvents

    public class RegisterEvents : ApplicationEventHandler
        {
            protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
            {
                var db = applicationContext.DatabaseContext.Database;
                if (!db.TableExist("categories"))
                {
                    db.CreateTable(false);
                }
            }
        }

    And the controller:

    public class CategoryApiController : UmbracoApiController
        {
            public IEnumerable GetAll()
            {
                var query = new Sql().Select("*").From("categories");
              return DatabaseContext.Database.Fetch(query);
            }
            public Category GetById(int id)
            {
                var query = new Sql().Select("*").From("categories").Where(x => x.CategoryId == id);
                return DatabaseContext.Database.Fetch(query).FirstOrDefault();
            }
            public Category PostSave(Category cat)
            {
                if (cat.CategoryId > 0)
                 DatabaseContext.Database.Update(cat);
             else
                 DatabaseContext.Database.Save(cat);
             return cat;
            }
            public int DeleteById(int id)
            {
                return DatabaseContext.Database.Delete(id);
            }
        }

    i don't see where is the error, but i can't edit or delete items, because them all have the same id

     

  • Robert Sikkens 7 posts 78 karma points
    Mar 03, 2016 @ 09:29
    Robert Sikkens
    0

    Same here, how did you solve this?

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies