public ResultModel update_Point(USER_ACTION u) { var ctx = HttpContext.Current; ResultModel result = new ResultModel(); if (ctx != null) { try { result = dataAccess.update_Point(u); if (result.Result > 0) { return(result); } else { return(result); } } catch (Exception) { throw; } } result.Result = -1; result.ResultMessage = "DONT_HAVE_CONTEXT"; return(result); }
// POST: api/UpdateAction public HttpResponseMessage Post([FromBody] USER_ACTION u) { ResultModel result = respository.update_Point(u); var response = Request.CreateResponse <ResultModel>(System.Net.HttpStatusCode.OK, result); return(response); }
public ResultModel updateTurn(USER_ACTION u, int iduser) { ResultModel result = new ResultModel(); try { OpenConnect(); SqlCommand cmd = new SqlCommand("CHANGE_TURN", sqlConnection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@IdUSER", SqlDbType.Int); cmd.Parameters["@IdUSER"].Value = iduser; cmd.Parameters.Add("@STURN", SqlDbType.Int); cmd.Parameters["@STURN"].Value = u.USERTURN; cmd.Parameters.Add("@Result", SqlDbType.Int); cmd.Parameters.Add("@ResultID", SqlDbType.Int); cmd.Parameters.Add("@ResutMesseage", SqlDbType.VarChar, 50); cmd.Parameters["@Result"].Direction = ParameterDirection.Output; cmd.Parameters["@ResultID"].Direction = ParameterDirection.Output; cmd.Parameters["@ResutMesseage"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); result.Result = (int)cmd.Parameters["@Result"].Value; result.ResultId = (int)cmd.Parameters["@ResultID"].Value; result.ResultMessage = cmd.Parameters["@ResutMesseage"].Value.ToString(); cmd.Dispose(); } catch (Exception e) { result.Result = -1; result.ResultMessage = e.Message; return(result); } finally { CloseConnect(); } return(result); }