//Create new user public async Task <ForumModel> Create(ForumModel user) { await Task.Run(() => _content.InsertOne(user)); return(user); }
public virtual IActionResult EditForum(ForumModel model, bool continueEditing) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageForums)) { return(AccessDeniedView()); } //try to get a forum with the specified id var forum = _forumService.GetForumById(model.Id); if (forum == null) { return(RedirectToAction("List")); } if (ModelState.IsValid) { forum = model.ToEntity(forum); forum.UpdatedOnUtc = DateTime.UtcNow; _forumService.UpdateForum(forum); SuccessNotification(_localizationService.GetResource("Admin.ContentManagement.Forums.Forum.Updated")); return(continueEditing ? RedirectToAction("EditForum", forum.Id) : RedirectToAction("List")); } //prepare model model = _forumModelFactory.PrepareForumModel(model, forum, true); //if we got this far, something failed, redisplay form return(View(model)); }
public IActionResult Question(ForumModel forumModel) { forumModel.userId = HttpContext.Session.GetInt32("UserId") ?? 0; forumModel.date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); forumModel.SaveQuestion(); return(RedirectToAction("Index", "Forum")); }
/// <summary> /// Get Forum list /// </summary> /// <param name="model"></param> /// <returns></returns> public List <ForumModel> GetForumListing(ForumModel model) { var bookingList = context.vw_GetForumList.Where(x => x.StratasBoardId == model.StratasBoardId && x.STATUS == 1).OrderByDescending(x => x.CreatedOn).ToList(); List <ForumModel> objProjListingModel = new List <ForumModel>(); foreach (var item in bookingList) { ForumModel objBookingList = new ForumModel { TopicId = item.TopicId, Topic = item.Topic, TopicContent = item.TopicContent, UploadedFileName = item.UploadedFileName, UploadedFileActualName = item.UploadedFileActualName, CreatedOn = item.CreatedOn.Value, CreatedDate = item.CreatedDate, CreatedTime = item.CreatedTime, Status = item.STATUS.Value, CreatedDateTime = item.CreatedDateTime, CreatedBy = item.CreatedBy.Value, StratasBoardId = item.StratasBoardId.Value, IsFlagged = item.IsFlagged.Value, CreatedByName = item.CreatedByName, ReplyCounter = item.ReplyCounter.Value // FlaggedByLoggedInUser = GetFlaggedUser(item.TopicId, ClientSessionData.UserClientId) }; objProjListingModel.Add(objBookingList); } return(objProjListingModel); }
//文章內部得細項 public ActionResult Detail(int?id = 10) { //接著透過cookie找出會員編號,確認讀讚人數 if (Request.Cookies["account"] != null) { string epid = Request.Cookies["account"].Value; var EP_ID = db.tEmployee.Where(p => p.fEp_Code == epid).Single().fEp_ID; ViewBag.EPIP = EP_ID; } var ftID = db.tForumTitle.Where(p => p.fMC_ID == id).First().fFT_ID; var addPOP = db.tForumTitle.Where(p => p.fMC_ID == id).First().fFT_Popul; tForumTitle updatePopul = db.tForumTitle.Find(ftID); updatePopul.fFT_Popul = updatePopul.fFT_Popul + 1; db.Entry(updatePopul).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //讀取Detail ForumModel vm = new ForumModel(); vm.Fclass = db.tForumClass.Where(p => p.fFC_Dad == null); vm.pushGood = db.tPushGood; vm.Fmessage = db.tForumMessage.Where(p => p.fMC_ID == id); vm.Ftitle = db.tForumTitle.Where(p => p.fMC_ID == id); vm.employees = db.tEmployee.Where(p => p.tForumMessage.First().fMC_ID == id); return(View(vm)); }
public ActionResult Edit(ForumModel model, string type, string returnURL) { ForumModel item = FindItemById(model.ID, type); if (item == null) { return(RedirectToAction(CategoriesPage, Db.ForumCategories)); } if (ModelState.IsValid) { item.Text = model.Text; try { Db.Entry(item).State = EntityState.Modified; Db.SaveChanges(); } catch (DbEntityValidationException ex) { var errorMessage = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage); ViewBag.ErrorMessage = string.Join("; ", errorMessage); return(View(model)); } return(Redirect(returnURL)); } return(View(model)); }
protected void Page_Load(object sender, EventArgs e) { btnSearch.Text = DictionaryConstants.GoButtonText; txtSearch.Attributes.Add("placeholder", DictionaryConstants.Community_EnterConversation); if (!IsPostBack) { ResultCount = 10; Item currItem = Sitecore.Context.Item; if (currItem != null) { hrfBack.HRef = LinkManager.GetItemUrl(currItem.Parent); litBack.Text = currItem.Parent.Name; ForumItem frmItem = new ForumItem(currItem); Session["forumItem"] = frmItem; if (frmItem != null) { ForumModel frmModel = Forum.ForumModelFactory(frmItem); litForumName.Text = frmModel.Name; if (frmModel != null) { Session["_threads"] = frmModel.Threads; rptThread.DataSource = frmModel.Threads.Take(ResultSet); rptThread.DataBind(); } } } } }
//收回點讚 public ActionResult recoveryGood(tPushGood recoveryPG, int?id = 1) { if (Request.Cookies["account"] == null) { return(RedirectToAction("Detail", "ForumHome", new { id = id })); } //傳值得ID便是文章編號,以及cookie的員工編號,便可找出他點讚的編號,刪掉就是取消 string epid = Request.Cookies["account"].Value; var EP_ID = db.tEmployee.Where(p => p.fEp_Code == epid).Single().fEp_ID; var PGid = db.tPushGood.Where(p => p.fFM_ID == id && p.fEp_ID == EP_ID).Single().fPG_ID; tPushGood delePG = db.tPushGood.Find(PGid); db.tPushGood.Remove(delePG); db.SaveChanges(); ForumModel vm = new ForumModel(); vm.Fmessage = db.tForumMessage.Where(p => p.fFM_ID == id); vm.pushGood = db.tPushGood; return(PartialView(vm)); }
public ActionResult twitter_all(int?id = 1) { ForumModel vm = new ForumModel(); vm.Fmessage = db.tForumMessage.Where(p => p.fFM_Dad == id); return(PartialView(vm)); }
public virtual IActionResult CreateForum(ForumModel model, bool continueEditing) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageForums)) { return(AccessDeniedView()); } if (ModelState.IsValid) { var forum = model.ToEntity <Forum>(); forum.CreatedOnUtc = DateTime.UtcNow; forum.UpdatedOnUtc = DateTime.UtcNow; _forumService.InsertForum(forum); _notificationService.SuccessNotification(_localizationService.GetResource("Admin.ContentManagement.Forums.Forum.Added")); return(continueEditing ? RedirectToAction("EditForum", new { forum.Id }) : RedirectToAction("List")); } //prepare model model = _forumModelFactory.PrepareForumModel(model, null, true); //if we got this far, something failed, redisplay form return(View(model)); }
//點讚去 public ActionResult pushGoodall(tPushGood updatePG, int?id = 1) { //當然你沒有帳號,會重登一次頁面,之後會要修改成登入頁面 if (Request.Cookies["account"] == null) { return(RedirectToAction("Detail", "ForumHome", new { id = id })); } //傳值得ID便是文章編號,透過他可找出文章代碼,接著透過cookie找出會員編號,再匯入點讚裡面 string epid = Request.Cookies["account"].Value; var EP_ID = db.tEmployee.Where(p => p.fEp_Code == epid).Single().fEp_ID; var MC_ID = db.tForumMessage.Where(p => p.fFM_ID == id).Single().fMC_ID; updatePG.fEp_ID = EP_ID; updatePG.fFM_ID = id; db.tPushGood.Add(updatePG); db.SaveChanges(); ForumModel vm = new ForumModel(); vm.Fmessage = db.tForumMessage.Where(p => p.fFM_ID == id); vm.pushGood = db.tPushGood; return(PartialView(vm)); }
public virtual async Task<IActionResult> EditForum(ForumModel model, bool continueEditing) { if (!await _permissionService.AuthorizeAsync(StandardPermissionProvider.ManageForums)) return AccessDeniedView(); //try to get a forum with the specified id var forum = await _forumService.GetForumByIdAsync(model.Id); if (forum == null) return RedirectToAction("List"); if (ModelState.IsValid) { forum = model.ToEntity(forum); forum.UpdatedOnUtc = DateTime.UtcNow; await _forumService.UpdateForumAsync(forum); _notificationService.SuccessNotification(await _localizationService.GetResourceAsync("Admin.ContentManagement.Forums.Forum.Updated")); return continueEditing ? RedirectToAction("EditForum", forum.Id) : RedirectToAction("List"); } //prepare model model = await _forumModelFactory.PrepareForumModelAsync(model, forum, true); //if we got this far, something failed, redisplay form return View(model); }
public static ForumDTO Map(ForumModel forumModel) { ForumDTO result = MapperBag.ForumMapper.Map(forumModel); result.TopicDtos = MapperBag.TopicMapper.Map(forumModel.Topics).ToList(); return(result); }
public ForumModel GetBy(int id) { ForumModel post = new ForumModel(); var sql = string.Format("SELECT * FROM PostTable WHERE PostId = '{0}'", id); var connectionString = "Server=(local);Database=Savnac.Database;Trusted_Connection=True;"; var command = new SqlCommand(sql, new SqlConnection(connectionString)); using (var connection = command.Connection) { connection.Open(); using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { post = new ForumModel() { postId = (int)reader["postId"], title = reader["postTitle"].ToString(), content = reader["postContent"].ToString(), datePosted = (DateTime)reader["postTime"], courseId = (int)reader["courseId"], userName = reader["userName"].ToString(), isRead = (bool)reader["post_isRead"] }; } } return(post); }
public ActionResult CreateForum(ForumModel model, bool continueEditing) { if (!_services.Permissions.Authorize(StandardPermissionProvider.ManageForums)) { return(AccessDeniedView()); } if (ModelState.IsValid) { var utcNow = DateTime.UtcNow; var forum = model.ToEntity(); _forumService.InsertForum(forum); model.SeName = forum.ValidateSeName(model.SeName, forum.Name, true); _urlRecordService.SaveSlug(forum, model.SeName, 0); NotifySuccess(_services.Localization.GetResource("Admin.ContentManagement.Forums.Forum.Added")); return(continueEditing ? RedirectToAction("EditForum", new { forum.Id }) : RedirectToAction("List")); } //If we got this far, something failed, redisplay form foreach (var forumGroup in _forumService.GetAllForumGroups(true)) { var forumGroupModel = forumGroup.ToModel(); model.ForumGroups.Add(forumGroupModel); } return(View(model)); }
public ActionResult CreateForum(ForumModel model, bool continueEditing) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageForums)) { return(AccessDeniedView()); } if (ModelState.IsValid) { var forum = model.ToEntity(); forum.CreatedOnUtc = DateTime.UtcNow; forum.UpdatedOnUtc = DateTime.UtcNow; _forumService.InsertForum(forum); SuccessNotification(_localizationService.GetResource("Admin.ContentManagement.Forums.Forum.Added")); return(continueEditing ? RedirectToAction("EditForum", new { forum.Id }) : RedirectToAction("List")); } //If we got this far, something failed, redisplay form foreach (var forumGroup in _forumService.GetAllForumGroups()) { var forumGroupModel = forumGroup.ToModel(); model.ForumGroups.Add(forumGroupModel); } return(View(model)); }
public void update_a_forum() { //Create forum Connection one = new Connection(); ForumRepo repo = new ForumRepo(new Connection()); ForumModel forum = new ForumModel(); forum.name = "testname"; forum.description = "testdescription"; int id = repo.store(forum); forum.id = id; //Give forum a new name forum.name = "new name!"; repo.update(forum); one.Connect(); SqlCommand sqlCommand = new SqlCommand("select * from forum where name = 'new name!'", one.getConnection()); SqlDataReader reader = sqlCommand.ExecuteReader(); Assert.AreEqual(true, reader.HasRows); one.disConnect(); repo.destroy(id); }
public static Item CreateSitecoreForum(ForumModel frmModel, string groupItemID, Language lang) { Item grpItem = Groups.ConvertGroupIDtoSitecoreItem(groupItemID); return CreateSitecoreForum(frmModel, grpItem, lang); }
public IActionResult EditForum(ForumModel model, bool continueEditing) { var forum = _forumService.GetForumById(model.Id); if (forum == null) { //No forum found with the specified id return(RedirectToAction("List")); } if (ModelState.IsValid) { forum = model.ToEntity(forum); forum.UpdatedOnUtc = DateTime.UtcNow; _forumService.UpdateForum(forum); SuccessNotification(_localizationService.GetResource("Admin.ContentManagement.Forums.Forum.Updated")); return(continueEditing ? RedirectToAction("EditForum", new { id = forum.Id }) : RedirectToAction("List")); } //If we got this far, something failed, redisplay form foreach (var forumGroup in _forumService.GetAllForumGroups()) { var forumGroupModel = forumGroup.ToModel(); model.ForumGroups.Add(forumGroupModel); } return(View(model)); }
public ActionResult EditForum(ForumModel model, bool continueEditing) { var forum = _forumService.GetForumById(model.Id); if (forum == null) { return(RedirectToAction("List")); } if (ModelState.IsValid) { forum = model.ToEntity(forum); _forumService.UpdateForum(forum); model.SeName = forum.ValidateSeName(model.SeName, forum.Name, true); _urlRecordService.SaveSlug(forum, model.SeName, 0); UpdateLocales(model, forum); NotifySuccess(_services.Localization.GetResource("Admin.ContentManagement.Forums.Forum.Updated")); return(continueEditing ? RedirectToAction("EditForum", forum.Id) : RedirectToAction("List")); } //If we got this far, something failed, redisplay form foreach (var forumGroup in _forumService.GetAllForumGroups(0, true)) { var forumGroupModel = forumGroup.ToModel(); model.ForumGroups.Add(forumGroupModel); } return(View(model)); }
public ActionResult twitter_short(int?id = 1) { ForumModel vm = new ForumModel(); vm.Fmessage = db.tForumMessage.Where(p => p.fFM_Dad == id).OrderByDescending(p => p.fFM_Date); return(PartialView(vm)); }
public IActionResult Post(ForumModel model)//pass in QuizModel as a quizmodel then instantiate it and add it. { repo.AddPost(model); return(Redirect("Forum")); // return View(model); //repo.AddPost(model)^ }
public ActionResult Index() { ForumModel forumModel = new ForumModel(); DataTable posts = new DataTable(); List <PostModel> PostModel = new List <PostModel>(); using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string getPosts = "SELECT * FROM Tbl_Posts ORDER BY Tbl_Posts.PostId DESC"; SqlDataAdapter sqlDa = new SqlDataAdapter(getPosts, sqlCon); sqlDa.Fill(posts); for (int i = 0; i < posts.Rows.Count; i++) { PostModel.Add(new Models.PostModel { PostId = int.Parse(posts.Rows[i]["PostId"].ToString()), PostContent = posts.Rows[i]["PostContent"].ToString(), PostFile = posts.Rows[i]["PostFile"].ToString(), Date = posts.Rows[i]["Date"].ToString(), }); } forumModel.PostModels = PostModel; } return(View(forumModel)); }
public ActionResult ComposePost(ForumModel model) { ForumRepository repository = new ForumRepository(); repository.AddPost(User.Identity.Name, model.title, model.content, model.courseId); return(RedirectToAction("PostMessage")); }
// GET: Home //討論版首頁,可以看到熱門文章與入口 public ActionResult FirstPage(int?id = 0) { ForumModel vm = new ForumModel(); vm.Fclass = db.tForumClass.Where(p => p.fFC_Dad == null); return(View(vm)); }
public IActionResult Reply(ForumModel forumModel) { forumModel.userIdReply = HttpContext.Session.GetInt32("UserId") ?? 0; forumModel.date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); forumModel.SaveReply(); forumModel.answer = String.Empty; return(RedirectToAction("Index", "Forum")); }
public IActionResult AddForum(int GameID) { ForumModel forum = new ForumModel(); forum.GameID = GameID; return(View(forum)); }
public ActionResult ReadPost(ForumModel model) { ForumRepository repository = new ForumRepository(); repository.MarkRead(model.postId); return(View(model)); }
public async Task UpdateForum(ForumModel forum) { forum.UpdateTimestamps(false); using (var ct = GetConnection(DatabaseType.Forum, false)) { await ct.DbConnection.ExecuteAsync(ReadQuery("UpdateForum", ct.ProviderName), forum, transaction : ct.DbTransaction); } }
public ActionResult FPclicktitle(int?id = 0) { ForumModel vm = new ForumModel(); vm.Fclass = db.tForumClass; vm.Ftitle = db.tForumTitle.AsEnumerable().Where(a => a.fFT_Date > DateTime.Now.AddMonths(-3)).OrderByDescending(a => a.tMessageCode.tForumMessage.First().tPushGood.Count()).Take(5); return(PartialView(vm)); }
public ActionResult FPpushgood(int?id = 0) { ForumModel vm = new ForumModel(); vm.Fclass = db.tForumClass; vm.Ftitle = db.tForumTitle.AsEnumerable().Where(a => a.fFT_Date > DateTime.Now.AddMonths(-3)).OrderByDescending(a => a.fFT_Popul).Take(5); return(PartialView(vm)); }
public static ForumModel ForumModelFactory(ForumItem item) { ForumModel frm = new ForumModel(item, TelligentService.TelligentService.ReadThreadList); return frm; }
public static Item CreateSitecoreForum(ForumModel frmModel, GroupItem grpItem, Language lang) { Item newItem = null; try { if (frmModel != null && grpItem != null && lang != null) { //Again we need to handle security //In this example we just disable it using (new SecurityDisabler()) { //First get the parent item from the master database Database masterDb = global:: Sitecore.Configuration.Factory.GetDatabase("master"); Item parentItem = masterDb.Items[grpItem.InnerItem.Paths.Path, lang]; //Now we need to get the template from which the item is created (Forum Thread Template) TemplateItem template = masterDb.GetTemplate(ForumModel.TemplateID); //StringBuilder sb = new StringBuilder(ItemName.Trim()); // string newName = ItemName.Replace('.', '_');//.Substring(0, ItemName.LastIndexOf(".")); // if(newName.Contains(".")) // newName=newName.Substring(newName.IndexOf(".") + 1); newItem = masterDb.GetItem(parentItem.Paths.Path + "/" + frmModel.Name, lang); if (newItem == null) { //Now we can add the new item as a child to the parent newItem = parentItem.Add(frmModel.Name, template); } //We can now manipulate the fields and publish as in the previous example //Item item = masterDb.GetItem(newItem); //Begin editing newItem.Editing.BeginEdit(); try { //perform the editing newItem.Fields["GroupID"].Value = frmModel.GroupID; newItem.Fields["ForumID"].Value = frmModel.ForumID; // errorState = true; } catch (Exception ex) { // errorState = false; throw ex; } finally { //Close the editing state newItem.Editing.EndEdit(); } } } } catch (Exception ex) { //Elmah.ErrorSignal.FromCurrentContext().Raise(new Exception("Error with :" + ItemName + " (" + lang.Name + ")\n Details:\n" + ex.Message)); Sitecore.Diagnostics.Error.LogError("Error with :" + frmModel.Name + " (" + lang.Name + ")\n Details:\n" + ex.Message); newItem = null; } return newItem; }