public Score PostScore(Score score) { try { connection.Open(); var cmd = connection.CreateCommand() as SqlCommand; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Score_PostScore"; cmd.Parameters.Add(new SqlParameter("@earthwatcherid", score.EarthwatcherId)); cmd.Parameters.Add(new SqlParameter("@action", score.Action)); cmd.Parameters.Add(new SqlParameter("@points", score.Points)); cmd.Parameters.Add(new SqlParameter("@landId", score.LandId)); cmd.Parameters.Add(new SqlParameter("@param1", score.Param1)); cmd.Parameters.Add(new SqlParameter("@param2", score.Param2)); var idParameter = new SqlParameter("@ID", SqlDbType.Int) { Direction = ParameterDirection.Output }; cmd.Parameters.Add(idParameter); cmd.ExecuteNonQuery(); connection.Close(); return score; } catch (Exception ex) { throw ex; } }
public void Post(Score score, string username, string password) { client.Authenticator = new HttpBasicAuthenticator(username, password); var request = new RestRequest("scores", Method.POST) { RequestFormat = DataFormat.Json }; request.JsonSerializer = new JsonSerializer(); request.AddBody(score); client.ExecuteAsync<Score>(request, response => Deployment.Current.Dispatcher.BeginInvoke(() => ScoreAdded(response.Data, null) )); }
public Score UpdateScore(Score score) { connection.Open(); var cmd = connection.CreateCommand() as SqlCommand; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Score_UpdateScore"; cmd.Parameters.Add(new SqlParameter("@earthwatcherid", score.EarthwatcherId)); cmd.Parameters.Add(new SqlParameter("@action", score.Action)); cmd.Parameters.Add(new SqlParameter("@points", score.Points)); cmd.ExecuteNonQuery(); connection.Close(); score.Published = DateTime.UtcNow; return score; }
public HttpResponseMessage<Score> UpdateScore(Score score, HttpRequestMessage<Score> request) { if (score.EarthwatcherId != 0 && !String.IsNullOrEmpty(score.Action) && score.Points != 0) { var newScore = scoreRepository.UpdateScore(score); var response = new HttpResponseMessage<Score>(newScore) { StatusCode = HttpStatusCode.OK }; response.Headers.Location = new Uri(newScore.Uri, UriKind.Relative); return response; } else { var response = new HttpResponseMessage<Score>(null) { StatusCode = HttpStatusCode.BadRequest, ReasonPhrase = "request parameters not correct" }; return response; } }
public void logSlInstall() { var connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["EarthwatchersConnection"].ConnectionString; IScoreRepository repo = new ScoreRepository(connectionstring); Score s = new Score(17, ActionPoints.Action.Log.ToString(), ActionPoints.Points(ActionPoints.Action.Log), 0, 100, null, null, "SL_Install"); repo.PostScore(s); }
public void logSlInstall() { var connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["EarthwatchersConnection"].ConnectionString; IScoreRepository repo = new ScoreRepository(connectionstring); Score s = new Score(); s.EarthwatcherId = 17; s.Action = ActionPoints.Action.Log.ToString(); s.Points = ActionPoints.Points(ActionPoints.Action.Log); s.Published = DateTime.UtcNow; s.Param1 = "SL_Install"; repo.PostScore(s); }
void UpdatePoints(string action, int points) { var score = new Score(Current.Instance.Earthwatcher.Id, action, points, Current.Instance.Earthwatcher.PlayingRegion, Current.Instance.PrecisionScore); isScoreAdding = true; scoreRequest.Update(score, Current.Instance.Username, Current.Instance.Password); }
void UpdatePoints(string action, int points) { var score = new Score { EarthwatcherId = Current.Instance.Earthwatcher.Id, Action = action, Points = points }; isScoreAdding = true; scoreRequest.Update(score, Current.Instance.Username, Current.Instance.Password); }