Example #1
0
        public int InsertMain(UplodableObject _uplodableObject, Guid _parent = default(Guid), int?_field = null)
        {
            var now = DateTime.Now;
            int result;

            if (_parent.Equals(default(Guid)))
            {
                result = ExecuteInsertOrUpdate("INSERT INTO main (uid, kind, vfrom) VALUES (@uid, @kind, @from)",
                                               new SqliteParameter("@uid", _uplodableObject.Uid),
                                               new SqliteParameter("@kind", _uplodableObject.Kind),
                                               new SqliteParameter("@from", now));
            }
            else
            {
                result = ExecuteInsertOrUpdate("INSERT INTO main (uid, parent, kind, field, vfrom) VALUES (@uid, @parent, @kind, @field, @from)",
                                               new SqliteParameter("@uid", _uplodableObject.Uid),
                                               new SqliteParameter("@parent", _parent),
                                               new SqliteParameter("@kind", _uplodableObject.Kind),
                                               new SqliteParameter("@field", _field),
                                               new SqliteParameter("@from", now));
            }
            _uplodableObject.SaveFields(this, now);
            return(result);
        }