public IActionResult Post([FromBody] SportTree sportTree)
{
try
{
if (sportTree != null)
{
_logger.LogInformation("API Request hit: INSERT Sport : " + sportTree.Name);
var result = _sportTreeRepository.Add(sportTree);
if (result == 0)
{
return(Ok("{\"status\": \"Success\"}"));
}
else
{
_logger.LogInformation("API Request (INSERT Sport : " + sportTree.Name + " ) not committed");
return(NotFound("Failed: INSERT could not commit"));
}
}
else
{
_logger.LogInformation("API Request hit (INSERT Sport) with null entry");
return(BadRequest("Failed: null entry"));
}
}
catch (Exception e)
{
_logger.LogError("API Request (INSERT Sport) FAILED: ", e);
return(BadRequest("Failed"));
}
}
public int Update(SportTree entity)
{
using (var connection = DBService.GetSqlConnection())
{
var result = connection.Execute($"EXECUTE dbo.UpdateSportTree {entity.Id},{entity.Name},{entity.Logo}");
return(result + 1);
}
}
public int Add(SportTree entity)
{
using (var connection = DBService.GetSqlConnection())
{
var parameters = new { entity.Name, entity.Logo };
connection.Execute("dbo.InsertSportTree", parameters, commandType: CommandType.StoredProcedure);
return(0);
}
}
public bool Update(SportTree sportTree)
{
using (var connection = DatabaseService.SqlConnection())
{
var parameters = new
{
sportTree.SportId,
sportTree.SportName,
sportTree.LogoUrl
};
var affectedRows = connection.Execute("UPDATE SportTree SET " +
"SportName=@SportName," +
"LogoUrl=@LogoUrl " +
"WHERE SportId =@SportId"
, parameters);
return(affectedRows > 0);
}
}
public IActionResult Post([FromBody] SportTree sportTree)
{
try
{
var result = _sportTree.Add(sportTree); // returns a boolean based on the number of rows affected
if (result) // if the post was successfully added to the db it will return true
{
return(StatusCode(200, StatusCodes.ReturnStatusObject("Successfully Added")));
}
else // if the post was unsuccesful it will return false
{
return(StatusCode(400, StatusCodes.ReturnStatusObject("Insert Failed.")));
}
}
catch (Exception eo)
{
return(StatusCode(400, StatusCodes.ReturnStatusObject("Insert Failed.")));
}
}
public bool Add(SportTree sportTree)
{
using (var connection = DatabaseService.SqlConnection())
{
var parameters = new
{
sportTree.SportName,
sportTree.LogoUrl
};
var affectedRows = connection.Execute("INSERT INTO SportTree" +
"(" +
"SportName," +
"LogoUrl)" +
"VALUES" +
"(" +
"@SportName," +
"@LogoUrl)",
parameters);
return(affectedRows > 0);
}
}
public IActionResult Put([FromBody] SportTree sportTree)
{
try
{
if (sportTree.Equals(null))
{
return(BadRequest("Oops something went wrong.")); // if there was no value entered of sportId it will return a bad request.
}
var result = _sportTree.Update(sportTree); // searches the table using the given idea and if the item is found and updated it will return true
if (result)
{
return(StatusCode(200, StatusCodes.ReturnStatusObject("Successfully Updated")));
}
else
{
return(StatusCode(400, StatusCodes.ReturnStatusObject("Update Failed.")));
}
}
catch (Exception e)
{
return(StatusCode(400, StatusCodes.ReturnStatusObject("Update Failed.")));
}
}
