public CreateUser2Request AddUser(CreateUser2Request newUserObject)
{
using (var db = new SqlConnection(ConnectionString))
{
var insertQuery = @"
INSERT INTO Users2
([FirstName],
[LastName],
[Rank],
[Affiliation],
[Competitor],
[GymId],
[OpenMatId])
OUTPUT inserted.*
VALUES
(@firstname,
@lastname,
@rank,
@affiliation,
@competitor,
@gymid,
@openmatid)";
var parameters = new
{
FirstName = newUserObject.FirstName,
LastName = newUserObject.LastName,
Rank = newUserObject.Rank,
Affiliation = newUserObject.Affiliation,
Competitor = newUserObject.Competitor,
GymId = newUserObject.GymId,
OpenMatId = newUserObject.OpenMatId
};
var newUser = db.QueryFirstOrDefault <CreateUser2Request>(insertQuery, parameters);
if (newUser != null)
{
return(newUser);
}
}
throw new Exception("User2 was not created");
}
public ActionResult <int> AddUser(CreateUser2Request createRequest)
{
var newUser = _user2Repository.AddUser(createRequest);
return(Ok(newUser));
}
