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