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