public void POST_events_nearby() { string url = string.Format(API_URL, "/events/nearby"); HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url); httpWebRequest.Method = WebRequestMethods.Http.Post; httpWebRequest.Headers = LoginHeaders; httpWebRequest.ContentType = "application/json; charset=utf-8"; EventsNearbyFilter filter = new EventsNearbyFilter() { Latitude = 50.041272, Longitude = 21.999231, MaxDistance = 40, MaxDaysLeft = 80 }; string postJson = objectToJsonNew <EventsNearbyFilter>(filter); StreamWriter writer = new StreamWriter(httpWebRequest.GetRequestStream()); writer.Write(postJson); writer.Close(); HttpWebResponse httpWebResponse = (HttpWebResponse)httpWebRequest.GetResponse(); string jsonString = streamToString(httpWebResponse); object obj = jsonToObject <List <Event> >(jsonString); Assert.IsInstanceOfType(obj, typeof(List <Event>)); }
public static List <Event> getEventsNearby(SqlConnection sqlConnection, EventsNearbyFilter filter) { sqlConnection.Close(); SqlCommand cmd = new SqlCommand(EVENTS_PROCEDURE, sqlConnection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue(EVENTS_PROC_LAT, filter.Latitude); cmd.Parameters.AddWithValue(EVENTS_PROC_LNG, filter.Longitude); cmd.Parameters.AddWithValue(EVENTS_PROC_MAX_DISTANCE, filter.MaxDistance); cmd.Parameters.AddWithValue(EVENTS_PROC_MAX_DAYS_LEFT, filter.MaxDaysLeft); sqlConnection.Open(); List <Event> events = new List <Event>(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { events.Add(parseEvent(reader)); } } sqlConnection.Close(); return(events); }
public object getEventsNearby(EventsNearbyFilter eventsFilter) { int loggedUserId = runAuthenticate(); if (loggedUserId > 0) { if (eventsFilter != null) { return(DBUtils.getEventsNearby(sqlConnection, eventsFilter)); } else { WebOperationContext.Current.OutgoingResponse.StatusCode = System.Net.HttpStatusCode.BadRequest; return(new Status(false, "Uzupełnij wszystkie parametry.")); } } else { return(getAuthorizationErrorStatus(true)); } }