public async Task <object> Add(State entity) { string storedProcedure = String.Empty; object result; int rows; storedProcedure = Settings.Database.StoredProcedures.FirstOrDefault(p => p == ADD_PROC); if (storedProcedure == null) { SqlCommandType = Constants.DBCommandType.SQL; CMDText = ADD_STMT; } else { SqlCommandType = Constants.DBCommandType.SPROC; CMDText = storedProcedure; } MapFromObject = new StateMapFromObject(logger); result = await base.Add(entity, entity.PK); if (result != null) { rows = (int)result; } else { rows = -1; } return(rows); }
public object Add(State entity) { string storedProcedure = String.Empty; object result; storedProcedure = Settings.Database.StoredProcedures.FirstOrDefault(p => p == ADD_PROC); if (storedProcedure == null) { SqlCommandType = Constants.DBCommandType.SQL; CMDText = ADD_STMT; } else { SqlCommandType = Constants.DBCommandType.SPROC; CMDText = storedProcedure; } MapFromObject = new StateMapFromObject(logger); result = base.Add(entity, entity.PK); if (result != null && (int)result == 1) { return(entity.PK.Key); } else { return(String.Empty); } }
public async Task <int> Update(State entity) { string storedProcedure = String.Empty; storedProcedure = Settings.Database.StoredProcedures.FirstOrDefault(p => p == UPDATE_PROC); if (storedProcedure == null) { SqlCommandType = Constants.DBCommandType.SQL; CMDText = UPDATE_STMT; } else { SqlCommandType = Constants.DBCommandType.SPROC; CMDText = storedProcedure; } MapFromObject = new StateMapFromObject(logger); return(await base.Update(entity, entity.PK)); }