public List <Data.Theme> GetThemes()
{
TchillrDBContext context = new TchillrDBContext(TchillrREST.Utilities.CONNEXION_STRING);
context.Configuration.ProxyCreationEnabled = false;
return(context.Themes.Include("Tags").ToList <Data.Theme>());
}
public List <Tag> GetTags(string theme)
{
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;");
context.Configuration.ProxyCreationEnabled = false;
List <Tag> tags = context.Tags.Where(tg => tg.Theme.Title == theme).ToList <Tag>();
return(tags);
}
public List <int> GetInterests(string usernameid)
{
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 <int> results = new List <int>();
int userNameID = int.Parse(usernameid);
foreach (UserTag ut in context.UserTags.Where(userTag => userTag.UserID == userNameID))
{
results.Add(ut.TagID);
}
return(results);
}
public void InjectTags(string theme)
{
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;");
Tag tg = new Tag();
tg.Title = "Concert";
tg.Weight = 1;
tg.ThemeID = 1;
context.Tags.Add(tg);
tg = new Tag();
tg.Title = "Festival";
tg.Weight = 1;
tg.ThemeID = 1;
context.Tags.Add(tg);
tg = new Tag();
tg.Title = "Jazz";
tg.Weight = 1;
tg.ThemeID = 1;
context.Tags.Add(tg);
tg = new Tag();
tg.Title = "Classique";
tg.Weight = 1;
tg.ThemeID = 1;
context.Tags.Add(tg);
tg = new Tag();
tg.Title = "Percussion";
tg.Weight = 1;
tg.ThemeID = 1;
context.Tags.Add(tg);
tg = new Tag();
tg.Title = "Hip Hop";
tg.Weight = 1;
tg.ThemeID = 1;
context.Tags.Add(tg);
context.SaveChanges();
}
public List <Data.Activity> GetFromDBAllActivities()
{
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;");
context.Configuration.ProxyCreationEnabled = false;
List <Activity> lstActi = context.Activities.ToList <Activity>();
List <string> tags = context.Tags.Select(tg => tg.Title).ToList <string>();
tags = tags.ConvertAll(d => d.ToUpper());
foreach (Activity act in lstActi)
{
act.GetKeywords(tags);
act.Occurences = context.Occurences.Where(os => os.ActivityID == act.ID).ToList <Occurence>();
}
return(lstActi);
}
public List <int> PostInterests(string usernameid, Stream content)
{
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;");
int userNameID = int.Parse(usernameid);
// convert Stream Data to StreamReader
StreamReader reader = new StreamReader(content);
string result = reader.ReadToEnd();
int tagID = int.Parse(result.Split('=')[1]);
UserTag ut = context.UserTags.FirstOrDefault(userTag => userTag.TagID == tagID && userTag.UserID == userNameID);
if (ut == null || ut.UserID == 0)
{
ut = new UserTag();
ut.UserID = userNameID;
ut.TagID = tagID;
context.UserTags.Add(ut);
}
else
{
context.UserTags.Remove(ut);
}
context.SaveChanges();
//return context.UserTags.Where(userTags => userTags.UserID == userNameID).Select(x => x.TagID).ToList<int>();
return(GetInterests(usernameid));
//JObject jsonActivities = JObject.Parse(reader.ReadToEnd());
//foreach (JObject activity in jsonActivities["data"])
//{
//}
//return new List<int>();
}
public List <Data.Activity> GetUserActivities(string usernameid)
{
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;");
context.Configuration.ProxyCreationEnabled = false;
List <Activity> lstActi = context.Activities.ToList <Activity>();
List <Tag> lstTags = context.Tags.ToList <Tag>();
List <int> userTags = GetInterests(usernameid);
List <string> userContextualTags = new List <string>();
foreach (Tag tag in lstTags.Where(tg => userTags.Contains(tg.ID)))
{
userContextualTags.Add(tag.Title);
tag.WordsCloud = context.WordsCloud.Where(twc => twc.TagID == tag.ID).ToList <WordCloud>();
foreach (WordCloud wc in tag.WordsCloud)
{
userContextualTags.Add(wc.Title);
}
}
//List<string> userContextualTags = context.Tags.Where(tg => userTags.Contains(tg.ID)).Select(x => x.Title).ToList<string>();
userContextualTags = userContextualTags.ConvertAll(d => d.ToUpper());
//List<string> tags = context.Tags.Select(tg => tg.Title).ToList<string>();
//tags = tags.ConvertAll(d => d.ToUpper());
foreach (Activity act in lstActi)
{
act.Keywords = context.Keywords.Where(keywords => keywords.ActivityID == act.ID).ToList <Keyword>();
//act.Keywords = act.GetKeywords(tags);
act.ActivityContextualTags = act.GetContextualTags(userContextualTags);
act.Occurences = context.Occurences.Where(os => os.ActivityID == act.ID).ToList <Occurence>();
//act.Occurences = (from c in context.Occurences select c).Take(1).ToList<Occurence>();
}
return(lstActi.Where(acti => acti.ActivityContextualTags.Intersect(userContextualTags).Count() > 0).OrderByDescending(acti => acti.ActivityContextualTags.Intersect(userContextualTags).Count()).ToList <Data.Activity>());
}
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;
}
public List <Data.Categorie> GetDBCategories()
{
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;");
return(context.Categories.ToList <Categorie>());
}
