public async Task <IActionResult> AddData([FromBody] UserSubModel condition) { if (condition == null) { return(BadRequest()); } int resp = _UserSubData.SubmitUserData(condition); if (resp == 1) { return(Ok()); } else { return(NotFound("There might be some issues")); } }
public int SubmitUserData(UserSubModel userdata) { int cond_id = CheckIfConditionExists(userdata.condition); if (cond_id == -1) { return(-1); } else { using (IDbConnection db = new SqlConnection(connectionString)) { var x = new { city = userdata.city, temp = userdata.temp, cond = cond_id }; var query = "INSERT INTO UserData ( city, temp, condition_id) VALUES ( @city, @temp, @cond)"; db.Execute(query, x); } return(1); } }