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