public CreateOpenMatRequest AddOpenMat(CreateOpenMatRequest newUserObject)
{
using (var db = new SqlConnection(ConnectionString))
{
var insertQuery = @"
INSERT INTO OpenMatt
([Date],
[GymID])
OUTPUT inserted.*
VALUES
(@date,
@gymid)";
var parameters = new
{
Date = newUserObject.Date,
GymID = newUserObject.GymID
};
var newOpenMat = db.QueryFirstOrDefault <CreateOpenMatRequest>(insertQuery, parameters);
if (newOpenMat != null)
{
return(newOpenMat);
}
}
throw new Exception("OpenMat was not created");
}
public ActionResult <int> AddOpenMat(CreateOpenMatRequest createRequest)
{
var newUser = _openMatRepository.AddOpenMat(createRequest);
return(Ok(newUser));
}
