예제 #1
0
        public static async Task <int?> UpdateAsync(this DirectDatabaseBase db, DirectModel model)
        {
            if (!model.LongID.HasValue)
            {
                throw new Exception("ID is not set, maybe this table was not loaded");
            }

            // UPDATE MobilePaywall.core.A SET A=1 WHERE AID=1
            string command = string.Format("UPDATE {0}.{1}{2} SET {3} WHERE {4}={5};",
                                           db.DatabaseName, db.DatabaseSchemeString, model.GetTableName(),
                                           model.Snapshot.GetUpdateData(),
                                           model.GetIdNameValue(), model.LongID.Value);

            DirectExecuteResult result = await db.ExecuteAsync(command);

            if (!result.IsSuccessfull)
            {
                return(null);
            }
            else
            {
                model.OnAfterUpdate?.Invoke();
                model.Snapshot.SetSnapshot();
                return(result.NumberOfRowsAffected);
            }
        }
예제 #2
0
        public static T Insert <T>(this DirectDatabaseBase db, DirectModel model) where T : DirectModel
        {
            DirectExecuteResult result = db.Execute(model.ConstructInsertQuery());

            if (result.IsSuccessfull && result.LastID.HasValue)
            {
                model.LongID = result.LastID;
                model.Snapshot.SetSnapshot();
                return((T)model);
            }
            return((T)model);
        }
예제 #3
0
        public static async Task <T> InsertAsync <T>(this DirectDatabaseBase db, DirectModel model) where T : DirectModel
        {
            string command = string.Format("INSERT INTO {0}.{1}{2} ({3}) VALUES ({4});",
                                           db.DatabaseName, db.DatabaseSchemeString, model.GetTableName(),
                                           model.Snapshot.GetPropertyNamesForInsert(), model.Snapshot.GetPropertyValuesForInsert());
            DirectExecuteResult result = await db.ExecuteAsync(command);

            if (result.IsSuccessfull && result.LastID.HasValue)
            {
                model.LongID = result.LastID;
                model.Snapshot.SetSnapshot();
                return((T)model);
            }
            return((T)model);
        }
예제 #4
0
        public static int?Update(this DirectDatabaseBase db, DirectModel model)
        {
            if (!model.LongID.HasValue)
            {
                throw new Exception("ID is not set, maybe this table was not loaded");
            }

            DirectExecuteResult result = db.Execute(model.ConstructUpdateQuery());

            if (!result.IsSuccessfull)
            {
                return(null);
            }
            else
            {
                model.Snapshot.SetSnapshot();
                return(result.NumberOfRowsAffected);
            }
        }
예제 #5
0
        public static async Task <bool> DeleteAsync(this DirectDatabaseBase db, DirectModel model)
        {
            if (!model.LongID.HasValue)
            {
                throw new Exception("THIS model has not ID");
            }

            string command = string.Format("DELETE FROM {0}.{1}{2} WHERE {3}={4};",
                                           db.DatabaseName, db.DatabaseSchemeString, model.GetTableName(),
                                           model.GetIdNameValue(), model.LongID.Value);
            DirectExecuteResult result = await db.ExecuteAsync(command);

            if (result.IsSuccessfull)
            {
                model.LongID = null;
                model.Snapshot.SetSnapshot();
                return(true);
            }
            return(false);
        }