Ejemplo n.º 1
0
        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"));
            }
        }
Ejemplo n.º 2
0
        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);
            }
        }