/// <summary> /// Reloads the data of the forum control. /// </summary> public override void ReloadData() { base.ReloadData(); this.UniPager1.Enabled = this.EnableThreadPaging; this.UniPager1.PageSize = this.ThreadPageSize; // Hide selected area if forum is AdHoc if (this.IsAdHocForum) { plcHeader.Visible = false; if (ForumContext.CurrentForum.ForumID == 0) { plcContent.Visible = false; } } // Get thread and subscribe link url bool newThread = base.IsAvailable(null, ForumActionType.NewThread); bool newSubscription = base.IsAvailable(null, ForumActionType.SubscribeToForum); bool newFavorites = base.IsAvailable(null, ForumActionType.AddForumToFavorites); bool newBreadCrumbs = (ForumBreadcrumbs1.GenerateBreadcrumbs() != ""); // Hide separators according to the link visibility // Each separator is hidden if the item preceeding the separator is invisible or // no item is behind the separator. if (!newThread || (!newSubscription && !newFavorites && !newBreadCrumbs)) { plcActionSeparator.Visible = false; } if (!newSubscription || (!newFavorites && !newBreadCrumbs)) { plcAddToFavoritesSeparator.Visible = false; } if (!newFavorites || !newBreadCrumbs) { plcBreadcrumbsSeparator.Visible = false; } if ((ForumContext.CurrentForum != null) && (ForumContext.CurrentForum.ForumID > 0)) { string orderBy = "PostStickOrder Desc, PostThreadLastPostTime DESC"; if (ForumContext.UserIsModerator(this.ForumID, this.CommunityGroupID)) { orderBy = "PostStickOrder Desc, PostThreadLastPostTimeAbsolute DESC"; } // Retrieve data just for the current page int currentOffset = EnablePostsPaging ? ThreadPageSize * (UniPager1.CurrentPage - 1) : 0; int maxRecords = EnablePostsPaging ? ThreadPageSize : 0; int totalRecords = 0; listForums.DataSource = ForumPostInfoProvider.SelectForumPosts(this.ForumID, "/%", null, orderBy, 0, !ForumContext.UserIsModerator(this.ForumID, this.CommunityGroupID), -1, null, currentOffset, maxRecords, ref totalRecords); // Set the total number of records to the pager UniPager1.PagedControl.PagerForceNumberOfResults = totalRecords; listForums.DataBind(); } }
public TopicController( ILogger <HomeController> logger, ForumContext context) { _logger = logger; _context = context; }
public static void RunInConnection <T>(Func <ForumContext, T> createRepo, Action <T> f) { var connection = new SqliteConnection("DataSource=:memory:"); connection.Open(); try { var options = new DbContextOptionsBuilder <ForumContext>() .UseSqlite(connection) .Options; // Create the schema in the database using (var context = new ForumContext(options)) { context.SeedData().Wait(); } // Insert seed data into the database using one instance of the context using (var context = new ForumContext(options)) { var rep = createRepo(context); f(rep); } } finally { connection.Close(); } }
private void SeedUsers(ForumContext context) { var store = new UserStore <Uzytkownik>(context); var manager = new UserManager <Uzytkownik>(store); if (!context.Users.Any(u => u.UserName == "*****@*****.**")) { var user = new Uzytkownik { UserName = "******", Email = "*****@*****.**", Imie = "Piotr", Nazwisko = "Pisarski", Foto = "autor1.jpg" }; var adminresult = manager.Create(user, "Mz8jpg5a!"); if (adminresult.Succeeded) { manager.AddToRole(user.Id, "Admin"); } } if (!context.Users.Any(u => u.UserName == "*****@*****.**")) { var user = new Uzytkownik { UserName = "******", Email = "*****@*****.**", Imie = "Anna", Nazwisko = "Autorska", Foto = "autor2.jpg" }; var adminresult = manager.Create(user, "Mz8jpg5a!"); if (adminresult.Succeeded) { manager.AddToRole(user.Id, "User"); } } }
public UnitOfWorkIdentity(/*string connectionString*/) { _db = new ForumContext(/*connectionString*/); _userService = new ApplicationUserService(new UserStore <ApplicationUser>(_db)); _roleService = new ApplicationRoleService(new RoleStore <ApplicationRole>(_db)); _clientService = new ClientService(_db); }
protected void Page_Load(object sender, EventArgs e) { string currentForumPost = ""; string[] post = QueryHelper.GetString("postid", "").Split(';'); postId = ValidationHelper.GetInteger(post[0], 0); ForumContext.CheckSite(0, 0, postId); if (post.Length >= 2) { forumId = ValidationHelper.GetInteger(post[1], 0); this.postListing.ForumId = forumId; } // Show current post postInfo = ForumPostInfoProvider.GetForumPostInfo(postId); if (postInfo != null) { currentForumPost = HTMLHelper.HTMLEncode(postInfo.PostSubject); this.postListing.PostInfo = postInfo; } // If not post, show current forum else if (forumId > 0) { ForumInfo fi = ForumInfoProvider.GetForumInfo(forumId); if (fi != null) { currentForumPost = fi.ForumDisplayName; } } this.postListing.IsLiveSite = false; this.InitializeMasterPage(currentForumPost); }
public void EditPost(Post u) { ForumContext db = new ForumContext(); db.Entry(db.postDB.SingleOrDefault(x => x.id == u.id)).CurrentValues.SetValues(u); db.SaveChanges(); }
internal List <CategoryData> GetCategoryDataApi() { List <Forum> cat; var local = new List <CategoryData>(); using (ForumContext db = new ForumContext()) { cat = db.Forum.Include(d => d.Topics).ToList(); } foreach (var c in cat) { var l = new CategoryData(); var topic = new List <TopicData>(); l.CategoryID = c.CategoryID; l.Title = c.Title; foreach (var t in c.Topics) { var lt = new TopicData { TopicID = t.TopicID, Title = t.Title }; topic.Add(lt); } l.Topics = topic; local.Add(l); } return(local); }
// // GET: /Forum/ public ActionResult Board() { ForumContext context = new ForumContext(); return(View(context.board.ToList())); }
public void DeletePost(Post u) { ForumContext db = new ForumContext(); db.postDB.Remove(u); db.SaveChanges(); }
public TopicRepository( ForumContext db, IMapper mapper) { _db = db ?? throw new ArgumentNullException(nameof(db)); _mapper = mapper ?? throw new ArgumentNullException(nameof(mapper)); }
// not implemented private async Task <List <Thread> > SearchByThread(string searchText, string category1, string category2) { using (var set = new ForumContext()) { dynamic items; if (!string.IsNullOrEmpty(searchText)) { switch (category1) { case "Thread name": items = await set.Threads.Where(x => x.Name.StartsWith(searchText)).ToListAsync(); break; case "Price": items = await set.Threads.Where(x => x.Name.Contains(searchText)).ToListAsync(); break; default: items = await set.Threads.ToListAsync(); break; } } else { items = await set.Threads.ToListAsync(); } return(items); } }
private async Task AddNewThread(Thread item) { using (var set = new ForumContext()) { var dbThread = set.Threads .SingleOrDefault(t => t.Name == item.Name); if (dbThread == null) { User user = (User)Session["User"]; var author = await set.Users.FirstOrDefaultAsync(u => u.Id == user.Id); Thread newItem = new Thread() { User = author, Name = item.Name }; set.Threads.Add(newItem); await set.SaveChangesAsync(); logger.Info($"User { Session["Username"] as string} added a new thread \"{newItem.Name}\" "); } } }
static void Main(string[] args) { var context = new ForumContext(); context.Users.Add(new User { Username = "******", Email = "*****@*****.**", Password = "******", RoleId = 3, }); context.SaveChanges(); //context.Users.Add(new User //{ // Username = "******", // Email = "*****@*****.**", // Password = "******", //}); //var context = new ForumContext(); //var users = context // .Users // .Where(u => u.Username.Length > 3) // .Include(u => u.Role).ToList(); //foreach (var user in users) //{ // System.Console.WriteLine(user.Username + " " + user.Role.Name); //} }
public void DeleteDiscussion(Discussion u) { ForumContext db = new ForumContext(); db.discussionDB.Remove(u); db.SaveChanges(); }
internal SubjectResp AddSubjectAction(SubjectData subject, int c_id, int t_id) { using (var db = new ForumContext()) { Forum category; category = (from e in db.Forum where e.CategoryID == c_id select e).Include(d => d.Topics).FirstOrDefault(); FTopic topic; topic = (from e in category.Topics where e.TopicID == t_id select e).FirstOrDefault(); if (topic.Subjects == null) { topic.Subjects = new List <FSubject>(); } var sub = new FSubject() { Title = subject.Title, Text = subject.Text }; topic.Subjects.Add(sub); db.Entry(category).State = EntityState.Modified; db.SaveChanges(); } return(new SubjectResp()); }
public void EditDiscussion(Discussion u) { ForumContext db = new ForumContext(); db.Entry(db.discussionDB.SingleOrDefault(x => x.DiscussionId == u.DiscussionId)).CurrentValues.SetValues(u); db.SaveChanges(); }
internal TopicData GetTopicDataApi(int id) { var local = new TopicData { Subjects = new List <SubjectData>() }; using (ForumContext db = new ForumContext()) { FTopic topic; topic = (from e in db.Topic where e.TopicID == id select e).Include(d => d.Subjects).FirstOrDefault(); local.TopicID = topic.TopicID; local.Title = topic.Title; foreach (var sub in topic.Subjects) { var s = new SubjectData { SubjectID = sub.SubjectID, Title = sub.Title, Author = sub.Author, Text = sub.Text }; local.Subjects.Add(s); } } return(local); }
public TopicController( ForumContext forumContext, TopicService topicService) { _forumContext = forumContext; _topicService = topicService; }
static void Main() { var context = new ForumContext(); /*-----------------------------------------------*/ //var user = new User //{ // FirstName = "Pesho", // LastName = "Goshev", // Gender = Gender.NotSpedified, // Username = "******", // RegisteredOn = DateTime.Now //}; //context.Users.Add(user); /*-----------------------------------------------*/ //var question = new Question //{ // Content = "Alcohol", // Title = "daite pls", // AuthorId = 1 //}; //context.Questions.Add(question); /*-----------------------------------------------*/ //var question = context.Questions.Find(2); //question.Tags.Add(new Tag() // { // Name = "Drugi prikazki" // }); //question.Tags.Add(new Tag() //{ // Name = "Vajni saobshteniya" //}); //context.SaveChanges(); //foreach (var tag in question.Tags) //{ // Console.WriteLine(tag.Name); //} /*-----------------------------------------------*/ //var user = context.Users.Find(1); var users = context.Users.ToList(); foreach (var friend in users[0].Friends) { Console.WriteLine(friend.FirstName + " " + friend.LastName); } context.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { string currentForumPost = ""; postId = QueryHelper.GetInteger("postid", 0); ForumContext.CheckSite(0, 0, postId); CurrentMaster.PanelContent.CssClass = String.Empty; ForumPostInfo forumPostObj = ForumPostInfoProvider.GetForumPostInfo(postId); if (forumPostObj != null) { currentForumPost = HTMLHelper.HTMLEncode(forumPostObj.PostSubject); } string listingPost = QueryHelper.GetString("listingpost", null); if (!String.IsNullOrEmpty(listingPost)) { listingParameter = "&listingpost=" + HTMLHelper.HTMLEncode(listingPost); } this.postEdit.EditPostID = postId; this.postEdit.OnSaved += new EventHandler(postEdit_OnSaved); this.postEdit.IsLiveSite = false; this.InitializeMasterPage(currentForumPost); }
// Возврат результата регистрации с записью в БД public static bool RegisterUser(HttpResponseBase response, string login, string pswrd) { bool isValid = false; if (ValidateLogin(login)) { using (ForumContext _db = new ForumContext()) { User user = new User(); user.Login = login; user.Password = GetHash(pswrd); user.Role = _db.Roles.FirstOrDefault(p => p.Id == 3); _db.Users.Add(user); _db.SaveChanges(); user = (from u in _db.Users where (u.Login == login) select u).FirstOrDefault(); if (user != null) { SetTicket(response, user); isValid = true; } } } return(isValid); }
public ActionResult Create(FormCollection form) { ForumContext context = new ForumContext(); Post post = new Post(); post.description = form["description"]; post.postedAt = DateTime.Now; if (form["postType"] == "Quote_Reply") { post.repliedTo = Convert.ToInt32(form["repliedTo"]); //post.repliedTo = p.repliedTo; post.postType = "Quote Reply"; //return post.postType + post.repliedTo +"ThreadID"+form["ThreadID"]; } else { post.postType = "Thread_Reply"; //return post.postType; } post.ThreadID = Convert.ToInt32(form["ThreadID"]); post.postedBy = Convert.ToInt32(form["postedBy"]); context.post.Add(post); context.SaveChanges(); return(RedirectToAction("Details", "Thread", new { id = form["ThreadID"] })); //return View("~/Views/Thread/Details.cshtml/" + form["ThreadID"].ToString()); //return post.postedBy.ToString(); }
protected void Page_Load(object sender, EventArgs e) { int forumId = ValidationHelper.GetInteger(Request.QueryString["forumid"], 0); ForumContext.CheckSite(0, forumId, 0); if (ValidationHelper.GetInteger(Request.QueryString["saved"], 0) > 0) { postsTreeUrl += forumId.ToString() + "&saved=1"; postsEditUrl += forumId.ToString() + "&saved=1"; } else { postsTreeUrl += forumId.ToString(); postsEditUrl += forumId.ToString(); } frameTree.Attributes["name"] = postFrameTree; frameTree.Attributes["src"] = postsTreeUrl; frameEdit.Attributes["name"] = postFrameEdit; frameEdit.Attributes["src"] = postsEditUrl; if (CultureHelper.IsUICultureRTL()) { ControlsHelper.ReverseFrames(colsFrameset); } }
public ActionResult Edit(int id) { ForumContext context = new ForumContext(); Post post = context.post.Where(s => s.postId == id).FirstOrDefault(); return(View(post)); }
private void SeedIkony(ForumContext context) { var kat = new List <Ikona> { new Ikona { IdIkony = 1, NazwaIkony = "glyphicon glyphicon-star-empty" }, new Ikona { IdIkony = 2, NazwaIkony = "glyphicon glyphicon-remove" }, new Ikona { IdIkony = 3, NazwaIkony = "glyphicon glyphicon-list-alt" }, new Ikona { IdIkony = 4, NazwaIkony = "glyphicon glyphicon-tint" }, new Ikona { IdIkony = 5, NazwaIkony = "glyphicon glyphicon-leaf" }, new Ikona { IdIkony = 6, NazwaIkony = "glyphicon glyphicon-wrench" } }; kat.ForEach(i => context.Ikony.AddOrUpdate(i)); context.SaveChanges(); }
public ActionResult Create(Thread t, FormCollection form) { ForumContext context = new ForumContext(); Thread thread = new Thread(); thread.startpost = t.startpost; thread.BoardId = t.BoardId; thread.title = t.title; thread.status = "Unlocked"; context.thread.Add(thread); context.SaveChanges(); Post post = new Post(); post.postType = "start"; post.ThreadID = thread.id; post.description = thread.startpost; post.postedAt = DateTime.Now; post.postType = "Thread_Reply"; //FormCollection form = new FormCollection(); post.postedBy = Convert.ToInt32(form["startedBy"]); context.post.Add(post); context.SaveChanges(); return(RedirectToAction("Details", "Forum", new { id = t.BoardId })); }
// GET: Forum public async Task <ActionResult> Index(int?id) { List <TopicsInfo> topicsInfo; try { using (ForumContext db = new ForumContext()) { topicsInfo = db.Forum_post.Select(t => new TopicsInfo { Id = t.Id, Topic_id = t.Topic_id, IdForum = t.Forum_id, Subject = t.Topic, CreatedBy = t.Author, Replies = db.Forum_post.Count(p => p.Topic_id == t.Topic_id) }).Where(t => t.Subject.Length > 0 && t.IdForum == id).ToList(); } } catch (Exception ex) { return(View(ex.Message)); } TempData["value"] = id; ViewBag.Name = User.Identity.Name; ViewBag.AdminRole = User.IsInRole("admin") ? true : false; return(View(topicsInfo)); }
protected void Page_Load(object sender, EventArgs e) { int forumId = QueryHelper.GetInteger("forumid", 0); ForumContext.CheckSite(0, forumId, 0); if (QueryHelper.GetInteger("saved", 0) > 0) { postsTreeUrl += forumId.ToString() + "&saved=1"; postsEditUrl += forumId.ToString() + "&saved=1"; } else { postsTreeUrl += forumId.ToString(); postsEditUrl += forumId.ToString(); } frameTree.Attributes["name"] = postFrameTree; frameTree.Attributes["src"] = postsTreeUrl; frameEdit.Attributes["name"] = postFrameEdit; frameEdit.Attributes["src"] = postsEditUrl; if (CultureHelper.IsUICultureRTL()) { ControlsHelper.ReverseFrames(colsFrameset); } ScriptHelper.HideVerticalTabs(this); }
internal static void Main() { Database.SetInitializer(new MigrateDatabaseToLatestVersion <ForumContext, Configuration>()); var db = new ForumContext(); var category = new Category { Parent = null, Name = "Database course", }; db.Categories.Add(category); var post = new Post { Title = "Срока на домашните", Content = "Моля удължете срока на домашните", Type = PostType.Normal, Category = category, }; post.Tags.Add(new Tag { Text = "домашни" }); post.Tags.Add(new Tag { Text = "срок" }); db.Posts.Add(post); db.SaveChanges(); Console.WriteLine("Ready!"); Console.ReadLine(); }
public void DeleteUser(User u) { ForumContext db = new ForumContext(); db.userDB.Remove(u); db.SaveChanges(); }