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