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 void Add(Idea idea)
{
db.Ideas.Add(idea);
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 }
}));
};
}
