public void Vote(Idea idea, int userId, int value) { if (db.Votes.Any(v => v.UserId == userId && v.IdeaId == idea.Id)) return; idea.Votes.Add(new Vote { IdeaId = idea.Id, UserId = userId, Value = value }); Update(idea); }
public IdeaModule(IIdeaRepository ideas) : base("/idea") { Get["/{id}"] = parameters => { int id = parameters.id; Idea idea = ideas.Get(id); if (idea == null) return View["Shared/404"]; return View["Idea/Index", idea]; }; Post["/"] = _ => { var i = new Idea { Time = DateTime.UtcNow, Title = Request.Form.Title, Description = Request.Form.Description, }; ideas.Add(i); return Response.AsRedirect("/idea/" + i.Id); }; Get["/{id}/vote/{userid}"] = parameters => { Idea idea = ideas.Get(parameters.id); ideas.Vote(idea, parameters.userid, 1); return Response.AsJson(new { Status = "OK", NewVotes = idea.Votes.Sum(v => v.Value) }); }; Get["/{id}/delete"] = parameters => { int id = parameters.id; ideas.Delete(id); return string.Format("Deleted Item {0}", id); }; }
public ApiSecuredModule(IIdeaRepository ideas, Settings settings) : base("/api") { _settings = settings; this.Before.AddItemToEndOfPipeline(ctx => { if (ctx.CurrentUser == null) return HttpStatusCode.Unauthorized; return null; }); Post["/ideas"] = _ => { var model = this.Bind<EditIdeaModel>(); var idea = new Idea { Title = model.title, Description = model.description, Time = DateTime.UtcNow, Author = (User)Context.CurrentUser, Status = _settings.IdeaStatusDefault }; ideas.Add(idea); return HttpStatusCode.Created; // TODO: Should return either the generated id or the json body }; Put["/ideas/{id}"] = _ => { var model = this.Bind<EditIdeaModel>(); int id = _.id; var idea = ideas.Get(id); if (idea == null) return HttpStatusCode.NotFound; if (model.title != null) idea.Title = model.title; if (model.description != null) idea.Description = model.description; ideas.Edit(idea); return HttpStatusCode.OK; }; }
public IdeaSecuredModule(IIdeaRepository ideas, IUserRepository users, ISettingsRepository settings, IImageRepository imageRepository) : base("/idea") { _ideas = ideas; _settings = settings; _imageRepository = imageRepository; _users = users; this.RequiresAuthentication(); Get["/new"] = _ => { var m = Context.Model(string.Format("New Idea - {0}", _settings.Title)); m.Ideas = _ideas.GetAll(); m.Errors = false; if (Request.Query["validation"] == "failed") { m.Errors = true; } return View["Idea/New", m]; }; Get["/{id}/edit"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) return View["404"]; if (idea.Author.UserName != Context.CurrentUser.UserName) return View["404"]; var m = Context.Model(string.Format(Strings.IdeaSecuredModule_EditIdea, idea.Title, _settings.Title)); m.PopularIdeas = _ideas.GetAll(); m.Idea = idea; m.StatusChoices = _settings.IdeaStatusChoices.Split(','); m.Errors = false; if (Request.Query["validation"] == "failed") { m.Errors = true; } return View["Idea/Edit", m]; }; // save result of edit to database Post["/{id}/edit"] = parameters => { int id = parameters.id; if (string.IsNullOrEmpty(Request.Form.Title) || string.IsNullOrEmpty(Request.Form.Description)) { return Response.AsRedirect(string.Format("/idea/{0}/edit?validation=failed", id)); } var idea = _ideas.Get(id); if (idea == null) return View["404"]; idea.Title = Request.Form.Title; idea.Description = Request.Form.Description; idea.Status = Request.Form.Status; //Add any images IEnumerable<string> keys = Context.Request.Form; var x = keys.Where(c => c.StartsWith("imageId")); var ids = x.Select(c => Context.Request.Form[c].ToString()).Cast<string>(); var images = ids.Select(y => _imageRepository.Get(Convert.ToInt32(y))); foreach (var i in images) { if (!idea.Images.Contains(i, i)) { idea.Images.Add(i); } } _ideas.Save(); return Response.AsRedirect(string.Format("/idea/{0}", idea.Id)); }; // save result of create to database Post["/new"] = _ => { if (string.IsNullOrEmpty(Request.Form.Title) || string.IsNullOrEmpty(Request.Form.Description)) { return Response.AsRedirect("/idea/new?validation=failed"); } var user = _users.FindBy(u => u.UserName == Context.CurrentUser.UserName).FirstOrDefault(); if (user == null) return Response.AsRedirect("/login"); var idea = new Idea { Author = user, Time = DateTime.UtcNow, Title = Request.Form.Title, Description = Request.Form.Description, Status = settings.IdeaStatusDefault }; IEnumerable<string> keys = Context.Request.Form; var parameters = keys.Where(c => c.StartsWith("imageId")); var ids = parameters.Select(c => Context.Request.Form[c].ToString()).Cast<string>(); var images = ids.Select(id => _imageRepository.Get(Convert.ToInt32(id))); idea.Images = images.ToList(); //i.Images = form.Cast<string>() // .Where(k => k.StartsWith("imageId")) // .Select(k => _imageRepository.Get(Convert.ToInt32(form[k]))) // .ToList(); //is there a way to do this using Nancy? if (idea.Votes.Any(u => u.UserId == user.Id)) idea.UserHasVoted = true; ideas.Add(idea); return Response.AsRedirect("/idea/" + idea.Id); }; // someone else votes for the idea Post["/{id}/vote"] = parameters => { var user = Context.GetCurrentUser(_users); if (user == null) return Response.AsRedirect("/login"); int ideaId = parameters.id; int votes = ideas.Vote(ideaId, user.Id, 1); return Response.AsJson(new { Status = "OK", NewVotes = votes }); }; // the user decides to repeal his vote Post["/{id}/unvote"] = parameters => { var user = Context.GetCurrentUser(_users); int votes = ideas.Unvote(parameters.id, user.Id); return Response.AsJson(new { Status = "OK", NewVotes = votes }); }; Post["/{id}/delete"] = parameters => { int id = parameters.id; ideas.Delete(id); ideas.Save(); // TODO: test return Response.AsJson(new { Status = "Error" }); }; // TODO: do we want unauthenticated users to be allowed to upload posts? Post["/uploadimage"] = parameters => { var user = Context.GetCurrentUser(_users); if (user == null) return Response.AsJson(new { status = "Error" }); var imageFile = Request.Files.FirstOrDefault(); if (imageFile == null) { return null; //TODO: handle error case } var image = new Image { Name = imageFile.Name }; var bytes = new byte[imageFile.Value.Length]; imageFile.Value.Read(bytes, 0, bytes.Length); image.ImageBits = bytes; imageRepository.Add(image); var status = new ImageFileStatus(image.Id, bytes.Length, image.Name); return Response.AsJson(new[] { status }).WithHeader("Vary", "Accept"); }; Delete["/deleteimage/{id}"] = parameters => { var user = Context.GetCurrentUser(_users); if (user == null) return Response.AsJson(new { status = "Error" }); imageRepository.Delete(parameters.id); return null; }; }
public AdminModule(IdeastrikeContext dbContext, Settings settings, IUserRepository users, IIdeaRepository ideas, IActivityRepository activities) : base("/admin") { this.RequiresAuthentication(); this.RequiresValidatedClaims(c => c.Contains("admin")); _settings = settings; _users = users; _ideas = ideas; _activities = activities; Get["/"] = _ => { var m = Context.Model(string.Format("Admin - {0}", (string)_settings.SiteTitle)); m.Name = _settings.Name; m.WelcomeMessage = _settings.WelcomeMessage; m.HomePage = _settings.HomePage; m.GAnalyticsKey = _settings.GAnalyticsKey; return View["Admin/Index", m]; }; Get["/users"] = _ => { var m = Context.Model(string.Format("Admin - {0}", (string)_settings.SiteTitle)); m.Name = _settings.Name; m.WelcomeMessage = _settings.WelcomeMessage; m.HomePage = _settings.HomePage; m.GAnalyticsKey = _settings.GAnalyticsKey; m.Users = users.GetAll(); return View["Admin/Users", m]; }; Get["/moderation"] = _ => { var m = Context.Model(string.Format("Admin - {0}", (string)_settings.SiteTitle)); m.Name = _settings.Name; m.WelcomeMessage = _settings.WelcomeMessage; m.HomePage = _settings.HomePage; m.GAnalyticsKey = _settings.GAnalyticsKey; return View["Admin/Moderation", m]; }; Get["/settings"] = _ => { var m = Context.Model(string.Format("Admin - {0}", (string)_settings.SiteTitle)); m.Name = _settings.Name; m.SiteTitle = _settings.SiteTitle; m.WelcomeMessage = _settings.WelcomeMessage; m.HomePage = _settings.HomePage; m.GAnalyticsKey = _settings.GAnalyticsKey; m.MaxThumbnailWidth = _settings.MaxThumbnailWidth; return View["Admin/Settings", m]; }; Post["/settings"] = _ => { _settings.WelcomeMessage = Request.Form.welcomemessage; _settings.SiteTitle = Request.Form.sitetitle; _settings.Name = Request.Form.yourname; _settings.HomePage = Request.Form.homepage; _settings.GAnalyticsKey = Request.Form.analyticskey; _settings.MaxThumbnailWidth = Request.Form.maxthumbnailwidth; return Response.AsRedirect("/admin/settings"); }; Get["/search"] = _ => ""; Get["/forums"] = _ => ""; Get["/forum/{forumId}"] = _ => ""; Get["/uservoice"] = _ => View["Admin/Uservoice", Context.Model("Admin")]; Post["/uservoice"] = _ => { var client = new WebClient(); var suggestions = GetSuggestions(client, Request.Form.channel, Request.Form.forumid, Request.Form.apikey, Request.Form.trusted); foreach (var s in suggestions) { string title = s.title; //If the idea exists, skip it if (ideas.FindBy(i => i.Title == title).Any()) continue; string date = s.created_at; var idea = new Idea { Title = title, Description = s.text, Time = DateTime.Parse(date.Substring(0, date.Length - 5)), }; string status = string.Empty; switch ((string)s.state) { case "approved": status = "Active"; break; case "closed" : if (s.status.key == "completed") status = "Completed"; else status = "Declined"; break; default: status = "New"; break; } idea.Status = status; //Get the author, or create string name = s.creator.name; var existing = users.FindBy(u => u.UserName == name).FirstOrDefault(); if (existing != null) idea.Author = existing; else { idea.Author = NewUser(s.creator); users.Add(idea.Author); } ideas.Add(idea); //Process all comments var comments = GetComments(client, (string)s.id, Request.Form.channel, Request.Form.forumid, Request.Form.apikey, Request.Form.trusted); List<Activity> ideaComments = new List<Activity>(); foreach (var c in comments) { string commentdate = c.created_at; var comment = new Comment { Time = DateTime.Parse(commentdate), Text = c.text }; string commentname = c.creator.name; existing = users.FindBy(u => u.UserName == commentname).FirstOrDefault(); if (existing != null) comment.User = existing; else { comment.User = NewUser(c.creator); users.Add(comment.User); } activities.Add(idea.Id, comment); } //Process all votes var votes = GetVotes(client, (string)s.id, Request.Form.channel, Request.Form.forumid, Request.Form.apikey, Request.Form.trusted); foreach (var v in votes) { string votername = v.user.name; string votesfor = v.votes_for; int vote; if (Int32.TryParse(votesfor, out vote)) { existing = users.FindBy(u => u.UserName == votername).FirstOrDefault(); if (existing != null) ideas.Vote(idea.Id, existing.Id, vote); else { var author = NewUser(v.user); users.Add(author); ideas.Vote(idea.Id, author.Id, vote); } } } } return Response.AsRedirect("/admin"); }; }
protected Idea CreateMockIdea(Idea idea) { mockIdeasRepo.Setup(d => d.Get(idea.Id)).Returns(idea); return idea; }
public void Add(Idea idea) { db.Ideas.Add(idea); db.SaveChanges(); }
public IdeaModule(IIdeaRepository ideas, ISettingsRepository settings) : base("/idea") { _ideas = ideas; _settings = settings; Get["/new"] = _ => View["Idea/New", new { Title = string.Format("New Idea - {0}", _settings.Title), Ideas = _ideas.GetAll() }]; Get["/{id}/edit"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) return View["404"]; return View["Idea/Edit", new { Title = string.Format("Edit Idea: '{0}' - {1}", idea.Title, _settings.Title), PopularIdeas = _ideas.GetAll(), Idea = idea }]; }; Get["/{id}"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) return View["404"]; var viewModel = new IdeaViewModel(idea) { UserHasVoted = false }; return View["Idea/Index", new { Title = string.Format("{0} - {1}", idea.Title, _settings.Title), Idea = viewModel, UserId = 2 // TODO: not hard-code these }]; }; // save result of edit to database Post["/{id}/edit"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) return View["404"]; idea.Title = Request.Form.Title; idea.Description = Request.Form.Description; _ideas.Save(); return Response.AsRedirect(string.Format("/idea/{0}", idea.Id)); }; // save result of create to database Post["/new"] = _ => { var i = new Idea { Time = DateTime.UtcNow, Title = Request.Form.Title, Description = Request.Form.Description, }; ideas.Add(i); return Response.AsRedirect("/idea/" + i.Id); }; // someone else votes for the idea Post["/{id}/vote/{userid}"] = parameters => { int votes = ideas.Vote(parameters.id, parameters.userid, 1); return Response.AsJson(new { Status = "OK", NewVotes = votes }); }; // the user decides to repeal his vote Post["/{id}/unvote/{userid}"] = parameters => { int votes = ideas.Unvote(parameters.id, parameters.userid); return Response.AsJson(new { Status = "OK", NewVotes = votes }); }; Post["/{id}/delete"] = parameters => { int id = parameters.id; ideas.Delete(id); ideas.Save(); // TODO: test return Response.AsJson(new { Status = "Error" }); }; }
public void Update(Idea idea) { var tmpIdea = db.Ideas.Single(i => i.Id == idea.Id); tmpIdea = idea; // wha? db.SaveChanges(); }
public ApiModule(IdeastrikeContext db, IIdeaRepository ideas) : base("/api") { Get["/ideas"] = _ => { return Response.AsJson(db.Ideas.Select(idea => new { id = idea.Id, title = idea.Title, description = idea.Description, time = SqlFunctions.DateDiff("s", new DateTime(1970, 1, 1), idea.Time), Author = new { idea.Author.Id, idea.Author.UserName }, vote_count = idea.Votes.Sum(vote => (int?)vote.Value) ?? 0 })); }; Post["/ideas"] = _ => { var model = this.Bind<EditIdeaModel>(); var idea = new Idea { Title= model.title, Description= model.description, Time = DateTime.UtcNow }; ideas.Add(idea); return HttpStatusCode.Created; // TODO: Should return either the generated id or the json body }; Put["/ideas/{id}"] = _ => { var model = this.Bind<EditIdeaModel>(); int id = _.id; var idea = ideas.Get(id); if (idea == null) return HttpStatusCode.NotFound; if (model.title != null) idea.Title = model.title; if (model.description != null) idea.Description = model.description; ideas.Edit(idea); return HttpStatusCode.OK; }; Get["/ideas/{id}"] = _ => { int id = _.id; var o = db.Ideas.Where(idea => idea.Id == id).Select(idea => new { id = idea.Id, title = idea.Title, description = idea.Description, time = SqlFunctions.DateDiff("s", new DateTime(1970, 1, 1), idea.Time), author = new { id = idea.Author.Id, username = idea.Author.UserName }, vote_count = idea.Votes.Sum(vote => (int?)vote.Value) ?? 0, features = idea.Features.Select(feature => new { id = feature.Id, text = feature.Text, time = SqlFunctions.DateDiff("s", new DateTime(1970, 1, 1), feature.Time) }), votes = idea.Votes.Select(vote => new { user = new { id = vote.UserId, username = vote.User.UserName }, value = vote.Value }) }).FirstOrDefault(); if (o == null) return HttpStatusCode.NotFound; return Response.AsJson(o); }; Get["/ideas/{id}/features"] = _ => { int id = _.id; if (!db.Ideas.Any(idea => idea.Id == id)) return HttpStatusCode.NotFound; return Response.AsJson(db.Features.Where(d => d.Idea.Id == id).Select(feature => new { id = feature.Id, text = feature.Text, time = SqlFunctions.DateDiff("s", new DateTime(1970, 1, 1), feature.Time), })); }; Get["/ideas/{id}/votes"] = _ => { int id = _.id; if (!db.Ideas.Any(idea => idea.Id == id)) return HttpStatusCode.NotFound; return Response.AsJson(db.Votes.Where(d => d.IdeaId == id).Select(vote => new { value = vote.Value, user = new { id = vote.UserId, username = vote.User.UserName } })); }; }