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 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 IdeaModule(IIdeaRepository ideas, IUserRepository users, ISettingsRepository settings, IImageRepository imageRepository) : base("/idea") { _ideas = ideas; _settings = settings; _users = users; Get["/{id}"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) return View["404"]; User user = Context.GetCurrentUser(_users); if (user != null) { if (idea.Votes.Any(u => u.UserId == user.Id)) idea.UserHasVoted = true; } var viewModel = new IdeaViewModel(idea); var model = Context.Model(string.Format("{0} - {1}", idea.Title, _settings.Title)); model.Idea = viewModel; return View["Idea/Index", model]; }; Get["/image/{id}"] = parameters => { var id = (string)parameters.id; if (id.Contains(".")) { id = id.Substring(0, id.IndexOf(".")); //string .jpg in case it was send in } var image = imageRepository.Get(int.Parse(id)); // TODO: format should be adaptive based on backing source? return Response.FromStream(new MemoryStream(image.ImageBits), "image/jpeg"); }; Get[@"/imagethumb/{id}/{width}"] = parameters => { var image = (Image)imageRepository.Get(parameters.id); using (var memoryStream = new MemoryStream(image.ImageBits)) { var drawingImage = System.Drawing.Image.FromStream(memoryStream); var thumb = drawingImage.ToThumbnail((int)parameters.width); using (var thumbnailStream = new MemoryStream()) { // TODO: format should be adaptive based on backing source? thumb.Save(thumbnailStream, ImageFormat.Jpeg); return Response.FromStream(new MemoryStream(thumbnailStream.GetBuffer()), "image/jpeg"); //massive WTF? If I just use thumnailStream, it doesn't work... } } }; }
public JsonResult ForIdea(int id) { Idea idea = _ideas.Get(id); // return Response.AsJson().WithHeader("Vary", "Accept"); return(new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = idea.Images.Select(i => new ImageViewModel(i.Id, i.ImageBits.Length, i.Name)).ToArray(), }); }
public ActionResult Index(int id) { var idea = _ideas.Get(id); ViewBag.Title = string.Format("{0} - {1}", idea.Title, _settings.SiteTitle); ViewBag.CanChangeIdeaStatus = false; ViewBag.StatusChoices = _settings.IdeaStatusChoices.Split(','); ViewBag.UserHasVoted = false; if (User.Identity.IsAuthenticated) { var user = _users.GetUserFromUserIdentity(Request.GetIdentity()); if (idea.Votes.Any(u => u.UserId == user.Id)) { ViewBag.UserHasVoted = true; } ViewBag.CanChangeIdeaStatus = user.Claims.Contains("admin"); } return(View(new IdeaViewModel(idea))); }
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 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 ActionResult Admincomment(int id) { var idea = _ideas.Get(id); var user = _users.GetUserFromUserIdentity(Request.GetIdentity()); _activities.Add(id, new AdminActivity { OldStatus = idea.Status, NewStatus = Request.Form["Status"], User = user, Time = DateTime.UtcNow }); _activities.Save(); idea.Status = Request.Form["Status"]; _ideas.Save(); return(Redirect("/idea/" + idea.Id)); }
public Idea Get(int itemId) { return(_repository.Get(itemId)); }
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); 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 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 IdeaModule(IIdeaRepository ideas, IUserRepository users, ISettingsRepository settings, IImageRepository imageRepository) : base("/idea") { _ideas = ideas; _settings = settings; _users = users; Get["/{id}"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) { return(View["404"]); } User user = Context.GetCurrentUser(_users); if (user != null) { if (idea.Votes.Any(u => u.UserId == user.Id)) { idea.UserHasVoted = true; } } var viewModel = new IdeaViewModel(idea); var model = Context.Model(string.Format("{0} - {1}", idea.Title, _settings.Title)); model.Idea = viewModel; return(View["Idea/Index", model]); }; Get["/{id}/activity"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) { return(Response.AsJson(new { Status = "error" })); } var results = idea.Activities.Select(MapToViewModel); return(Response.AsJson(new { Status = "success", Items = results })); }; Get["/image/{id}"] = parameters => { var id = (string)parameters.id; if (id.Contains(".")) { id = id.Substring(0, id.IndexOf(".")); //string .jpg in case it was send in } var image = imageRepository.Get(int.Parse(id)); // TODO: format should be adaptive based on backing source? return(Response.FromStream(new MemoryStream(image.ImageBits), "image/jpeg")); }; Get[@"/imagethumb/{id}/{width}"] = parameters => { var image = (Image)imageRepository.Get(parameters.id); using (var memoryStream = new MemoryStream(image.ImageBits)) { var drawingImage = System.Drawing.Image.FromStream(memoryStream); var thumb = drawingImage.ToThumbnail((int)parameters.width); using (var thumbnailStream = new MemoryStream()) { // TODO: format should be adaptive based on backing source? thumb.Save(thumbnailStream, ImageFormat.Jpeg); return(Response.FromStream(new MemoryStream(thumbnailStream.GetBuffer()), "image/jpeg")); //massive WTF? If I just use thumnailStream, it doesn't work... } } }; Get["/imagesforidea/{id}"] = parameters => { Idea idea = _ideas.Get((int)parameters.id); return(Response.AsJson(idea.Images.Select(i => new ImageFileStatus(i.Id, i.ImageBits.Length, i.Name)) .ToArray() ).WithHeader("Vary", "Accept")); }; }
public IdeaModule(IIdeaRepository ideas, IUserRepository users, Settings settings, IImageRepository imageRepository) : base("/idea") { _ideas = ideas; _settings = settings; _users = users; Get["/{id}"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) return View["404"]; User user = Context.GetCurrentUser(_users); if (user != null) { if (idea.Votes.Any(u => u.UserId == user.Id)) idea.UserHasVoted = true; } var viewModel = new IdeaViewModel(idea); var model = Context.Model(string.Format("{0} - {1}", idea.Title, (string)_settings.SiteTitle)); model.Idea = viewModel; return View["Idea/Index", model]; }; Get["/{id}/activity"] = parameters => { int id = parameters.id; var idea = _ideas.Get(id); if (idea == null) return Response.AsJson(new { Status = "error" }); var results = idea.Activities.OrderBy(a => a.Time).Select(MapToViewModel); return Response.AsJson(new { Status = "success", Items = results }); }; Get["/image/{id}"] = parameters => { var id = (string)parameters.id; if (id.Contains(".")) { id = id.Substring(0, id.IndexOf(".")); //string .jpg in case it was send in } var image = imageRepository.Get(int.Parse(id)); // TODO: format should be adaptive based on backing source? return Response.FromStream(new MemoryStream(image.ImageBits), "image/jpeg"); }; Get[@"/imagethumb/{id}/{width}"] = parameters => { var image = (Image)imageRepository.Get(parameters.id); using (var memoryStream = new MemoryStream(image.ImageBits)) { var drawingImage = System.Drawing.Image.FromStream(memoryStream); int thumbWidth = (int)parameters.width; if (thumbWidth > int.Parse(_settings.MaxThumbnailWidth)) { thumbWidth = int.Parse(_settings.MaxThumbnailWidth); } var thumb = drawingImage.ToThumbnail(thumbWidth); using (var thumbnailStream = new MemoryStream()) { // TODO: format should be adaptive based on backing source? thumb.Save(thumbnailStream, ImageFormat.Jpeg); return Response.FromStream(new MemoryStream(thumbnailStream.GetBuffer()), "image/jpeg"); //massive WTF? If I just use thumnailStream, it doesn't work... } } }; Get["/imagesforidea/{id}"] = parameters => { Idea idea = _ideas.Get((int)parameters.id); return Response.AsJson(idea.Images.Select(i => new ImageFileStatus(i.Id, i.ImageBits.Length, i.Name)) .ToArray() ).WithHeader("Vary", "Accept"); }; }
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 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 } })); }; }
public Task <IEnumerable <Idea> > Get(Func <Idea, bool> predicate) { return(_ideaRepository.Get(predicate)); }