public bool AddUserSuggestion(UserSuggestion suggestion) { db.UserSuggestions.Add(suggestion); Boolean result = (db.SaveChanges() == 1); return(result); }
/// <summary> /// 用户提交意见 /// </summary> /// <param name="apiSuggestionModel"></param> /// <returns></returns> public object AddSuggestion([FromBody] ApiSuggestionModel apiSuggestionModel) { var userInfo = GetCurrentUserInfo(); UserSuggestion userSuggestion = new UserSuggestion() { Id = Guid.NewGuid(), Msg = apiSuggestionModel.Msg, UserId = userInfo.Id, CreateTime = DateTime.Now }; try { SuggestionBusiness.AddItem(userSuggestion); return(ApiReturnModel.ReturnOk("提交成功")); } catch (Exception e) { //记录日志 LogHelp.WriteLog(e.Message, ApiFileDirectoryPara.ApiErrorDir); return(ApiReturnModel.ReturnError("提交错误")); } }
public async Task <ActionResult> DeleteConfirmed(int?id) { var user = await GetUser(); UserSuggestion userSuggestion = db.UserSuggestions.Find(user.Id, id); db.UserSuggestions.Remove(userSuggestion); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: StuffSuggestion public override ActionResult Index(string sortOrder, string searchString) { List <UserSuggestion> userSuggestions = new List <UserSuggestion>(); ViewBag.TitleSortParm = String.IsNullOrEmpty(sortOrder) ? "title_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; ViewBag.VoteSortParm = sortOrder == "mostPopular" ? "leastPopular" : "mostPopular"; var suggestions = from s in db.Suggestions.Include(s => s.User).Where(s => s.GroupName == Models.Suggestion.Group.Staff) select s; if (!String.IsNullOrEmpty(searchString)) { suggestions = suggestions.Where(s => s.Title.Contains(searchString) || s.Description.Contains(searchString) || s.CreatingTime.ToString().Contains(searchString)); } switch (sortOrder) { case "title_desc": suggestions = suggestions.OrderByDescending(s => s.Title); break; case "Date": suggestions = suggestions.OrderBy(s => s.CreatingTime); break; case "date_desc": suggestions = suggestions.OrderByDescending(s => s.CreatingTime); break; case "mostPopular": suggestions = suggestions.OrderByDescending(s => s.Vote); break; case "leastPopular": suggestions = suggestions.OrderBy(s => s.Vote); break; default: suggestions = suggestions.OrderBy(s => s.Title); break; } var x = suggestions.ToList(); foreach (var suggestion in suggestions.ToList()) { UserSuggestion userSuggestion = MakeAUserSuggestion(suggestion); userSuggestions.Add(userSuggestion); } return(View(userSuggestions)); }
public ActionResult MakeSuggestion(UserSuggestion newSuggestion) { using (DataContext context = new DataContext()) { newSuggestion.UserId = WebSecurity.CurrentUserId; context.UserSuggestions.Add(newSuggestion); context.SaveChanges(); } return(Redirect("/Polls")); }
public ActionResult MySuggestion(string sortOrder, string searchString) { int currentUserId = db.users.Where(u => u.Email == User.Identity.Name).Single().Id; List <UserSuggestion> userSuggestions = new List <UserSuggestion>(); ViewBag.TitleSortParm = String.IsNullOrEmpty(sortOrder) ? "title_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; ViewBag.VoteSortParm = sortOrder == "mostPopular" ? "leastPopular" : "mostPopular"; var suggestions = from s in db.Suggestions.Include("User").Where(s => s.UserId == currentUserId) select s; if (!String.IsNullOrEmpty(searchString)) { suggestions = suggestions.Where(s => s.Title.Contains(searchString) || s.Description.Contains(searchString) || s.CreatingTime.ToString().Contains(searchString)); } switch (sortOrder) { case "title_desc": suggestions = suggestions.OrderByDescending(s => s.Title); break; case "Date": suggestions = suggestions.OrderBy(s => s.CreatingTime); break; case "date_desc": suggestions = suggestions.OrderByDescending(s => s.CreatingTime); break; case "mostPopular": suggestions = suggestions.OrderByDescending(s => s.Vote); break; case "leastPopular": suggestions = suggestions.OrderBy(s => s.Vote); break; default: suggestions = suggestions.OrderBy(s => s.Title); break; } foreach (var suggestion in suggestions.ToList()) { UserSuggestion userSuggestion = MakeAUserSuggestion(suggestion); userSuggestions.Add(userSuggestion); } return(View(userSuggestions)); }
public IActionResult SubmitSuggestion(UserSuggestion suggestion) { if (ModelState.IsValid) { //Making sure that the data that was passed is valid and if not returning the normal view with error message. If valid, adding the info the temp tempStorage.AddResturant(suggestion); return(View("SuggestList", tempStorage.SuggestList)); } else { return(View()); } }
public async Task <ActionResult> Create([Bind(Include = "UserId,SuggestionId,Status")] UserSuggestion userSuggestion) { if (ModelState.IsValid) { var user = await GetUser(); userSuggestion.UserId = user.Id; db.UserSuggestions.Add(userSuggestion); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SuggestionId = new SelectList(db.Suggestions, "Id", "Text", userSuggestion.SuggestionId); ViewBag.UserId = new SelectList(db.Users, "Id", "Email", userSuggestion.UserId); return(View(userSuggestion)); }
// GET: UserSuggestions/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var user = await GetUser(); UserSuggestion userSuggestion = db.UserSuggestions.Find(user.Id, id); if (userSuggestion == null) { return(HttpNotFound()); } return(View(userSuggestion)); }
public ActionResult Edit([Bind(Include = "UserId,SuggestionId,Status")] UserSuggestion userSuggestion) { if (ModelState.IsValid) { var entry = db.Entry(userSuggestion); if (userSuggestion.Status == SuggestionStatus.NotToday && entry.Entity.Status != SuggestionStatus.NotToday) { userSuggestion.DTAdded = DateTime.Now; } entry.State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SuggestionId = new SelectList(db.Suggestions, "Id", "Text", userSuggestion.SuggestionId); ViewBag.UserId = new SelectList(db.Users, "Id", "Email", userSuggestion.UserId); return(View(userSuggestion)); }
// GET: UserSuggestions/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var user = await GetUser(); UserSuggestion userSuggestion = db.UserSuggestions.Find(user.Id, id); if (userSuggestion == null) { return(HttpNotFound()); } ViewBag.SuggestionId = new SelectList(db.Suggestions, "Id", "Text", userSuggestion.SuggestionId); ViewBag.UserId = new SelectList(db.Users, "Id", "Email", userSuggestion.UserId); return(View(userSuggestion)); }
public ActionResult UserComplaint(String Description, String ContactType, String Contact, String Title) { try { if (Description == "") { throw new Exception("无内容请求"); } UserSuggestion suggestion = new UserSuggestion(); suggestion.AddTime = DateTime.Now; suggestion.Description = Description; suggestion.Contact = Contact; suggestion.Title = Title; suggestion.ContactType = ContactType; Service.AddUserSuggestion(suggestion); } catch (Exception ex) { return(RedirectToAction("Error")); } return(View()); }
// GET: Suggestion/Details/5 public virtual ActionResult Details(int?id, string message) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Suggestion suggestion = db.Suggestions.Find(id); UserSuggestion userSuggestion = MakeAUserSuggestion(suggestion, "detail"); if (!String.IsNullOrWhiteSpace(message)) { userSuggestion.SystemMessage = message; } if (suggestion == null) { return(HttpNotFound()); } return(View(userSuggestion)); }
protected UserSuggestion MakeAUserSuggestion(Suggestion suggestion, string flag = "index") { UserSuggestion userSuggestion = new UserSuggestion(); userSuggestion.UserId = suggestion.UserId; userSuggestion.SuggestionId = suggestion.SuggestionId; userSuggestion.FirstName = suggestion.User.FirstName; userSuggestion.LastName = suggestion.User.LastName; userSuggestion.Title = suggestion.Title; userSuggestion.Description = suggestion.Description; userSuggestion.CreatingTime = suggestion.CreatingTime; userSuggestion.Vote = suggestion.Vote; userSuggestion.GroupName = suggestion.GroupName; userSuggestion.NumComments = suggestion.SuggestionComments.Count; userSuggestion.Email = suggestion.User.Email; foreach (var upvote in suggestion.SuggestionUpvotes) { userSuggestion.SuggestionUpvotes.Add(upvote); } if (flag == "detail") { foreach (var comment in suggestion.SuggestionComments) { SuggestionCommentView suggestionCommentView = new SuggestionCommentView(); suggestionCommentView.CommentId = comment.CommentId; suggestionCommentView.UserId = comment.UserId; suggestionCommentView.UserName = comment.User.LastName + ", " + comment.User.FirstName; suggestionCommentView.Email = comment.User.Email; suggestionCommentView.SuggestionId = comment.SuggestionId; suggestionCommentView.Description = comment.Description; suggestionCommentView.CreatingTime = comment.CreatingTime; userSuggestion.SuggestionCommentViews.Add(suggestionCommentView); } } return(userSuggestion); }