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;
     }
 }
示例#2
0
 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;
 }
示例#4
0
 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);
 }
示例#8
0
 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);
 }