Пример #1
0
        protected override OpResult _Store(RecurringMoneySpent _obj)
        {
            if (_obj == null)
            {
                return(OpResult.NotifyStoreAction(OpResult.ResultStatus.ObjectIsNull, _obj, "RecurringMoneySpent object cannot be created as it is null"));
            }

            if (Exists(_obj))
            {
                ExecuteNonQuery(GetQuery_UpdateQuery(_obj));
                return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Updated, _obj));
            }

            ExecuteNonQuery(GetQuery_InsertQuery(_obj));
            if (_obj.RecurringMoneySpentID == null)
            {
                _obj.RecurringMoneySpentID = DbMgr.GetLastInsertID();
            }
            _obj.FromDb = true;

            return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Created, _obj));
        }
Пример #2
0
 private DbUpdateStatement GetQuery_UpdateQuery(RecurringMoneySpent _obj)
 {
     return(DbMgr.CreateUpdateClause("RecurringMoneySpent", GetFields(_obj), "RecurringMoneySpentID", _obj.RecurringMoneySpentID));
 }
Пример #3
0
        private DbInsertStatement GetQuery_InsertQuery(RecurringMoneySpent _obj)
        {
            Dictionary <string, DbFieldEntry> fields = GetFields(_obj);

            return(DbMgr.CreateInsertClause("RecurringMoneySpent", fields));
        }