public async Task <object> Add(City entity) { string storedProcedure = String.Empty; object result; int key = 0; 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 CityMapFromObject(logger); result = await base.Add(entity, entity.PK); if (result != null) { key = Convert.ToInt32(result); } return(key); }
public object Add(City 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 CityMapFromObject(logger); result = base.Add(entity, entity.PK); if (result != null) { return((int)Convert.ToInt32(result)); // Apparently, the default returned is 64 bits } else { return(-1); } }
public async Task <int> Update(City 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 CityMapFromObject(logger); return(await base.Update(entity, entity.PK)); }