public List <Models.ViewTag> Get() { CrowdHeynaEntities db = new CrowdHeynaEntities(); var tags = new List <Models.ViewTag>(); // foreach (Tag tag in db.Tags.ToList()) { var viewTag = new ViewTag() { Id = tag.Id, Name = tag.Name // }; switch (tag.Id) { case 1: viewTag.Color = "Red"; break; case 2: viewTag.Color = "Green"; break; case 3: viewTag.Color = "Blue"; break; case 4: viewTag.Color = "Purple"; break; } tags.Add(viewTag); } return(tags); }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email, Hometown = model.Hometown }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); CrowdHeynaEntities db = new CrowdHeynaEntities(); db.Users.Add(new User() { UserId = user.Id }); db.SaveChanges(); // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); return(RedirectToAction("Index", "Home")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
public List <Models.Tweet> get() { try { CrowdHeynaEntities db = new CrowdHeynaEntities(); List <Models.Tweet> tweets = new List <Models.Tweet>(); var skip = new Random().Next(tweets.Count); // var tList = db.Tweets.OrderBy(x => x.Id).Skip(skip).Take(15).ToList(); var tList = db.Tweets.OrderBy(x => x.Id).Take(15).ToList(); foreach (Tweet t in tList) { Models.Tweet tw = new Models.Tweet() { Id = t.Id, Text = t.Text }; tweets.Add(tw); } return(tweets); } catch (Exception ex) { var message = ex.Message; } return(null); }
public Models.Keywords get(int tweetid) { CrowdHeynaEntities db = new CrowdHeynaEntities(); var keywords = new List <Keyword>(); // keywords = db.Keywords.Where(key => key.TweetId == tweetid).ToList(); var results = new Models.Keywords(); foreach (Keyword k in keywords) { Models.Keyword item = new Models.Keyword(); item.Id = k.Id; item.Name = k.Keyword1; item.TagCount = 0; // switch (k.SourceId) { case 1: results.fromText.Add(item); break; case 2: results.fromHashtag.Add(item); break; case 3: results.fromURL.Add(item); break; } } return(results); }
public void Post(List <UserKeywordSuggestion> suggestions) { CrowdHeynaEntities db = new CrowdHeynaEntities(); var username = (string)HttpContext.Current.Session["username"]; var user = db.AspNetUsers.Where(us => us.UserName == username).FirstOrDefault(); // foreach (UserKeywordSuggestion sugg in suggestions) { var internalUser = db.Users.Where(us => us.UserId == user.Id).FirstOrDefault(); if (internalUser != null) { UserKeywordTagSuggestion sug = new UserKeywordTagSuggestion() { KeywordId = sugg.KeywordId, TagId = sugg.TagId, UserId = internalUser.Id, Suggestion = sugg.Suggestion }; db.UserKeywordTagSuggestions.Add(sug); } } db.SaveChanges(); }
public List <string> Get(int keyword, int id) { CrowdHeynaEntities db = new CrowdHeynaEntities(); //var key = db.Keywords.Where(k => k.Keyword1 == keywordId).FirstOrDefault().Id; return(db.UserKeywordTagSuggestions.Where(uts => uts.KeywordId == keyword && uts.TagId == id).Select(s => s.Suggestion).ToList()); }
public async Task <ActionResult> ExternalLoginConfirmation(ExternalLoginConfirmationViewModel model, string returnUrl) { if (User.Identity.IsAuthenticated) { return(RedirectToAction("Index", "Manage")); } if (ModelState.IsValid) { // Get the information about the user from the external login provider var info = await AuthenticationManager.GetExternalLoginInfoAsync(); if (info == null) { return(View("ExternalLoginFailure")); } var user = new ApplicationUser { UserName = model.Email, Email = model.Email, Hometown = model.Hometown }; var result = await UserManager.CreateAsync(user); if (result.Succeeded) { result = await UserManager.AddLoginAsync(user.Id, info.Login); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); CrowdHeynaEntities db = new CrowdHeynaEntities(); db.Users.Add(new User() { UserId = user.Id }); db.SaveChanges(); return(RedirectToLocal(returnUrl)); } } AddErrors(result); } ViewBag.ReturnUrl = returnUrl; return(View(model)); }
public Models.Tweet get(int id) { try { CrowdHeynaEntities db = new CrowdHeynaEntities(); var tweet = db.Tweets.Where(t => t.Id == id).FirstOrDefault(); var tw = new Models.Tweet() { Id = tweet.Id, Text = tweet.Text }; return(tw); } catch (Exception ex) { var message = ex.Message; } return(null); }
public List <Models.GridRowModel> Get(int tweetId) { var resultRows = new List <Models.GridRowModel>(); using (CrowdHeynaEntities db = new CrowdHeynaEntities()) { var keywords = db.UserKeywordTags.Where(key => key.Keyword.TweetId == tweetId).ToList(); // var uniqueKeywords = keywords.Select(s => s.Keyword.Keyword1).Distinct().ToList(); // foreach (string keyword in uniqueKeywords) { Models.GridRowModel newRow = new Models.GridRowModel(); newRow.Keyword = keyword; // resultRows.Add(newRow); } } // return(resultRows); }
public List <Models.KeywordUserTags> Get(int tweetid, string keyword = null) { var keywordUserTags = new List <Models.KeywordUserTags>(); // using (CrowdHeynaEntities db = new CrowdHeynaEntities()) { var tweet = db.Tweets.Where(tw => tw.Id == tweetid).FirstOrDefault(); var tags = db.Tags.ToList(); var userKeywordTags = db.UserKeywordTags.ToList(); var totalUsers = db.UserKeywordTags.Select(m => m.UserId).Distinct().Count(); // foreach (Tag tag in tags) { var kut = new Models.KeywordUserTags() { TagId = tag.Id, TagName = tag.Name }; switch (kut.TagId) { case 1: kut.TagColor = "Red"; break; case 2: kut.TagColor = "Green"; break; case 3: kut.TagColor = "Blue"; break; case 4: kut.TagColor = "Purple"; break; } // foreach (Keyword k in tweet.Keywords.ToList()) { if (keyword != "0" && keyword != k.Keyword1) { continue; } // var keywordTags = userKeywordTags.Where(ukt => ukt.KeywordId == k.Id && ukt.Keyword.TweetId == tweet.Id); if (keywordTags != null) { var list = keywordTags.ToList(); foreach (UserKeywordTag ukt in list) { if (ukt.TagId == tag.Id) { if (kut.TagInfo.Exists(ti => ti.KeywordId == ukt.KeywordId)) { //var tagInf = kut.TagInfo.Where(ti => ti.KeywordId == ukt.KeywordId).FirstOrDefault(); } else { Models.TagInfo tagInfo = new Models.TagInfo(); tagInfo.KeywordId = ukt.KeywordId; tagInfo.KeywordName = ukt.Keyword.Keyword1; tagInfo.TagUserCount = keywordTags.Where(kt => kt.TagId == tag.Id).Count(); tagInfo.UserCount = totalUsers; // kut.TagInfo.Add(tagInfo); } } } } } keywordUserTags.Add(kut); } } // return(keywordUserTags); }