public List <Data.Activity> GetAllActivities()
{
List <Data.Activity> activities = new List <Data.Activity>();
try
{
WebRequest req = WebRequest.Create(@"https://api.paris.fr:3000/data/1.0/QueFaire/get_activities/?token=30539e0d4d810782e992a154e4dfa37bedb33652c6baf3fcbf7e6fd431482b23bbd8f892318ac3b58c45527e7aba721d&offset=0&limit=100");
req.Method = "GET";
HttpWebResponse resp = req.GetResponse() as HttpWebResponse;
if (resp.StatusCode == HttpStatusCode.OK)
{
using (Stream respStream = resp.GetResponseStream())
{
StreamReader reader = new StreamReader(respStream, Encoding.UTF8);
JObject jsonActivities = JObject.Parse(reader.ReadToEnd());
foreach (JObject activity in jsonActivities["data"])
{
Data.Activity act = new Data.Activity();
act.Adresse = activity["adresse"].ToString();
act.City = activity["city"].ToString();
act.Description = StripHTML(HttpUtility.HtmlDecode(activity["description"].ToString()));
act.ID = (int)activity["idactivites"];
activities.Add(act);
}
}
}
else
{
}
}
catch (Exception exp)
{
Data.Activity dumb = new Data.Activity();
dumb.Adresse = exp.Message;
dumb.City = exp.Source;
dumb.Description = "dumb desc";
dumb.ID = 1;
activities.Add(dumb);
}
return(activities);
}
public List <Data.Activity> GetStaticAllActivities()
{
TchillrDBContext context = new TchillrDBContext("Server=tcp:myuc6ta27d.database.windows.net,1433;Database=TchillrDB;User ID=TchillrSGBD@myuc6ta27d;Password=Tch1llrInTown;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;");
//List<Data.Activity> activities = new List<Data.Activity>();
try
{
WebRequest req = WebRequest.Create("http://" + HttpContext.Current.Request.Url.Authority + "/staticActivy3.txt");
req.Method = "GET";
HttpWebResponse resp = req.GetResponse() as HttpWebResponse;
if (resp.StatusCode == HttpStatusCode.OK)
{
using (Stream respStream = resp.GetResponseStream())
{
StreamReader reader = new StreamReader(respStream, Encoding.UTF8);
JObject jsonActivities = JObject.Parse(reader.ReadToEnd());
foreach (JObject activity in jsonActivities["data"])
{
int identifier = (int)activity["identifier"];
Data.Activity act = context.Activities.Include("Occurences").FirstOrDefault(acti => acti.ID == identifier);
if (act == null)
{
act = new Activity();
act.Occurences = new List <Occurence>();
context.Activities.Add(act);
}
act.Nom = WebUtility.HtmlDecode(activity["name"].ToString());
act.Adresse = WebUtility.HtmlDecode(activity["adress"].ToString());
act.City = WebUtility.HtmlDecode(activity["city"] == null ? "" : activity["city"].ToString());
act.Description = StripHTML(WebUtility.HtmlDecode(activity["description"].ToString()));
act.ID = (int)activity["identifier"];
act.Zipcode = activity["zipcode"].ToString();
act.ShortDescription = activity["shortDescription"].ToString();
act.Lieu = activity["place"].ToString();
float temp = 0;
if (float.TryParse(activity["latitude"].ToString(), out temp))
{
act.Lat = temp;
}
temp = 0;
if (float.TryParse(activity["longitude"].ToString(), out temp))
{
act.Lon = temp;
}
foreach (JObject occ in activity["occurences"])
{
#warning convertir en start date end date
// we found that some activity have multiple equal occurences
if (act.Occurences.Exists(o => o.ActivityID == act.ID && o.Day == occ["jour"].ToString() && o.StartTime == occ["hour_start"].ToString() && o.EndTime == occ["hour_end"].ToString()))
{
continue;
}
Occurence occurence = new Occurence();
occurence.Day = occ["jour"].ToString();
occurence.StartTime = occ["hour_start"].ToString();
occurence.EndTime = occ["hour_end"].ToString();
occurence.ActivityID = act.ID;
act.Occurences.Add(occurence);
}
//act.Keywords = act.GetKeywords();
// activities.Add(act);
}
}
}
}
catch (Exception exp)
{
Data.Activity dumb = new Data.Activity();
dumb.Adresse = exp.Message;
dumb.City = exp.Source;
dumb.Description = "dumb desc";
dumb.ID = 1;
//activities.Add(dumb);
}
context.SaveChanges();
return(context.Activities.ToList <Activity>());
//return activities;
}