public CreateGymRequest AddGym(CreateGymRequest newGymObject) { using (var db = new SqlConnection(ConnectionString)) { var insertQuery = @" INSERT INTO Gym ([Name], [Phone], [Affiliation], [Address1], [Address2], [City], [State], [Zipcode], [lat], [lng]) OUTPUT inserted.* VALUES (@name, @phone, @affiliation, @address1, @address2, @city, @state, @zipcode, @lat, @lng)"; var parameters = new { Name = newGymObject.Name, Phone = newGymObject.Phone, Affiliation = newGymObject.Affiliation, Address1 = newGymObject.Address1, Address2 = newGymObject.Address2, City = newGymObject.City, State = newGymObject.State, Zipcode = newGymObject.Zipcode, lat = newGymObject.lat, lng = newGymObject.lng }; var newGym = db.QueryFirstOrDefault <CreateGymRequest>(insertQuery, parameters); if (newGym != null) { return(newGym); } } throw new Exception("Gym was not created"); }
public ActionResult <int> AddGym(CreateGymRequest createRequest) { var newGym = _gymRepository.AddGym(createRequest); return(Ok(newGym)); }