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));
}
